Zoltan Posted October 8, 2013 Report Posted October 8, 2013 Hi! When I try to updrage in the admin, I received this: Oh noes! SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'root_web_dir' for key 'PRIMARY' on line 124 in /home/cmdesign/public_html/cmhost/ugyfelek/lib/model.php Printing Stack Trace:#0 /home/cmdesign/public_html/cmhost/ugyfelek/lib/model.php(124): PDOStatement->execute(Array)#1 /home/cmdesign/public_html/cmhost/ugyfelek/components/record/record.php(215): Model->query('INSERT INTO `se...', Array)#2 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/tasks/upgrade3_0_2.php(76): Record->insert('settings', Array)#3 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/tasks/upgrade3_0_2.php(49): Upgrade3_0_2->setRootWebDir()#4 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/upgrades.php(109): Upgrade3_0_2->process('setRootWebDir')#5 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/upgrades.php(58): Upgrades->processObject(Object(Upgrade3_0_2), NULL)#6 /home/cmdesign/public_html/cmhost/ugyfelek/app/controllers/admin_upgrade.php(73): Upgrades->start('3.0.0.b7', '3.0.4')#7 /home/cmdesign/public_html/cmhost/ugyfelek/lib/dispatcher.php(111): AdminUpgrade->process()#8 /home/cmdesign/public_html/cmhost/ugyfelek/index.php(21): Dispatcher::dispatch('/ugyfelek/index...')#9 {main} Any ideas? Thanks
0 Paul Posted October 8, 2013 Report Posted October 8, 2013 Ooh, upgrading from beta 7. Did you download the full version of 3.0.4? Not the patch, correct?
0 Zoltan Posted October 9, 2013 Author Report Posted October 9, 2013 I downloaded the patch. I think I forgot to hit the upgrade button a few times, but I uploaded the new files all the time an upgrade came out. Could you tell me what should I do to make this right? Thanks
0 Cody Posted October 9, 2013 Report Posted October 9, 2013 I downloaded the patch. I think I forgot to hit the upgrade button a few times, but I uploaded the new files all the time an upgrade came out. Could you tell me what should I do to make this right? Thanks So you uploaded files when 3.0.2 came out, then again for 3.0.3, but you never ran the upgrade? That's not good. You might have other issues, but for now what you can do is update /components/upgrades/tasks/upgrade3_0_2.php and change line 76: From: $this->Record->insert("settings", array('key' => "root_web_dir", 'value' => $public_root_web)); To: //$this->Record->insert("settings", array('key' => "root_web_dir", 'value' => $public_root_web)); Michael 1
0 Zoltan Posted October 10, 2013 Author Report Posted October 10, 2013 Thank you, the upgrade completed successfully. What do you suggest I should do in the future? Keep upgrading with the patches or completly change the files for the new ones? Thank You
0 Michael Posted October 10, 2013 Report Posted October 10, 2013 Thank you, the upgrade completed successfully. What do you suggest I should do in the future? Keep upgrading with the patches or completly change the files for the new ones? Thank You Patches.
0 Tyson Posted October 10, 2013 Report Posted October 10, 2013 After patching, always run the upgrade. It should be the first thing you do after each patch. Michael 1
Question
Zoltan
Hi!
When I try to updrage in the admin, I received this:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'root_web_dir' for key 'PRIMARY' on line 124 in /home/cmdesign/public_html/cmhost/ugyfelek/lib/model.php
Printing Stack Trace:
#0 /home/cmdesign/public_html/cmhost/ugyfelek/lib/model.php(124): PDOStatement->execute(Array)
#1 /home/cmdesign/public_html/cmhost/ugyfelek/components/record/record.php(215): Model->query('INSERT INTO `se...', Array)
#2 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/tasks/upgrade3_0_2.php(76): Record->insert('settings', Array)
#3 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/tasks/upgrade3_0_2.php(49): Upgrade3_0_2->setRootWebDir()
#4 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/upgrades.php(109): Upgrade3_0_2->process('setRootWebDir')
#5 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/upgrades.php(58): Upgrades->processObject(Object(Upgrade3_0_2), NULL)
#6 /home/cmdesign/public_html/cmhost/ugyfelek/app/controllers/admin_upgrade.php(73): Upgrades->start('3.0.0.b7', '3.0.4')
#7 /home/cmdesign/public_html/cmhost/ugyfelek/lib/dispatcher.php(111): AdminUpgrade->process()
#8 /home/cmdesign/public_html/cmhost/ugyfelek/index.php(21): Dispatcher::dispatch('/ugyfelek/index...')
#9 {main}
Any ideas?
Thanks
6 answers to this question
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now