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

[RodG]

I'm not sure the problem is with configure.php?

Just to be sure, could you please post the DB portion of your configure.php files (XXX out the username/password).

There's no other connectivity problem with the db.

If it is pointing to a *different* database you probably *won't* notice any other 'connectivity' problems.

This has me baffled at the moment, and I don't sleep easy when I can't explain why a software problem seems to have no logical cause.
As the Dr. Says "it's not going to say the table doesn't exist if it's not true".

Computers can be mysterious things, but I've never known them to actually 'lie', or even make a mistake (even though it is true that some error messages can be a little misleading, or less than helpful).

Cheers
Rod

[plymgary1]

Hello again,

I just wanted to say thanks again for taking the time out to reply. :)

Here's the info:

from includes/configure.php

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', '');
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'xkwies_username');
  define('DB_SERVER_PASSWORD', 'delted for this post!');
  define('DB_DATABASE', 'xkwies_handcrafteduk');
  define('USE_PCONNECT', 'false'); // use persistent connections?
  define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

from admin/includes/configure.php

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', '');
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'xkwies_username');
  define('DB_SERVER_PASSWORD', 'deleted');
  define('DB_DATABASE', 'xkwies_handcrafteduk');
  define('USE_PCONNECT', 'false'); // use persistent connections?
  define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

It's got me stumped too!

[RodG]

I just wanted to say thanks again for taking the time out to reply. :)

I love a ood mystery.

It's got me stumped too!

Configs look OK.

Worst part is, I know I've come across something like this once before.... a long time ago. I *think* it had to do with the underscore and the way the server was configured, but it was such an unlikely scenario that I haven't given it a second thought since.

Did you try adding the DB_PREFIX as suggested by Dr.Byte?

If that doesn't help, perhaps a few 'echo' statements conveniently placed in the script to output the current variable and CONSTANT values may be helpful.

I'll let you know if I casn think of anthing else.

Cheers
Rod