modified a table now the site is shot

General Installation & Upgrade
1

i migrated the other day from 1.35 to 2.08

i didn’t go past 2.08 yet as i wanted to see if the site can stay stable. today i modifed a block and changed a product. now users cant access my site. . they receive this error .



Database error: Unknown column ‘exception_id’ in ‘order clause’ (1054)

Invalid query: SELECT * FROM cscart_product_options_exceptions WHERE product_id = 7880 ORDER BY exception_id



Backtrace:

File: /core/fn.database.php

Line: 233

Function: db_error

File: //fn.database.php

Line: 33

Function: db_query

File: /core/fn.catalog.php

Line: 2200

Function: db_get_array

File: /2x/core/fn.catalog.php

Line: 278

Function: fn_get_product_exceptions

File: //2x/controllers/customer/products.php

Line: 40

Function: fn_gather_additional_product_data

File: /h/2x/core/fn.control.php

Line: 462

Function: include

File: /l/2x/core/fn.control.php

Line: 337

Function: fn_run_controller

File: /l/2x/index.php

Line: 28

Function: fn_dispatch





please help…i would upgrade but i can’t access upgrade center its all blank

2

i ended up reloading. i could not afford more downtime

3

[quote name=‘giftedwon’]i ended up reloading. i could not afford more downtime[/quote]



CREATE TABLE `cscart_product_options_exceptions` (
[COLOR=Red][B] `exception_id` mediumint(8) unsigned NOT NULL auto_increment,[/B][/COLOR]
`product_id` mediumint(8) unsigned NOT NULL default '0',
`combination` varchar(255) NOT NULL default '',
PRIMARY KEY (`exception_id`),
KEY `product` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




You just need to add the missing field using phpmyadmin - Sno