time to finish upgrade

ok been worrking on the upgrade to 1.3.9e
i installed a demo site under www/demo/zencart with the demo products and new database. i applied all my overrides onto it and worked on it live, added stock by attributes and that was that. now its ready to be my real site

questions

1. my understanding of the upgrade is that i will need to copy this NEW website to a new directory and upgrade the database(from a copy of live one into new one), ie not install it??? i read the upgrade notes lots of times
   does the products move with the upgrade into the new site? im nott really sure

2. a few modules look interesting/useful. when would be the best time to try them?

thanks

1. my understanding of the upgrade is that i will need to copy this NEW website to a new directory and upgrade the database(from a copy of live one into new one), ie not install it??? i read the upgrade notes lots of times
   does the products move with the upgrade into the new site? im nott really sure
   Do the DB import now and also insure that your images are copied to the new install
   Tutorial
   https://www.zen-cart.com/tutorials/index.php?article=98
   https://www.zen-cart.com/tutorials/index.php?article=100
2. a few modules look interesting/useful. when would be the best time to try them?
   Now would be best after you import the DB - - - if this then takes time of hours to days
   Just place your site down for maintenance when ready - -
   re-import the live DB to capture the activity BUT omit the configuration table from this last backup

The configuration table will contain references to the added modules

ok now i have a problem when trying to go to site

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

and admin section says

1146 Table 'qssuppl1_2010.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.

i used the phpmyadmin to load up the live database into the new one
whats wrong?

Use phpmyadmin to view that those tables exist and are not empty

they exist, how to know if they are empty,
thanks by the way

In phpmyadmin there should be a column next to the table with bytes

configuration is 198.4 and project version is 3.1

configuration is 198.4 and project version is 3.1
\So they are not empty....
What install is the configuration table from?

im not sure what you mean?

QS Supplements:

im not sure what you mean?
kobra:

What install is the configuration table from?
Where earlier I recommended the fllowing and was not sure if you did this or not???
kobra:

Now would be best after you import the DB - - - if this then takes time of hours to days
Just place your site down for maintenance when ready - -
re-import the live DB to capture the activity BUT omit the configuration table from this last backup

ii did not omit the configuration table, does that mean its from the live site?

ii did not omit the configuration table, does that mean its from the live site?
Did you re-run zx_install and upgrade the DB?

i tried to rerun but BOTH install and upgrade were not available

frustrating!!! im not sure what to do

the only information on the database that we need is the product info(brands/categories/flavours/description). is there anyway to just grab that part of the database and add it to the new one?

this is really starting to slow down and we are behind time, unless someone got a solution

thanks

after some research on the net, someone said that they used firefox browser instead of IE, and it managed to fix his error
i only have chrome and older IE. usually use chrome so switched to IE and now i get a different error message

1146 Table 'qssuppl1_new.configuration' doesn't exist
in:
[update configuration set configuration_value='/home/qssuppl1/public_html/zencart2/cache' where configuration_key = 'SESSION_WRITE_DIRECTORY']

any ideas?
it seems 1146 is a very common error(heaps of oscommerce guys have them) with not so many solutions

HELP! everything else is done, just need the database

i just foound that the live store uses a zen_ prefix in the database, do i need to account for this?
also the live store database has 96 tables and the fresh install database has 190 tables????????

WHHHHHOOOOOO!!! BREAKTHROUGH
i used zen_ and it made the thing work
now i h ave another problem

your database appears to need patching to a higher level. See Tools->Server Information to review patch levels

What to do now?

your database appears to need patching to a higher level. See Tools->Server Information to review patch levels

What to do now?
Re-run zc_install and upgrade DB only