jack45678 Posted October 20, 2006 Posted October 20, 2006 I've recently been helping with a friend's OsCommerce.It was originally a heavilly modified French version of whatever version of OsCommerce was around circa 2003 (Sorry,I'm not trying to be difficult,it's just so heavilly modified that I have no idea what version it was). To cut a long story short,we moved servers & I upgraded it to oscommerce-2.2ms2-060817.First I manually applied all the original programmer's edits to the core files,FTP'd that to the server.Imported the unknown-version database then executed the upgrade procedure.Everything vital to the store,such as the TVA Intracom is broken,and the whole thing,whilst not throwing any errors at all is behaving strangely. I of course loaded the original (running off an un-upgraded databse) and that also exhibits the same behaviours,so I am thinking it is connected to the fact that the server runs with Register_Globals "OFF".I have obviously added the code to enable OSCommerce to run at all in this preferred environment. Meanwhile,the admin panel on the upgraded version shows many duplicated entires under TVA Intracom and "My Store" - this makes me think I have not upgraded the database properly.I cannot see any duplicated entries via phpMyAdmin,though. Is there anywhere I could find a list of databse upgrades going back around three years? Could something else be causing the duplicate entries? If so how can I remove them? I'm quite used to repatterning Mambo databases,so at a push I could try the same with OSCommerce.To be honest though,I SO want this over,it's been weeks of pure misery! Executing a few sql upgrades sounds good to me.
jack45678 Posted October 20, 2006 Author Posted October 20, 2006 Here are the error messages thrown when running upgrade.php though a "success" type message is given: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxxx/public_html/xxxx/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxxx/public_html/xxx/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxxx/public_html/xxxx/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/xxx/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/xxx/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/xxx/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/xxx/install/includes/functions/database.php on line 45
jack45678 Posted October 20, 2006 Author Posted October 20, 2006 O.K I've "solved" the duplicated entries problem by importing *only* the old sql - no upgrades whatsoever. I was very surprised to find that this didn't cause any problems despite the upgraded files. Rather than try to struggle fixing the other problems,I've decided to take a bath with a toaster.Cheers. (Sorry.No offence meant.Oscommerce really aint my bag).
Guest Posted October 20, 2006 Posted October 20, 2006 To see if its a server problem, why not try installing a clean version of OScommerce and see if that works, if so the problem lies with your SQL or contribs installed.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.