Mirza, updating the database only as you come from 4.5.0 to the latest version is probably not the worst idea. Use the updateApp.php to achieve that! In case of SQL errors like you describe it check the MySQL version you run. Also - independent from the database - there's the so called oxchkversion to check the consistency of your files, before and after the update process.
Regards Marco ________________________________ From: dev-general-boun...@lists.oxidforge.org [dev-general-boun...@lists.oxidforge.org] on behalf of Mirza Ahtasham Ahmad [ahtasha...@gmail.com] Sent: Sunday, October 27, 2013 12:51 PM To: dev-general@lists.oxidforge.org Subject: Re: [oxid-dev-general] 4.5.0 Update Hi Guys, Again...I think the site is not in 4.5.0 Version...when I log into the admin I see the follwoing version at the top right corner... Professional Edition 4.5.0_34568 but once I ran the update package from UPDATE_OXID_ESHOP_PE_V.4.5.0_34568_TO_V.4.6.5_49955_for_PHP5.3 It gave me errors on query for the tables like oxconfigdisplay, oxtplblocks, oxseo ... theses table aren't present in my db and the script is trying to alter those tables... Then I have a oxconfig table and another oxconfig2 table....so I am thinking that the version is updated in the db only but the site is still the old one...right ??? What do you guys say ? Thanks and looking forward to your replies. Mirza On Sun, Oct 27, 2013 at 12:16 PM, Mirza Ahtasham Ahmad <ahtasha...@gmail.com<mailto:ahtasha...@gmail.com>> wrote: Hi, Guys, I want to update my Current OXID 4.5.0 site Database to the latest version. Actually I am thinking of installing a new copy of OXID 4.7.8 and update only the database. For that I saw the steps...that First from 4.5.0 to 4.6.5...then 4.6.5 to 4.7.0 and then 4.7.0 to 4.7.8. But I got stuck in the first step, I installed OXID_ESHOP_PE_4.7.8_for_PHP_5.3, setup the config file with my old 4.5.0 DB. and now I am getting this error when I try to access the homepage... oxConnectionException-oxException (time: 2013-10-27 11:41:31): [0]: Unable to load shop config values from database Stack Trace: #0 C:\wamp\www\oxid478\core\oxutilsobject.php(185): oxUtilsObject->_getObject('oxconnectionexc...', 0, Array) #1 [internal function]: oxUtilsObject->oxNew('oxConnectionExc...') and when I try to update the db via updateApp and press Start Update button, I get the following error. Shop offline! Error: script did not finish successfully. Please check oxupdatetrack database table for executed actions. Can anybody help me out here...I should be able to partially use the OLD DB with the new installation. right ?? Looking forward to your reply guys... -- Mit freundlichen Grüßen, Ahmad +4917645387460<tel:%2B4917645387460> -- Mit freundlichen Grüßen, Ahmad +4917645387460
_______________________________________________ dev-general mailing list dev-general@lists.oxidforge.org http://dir.gmane.org/gmane.comp.php.oxid.general