Post by postcardcollecting » Wed Oct 07, 2015 10:30 am

I installed OC last night with V2.0.3.1 and all went well .... then I saw the new release tonight so I decided to do the upgrade before getting too far along with the new store
I upgraded tonight using the newest V2.1.0.1 and these are the errors I get

Notice: Error: Table 'checkout_checkout.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 /home/checkout/public_html/system/library/db/mysqli.php on line 41Notice: Error: Table 'checkout_checkout.oc_cart' doesn't exist
Error No: 1146
SELECT * FROM oc_cart WHERE customer_id = '0' AND session_id = 'b66329eb0afed23d56dfaec2541cfea2' in /home/checkout/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/checkout/public_html/system/library/cart.php on line 37Warning: Invalid argument supplied for foreach() in /home/checkout/public_html/system/library/cart.php on line 37Notice: Error: Table 'checkout_checkout.oc_cart' doesn't exist
Error No: 1146
SELECT * FROM oc_cart WHERE customer_id = '0' AND session_id = 'b66329eb0afed23d56dfaec2541cfea2' in /home/checkout/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/checkout/public_html/system/library/cart.php on line 37Warning: Invalid argument supplied for foreach() in /home/checkout/public_html/system/library/cart.php on line 37Notice: Error: Table 'checkout_checkout.oc_cart' doesn't exist
Error No: 1146
SELECT * FROM oc_cart WHERE customer_id = '0' AND session_id = 'b66329eb0afed23d56dfaec2541cfea2' in /home/checkout/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/checkout/public_html/system/library/cart.php on line 37Warning: Invalid argument supplied for foreach() in /home/checkout/public_html/system/library/cart.php on line 37Notice: Error: Table 'checkout_checkout.oc_cart' doesn't exist
Error No: 1146
SELECT * FROM oc_cart WHERE customer_id = '0' AND session_id = 'b66329eb0afed23d56dfaec2541cfea2' in /home/checkout/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/checkout/public_html/system/library/cart.php on line 37Warning: Invalid argument supplied for foreach() in /home/checkout/public_html/system/library/cart.php on line 37Notice: Error: Table 'checkout_checkout.oc_cart' doesn't exist
Error No: 1146
SELECT * FROM oc_cart WHERE customer_id = '0' AND session_id = 'b66329eb0afed23d56dfaec2541cfea2' in /home/checkout/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/checkout/public_html/system/library/cart.php on line 37Warning: Invalid argument supplied for foreach() in /home/checkout/public_html/system/library/cart.php on line 37
________________________________________________________________________________
I am also finding these errors in the admin settings area:

Notice: Error: Unknown column 'name' in 'order clause'
Error No: 1054
SELECT * FROM `oc_api` ORDER BY name ASC in /home/checkout/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/checkout/public_html/admin/model/user/api.php on line 77

Do I need to start a new install or can all this be fixed. I don't have the expertise to make these fixes on my own unless it's just running a script again. The upgrade said it was successful .... obviously NOT

http://www.postcardcollecting.com
http://www.aboardnoahsark.com



Posts

Joined
Mon Aug 06, 2012 11:30 pm


Post by tmart » Wed Oct 07, 2015 1:43 pm

I am having the same problem. It first said the Upgrade is successful. But I got all the same errors. Someone please? Quphoria please!

Regards / Tissy

Image
Logo Printed / Embroidered T-Shirts
Polo Shirts, Sweatshirts & Hoodies

http://www.tmart.in


New member

Posts

Joined
Fri Jan 21, 2011 2:02 am


Post by kestas » Wed Oct 07, 2015 2:33 pm

Hi,

I also got the same errors and in admin this:
2015-10-07 6:25:48 - PHP Warning: vsprintf(): Too few arguments in /mounted-storage/home127/sub005/sc75372-HHAX/*****/eshop/admin/controller/dashboard/activity.php on line 19

What to do?

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by Bassi » Wed Oct 07, 2015 8:33 pm

It seems that when you upgrade to 2.1.01 it does not amend the mysql database.

Doing a quick comparison I detail the differences below.

How is this going to be resolved ?

Regards

Bassi
Database differences

Structure is different.
WAS
CREATE TABLE IF NOT EXISTS `oc_api` (
`api_id` int(11) NOT NULL,
`username` varchar(64) NOT NULL,
`firstname` varchar(64) NOT NULL,
`lastname` varchar(64) NOT NULL,
`password` text NOT NULL,
`status` tinyint(1) NOT NULL,
`date_added` datetime NOT NULL,
`date_modified` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
NOW
CREATE TABLE IF NOT EXISTS `oc_api` (
`api_id` int(11) NOT NULL,
`name` varchar(64) NOT NULL,
`key` text NOT NULL,
`status` tinyint(1) NOT NULL,
`date_added` datetime NOT NULL,
`date_modified` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

New Tables & alterations
CREATE TABLE IF NOT EXISTS `oc_api_ip` (
`api_ip_id` int(11) NOT NULL,
`api_id` int(11) NOT NULL,
`ip` varchar(40) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `oc_api_session` (
`api_session_id` int(11) NOT NULL,
`api_id` int(11) NOT NULL,
`token` varchar(32) NOT NULL,
`session_id` varchar(32) NOT NULL,
`session_name` varchar(32) NOT NULL,
`ip` varchar(40) NOT NULL,
`date_added` datetime NOT NULL,
`date_modified` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `oc_cart` (
`cart_id` int(11) NOT NULL,
`customer_id` int(11) NOT NULL,
`session_id` varchar(32) NOT NULL,
`product_id` int(11) NOT NULL,
`recurring_id` int(11) NOT NULL,
`option` text NOT NULL,
`quantity` int(5) NOT NULL,
`date_added` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `oc_customer_wishlist` (
`customer_id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`date_added` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `oc_api_ip`
ADD PRIMARY KEY (`api_ip_id`);

ALTER TABLE `oc_api_session`
ADD PRIMARY KEY (`api_session_id`);


ALTER TABLE `oc_cart`
ADD PRIMARY KEY (`cart_id`),
ADD KEY `cart_id` (`customer_id`,`session_id`,`product_id`,`recurring_id`);

ALTER TABLE `oc_cart`
MODIFY `cart_id` int(11) NOT NULL AUTO_INCREMENT;


ALTER TABLE `oc_customer_wishlist`
ADD PRIMARY KEY (`customer_id`,`product_id`);
ALTER TABLE `oc_api_ip`
MODIFY `api_ip_id` int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE `oc_api_session`
MODIFY `api_session_id` int(11) NOT NULL AUTO_INCREMENT;


Table Changes
oc_customer
change `token` varchar(255) NOT NULL, to `token` text NOT NULL,

Remove Tables and alterations
CREATE TABLE IF NOT EXISTS `oc_customer_ban_ip` (
`customer_ban_ip_id` int(11) NOT NULL,
`ip` varchar(40) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `oc_customer_ban_ip`
ADD PRIMARY KEY (`customer_ban_ip_id`),
ADD KEY `ip` (`ip`);

ALTER TABLE `oc_customer_ban_ip`
MODIFY `customer_ban_ip_id` int(11) NOT NULL AUTO_INCREMENT;

Newbie

Posts

Joined
Thu Dec 16, 2010 5:04 am

Post by tdprado » Wed Oct 07, 2015 10:16 pm

Yes, I have received similar errors and have just spent all day going back to 2.0.3.1
This will be a nightmare for all the inexperienced OC users like myself.
I still like the software, just not the bugs.

Newbie

Posts

Joined
Fri Jun 19, 2015 7:48 am

Post by ebmarques » Thu Oct 08, 2015 3:26 am

The same with me. >:D
My store is down, my Website is down.
I am so mad with OpenCart!!! Amateurs!!! It is unacceptable to release a new version without testing!!!
In spite of hiring someone to fix it I will move to WordPress with an Ecommerce plugin.
BYE BYE OpenCart!!!

User avatar
Newbie

Posts

Joined
Tue Nov 22, 2011 3:45 am

Post by IP_CAM » Thu Oct 08, 2015 7:13 am

I tried it the Fast Draw Way, by uploading and overwriting all existing OC v.2.1.0.0 files with v.2.1.0.2_rc files, with the exeption of the both config.php files. The result, and a rather NEWBIE TYPE DB addition, but at least, it worked error free, after all. Would I have looked here before, finding all this nice DB ROUTINES, I would have saved some time!

Therefore, I would not recommend someone to do the same as I did, without a clean install process, it won't work, exept, one ADD's the DB-Sections, what is shown ABOVE, before one tests a Shop for function!
Ernie
Last edited by IP_CAM on Thu Oct 15, 2015 4:10 am, edited 3 times in total.

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by straightlight » Thu Oct 08, 2015 8:24 am

A safer method, for testing purposes, would be by simply create the database from cPanel / Plesk and run the SQL file or queries as such from the SQL tab under PHPMyAdmin. This is how I used to handle all my upgrades whenever the install CLI failed due on too many queries applied on the browser ending with 30 seconds maximum time reached error.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by mRC » Thu Oct 08, 2015 6:23 pm

I have updated and added / moded the table but getting the following

Code: Select all

2015-10-08 6:20:46 - PHP Notice:  Error: Unknown column 'name' in 'order clause'<br />Error No: 1054<br />SELECT * FROM `oc_api` ORDER BY name ASC in /data/17/0/108/1/760979/user/778219/htdocs/fonetools/system/library/db/mysqli.php on line 41
2015-10-08 6:20:46 - PHP Notice:  Trying to get property of non-object in /data/17/0/108/1/760979/user/778219/htdocs/fonetools/admin/model/user/api.php on line 77
2015-10-08 6:20:46 - PHP Warning:  Invalid argument supplied for foreach() in /data/17/0/108/1/760979/user/778219/htdocs/fonetools/admin/view/template/setting/setting.tpl on line 820
any help please

mRC
Active Member

Posts

Joined
Wed Nov 12, 2014 12:43 am

Post by mRC » Thu Oct 08, 2015 7:01 pm

I think I have fixed the other issues just the following now

Code: Select all

2015-10-08 7:00:41 - PHP Warning:  vsprintf() [<a href='function.vsprintf'>function.vsprintf</a>]: Too few arguments in /data/17/0/108/1/760979/user/778219/htdocs/fonetools/admin/controller/dashboard/activity.php on line 19
I only get this error when going to admin and activity

mRC
Active Member

Posts

Joined
Wed Nov 12, 2014 12:43 am

Post by fringi » Thu Oct 08, 2015 10:39 pm

mRC wrote:I think I have fixed the other issues just the following now

Code: Select all

2015-10-08 7:00:41 - PHP Warning:  vsprintf() [<a href='function.vsprintf'>function.vsprintf</a>]: Too few arguments in /data/17/0/108/1/760979/user/778219/htdocs/fonetools/admin/controller/dashboard/activity.php on line 19
I only get this error when going to admin and activity
The easyest way to fix this, is to empty your customer_activity table of your database.
The way the data is saved inside this table is different now, so is the way they handle the data and this causes the error.
Hope this is a possible solution for you.

Newbie

Posts

Joined
Tue Feb 17, 2015 5:57 pm
Location - Germany

Post by mRC » Thu Oct 08, 2015 11:30 pm

Thanks very much that's solved it O0

mRC
Active Member

Posts

Joined
Wed Nov 12, 2014 12:43 am

Post by Vetroff » Fri Oct 09, 2015 12:50 am

Just need to create a SQL query from installation opencart.sql in database with phpmyadmin etc.

Code: Select all

CREATE TABLE `oc_cart` (
  `cart_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `session_id` varchar(32) NOT NULL,
  `product_id` int(11) NOT NULL,
  `recurring_id` int(11) NOT NULL,
  `option` text NOT NULL,
  `quantity` int(5) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`cart_id`),
  KEY `cart_id` (`customer_id`,`session_id`,`product_id`,`recurring_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

User avatar
Newbie

Posts

Joined
Tue Apr 27, 2010 4:19 am
Location - Odessa, UA

Post by IP_CAM » Fri Oct 09, 2015 1:55 am

Well done! I would have been glad, to have such a 'complete' routine, to solve my problems in a minute!!
Buit I am not a (real) Coder, and won't be one ever... :D
----
ENGINE=InnoDB
Just to remind the Folks around here, BY DEFAULT, InnoDB is NOT used as DB Engine, by OC DEFAULT,
the MyISAM DB Engine is used instead. Also, an OC DB can be 'filled' with Tables/Sections, driven by DIFFERENT DB-Engines, as well, depending on how a Table has been created/defined, by Mod's or Extensions, like, with the Routine, as shown above!
----
As a Consequence, after a While, a OC DB will contain multiple Tables/Sections, where NOT the Default
MyISAM DB Server Engine handle's the Task/Operation, but a (believed to still be slightly more v.2. efficient)
InnoDB Server DB Engine, or even something else (but unfamiliar to me)!

BUT such DOING has, at BEST, a negative Effect on overall DB Performance, by the need to switch engines,
several times, to possibly 'handle' some different Sections/Tables, related to a 'Task'. I therefore advise
to use the legendary ATOMIX TURBO PHP File, to:

1. SET ALL TABLES TO InnoDB, it's a very efficient and rock-solid way, to 'drive/use/handle' a DB.
2. FULL INDEX ALL OC DB TABLES to speed up overall Performance. Also includes all those Tables,
placed by Extensions and/or not indexed by Default already ! It was/is especially highly important on
v.1.5.6.x Versions to increase Performance to a decent level.
----
The File works widely independent from OC, it therefore just requires to be
placed within the OC Directory and be called by

Code: Select all

http://yourshop.com/shop/turbo.php
http://forum.opencart.com/viewtopic.php?f=173&t=151371
Works for ALL OC Versions! And should be used, after any NEW DB-related Extensions have been installed,
to keep the DB handled SWELL at all times! NO INSTALLATION required, just upload it and call it!
Just to mention it! ;)
Good Luck
Ernie
openshop.li/shop/
Last edited by IP_CAM on Fri Oct 09, 2015 2:39 am, edited 2 times in total.

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by Qphoria » Fri Oct 09, 2015 2:38 am

ebmarques wrote:The same with me. >:D
My store is down, my Website is down.
I am so mad with OpenCart!!! Amateurs!!! It is unacceptable to release a new version without testing!!!
In spite of hiring someone to fix it I will move to WordPress with an Ecommerce plugin.
BYE BYE OpenCart!!!
It's just amateur to to blindly update your live site with a bleeding edge version for no reason.

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by IP_CAM » Fri Oct 09, 2015 2:51 am

this may be so, but it's the easiest way, to find out, what changed! :D
All those poor Fellows ... ^-^
BUT if one keeps the former Version on another sub, just waiting to be renamed again,
with it's own DB-Copy, by Nature of things, it's always worth the Task.
At least, if one looks at it as a Game, like me! ;)

But, to be honest, the exact Contrary is the Case, because the people expect, to have
a Microsoft LIKE Product in Front of them, with automatic 'whatever'. And as long as the
Product is believed to be a Turn-key Upload-Use Object, it will be handled accordingly.
With all the Results, related to, obviously.

Looking at it from this point, it's rather reasonable, trying to find out, by attempt,
what goes wrong. At least, so I understud one on the Postings above, where the fellow
was confronted with exactly the same errors, as I found.

But, in Contrary to most of you, I have all the time in the world, to try such,
for the only reason, to find out and possibly publish it , hooked on 1.5.6.5, by default ::)
It may help here and there, a little...
Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by postcardcollecting » Fri Oct 09, 2015 3:48 am

Hi Vetroff ..
I ran your SQL and it took away some of the errors but caused other problems
I no longer have anything showing on the Home Page. (products, etc) only the header and cats with the links at bottom show now ... plus a new error in the store settings area
I am just wondering if I should just start all over with a new installation since I began one day with the previous version and the next day the new version came out with the upgrade and that's when it all happened
I am just not sure if OC has addressed the issue or the issue only lies with upgrading
Can anyone offer a suggestion. I really could start all over ... it's no biggie !
___________________________________________________________________________
Notice: Error: Unknown column 'name' in 'order clause'
Error No: 1054
SELECT * FROM `oc_api` ORDER BY name ASC in /home/checkout/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/checkout/public_html/admin/model/user/api.php on line 77
_____________________________________________________________________________
Vetroff wrote:Just need to create a SQL query from installation opencart.sql in database with phpmyadmin etc.

Code: Select all

CREATE TABLE `oc_cart` (
  `cart_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `session_id` varchar(32) NOT NULL,
  `product_id` int(11) NOT NULL,
  `recurring_id` int(11) NOT NULL,
  `option` text NOT NULL,
  `quantity` int(5) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`cart_id`),
  KEY `cart_id` (`customer_id`,`session_id`,`product_id`,`recurring_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

http://www.postcardcollecting.com
http://www.aboardnoahsark.com



Posts

Joined
Mon Aug 06, 2012 11:30 pm


Post by froschgift » Fri Oct 09, 2015 3:56 am

So there is no way at the moment to upgrade from 2.0.3.1 to 2.1.0.1 without completly wipe out your store... That's great work OC team... LOL O0

Newbie

Posts

Joined
Sat May 30, 2015 4:16 am

Post by IP_CAM » Fri Oct 09, 2015 4:13 am

better, it just makes absolutely NO SENSE, to UPDATE an officially so
announced TEST Shop Software, obviously already been used by SOME ??? as LIVE SHOP.
It does not even make sense, to use a v.2.1.x as FINAL SHOP Solution.
That's, what it is. No offense, just information. ;)
Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by froschgift » Fri Oct 09, 2015 4:21 am

I just created a clone of my productive 2.0.3.1 version and did the upgrade.

It's just LOL I can't even log in with my admin account. It seems there is no connection to the database anymore... wrong template in frontend, no products shown and admin user pw not known. (I DID SAVE MY config.php's :) ).

This is so fucked up...

So I got this shit:

Check Attachement
Bildschirmfoto 2015-10-08 um 22.32.10.png

Bildschirmfoto 2015-10-08 um 22.32.10.png (84.58 KiB) Viewed 20296 times

Anyone knows whats wrong here?

Newbie

Posts

Joined
Sat May 30, 2015 4:16 am
Who is online

Users browsing this forum: No registered users and 29 guests