New Install, Old Tables

[fishchairs]

i did a complete new install of the cart but i have my old tables. i went and uploaded the back up of the database that i had.

all looks good but i have duplicate tables. half are named without the zen_ prefix, which were the originals from the new install.

the other half have the zen_ prefix and look like they're the populated tables.

i may be wrong using the word tables but i'm hoping someone gets my drift and can help me. i do believe i change something in the config file and delete the tables that we're built on the install.

can anyone shed some light on what i need to do here?

thanks,
dana

[fishchairs]

ok, i found the lines in the config file and added the correct table prefix, but when i did, i get this error for the admin area, the admin area was working fine before i added the correct table prefix. also, i dumped all the old tables that were not popluted from the install -

1146 Table 'addyfish_addy.project_version' doesn't exist
in:
[select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


all my products and descriptions from before showed up so i'm almost there, can anyone help me fix that error i'm getting for the admin folder?

THANKS!

[tino.schlegel]

Do you have the same Zencart version As before? I guess not.

Maybe post you before and after version to get further advise.

[fishchairs]

i used the latest download/version this website had

thanks

[RodG]

ok, i found the lines in the config file and added the correct table prefix,

Although probably not related to your immediate problem, do keep in mind that this change needs to be made in BOTH configure.php files.

but when i did, i get this error for the admin area, the admin area was working fine before i added the correct table prefix. also, i dumped all the old tables that were not popluted from the install -

Dumping the old tables was a good idea, because it ensures you only have one set of data to work with.

1146 Table 'addyfish_addy.project_version' doesn't exist
in:

This looks wrong to me. zencart generally uses the underscore character as the prefix/name separator, so assuming your prefix is "addyfish_" the table name should be 'addyfish_project_version'

For some reason or another, your prefix appears to be "addyfish_addy." so perhaps you messed up when you edited your config file?

[select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]

This also looks 'wrong' in that it implies a prefix isn't used at all (Not that that is wrong in itself, but if a prefix is expected then this select command won't find the table named "project_version"

all my products and descriptions from before showed up so i'm almost there, can anyone help me fix that error i'm getting for the admin folder?

THANKS!

Double check your prefixes, and ensure you make the same changes in both configure.php files, because this really does look like you may have made a typo with your edits. Something is definiterly fishy with "addyfish_addy." being used as a prefix in one place, and no apparent prefix being used in another.

Cheers
Rod

[fishchairs]

ok, i have to go to work and will check this out tonight. it looks like i may get it from your writings, thank you very much! i will keep you posted either way.

[fishchairs]

got my admin screen, user name and passwords are bad. will figure that out later, thanks!!!

[RodG]

got my admin screen, user name and passwords are bad. will figure that out later, thanks!!!

You'll be needing to use the username/password that was stored in your old tables rather than those used when you setup the new installation.

Cheers
Rod

[fishchairs]

got that minutes ago! now im late for work, im in and running, have to fix server patch level when i get home tonight and thats it! thanks again!!!!!!!