Problem Upgrading


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


File: /var/www/vhosts/

Line: 311

Function: db_error

File: /var/www/vhosts/

Line: 70

Function: db_query

File: /var/www/vhosts/

Line: 451

Function: db_get_hash_array

File: /var/www/vhosts/

Line: 47

Function: fn_get_blocks

File: /var/www/vhosts/

Line: 479

Function: include

File: /var/www/vhosts/

Line: 344

Function: fn_run_controller

File: /var/www/vhosts/

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…


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