Update problem! site short down

Can somebody help me, i got the following error while i was updating to the leatest version from the Admin section;

" Database error: Table ‘qrscomputers20.cscart_usergroup_links’ doesn’t exist (1146)

Invalid query: SELECT link_id, usergroup_id, status FROM cscart_usergroup_links WHERE user_id = 1


Backtrace: File: /home/content/q/r/s/qrscomputers/html/core/fn.database.php

Line: 310

Function: db_error

File: /home/content/q/r/s/qrscomputers/html/core/fn.database.php

Line: 70

Function: db_query

File: /home/content/q/r/s/qrscomputers/html/controllers/common/auth.php

Line: 268

Function: db_get_hash_array

File: /home/content/q/r/s/qrscomputers/html/controllers/common/auth.php

Line: 38

Function: fn_auth_routines

File: /home/content/q/r/s/qrscomputers/html/core/fn.control.php

Line: 487

Function: include

File: /home/content/q/r/s/qrscomputers/html/core/fn.control.php

Line: 352

Function: fn_run_controller

File: /home/content/q/r/s/qrscomputers/html/admin.php

Line: 27

Function: fn_dispatch"

The error shows up immediately i logged on, nothing works now.

Anybody have similar problem?

Thanks for your help.


If your DB still has the ‘membership’ tables, try:


CREATE TABLE `cscart_usergroup_links` (
`link_id` mediumint(8) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) unsigned NOT NULL default '0',
`usergroup_id` mediumint(8) unsigned NOT NULL default '0',
`status` char(1) NOT NULL default 'A',
PRIMARY KEY (`link_id`),
UNIQUE KEY `user_id` (`user_id`,`usergroup_id`)


Rename cscart_memberships to cscart_usergroups, rename its membership_id to usergroup_id

Rename cscart_membership_descriptions to cscart_usergroups_descriptions, rename membership_id to usergroup_id, rename membership to usergroup

Rename cscart_membership_privileges to cscart_usergroups_privileges, rename membership_id to usergroup_id

I just upgraded from 1.3.5sp4 to 2.0.10, and a lot of the tables are missing, or have old tablenames or have old fieldnames in the table. If in doubt, check /install/database/scheme.sql for the correct table data