sql - Error: Table 'django_db.polls_question' doesn't exist [SQLCode: 1146], [SQLState: 42S02] -

-

i following tutorial on

https://docs.djangoproject.com/en/1.10/intro/tutorial02/.

i have reached section : playing api¶

once you’re in shell, explore database api:

>>> polls.models import question, choice   # import model classes wrote.  # no questions in system yet. >>> question.objects.all()

this gives error :

error: table 'django_db.polls_question' doesn't exist [sqlcode: 1146], [sqlstate: 42s02]

before above error : prints :

>>> traceback (most recent call last):   file "<console>", line 1, in <module>   file "/usr/local/lib/jython/lib/site-packages/django-1.8.16-py2.7.egg/django/db/models/query.py", line 138, in __repr__     data = list(self[:repr_output_size + 1])   file "/usr/local/lib/jython/lib/site-packages/django-1.8.16-py2.7.egg/django/db/models/query.py", line 162, in __iter__     self._fetch_all()   file "/usr/local/lib/jython/lib/site-packages/django-1.8.16-py2.7.egg/django/db/models/query.py", line 965, in _fetch_all     self._result_cache = list(self.iterator())   file "/usr/local/lib/jython/lib/site-packages/django-1.8.16-py2.7.egg/django/db/models/query.py", line 238, in iterator     results = compiler.execute_sql()   file "/usr/local/lib/jython/lib/site-packages/django-1.8.16-py2.7.egg/django/db/models/sql/compiler.py", line 840, in execute_sql     cursor.execute(sql, params)   file "/usr/local/lib/jython/lib/site-packages/django-1.8.16-py2.7.egg/django/db/backends/utils.py", line 79, in execute     return super(cursordebugwrapper, self).execute(sql, params)   file "/usr/local/lib/jython/lib/site-packages/django-1.8.16-py2.7.egg/django/db/backends/utils.py", line 64, in execute     return self.cursor.execute(sql, params)   file "/usr/local/lib/jython/lib/site-packages/django-1.8.16-py2.7.egg/django/db/utils.py", line 98, in __exit__     six.reraise(dj_exc_type, dj_exc_value, traceback)   file "/usr/local/lib/jython/lib/site-packages/django-1.8.16-py2.7.egg/django/db/backends/utils.py", line 64, in execute     return self.cursor.execute(sql, params)   file "/usr/local/lib/jython/lib/site-packages/django_jython-1.8.0b3-py2.7.egg/doj/db/backends/__init__.py", line 185, in execute     self.cursor.execute(sql, params)

i went mysql, same database check existing tables. 

mysql> show tables; +----------------------------+ | tables_in_django_db        | +----------------------------+ | auth_group                 | | auth_group_permissions     | | auth_permission            | | auth_user                  | | auth_user_groups           | | auth_user_user_permissions | | django_admin_log           | | django_content_type        | | django_migrations          | | django_session             | | polls_choice               | | polls_poll                 | +----------------------------+ 12 rows in set (0.00 sec)

after describing tables, realized polls_question being renamed polls_poll

$jython manage.py sqlmigrate polls 0001  begin; create table `polls_choice` (`id` integer auto_increment not null primary key, `choice_text` varchar(200) not null, `votes` integer not null); create table `polls_question` (`id` integer auto_increment not null primary key, `question_text` varchar(200) not null, `pub_date` datetime not null); alter table `polls_choice` add column `question_id` integer not null; alter table `polls_choice` alter column `question_id` drop default; create index `polls_choice_7aa0f6ee` on `polls_choice` (`question_id`); alter table `polls_choice` add constraint `polls_choice_question_id_54f1d7bd_fk_polls_question_id` foreign key (`question_id`) references `polls_question` (`id`);  commit;

and in mysql, 

mysql> describe polls_poll; +----------+--------------+------+-----+---------+----------------+ | field    | type         | null | key | default |          | +----------+--------------+------+-----+---------+----------------+ | id       | int(11)      | no   | pri | null    | auto_increment | | question | varchar(200) | no   |     | null    |                | | pub_date | datetime     | no   |     | null    |                | +----------+--------------+------+-----+---------+----------------+ 3 rows in set (0.00 sec)

i have tried searching extensively in other answers unable find solution.


Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more