upgrade script does not work

General Forums Installation & Upgrade
#1

i tried to upgrade my database using the upgrade script and continues to fail



Database error: Table ‘admin_store2.cscart_settings’ doesn’t exist (1146)

Invalid query: SELECT value FROM cscart_settings WHERE option_name=‘images_location’



Backtrace:

File: /home/owner/public_html/store/core/fn.database.php

Line: 233

Function: db_error

File: /home/owner/public_html/store/core/fn.database.php

Line: 101

Function: db_query

File: /home/owner/public_html/store/upgrade135sp4-206.php

Line: 148

Function: db_get_field





i tried like 5 times and it keeps on doing this

#2

Do you have this table in your database? admin_store2.cscart_settings

#3

Basically Cs-Cart is trying to find where the images are located, I guess this table has been modified or does not exist in the dump file

#4

[quote name=‘Tool Outfitters’]Do you have this table in your database? admin_store2.cscart_settings[/QUOTE]



no i don’t



i created a new database and was importing the dump as instructed. did i do something wrong ?

#5

Sounds like something went wrong with the new install? Reinstall the new version then run the upgrade.

#6

i figured out my problem.



i skipped the step where it said to copy the images to the database… I currently use the file system



is there a way that i can just leave it in the file system? i have 5000+ products. don’t want to screw anything up .

#7

In short, no. The script requires the images to be in the database. The only thing I didn’t like was that the image names are changed to numbers. If you want to keep the original names, make a backup of your images then move them to the database for the update. Once the update is done then you can import your backup images to the updated version.



I don’t think that was your problem? The script will stop in the middle of the process if it detects that your images are not in the database. Shouldn’t have anything to do with the settings table missing.

#8

[quote name=‘giftedwon’]

i skipped the step where it said to copy the images to the database… I currently use the file system



is there a way that i can just leave it in the file system? i have 5000+ products. don’t want to screw anything up .[/quote]



Goodluck trying to run the process without images being in the database yet alone correctly run, the script uses a large mount of system resources so you can get cut off the upgrade mid-process