SQL Table Error (table doesn't exist?)

[DrByte]

Well, it's not going to say the table doesn't exist if it's not true.

And it's not giving you a permission-denied message, so it doesn't sound like a permissions problem.

What's the history behind this site? Do you have several databases and several db users and several db servers etc? Or has it always only been JUST ONE and never any others?

Also, please click Reply below and answer all the questions in the Posting Tips section on that page.

[DrByte]

Further, I might suggest a couple code changes, for better practice.

ie: change this:

		$sql_chk = " select products_id from products_3_for_2_flags where products_id = ". (int)$pid;

to this:

		$sql_chk = "select products_id from " . DB_PREFIX . "products_3_for_2_flags where products_id = ". (int)$pid;

- remove the space at the beginning of the query
- add the DB_PREFIX