Trying to upgrade 1.3.5 to 2.04 version

General Installation & Upgrade
1

I am trying to upgrade my 1.3.5 SP4 to 2.0.5 version, after download all database files from filearea and execute them, on running installation it shows mysql error


Status: Updating CMS pages structure...

Database error: Duplicate entry '1-E-EN' for key 'PRIMARY' (1062)
Invalid query: INSERT INTO cscart_form_descriptions (`object_id`, `description`, `lang_code`) VALUES ('1', '

Please specify product and quantity you wish us to looking for:
', 'EN')


Backtrace:
File: /home/******/public_html/csc/core/fn.database.php
Line: 233
Function: db_error
File: /home/*****/public_html/csc/upgrade135sp4-205.php
Line: 749
Function: db_query



Please help :frowning:

2

PROBLEM SOLVED :smiley:



If you also getting same error try to replace files



In order to fix this bug please try to replace the following part of code:


foreach ($forms_descriptions['S'] as $lc => $descr) {
$a = array(
'object_id' => $elm_id,
'description' => $descr['description'],
'lang_code' => $lc
);
$elm_id = db_query("INSERT INTO ?:form_descriptions ?e", $a);
}



with this one:


foreach ($forms_descriptions['S'] as $lc => $descr) {
$a = array(
'object_id' => $elm_id,
'description' => $descr['description'],
'lang_code' => $lc
);
$elm_id = db_query("REPLACE INTO ?:form_descriptions ?e", $a);
}




in the “/upgrade135sp4-205.php” file.



Thank you CSC Team :smiley:

3

did the latest upgrade twice today and got this crash… any quick suggestions?



4

You can ask this on helpdesk, team will definitely help you .

5

Hi miracles, Alexander Repin said i was out of support time…

6

Than you can ask forum admin

7

[quote name=‘miracles’]Than you can ask forum admin[/quote]

Then he wont get a response since I am not a paid employee of CS-Cart.

8

[quote name=‘miracles’]You can ask this on helpdesk, team will definitely help you .[/QUOTE]



On my personal experience I would first ask if these support credits would cover such problem solving… Many things I requested from support for 135 were covered for 2XX custom development only offered :slight_smile: