Log in

View Full Version : Executing queries


Abaweet69
08-01-2005, 11:46 AM
Hi,

Whenever i try to execute a SQL query, whether it's through my ACP or phpMyAdmin, I always get this error...
error number: 1146
error desc: Table 'pbvidsco_forum.user' doesn't exist

For example, i want to try to execute
ALTER TABLE user ADD mood varchar(15) NOT NULL

But it just gives me the error above ^

i'm missing something. any ideas?

Thanks

Andreas
08-01-2005, 11:49 AM
Are you using a Table Prefic?
Then this must be put in front of every Tablename in SQL Queries, eg. in front of user in this one.