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
Regards / Tissy
Logo Printed / Embroidered T-Shirts
Polo Shirts, Sweatshirts & Hoodies
http://www.tmart.in
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
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;
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!!!
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
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.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
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
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
The easyest way to fix this, is to empty your customer_activity table of your database.mRC wrote:I think I have fixed the other issues just the following now
I only get this error when going to admin and activityCode: 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
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.
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;
Buit I am not a (real) Coder, and won't be one ever...
----
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
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/
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.
It's just amateur to to blindly update your live site with a bleeding edge version for no reason.ebmarques wrote:The same with me.
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!!!
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.
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
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.
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 Anyone knows whats wrong here?
Users browsing this forum: No registered users and 29 guests