After failed upgrade to v2.09, i cannot login my website or see my website
it is showing:
Error occured
Database error: Table ‘goopjwom_shopping4pet.cscart_block_positions’ doesn’t exist (1146)
Invalid query: SELECT location FROM cscart_block_positions WHERE object_id = 0
Backtrace:
File: /home/goopjwom/public_html/core/fn.database.php
Line: 311
Function: db_error
File: /home/goopjwom/public_html/core/fn.database.php
Line: 102
Function: db_query
File: /home/goopjwom/public_html/core/fn.cms.php
Line: 553
Function: db_get_row
File: /home/goopjwom/public_html/core/fn.cms.php
Line: 510
Function: fn_sort_blocks
File: /home/goopjwom/public_html/controllers/customer/init.php
Line: 51
Function: fn_get_blocks
File: /home/goopjwom/public_html/core/fn.control.php
Line: 487
Function: include
File: /home/goopjwom/public_html/core/fn.control.php
Line: 352
Function: fn_run_controller
File: /home/goopjwom/public_html/index.php
Line: 26
Function: fn_dispatch
please help, thanks
After upgrading my site I get the following:
Error occured
Database error: Table ‘pirates3_cscart.cscart_usergroups’ doesn’t exist (1146)
Invalid query: SELECT a.usergroup_id, a.status, a.type, b.usergroup FROM cscart_usergroups as a LEFT JOIN cscart_usergroup_descriptions as b ON b.usergroup_id = a.usergroup_id AND b.lang_code = ‘EN’ WHERE a.status != ‘D’ ORDER BY usergroup
Backtrace:
File: /home/xxx/public_html/store/core/fn.database.php
Line: 310
Function: db_error
File: /home/xxx/public_html/store/core/fn.database.php
Line: 70
Function: db_query
File: /home/xxx/public_html/store/core/fn.users.php
Line: 195
Function: db_get_hash_array
File: /home/xxx/public_html/store/controllers/admin/index.php
Line: 60
Function: fn_get_usergroups
File: /home/xxx/public_html/store/core/fn.control.php
Line: 487
Function: include
File: /home/xxx/public_html/store/core/fn.control.php
Line: 352
Function: fn_run_controller
File: /home/xxx/public_html/store/admin.php
Line: 27
Function: fn_dispatch
I have been trying to update to version 2.0.10 with no success. The problem is not 2.0.10 but 2.0.9. The thing is, for us to be able to upgrade to version 2.0.10, first, an upgrade to 2.0.9 has to be done. When i try to update to 2.0.9 i get error. See below:
********************************************************************
Database error: Unknown column ‘position’ in ‘order clause’ (1054)
Invalid query: SELECT cscart_blocks.,cscart_block_descriptions.block,cscart_block_descriptions.block_id,cscart_block_links.item_ids,cscart_block_links.enable AS assigned FROM cscart_blocks LEFT JOIN cscart_block_links ON cscart_block_links.block_id = cscart_blocks.block_id LEFT JOIN cscart_block_descriptions ON cscart_block_descriptions.block_id = cscart_blocks.block_id AND lang_code = ‘EN’ WHERE 1 AND cscart_blocks.status = ‘A’ AND cscart_block_links.enable = ‘Y’ AND NOT FIND_IN_SET(‘categories’, cscart_blocks.disabled_locations) AND (cscart_block_links.location = ‘all_pages’ OR (cscart_block_links.location = ‘categories’ AND cscart_block_links.object_id = 396)) ORDER BY position
Backtrace:
File: /var/www/vhosts/tritonpackaging.com/httpdocs/core/fn.database.php
Line: 311
Function: db_error
File: /var/www/vhosts/tritonpackaging.com/httpdocs/core/fn.database.php
Line: 70
Function: db_query
File: /var/www/vhosts/tritonpackaging.com/httpdocs/core/fn.cms.php
Line: 451
Function: db_get_hash_array
File: /var/www/vhosts/tritonpackaging.com/httpdocs/controllers/customer/init.php
Line: 47
Function: fn_get_blocks
File: /var/www/vhosts/tritonpackaging.com/httpdocs/core/fn.control.php
Line: 479
Function: include
File: /var/www/vhosts/tritonpackaging.com/httpdocs/core/fn.control.php
Line: 344
Function: fn_run_controller
File: /var/www/vhosts/tritonpackaging.com/httpdocs/index.php
Line: 26
Function: fn_dispatch
***********************************************************************
It looks like the files are still parsing the old database since there are requests for the same old database fields which are now changed. The thing is, i have inputted to the system the correct FTP Credentials with the right access, however it seems, the system still have problems modifying these files (SC-CART) with the updated ones.
2.0.10 running fine. Installed manually from 2.0.8 to 2.0.9 and then run update from 2.0-9 to 2.0.10
Thanks
I tried and I lost my site… white page!!! ahhhhhhh
So, where did you fine 2.09 package? www/var/upgrade , i’ve just an xml files…
So what can I do know… Thanks!
i have same problem any one can help me ? 
[quote name=‘alebargut’]2.0.10 running fine. Installed manually from 2.0.8 to 2.0.9 and then run update from 2.0-9 to 2.0.10
Thanks[/QUOTE]
I am also willing to update manually. You did upload all the files overwriting the ones there?
thanks
Hello,
Where is the package???
Thanks