Forums / General Questions / Fatal error - site down

Fatal error - site down

Locked

Started by countrycupboard on 26 Mar 2008, 2:33 PM · Views: 2,587

Results 21 to 30 of 30
This thread is locked. New replies are disabled.
1 Apr 2008, 5:51 PM
#21
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

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.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

1 Apr 2008, 6:51 PM
#22
countrycupboard avatar

countrycupboard

New Zenner

Join Date:
Mar 2008
Posts:
37
Plugin Contributions:
0

Re: Fatal error - site down

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.

1 Apr 2008, 6:54 PM
#23
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Fatal error - site down

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?

Zen-Venom Get Bitten

1 Apr 2008, 7:35 PM
#24
countrycupboard avatar

countrycupboard

New Zenner

Join Date:
Mar 2008
Posts:
37
Plugin Contributions:
0

Re: Fatal error - site down

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

1 Apr 2008, 7:38 PM
#25
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Fatal error - site down

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

Zen-Venom Get Bitten

1 Apr 2008, 9:46 PM
#26
countrycupboard avatar

countrycupboard

New Zenner

Join Date:
Mar 2008
Posts:
37
Plugin Contributions:
0

Re: Fatal error - site down

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?

2 Apr 2008, 3:31 AM
#27
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: Fatal error - site down

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.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

2 Apr 2008, 3:35 AM
#28
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: Fatal error - site down

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.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

2 Apr 2008, 3:38 AM
#29
countrycupboard avatar

countrycupboard

New Zenner

Join Date:
Mar 2008
Posts:
37
Plugin Contributions:
0

Re: Fatal error - site down

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?

2 Apr 2008, 3:42 AM
#30
countrycupboard avatar

countrycupboard

New Zenner

Join Date:
Mar 2008
Posts:
37
Plugin Contributions:
0

Re: Fatal error - site down

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?