Post by raybark » Mon Oct 12, 2015 12:08 am

Followed upgrade instructions to the "T", navigate to the "install" directory fine, but upon clicking "Upgrade", I get a whole page of errors, starting with:

Notice: Use of undefined constant DB_PORT - assumed 'DB_PORT' in /home/firstr11/public_html/cart2/install/model/upgrade.php on line 139

New member

Posts

Joined
Tue Sep 03, 2013 9:23 pm

Post by rbuelund » Mon Oct 12, 2015 5:19 am

I got exact same error - what is going on here ??? Please respond asap!

Newbie

Posts

Joined
Sun Mar 02, 2014 11:40 pm

Post by dvdvideo » Mon Oct 12, 2015 7:20 am

you need to add this to bottom of both config.php files

define('DB_PORT', '3306');

Newbie

Posts

Joined
Sat Apr 16, 2011 5:01 am

Post by rbuelund » Mon Oct 12, 2015 7:41 pm

Well that helped - but now I get this error in frontend: Notice: Error: Table 'xxxx_digi123.oc3e_cart' doesn't exist
What is going on here ??

Newbie

Posts

Joined
Sun Mar 02, 2014 11:40 pm

Post by raybark » Mon Oct 12, 2015 9:09 pm

dvdvideo wrote:you need to add this to bottom of both config.php files

define('DB_PORT', '3306');
What and Where would that have written to the DB???

After doing that i now get multiple error messages at the top of all store and admin pages (which I cannot log into):

Code: Select all

Notice: unserialize(): Error at offset 0 of 78 bytes in /home/firstr11/public_html/cart/index.php on line 58

New member

Posts

Joined
Tue Sep 03, 2013 9:23 pm

Post by hpmon » Tue Oct 13, 2015 1:25 am

don't want to jack the thread but I ran into a similar problem. When I go to the admin dashboard I get this
Warning: vsprintf(): Too few arguments in /home5/harrypat/public_html/OC/admin/controller/dashboard/activity.php on line 19Warning: vsprintf(): Too few arguments in /home5/harrypat/public_html/OC/admin/controller/dashboard/activity.php on line 19Warning: vsprintf(): Too few arguments in /home5/harrypat/public_html/OC/admin/controller/dashboard/activity.php on line 19Warning: vsprintf(): Too few arguments in /home5/harrypat/public_html/OC/admin/controller/dashboard/activity.php on line 19Warning: vsprintf(): Too few arguments in /home5/harrypat/public_html/OC/admin/controller/dashboard/activity.php on line 19
and when I go to the marketplace I get this
Notice: Error: Table 'harrypat_opencart.oc_cart' doesn't exist
Error No: 1146
DELETE FROM oc_cart WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR) in /home5/harrypat/public_html/OC/system/library/db/mysqli.php on line 41Notice: Error: Table 'harrypat_opencart.oc_cart' doesn't exist
Error No: 1146
SELECT * FROM oc_cart WHERE customer_id = '0' AND session_id = '8de5f2a636021458f328584c76475ed2' in /home5/harrypat/public_html/OC/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home5/harrypat/public_html/OC/system/library/cart.php on line 37Warning: Invalid argument supplied for foreach() in /home5/harrypat/public_html/OC/system/library/cart.php on line 37Notice: Error: Table 'harrypat_opencart.oc_cart' doesn't exist
Error No: 1146
SELECT * FROM oc_cart WHERE customer_id = '0' AND session_id = '8de5f2a636021458f328584c76475ed2' in /home5/harrypat/public_html/OC/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home5/harrypat/public_html/OC/system/library/cart.php on line 37Warning: Invalid argument supplied for foreach() in /home5/harrypat/public_html/OC/system/library/cart.php on line 37Notice: Error: Table 'harrypat_opencart.oc_cart' doesn't exist
Error No: 1146
SELECT * FROM oc_cart WHERE customer_id = '0' AND session_id = '8de5f2a636021458f328584c76475ed2' in /home5/harrypat/public_html/OC/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home5/harrypat/public_html/OC/system/library/cart.php on line 37Warning: Invalid argument supplied for foreach() in /home5/harrypat/public_html/OC/system/library/cart.php on line 37Notice: Error: Table 'harrypat_opencart.oc_cart' doesn't exist
Error No: 1146
SELECT * FROM oc_cart WHERE customer_id = '0' AND session_id = '8de5f2a636021458f328584c76475ed2' in /home5/harrypat/public_html/OC/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home5/harrypat/public_html/OC/system/library/cart.php on line 37Warning: Invalid argument supplied for foreach() in /home5/harrypat/public_html/OC/system/library/cart.php on line 37Notice: Error: Table 'harrypat_opencart.oc_cart' doesn't exist
Error No: 1146
SELECT * FROM oc_cart WHERE customer_id = '0' AND session_id = '8de5f2a636021458f328584c76475ed2' in /home5/harrypat/public_html/OC/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home5/harrypat/public_html/OC/system/library/cart.php on line 37Warning: Invalid argument supplied for foreach() in /home5/harrypat/public_html/OC/system/library/cart.php on line 37
sorry if that takes up too much space

Newbie

Posts

Joined
Sat Aug 29, 2015 2:24 am

Post by rbuelund » Tue Oct 13, 2015 1:35 am

That is exactly the same problem I get after trying to upgrade!

Newbie

Posts

Joined
Sun Mar 02, 2014 11:40 pm

Post by raybark » Tue Oct 13, 2015 6:39 am

OK, after adding define('DB_PORT', '3306'); to both config.php files, I now see this:

Image

So what in hell is going on? What can I do to fix it? Thanks for any help.

New member

Posts

Joined
Tue Sep 03, 2013 9:23 pm

Post by Mutual » Sun Nov 01, 2015 5:58 am

I have the exact same problem! How do we fix this?

Newbie

Posts

Joined
Sun Jul 12, 2015 11:31 pm

Post by rbuelund » Sun Nov 01, 2015 7:50 am

Well..sad to say it.. but because of the lack of support on this issue I have migrated to another system! No more Opencart for me!

Newbie

Posts

Joined
Sun Mar 02, 2014 11:40 pm

Post by EvolveWebHosting » Sun Nov 01, 2015 11:53 am

rbuelund wrote:Well..sad to say it.. but because of the lack of support on this issue I have migrated to another system! No more Opencart for me!
Did you try emailing support@opencart.com ?

I have not seen this exact error but I know that the upgrade script does not work the way it should. There are a couple of suggestions at the bottom of this page and if you're doing the upgrade on a separate install, it's worth a shot:

https://github.com/opencart/opencart/issues/3424

There's also this: http://www.opencart.com/index.php?route ... n_id=24454

Again, I have not used this and it's a try at your own risk on a separate install.

Opencart Hosting Plans, Domain Registration, Microsoft and Google Email and More
Visit our website for great deals and most importantly, fast and friendly support - www.evolvewebhost.com


User avatar
Active Member

Posts

Joined
Fri Mar 27, 2015 11:13 pm
Location - Denver, Colorado, USA

Post by Dolpheria » Fri Jan 22, 2016 3:25 pm

So......what is the solution to this error, in plain simple steps? Is there now a bug-free upgrade available for download?

I am astonished that there is no official response to this thread. Clear and timely responses to critical issues will keep the party going for OpenCart.

If anyone from OpenCart or otherwise can elucidate the issue and post a step-by-step solution, that would be much appreciated. Otherwise I guess we can never upgrade....?

Newbie

Posts

Joined
Thu Jan 07, 2016 10:51 am

Post by Randem » Fri Jan 22, 2016 3:52 pm

Hi,

This is as official as you will get... (I am not affiliated)

Use this process for a good upgrade. There are more than a few dozen threads about the same issue...

http://www.randemsystems.com/support/op ... 9/#msg6199

And

http://www.randemsystems.com/support/op ... cart-v2-x/

NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart


User avatar
Active Member

Posts

Joined
Sat Sep 27, 2014 9:17 am

Post by pm-netti » Fri Jan 22, 2016 10:53 pm

So what in hell is going on? What can I do to fix it? Thanks for any help.
------
I have the exact same problem! How do we fix this?
----
Well..sad to say it.. but because of the lack of support on this issue I have migrated to another system! No more Opencart for me!
This fix is simple.
Can you upload to server index.php from Openacrt 2.1.x?

User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä, Finland

Post by Qphoria » Sat Jan 23, 2016 3:24 am

I do offer professional upgrades with guaranteed data preservation. See the link in my signature for more info

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am
Who is online

Users browsing this forum: No registered users and 197 guests