Page 1 of 1

Errors in Admin after upgrading to 2.1

Posted: Fri Oct 09, 2015 7:25 am
by JozaCRO
I got this warning after updating to 2.1.0.1

Warning: vsprintf(): Too few arguments in /home/123456/public_html/admin/controller/dashboard/activity.php on line 19

Code: Select all

		foreach ($results as $result) {
			$comment = vsprintf($this->language->get('text_' . $result['key']), json_decode($result['data'], true));
When I want to config my website I get these errors:

Code: Select all

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

I went to the install folder and searched oc_api in the sql file and added this in mysql:

Code: Select all

DROP TABLE IF EXISTS `oc_api`;
CREATE TABLE `oc_api` (
  `api_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `key` text NOT NULL,
  `status` tinyint(1) NOT NULL,
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  PRIMARY KEY (`api_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
It worked and the error went away. But I wonder how many other tables did not got dropped correctly... ::) ::)
Anyone can help?

Thank you.

Re: Errors in Admin after upgrading to 2.1

Posted: Sun Oct 11, 2015 4:36 pm
by garry-b
THIS FIXES THIS
Warning: vsprintf(): Too few arguments in /home/123456/public_html/admin/controller/dashboard/activity.php on line 19

use phpmyadmin and upload this to your shop sql
it deletes and re-createS the tables for activity

DROP TABLE IF EXISTS `oc_customer_activity`;
CREATE TABLE `oc_customer_activity` (
`activity_id` int(11) NOT NULL AUTO_INCREMENT,
`customer_id` int(11) NOT NULL,
`key` varchar(64) NOT NULL,
`data` text NOT NULL,
`ip` varchar(40) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`activity_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;


WORKS NO ERRORS

Re: Errors in Admin after upgrading to 2.1

Posted: Fri Jan 29, 2016 9:11 pm
by alancheong
Hi there, its temporary fix it.

But after customer login, the error appear again. kindly advise.

Re: Errors in Admin after upgrading to 2.1

Posted: Sat Jan 30, 2016 8:32 am
by Randem
Hi JozaCRO,

If you used the default "upgrade" you need to re-do your conversion with this - http://www.randemsystems.com/support/op ... 9/#msg6199

Re: Errors in Admin after upgrading to 2.1

Posted: Sat Oct 08, 2016 11:02 pm
by huntbee
Go to PHPMYADMIN and Try truncate the data in customer_activity table and affiliate_activity table

Re: Errors in Admin after upgrading to 2.1

Posted: Sat Oct 08, 2016 11:57 pm
by EvolveWebHosting
Is there a reason you're not using v2.3.0.2? This is not only the latest release but it is actually quite stable (the best of the 2.x version IMO).

Re: Errors in Admin after upgrading to 2.1

Posted: Sun Apr 16, 2017 1:32 pm
by diswal
Truncating the tables as HuntBee suggested worked in my case.

The reason why I don't use OC 2.3 is that my payment solution so far does not support any higher than OC 2.1 :-(