DataBase problem after moving site!!!!!!

[PetesTown]

Well Ok I FTP'd those configs down and the are prefexed "ZEN" where my origianls are prefixed " " nothing? So I guess I need to change their prefix to match mine "my old ones " No trying to be stupid just don't want to mess this up!

[PetesTown]

What does this error mean?

1146 Table 'petesdb.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

I was playing with the zencart prefix changer on the old site doing some experimenting

[DrByte]

It means ZC is looking at the database named "petesdb" for the table named "configuration", but can't find it ... presumably because it's no longer named "configuration".

[PetesTown]

Well what I was doing was trying to experiment! I used the ad-on here from the forum db prefix changer! I loaded to root like the instructions said. I ran it in-order to ad the zen prefix to it. I then changed the admin/includes/config and the includes/ config to use the prefix "zen" it did not work and errored so then I ran it again and left the prefix blank and changed the config files back. ITS STILL ERRORING? What did I miss? PLEASE DOC PLEASE tell me I can fix this

[DrByte]

If your DB_PREFIX is not set to blank, but all your tablenames have no prefix, you're going to get those errors.
If your DB_PREFIX is set to something, but all your tablenames do not have that at the beginning of the table names, you're also going to get "not found" errors.

I'm not familiar with the addon you're talking about. Remember, addons are use-at-own risk.

To fix the problem, you'll need to make sure all your tablenames have whatever prefix is in your DB_PREFIX setting. That may mean you need to manually rename them. phpMyAdmin lets you do that, although it's one-at-a-time.

Worst-case scenario, you could use the database-backup you made before you started making changes ...

[PetesTown]

Hey doc on Go Daddy does the version of PHP 4.1 or 5.0 have anything to do with it FINDING the database! SO say's GoDaddy support ? ALso I did prefix every field and it came up with garbled information under categories! ? It looked like descriptions from DB FIELDS instead of the category names!

[kuroi]

DB prefix should only be attached to tables, not column fields.

Either of those versions of PHP should be fine. Sounds like they're grasping at straws.

[PetesTown]

I apologize that was my mistake with terminology! I prefixed each table with zen_tablenamehere. It still did not work LOL. THings that make ya say Hummmmm LOL!