soo - after reading about the many folks who had issues dealing with the upgrade from 2.0.8 to 2.0.9, I could not find any real answers to the problem. I’m sure there are many out there who have gotten through this update, so help would be greatly appreciated!!
We’ve tried setting permissions as suggested by the cart support team, but didn’t have any effect. Wouldn’t mind trying things manually, just not quite sure how to go about it.
Error we’re receiving follows. Thanks in advance!
Warning: copy(/home/domain/public_html/shop/core/fn.sales_reports.php) [function.copy]: failed to open stream: Permission denied in /home/domain/public_html/shop/var/upgrade/upgrade_2.0.8-2.0.9.tgz/uc_override.php on line 608
Database error: Unknown column ‘usergroup_ids’ in ‘where clause’ (1054)
Invalid query: UPDATE cscart_categories SET usergroup_ids = 6 WHERE usergroup_ids = 1
Backtrace:
File: /home/domain/public_html/shop/core/fn.database.php
Line: 311
Function: db_error
File: /home/domain/public_html/shop/var/upgrade/upgrade_2.0.8-2.0.9.tgz/uc.php
Line: 87
Function: db_query
File: /home/domain/public_html/shop/var/upgrade/upgrade_2.0.8-2.0.9.tgz/uc_override.php
Line: 744
Function: include
File: /home/domain/public_html/shop/var/upgrade/upgrade_2.0.8-2.0.9.tgz/uc_override.php
Line: 160
Function: fn_uc2_post_upgrade
File: /home/domain/public_html/shop/controllers/admin/upgrade_center.php
Line: 39
Function: include
File: /home/domain/public_html/shop/core/fn.control.php
Line: 479
Function: include
File: /home/domain/public_html/shop/core/fn.control.php
Line: 344
Function: fn_run_controller
File: /home/domain/public_html/shop/admin.php
Line: 27
Function: fn_dispatch
Look in here…
/home/domain/public_html/shop/var/upgrade/upgrade_2.0.8-2.0.9.tgz/uc_override.php on line 608
Open in edit see what line 608 is, and then make changes as required.
I had to do this with an upgrade once, took a while but eventually did it.
The error:
The query is looking for a column in the db that doesn’t exist, a telltale sign that something got botched bigtime in a previous upgrade.
Unknown column 'usergroup_ids' in 'where clause'
You need to open up phpmyadmin and browse to the “cscart_categories” table and see if the column “usergroup_ids” exists as it should. If it does not exist you will need to modify whatever column is there, it could be membership_id from an earlier version - Sno
[quote name=‘snorocket’]The error:
Unknown column 'usergroup_ids' in 'where clause'
Response: The query is looking for a column in the db that doesn't exist, a telltale sign that something got botched bigtime in a previous upgrade.
Yes, snorocket, that is exactly what the problem was. Had to do with all permissions not being set as they should have been, so script could not run properly. Ended up working with the Helpdesk to get the problem solved. Reverted DB back to original config, set permissions, and then ran the upgrade and all seemed to go smoothly. Have learned that correct permission settings is critical for the upgrades to run correctly!
Would also like to say the Helpdesk has been great in their response and willingness to help!