The above errors occurred because the script could not properly determine the existing state of those db elements. Your store may not need those changes. Please post any errors on the forums to ensure that they can be addressed in future versions!

LINE 17: [2048] require_once() [function.require-once]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead

Last edited by kryptonbulbs on Tue Mar 20, 2012 11:36 pm, edited 1 time in total.

LINE 17: [2048] require_once() [function.require-once]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead

You are sure you uploaded the new files? This is defined in the system/startup.php file on line: 47

LINE 17: [2048] require_once() [function.require-once]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead

You are sure you uploaded the new files? This is defined in the system/startup.php file on line: 47

Yes, Ive even restored the site back to 1.4.8 and then tried another 1.5.x platform and still get the same message when I go to the script page. Could it be a problem on my server? Im lost on this one, so close to just doing a fresh install because I need to get this up and running by tomorrow. The main reason for my upgrade is to accept web payment software, but also the affiliate program intrigues me as the affiliate program integration sounds great instead of running IDEV as I currently do. I would really hate to lose everything I already have in my database though so I want to do anything I can to get this upgrade to go through.

Currently I am overwriting again with all 1.5.2.1 files to try and make sure everything copied, but im pretty sure that it all did.

Stupid question Q, Could I be getting this error because the site was in oh whats it called "maintenance mode" before I started the upgrade? Do you think it might solve the problem if I reinstalled my last known good configuration, turned maintenance mode off and then uploaded and ran the new files and update?

Maintenance won't affect this. It is even recommended to be in maintenance mode before upgrade.
This is simply a php configuration error but the code checks for this error and is supposed to be overriding the error. For some reason your server isn't accepting the override or something.

Oddly, that same line is in 1.4.x so I dont know what its having a problem now

Qphoria wrote:Maintenance won't affect this. It is even recommended to be in maintenance mode before upgrade.
This is simply a php configuration error but the code checks for this error and is supposed to be overriding the error. For some reason your server isn't accepting the override or something.

Oddly, that same line is in 1.4.x so I dont know what its having a problem now

Talked to my host and they said to try it now(contacted them while doing the overwrite)... but, nothing was even showing up on the site at that point (my reinstall upload failed part way through) so I am trying to upload the original 1.4.8 backup right now and then will start over.

Oh, we also did a server upgrade a few months back, so maybe something with that is or was causing it. Not sure what the host changed but if it does work I will find out.

LINE 150: [2] mysql_num_rows(): supplied argument is not a valid MySQL result resource
LINE 150: [2] mysql_num_rows(): supplied argument is not a valid MySQL result resource
LINE 150: [2] mysql_num_rows(): supplied argument is not a valid MySQL result resource

The above errors occurred because the script could not properly determine the existing state of those db elements. Your store may not need those changes. Please post any errors on the forums to ensure that they can be addressed in future versions!

OpenCart.com

Not touching anything till i hear back, I know youve told some people that they can just ignore some errors and continue if thats the case with me please define continue, if there is supposed to be another link to check or just continue through the steps in the instructions.

I am assuming this could have been one of 2 problems, Either whatever the host took care of OR I think I might have inserted the HTTP code in front of the php instead of between the PHP and \\DIR

First Post on here so I'd firstly like to thank everyone for their contributions to the forum - especially the moderators!!

So here I go:

I upgraded version 1.4.9.3 of Opencart to 1.5.1.2, firstly using the BETA3 update script to update to 1.5.1.2, and then I upgraded to version 1.5.2.1 using the upgrade instructions with the 1.5.2.1 download. That all worked fine.

So I am now running Opencart 1.5.2.1

But here is my problem (and yes, I am relatively new to Opencart):

I had approximately 2,000 items in my original database on OC 1.4.9.3. As I read in these forums the items(products) won't appear in the upgraded version of OC automatically, but I just can't work out how to get my old database of products into the new version of OC. I have read everything I can find in these forums, and the only relevant information I find has to do with re-installing 'modules' as they might need to be updated for the new OC version. I didn't have any external modules installed for my 1.4.9.3 Opencart... However, I did uninstall and re-install ALL modules in the new 1.5.2.1 Opencart.... Still no luck with seeing my database of products. The Only Products I can see are the default products that come with the installation.

I have an Opencart backup of my database (from 1.4.9.3). When I try to restore that backup into 1.5.2.1 I get the following error:

I remember reading somewhere on here that the database structure has changed between versions 1.4.x and 1.5.x but can't work out how to update my old database version to one that works with 1.5.2.1.

So in short, does anyone have detailed step by step instructions on how to migtrate a database of products from OC 1.4.9.3 into 1.5.2.1?? Am pulling my hair out here and would be HUGELY grateful for any help!....