Aggravating Error 1109 from simple query

[kidneybean]

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_answ ered int(1),
question_verifi cation_key varchar(10),
question_commen t_vote varchar(10),
FULLTEXT (question_text)
)type=MyISAM;

In my questions table, the question_commen t_vote row can be set to '1' or '2'. I don't get Error 1109 when question_commen t_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

[bartonc]

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.

[kidneybean]

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_comme nt_vote' -- then the query works. Something is wrong with that row and I can't figure out what?!

[ronverdonk]

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:

[kidneybean]

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.