1146:Table 'configuration' doesn't exist

[moesoap]

Hi Guys hopefully someone can help with this as its ongoing three days.

I created a new site on localhost and having followed all instructions I uploaded it to the liveserver. Everything works fine until I goto use the product_filter sidebox then the site says its loading and nothing happens. Each time I try to access the site it times out with an internal server error.

As a result I am unable to drop the database tables from phpmyadmin and have had the host do this three times in 3 days. I assumed the module wasn't installed correctly so I reinstalled it and tried again, but the flaming thing has gone again, is it looping somewhere?

The error I receive is -

[24-May-2012 14:44:19] PHP Fatal error:  1146:Table 'zencart.configuration' doesn't exist :: select configuration_key as cfgkey, configuration_value as cfgvalue
                                 from configuration in /home/*****/*******/includes/classes/db/mysql/query_factory.php on line 101

I don't have any prefixes in my db and I checked configure.php in admin and includes and no prefixes are listed there either.

PHP Version is - 5.2.17
Zencart Version is - 1.50

Site Link - http://bit.ly/KC6CsU

Can someone help as I don't want to have to run to the host again. Everything works great on my local server, its puzzling

[DrByte]

That classically means that the database name or database server or database prefix is wrong, such that you're making ZC look in a database that's present but doesn't contain a table named "configuration" as it should.

[moesoap]

That classically means that the database name or database server or database prefix is wrong, such that you're making ZC look in a database that's present but doesn't contain a table named "configuration" as it should.

Hi dr byte,

I checked the database and there is a configuration table?

[DrByte]

It's very simple: Zen Cart won't be saying that the table doesn't exist if the table is actually there.

So, that means that one or more of the DB_xxxxxx settings is incorrect. As in pointing to the wrong place or the wrong database.

From the error message it's telling me that your configure.php is telling Zen Cart to look into a database named "zencart" to find a table named "configuration". From that I can tell that your DB_PREFIX is set to blank.
It's not telling me what server it's looking at, nor the username or password.

So if *you* are saying that when you go to some server out there and look at its databases and find a database named "zencart" and find a table in it named "configuration", then it must be a different server than the one you're telling Zen Cart to look into.

[moesoap]

The issue seems to stem from the product filter by attribute mod. I just checked it again on my local server and it crashes the server and database. I don't know how it is causing the 1146:Table 'configuration' error though, as this is the only error that appears in the debugger and my settings for this are accurate.