SQL error: Error creating temporary table:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show TEXT, reviewDate TEXT, reviewerNamePub TEXT, starRating TEXT, reviewText TE' at line 1
CREATE TEMPORARY TABLE KT_fakeRS_20070814 (show TEXT, reviewDate TEXT, reviewerNamePub TEXT, starRating TEXT, reviewText TEXT, reviewLink TEXT, reviewID TEXT) (FIELDS_FAKE_RS_ERROR)
tNG Execution Trace - VIEW
I've checked for the use of reserved words but I do not seem to have used any.
Gotcha ! :-) You can´t use the term "show" as MySQL column name, because it´s indeed a "reserved word" -- please rename the field to something else, and make sure to avoid the reserved words indicated on this page:
Cheers for the reply... I did look at a list of reserved words and couldn't see it there... but I've changed it and it worked so obviously I missed it!... thanks for pointing it out to me... thought it would be a simple solution :)