user warning: Table 'drupal.location' doesn't exist
Installed and ready to roll, or so I thought. When a new user attempts to sign up, this error gets thrown:
* user warning: Table 'drupal.location' doesn't exist query: SELECT * FROM location WHERE oid=0 AND type='user' in /htdocs/www/includes/database.mysql.inc on line 120.
* user warning: Table 'drupal.location' doesn't exist query: SELECT * FROM location WHERE oid=3 AND type='user' in /htdocs/www/includes/database.mysql.inc on line 120.
* user warning: Table 'drupal.location' doesn't exist query: SELECT * FROM location WHERE oid=3 AND type='user' in /htdocs/www/includes/database.mysql.inc on line 120.
Weird thing is, a signup email is generated with a link to the initial temporary login page, which throws a similar error at the top, although only once this time:
user warning: Table 'drupal.location' doesn't exist query: SELECT * FROM location WHERE oid=3 AND type='user' in /htdocs/www/includes/database.mysql.inc on line 120.
Signing in there, which redirects to the edit user profiile (to change initial password), does the same thing:
* user warning: Table 'drupal.location' doesn't exist query: SELECT * FROM location WHERE oid=3 AND type='user' in /htdocs/www/includes/database.mysql.inc on line 120.
* user warning: Table 'drupal.location' doesn't exist query: SELECT * FROM location WHERE oid=3 AND type='user' in /htdocs/www/includes/database.mysql.inc on line 120.
* user warning: Table 'drupal.location' doesn't exist query: SELECT * FROM location WHERE oid=3 AND type='user' in /htdocs/www/includes/database.mysql.inc on line 120.
Oddly enough, throughout all of these errors, the user is still created, and everything SEEMS to function properly.
I am seeing similar SQL errors in random spots through the site on occasion, and though they may be symptoms of the same problem, I thought I would try and take care of this one first..
Any takers?
database error
It looks like the "location" table does not exist in your database (possibly from the location module?).
Did you run through the install routine for your added modules?
- Corey
Table was not created during install
The SQL table was probably not created during install. So you'll need to do it manually, e.g.
mysql -p -u username database < location.mysql---
Software Development and IT-Consulting Services: ramiro.org
Search Engine Optimization Blog: seo-expert-blog.com
Thanks Corey, that was
Thanks Corey, that was definetly it - The fact that "location" is such an ambiguous term led me to believe that it may be a sitewide problem, not module related.
Thanks!
I dont know how to create tables manually
hi
Currently I am working on my local machine, I have been using wordpress and mastered it for skinning and other features.
WP creates tables in MySQL automatically.
I am now trying new CMS - Drupal, and i dont know how to create tables manually, I have created a database name, but i have no idea how and where to run the command to create tables.
I have a directory in drupal install called "database", I know i have to run some command using that database file "database.4.0.mysql". Please help me.
I am using abriasoft mysql, please let me know.
========
Also on another note, :
Please let me know which is the best CMS to have all these features:-
- restricted area for certian pages
- skinning like WP
- forum
- site search
- small in size not too big
- PHP
i did it
hiiii
above i was not able to create tables.
I finally did it.
copied the database.4.0.mysql to msql/bin directory.
here I went to my mysql/bin, used mysql.exe
then this command
mysql -u admin -p dbname < database.4.0.mysql=====
Now i would like to know if i have to repeat this on live server how will i do ?
Thank you
Fix "warning's problem from Moduls
I had the same problem, and I do the following things:
I open my database whit phpMyadmin and importet the file "daily.mysql" and so I renamed the table so it get my prefix. And now it's works fine.
Ole Martin - Norway
http://www.drupal.no
http://foreldrekontakten.com/ (My first step with Drupal)