OpenCart 2.0 upgrade issue

Post Reply

11 posts Page 1 of 1

kestas

Active Member

Posts

1021

Joined

Tue Oct 12, 2010 2:23 am

Post by kestas » Fri Oct 03, 2014 2:33 pm

Hello,

Seems some tables in DB are not creating during upgrade from 1.5.x to 2.0
event table are not created. location table are not created...
I got this erors:
in admin:
Notice: Error: Table 'xxxx.location' doesn't exist
Error No: 1146

in front end:
Notice: Error: Table 'xxxx.event' doesn't exist
Error No: 1146

where is the problems?

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

kestas

Active Member

Posts

1021

Joined

Tue Oct 12, 2010 2:23 am

Re: OpenCart 2.0 BUG Topic

pm-netti

Active Member

Posts

1089

Joined

Sat Apr 07, 2012 11:22 pm

Location

Kittilä, Finland

Post by pm-netti » Fri Oct 03, 2014 5:40 pm

kestas wrote:Hello,

Seems some tables in DB are not creating during upgrade from 1.5.x to 2.0
event table are not created. location table are not created...
I got this erors:
in admin:
Notice: Error: Table 'xxxx.location' doesn't exist
Error No: 1146

in front end:
Notice: Error: Table 'xxxx.event' doesn't exist
Error No: 1146

where is the problems?

The database does not have tables "location" and "event".

Create file etc. kestas.sql.

Copy and paste opencart.sql these lines to file kestas.sql:
1-9
107-120
1267-1290
1641-1659
1711-1743
2745-2777
3214-3226

Load this kestas.sql-file to database in Phpmyadmin

pm-netti

Active Member

Posts

1089

Joined

Sat Apr 07, 2012 11:22 pm

Location - Kittilä, Finland

Re: OpenCart 2.0 BUG Topic

kestas

Active Member

Posts

1021

Joined

Tue Oct 12, 2010 2:23 am

Post by kestas » Fri Oct 03, 2014 7:24 pm

pm-netti wrote:
kestas wrote:Hello,

Seems some tables in DB are not creating during upgrade from 1.5.x to 2.0
event table are not created. location table are not created...
I got this erors:
in admin:
Notice: Error: Table 'xxxx.location' doesn't exist
Error No: 1146

in front end:
Notice: Error: Table 'xxxx.event' doesn't exist
Error No: 1146

where is the problems?
The database does not have tables "location" and "event".

Create file etc. kestas.sql.

Copy and paste opencart.sql these lines to file kestas.sql:
1-9
107-120
1267-1290
1641-1659
1711-1743
2745-2777
3214-3226

Load this kestas.sql-file to database in Phpmyadmin

I make all you said and in admin geting the same error:
Notice: Error: Table xxxx.location' doesn't exist
Error No: 1146

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

kestas

Active Member

Posts

1021

Joined

Tue Oct 12, 2010 2:23 am

Re: OpenCart 2.0 upgrade issue

pm-netti

Active Member

Posts

1089

Joined

Sat Apr 07, 2012 11:22 pm

Location

Kittilä, Finland

Post by pm-netti » Fri Oct 03, 2014 10:31 pm

Notice: Error: Table 'xxxx.location' doesn't exist
Error No: 1146

Copy and paste yet these opencart.sql file lines 1641-1659 to file kestas.sql and load again:

Code: Select all

--
-- Table structure for table `oc_location`
--

CREATE TABLE IF NOT EXISTS `oc_location` (
  `location_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `address` text NOT NULL,
  `telephone` varchar(32) NOT NULL,
  `fax` varchar(32) NOT NULL,
  `geocode` varchar(32) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `open` text NOT NULL,
  `comment` text NOT NULL,
  PRIMARY KEY (`location_id`),
  KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

pm-netti

Active Member

Posts

1089

Joined

Sat Apr 07, 2012 11:22 pm

Location - Kittilä, Finland

Re: OpenCart 2.0 upgrade issue

ljstorage

Newbie

Posts

Joined

Mon Aug 11, 2014 5:04 pm

Post by ljstorage » Sat Oct 04, 2014 2:35 am

Hi,

Thanks for that. It worked (I had to remove the "oc_" for it to work) BUT I'm now receiving the below error in my admin panel

Code: Select all

Warning: implode() [function.implode]: Invalid arguments passed in /mysite/store/admin/controller/common/header.php on line 58Warning: implode() [function.implode]: Invalid arguments passed in /mysite/store/admin/controller/common/header.php on line 59Warning: implode() [function.implode]: Invalid arguments passed in /mysite/store/admin/controller/common/header.php on line 62Warning: implode() [function.implode]: Invalid arguments passed in /mysite/store/admin/controller/common/header.php on line 63Notice: Undefined index: image in /mysite/store/admin/controller/common/profile.php on line 19Warning: implode() [function.implode]: Invalid arguments passed in /mysite/store/admin/controller/common/stats.php on line 14Warning: implode() [function.implode]: Invalid arguments passed in /mysite/store/admin/controller/common/stats.php on line 22Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /mysite/store/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in /mysite/store/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /mysite/store/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in /mysite/store/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /mysite/store/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in /mysite/store/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /mysite/store/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in /mysite/store/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /mysite/store/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in /mysite/store/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /mysite/store/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in /mysite/store/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /mysite/store/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in /mysite/store/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /mysite/store/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in /mysite/store/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /mysite/store/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in /mysite/store/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /mysite/store/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in /mysite/store/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /mysite/store/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in /mysite/store/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /mysite/store/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in /mysite/store/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /mysite/store/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in /mysite/store/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /mysite/store/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in /mysite/store/admin/controller/common/stats.php on line 37Notice: Error: Table 'ljstorage.customer_activity' doesn't exist
Error No: 1146
SELECT a.key, a.data, a.date_added FROM ((SELECT CONCAT('customer_', ca.key) AS `key`, ca.data, ca.date_added FROM `customer_activity` ca) UNION (SELECT CONCAT('affiliate_', aa.key) AS `key`, aa.data, aa.date_added FROM `affiliate_activity` aa)) a ORDER BY a.date_added DESC LIMIT 0,5 in /mysite/store/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /mysite/store/admin/model/report/activity.php on line 6Warning: Invalid argument supplied for foreach() in /mysite/store/admin/controller/dashboard/activity.php on line 18

Can anyone help?

ljstorage

Newbie

Posts

Joined

Mon Aug 11, 2014 5:04 pm

Re: OpenCart 2.0 upgrade issue

pm-netti

Active Member

Posts

1089

Joined

Sat Apr 07, 2012 11:22 pm

Location

Kittilä, Finland

Post by pm-netti » Sat Oct 04, 2014 2:56 am

ljstorage wrote:Hi,

Can anyone help?

You add these lines you "ljstorage.sql" file and load to database

Code: Select all

INSERT INTO `setting` (`setting_id`, `store_id`, `group`, `key`, `value`, `serialized`) VALUES
(218, 0, 'config', 'config_processing_status', 'a:1:{i:0;s:1:"2";}', 1),
(219, 0, 'config', 'config_complete_status', 'a:1:{i:0;s:1:"5";}', 1);

pm-netti

Active Member

Posts

1089

Joined

Sat Apr 07, 2012 11:22 pm

Location - Kittilä, Finland

Re: OpenCart 2.0 upgrade issue

imashiine

New member

Posts

Joined

Mon Jul 14, 2014 11:36 pm

Post by imashiine » Mon Oct 27, 2014 8:00 am

on my admin login page, after i enter my username and password, i get a white page that has this on it

Notice: Error: Table 'prosoundz.event' doesn't exist
Error No: 1146
Error in: /home/content/92/10760092/html/admin/index.php line 148
SELECT * FROM event in /home/content/92/10760092/html/system/library/db/mysql.php on line 53Notice: Trying to get property of non-object in /home/content/92/10760092/html/admin/index.php on line 150Warning: Invalid argument supplied for foreach() in /home/content/92/10760092/html/admin/index.php on line 150Warning: Cannot modify header information - headers already sent by (output started at /home/content/92/10760092/html/admin/index.php:80) in /home/content/92/10760092/html/system/library/response.php on line 12

how do i fix it?

imashiine

New member

Posts

Joined

Mon Jul 14, 2014 11:36 pm

Re: OpenCart 2.0 upgrade issue

imashiine

New member

Posts

Joined

Mon Jul 14, 2014 11:36 pm

Post by imashiine » Mon Oct 27, 2014 8:32 am

pm-netti wrote:
ljstorage wrote:Hi,

Can anyone help?
You add these lines you "ljstorage.sql" file and load to database
Code: Select all
INSERT INTO `setting` (`setting_id`, `store_id`, `group`, `key`, `value`, `serialized`) VALUES
(218, 0, 'config', 'config_processing_status', 'a:1:{i:0;s:1:"2";}', 1),
(219, 0, 'config', 'config_complete_status', 'a:1:{i:0;s:1:"5";}', 1);

im having the first issue he had can you help me.

imashiine

New member

Posts

Joined

Mon Jul 14, 2014 11:36 pm

Re: OpenCart 2.0 upgrade issue

i2Paq

Global Moderator

Posts

12244

Joined

Mon Nov 09, 2009 7:00 pm

Location

Winkel - The Netherlands

Post by i2Paq » Mon Oct 27, 2014 6:05 pm

http://forum.opencart.com/viewtopic.php?f=181&t=132270

Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.

i2Paq

Global Moderator

Posts

12244

Joined

Mon Nov 09, 2009 7:00 pm

Location - Winkel - The Netherlands

Re: OpenCart 2.0 upgrade issue

oberheimer

New member

Posts

Joined

Fri Jun 22, 2012 5:28 am

Post by oberheimer » Mon Dec 08, 2014 9:14 pm

Hello i get this error when i log into admin. I have just upgraded so

Warning: implode() [function.implode]: Invalid arguments passed in xxxx/admin/controller/common/header.php on line 58Warning: implode() [function.implode]: Invalid arguments passed in xxxx/admin/controller/common/header.php on line 59Warning: implode() [function.implode]: Invalid arguments passed in xxxx/admin/controller/common/header.php on line 62Warning: implode() [function.implode]: Invalid arguments passed in xxxx/admin/controller/common/header.php on line 63Warning: implode() [function.implode]: Invalid arguments passed in xxxx/admin/controller/common/stats.php on line 14Warning: implode() [function.implode]: Invalid arguments passed in xxxx/admin/controller/common/stats.php on line 22Warning: array_merge() [function.array-merge]: Argument #1 is not an array in xxxx/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in xxxx/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in xxxx/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in xxxx/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in xxxx/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in xxxx/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in xxxx/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in xxxx/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in xxxx/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in xxxx/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in xxxx/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in xxxx/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in xxxx/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in xxxx/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in xxxx/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in xxxx/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in xxxx/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in xxxx/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in xxxx/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in xxxx/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in xxxx/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in xxxx/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in xxxx/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in xxxx/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in xxxx/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in xxxx/admin/controller/common/stats.php on line 37Warning: array_merge() [function.array-merge]: Argument #1 is not an array in xxxx/admin/controller/common/stats.php on line 37Warning: in_array() expects parameter 2 to be array, null given in xxxx/admin/controller/common/stats.php on line 37

oberheimer

New member

Posts

Joined

Fri Jun 22, 2012 5:28 am