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 Quote
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? Quote
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 Quote
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 Quote
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 Quote
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. Quote
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 Quote
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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.