I'm getting "Error 1109 : Unknown table 'questions' in where clause" when I
do the simplest query.

This is the query:

SELECT * FROM questions;

My database has the following two tables:

CREATE TABLE subscribers(
subscriber_id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
email varchar(50),
gender varchar(10),
username varchar(50),
password varchar(50),
birthday char(10),
zipcode char(15),
register_date char(10),
FULLTEXT (username)
)type=MyISAM;


CREATE TABLE questions(
question_id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
question_text varchar(500),
question_date char(10),
subscriber_id INT UNSIGNED,
answer_count INT UNSIGNED,
email_when_answered int(1),
question_verification_key varchar(10),
question_comment_vote varchar(10),
FULLTEXT (question_text)
)type=MyISAM;

In my questions table, the question_comment_vote row can be set to '1' or
'2'. I don't get Error 1109 when question_comment_vote is set to '1' but I
do when it's set to '2'. How strange!
It would be so great to get some insight into this.
Thanks

Reply via email to