OpenCart Community

Posted: **Wed Sep 07, 2016 8:02 am**

I tried upgrading Opencart Version 1.5.5.1 to opencart 2.1, but I received a lot of errors, so I thought ok I may aswell just revert back to before my old version, where there were no errors.

So I deleted everything in the FTP and re uploaded my backup, but now when I go to my homepage it says

Code: Select all

Notice: unserialize() [function.unserialize]: Error at offset 0 of 76 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 75 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 2607 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 128 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 119 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 651 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 6733 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 398 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 947 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 1119 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 173 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 17 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 866 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 86 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 236 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 2 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 121 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 193 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 410 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 31 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 5460 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 1273 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 5 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 43 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 5 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 5 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 54 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 277 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 502 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 74 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 17 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 7113 bytes in /home/retrotow/public_html/index.php on line 72

Notice: unserialize() [function.unserialize]: Error at offset 0 of 17 bytes in /home/retrotow/public_html/index.php on line 72
Notice: unserialize() [function.unserialize]: Error at offset 0 of 7289 bytes in /home/retrotow/public_html/system/library/user.php on line 23 Notice: Undefined variable: fbOpengraphHeader in /home/retrotow/public_html/vqmod/vqcache/vq2-catalog_view_theme_bigshop_template_common_header.tpl on line 2 lang="en"> Notice: Undefined variable: fbOpengraph in /home/retrotow/public_html/vqmod/vqcache/vq2-catalog_view_theme_bigshop_template_common_header.tpl on line 7

and when I got to my admin panel it says

Code: Select all

Notice: unserialize() [function.unserialize]: Error at offset 0 of 76 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 75 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 2607 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 128 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 119 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 651 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 6733 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 398 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 947 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 1119 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 173 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 17 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 866 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 86 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 236 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 2 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 121 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 193 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 410 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 31 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 5460 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 1273 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 5 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 43 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 5 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 5 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 54 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 277 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 502 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 74 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 17 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 7113 bytes in /home/retrotow/public_html/admin/index.php on line 51

Notice: unserialize() [function.unserialize]: Error at offset 0 of 17 bytes in /home/retrotow/public_html/admin/index.php on line 51
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/retrotow/public_html/admin/index.php:51) in /home/retrotow/public_html/system/library/session.php on line 11Notice: unserialize() [function.unserialize]: Error at offset 0 of 7289 bytes in /home/retrotow/public_html/system/library/user.php on line 23

Does anyone know how this can be fixed?

Posted: **Wed Sep 07, 2016 8:07 am**

this can be fixed, if your Hoster has a late Backup of your v.1.x DB, and will be willing to restore your old DB.
Otherways, just accept the fact, that you screwed up, before making sure, to have everything secured and saved,
before starting to play around, like a Newbie, in a live System.

Good Luck

Ernie

Posted: **Wed Sep 07, 2016 8:17 am**

IP_CAM wrote:this can be fixed, if your Hoster has a late Backup of your v.1.x DB, and will be willing to restore your old DB.
Otherways, just accept the fact, that you screwed up, before making sure, to have everything secured and saved,
before starting to play around, like a Newbie, in a live System.

Good Luck
Ernie

I have a backup of the v1.5.5 DB on my computer, but I can't log into the admin panel to restore it. Would it be possible for me to somehow restore my backup and would that fix it?

Posted: **Wed Sep 07, 2016 7:40 pm**

you cannot use the ADMIN Function, to restore your DB, it would not work, a FULL DB Backup has to be done, from/by the SERVER ADMIN Side, in order to fully RESTORE all TABLE SECTIONS, not only their CONTENT. This, because your Upgrade-Attempt has changed THINGS, wich cannot be 'reversed', just by re-uploading DB Table Content by use of the OC Admin.

Therefore, you need to contact your Hoster, and tell him, to fully reinstall the LAST DB, saved during one of their regular Site-Backups.

Ernie

Posted: **Wed Sep 07, 2016 8:43 pm**

IP_CAM wrote:you cannot use the ADMIN Function, to restore your DB, it would not work, a FULL DB Backup has to be done, from/by the SERVER ADMIN Side, in order to fully RESTORE all TABLE SECTIONS, not only their CONTENT. This, because your Upgrade-Attempt has changed THINGS, wich cannot be 'reversed', just by re-uploading DB Table Content by use of the OC Admin.

Therefore, you need to contact your Hoster, and tell him, to fully reinstall the LAST DB, saved during one of their regular Site-Backups.

Ernie

I asked my hoster and got the database backup, thank you so much for this info, now the bulk of the problems have been fixed.

There are a few errors, I am getting

like this on the top of a product page

Code: Select all

Notice: Undefined variable: fbOpengraphHeader in /home/retrotow/public_html/vqmod/vqcache/vq2-catalog_view_theme_bigshop_template_common_header.tpl on line 2 lang="en"> Notice: Undefined variable: fbOpengraph in /home/retrotow/public_html/vqmod/vqcache/vq2-catalog_view_theme_bigshop_template_common_header.tpl on line 7

this above the title of a product

Code: Select all

Notice: Undefined variable: mbreadcrumbs in /home/retrotow/public_html/vqmod/vqcache/vq2-catalog_view_theme_bigshop_template_product_product.tpl on line 50Warning: Invalid argument supplied for foreach() in /home/retrotow/public_html/vqmod/vqcache/vq2-catalog_view_theme_bigshop_template_product_product.tpl on line 50

this below the title of a product

Code: Select all

Notice: Undefined variable: show_awis in /home/retrotow/public_html/vqmod/vqcache/vq2-catalog_view_theme_bigshop_template_product_product.tpl on line 86 Product Code: 0128

this below the add to cart area

Code: Select all

Undefined variable: text_points_only_purchase in /home/retrotow/public_html/vqmod/vqcache/vq2-catalog_view_theme_bigshop_template_product_product.tpl on line 602	Notice: Undefined variable: text_reward_points_amount in /home/retrotow/public_html/vqmod/vqcache/vq2-catalog_view_theme_bigshop_template_product_product.tpl on line 605

this at the top of the description

Code: Select all

Notice: Undefined variable: articleRelated in /home/retrotow/public_html/vqmod/vqcache/vq2-catalog_view_theme_bigshop_template_product_product.tpl on line 692

this below related products

Code: Select all

Notice: Undefined variable: chained_options in /home/retrotow/public_html/vqmod/vqcache/vq2-catalog_view_theme_bigshop_template_product_product.tpl on line 1272

Posted: **Wed Sep 07, 2016 11:10 pm**

those Errors are ALL related to Extensions, you had installed.You therefore probably have to re-install all those Extensions again, since they possibly are not longer Part of your DB-Backup-Content. Or then, they left some traces in the Backup-DB, but are not longer installed of your Shop. Possibly, you once used an enhanced russian or ukrainian origin OC-version, or such Mod's, since you used Extensions like articleRelated !

Ernie

Posted: **Thu Sep 08, 2016 8:05 pm**

The errors that you have posted relate to a change in how data is entered into and retrieved from the database.

In versions of OpenCart prior to version 2, settings data for extensions and system were "serialized" when entered into the setting table in the database. When the data was retrieved, it was "unserialized". This method was discontinued as of version 2.

As of version 2, data is entered using the "json_encode" method and retrieved using the "json_decode" method. This is incompatible with the "serialize/unserialize" methods and is one of the major problems with upgrading to OC version 2 (or above) from previous versions.

However, a function could be written that unserializes the data into an array and then json_encodes it back into the database.

Posted: **Tue Sep 13, 2016 4:42 pm**

Upgrade from OpenCart 1.x to OpenCart 2 is not easy because of change in structure. After some solution of other users, you can find information about OpenCart upgrade 1.5 to 2.1 of LitExtension. It is automated migration tool. As I know, this tool is developed to avoid errors of data loss during upgrading project.
Hope it fullfil your demand.

OpenCart Community

I tried upgrading from 1.5.5.1 to 2.1 but lots of errors

I tried upgrading from 1.5.5.1 to 2.1 but lots of errors

Re: I tried upgrading from 1.5.5.1 to 2.1 but lots of errors

Re: I tried upgrading from 1.5.5.1 to 2.1 but lots of errors

Re: I tried upgrading from 1.5.5.1 to 2.1 but lots of errors

Re: I tried upgrading from 1.5.5.1 to 2.1 but lots of errors

Re: I tried upgrading from 1.5.5.1 to 2.1 but lots of errors

Re: I tried upgrading from 1.5.5.1 to 2.1 but lots of errors

Re: I tried upgrading from 1.5.5.1 to 2.1 but lots of errors