469,622 Members | 2,060 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,622 developers. It's quick & easy.

Aggravating Error 1109 from simple query

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
Dec 22 '06 #1
4 2890
bartonc
6,596 Expert 4TB
I'm getting "Error 1109 : Unknown table 'questions' in where clause" when I do the simplest query.

This is the query:

SELECT * FROM questions;
That is very strange, considering there is no where clause in this query.
Dec 22 '06 #2
That is very strange, considering there is no where clause in this query.
When I get rid of that one row -- the one named 'question_comment_vote' -- then the query works. Something is wrong with that row and I can't figure out what?!
Dec 22 '06 #3
ronverdonk
4,258 Expert 4TB
Then the only conclusion can be that you have not shown the complete SELECT. Where else would the error message reg. the WHERE clause come from?

I created that table with your definitions and filled it, and I have no error in a straight select *.

Ronald :cool:
Dec 22 '06 #4
might my error 1109 reflect memory management problems?

could it be that i'm trying to stuff the wrong sort of data into a table? or might the error be from using primary keys incorrectly?

i'm new to mysql, but i remember in C i used to get strange errors that were actually just memory problems.
Jan 3 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by bill_hounslow | last post: by
4 posts views Thread by vg-mail | last post: by
15 posts views Thread by Lawrence Krubner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.