I went into repair optimize tables as I did not think he used a prefix but I found
vb422pf_product
so ran the query again
SELECT * FROM vb422pf_product WHERE threadid = X
this time I get
An error occurred while attempting to execute your query. The following information was returned.
error number: 1054
error desc: Unknown column 'X' in 'where clause'
Then just for giggles I ran this thinking there needed to be a . between the prefix and the table name
SELECT * FROM vb422.pf_product WHERE threadid = X;
and got this error
An error occurred while attempting to execute your query. The following information was returned.
error number: 1142
error desc: SELECT command denied to user 'tomwayne_vb422'@'localhost' for table 'pf_product'
|