Fatal error - site down

countrycupboard:

**Fatal error: Call to undefined function cfg_select_option()**That happens when someone attempts to remove table-prefixes in their database by exporting the database content, doing a blind global search-and-replace of "zen_" to "", and then importing the data.

There are hundreds of records in the configuration and product_type_layout tables that have zen_cfg_xxxxxxxx() functions defined to them. If you've renamed those as part of your search-and-replace, you've shot yourself in the foot, and will have to fix them all manually.

This is me, bandaging my foot. Any chance there's a standard DB template I can use with WinMerge to see where I need to make the changes? he asked with great humility.

This is me, bandaging my foot. Any chance there's a standard DB template I can use with WinMerge to see where I need to make the changes? he asked with great humility.
Do you still an un-adulterated backup prior to your changes?

i believe so. I'm doing a complete re-install and will start over with the unadulterated version. Failing that - any suggestions?

i believe so. I'm doing a complete re-install and will start over with the unadulterated version. Failing that - any suggestions?
Unless there is a GOOD reason to eliminate the prefix - just leave it

OK. completed a new full install and reinstalled the previous database. Now I can no longer see any of my customization. Problem that started all this was that my hosting service cancelled my existing mySQL account and created a new one with a different database name when I moved my site from a Windows server to a Linux server. After trying and failing to upload my old database to the new database, I went in to the old sql file and changed the name of the database and the table names. All the zen_cfg_xxxx stuff is still in place. Can you take a look at the attached sql file and tell me what the syntax should be for the table names?

countrycupboard:

I went in to the old sql file and changed the name of the database and the table names.I can see why you'd need to rename the database (or just comment out the line which names the database), but I don't understand why you would need to rename any tables.

Hmmm ... correction.

You have at least 3 sets of tables in that SQL file:

1. Zen Cart tables without a prefix
2. Cube Cart tables
3. Zen Cart tables with a zen_ prefix

I guess the right answer depends on which set of data is the correct set.

Actually that's what I thought. Tables is tables. Somehow, though, I'm not seeing any of my customization at all. Just the plain zencart template. Any suggestions? Something wrong with a config file? It was working this morning, then I did the new install. I must have done something when I did the install. Once more from the top?

i believe the ones without the zen_prefix are correct. Cube Cart tables are a vestige from an earlier lack of decision making. After I copy the files once more (just to cover my ....), can I just delete the cube cart tables and the zen_ tables and repost?