Hi
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.
Please let me know how to proceed in this case. I checked all forums and 2.0.9 version seems to be buggy. Please advice…
Thanks
any ideas??
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