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


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

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

Image
- - - OpenCart Upgrade Service - - -


User avatar
Active Member

Posts

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

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


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

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 ;

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

Image
- - - OpenCart Upgrade Service - - -


User avatar
Active Member

Posts

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

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?

Newbie

Posts

Joined
Mon Aug 11, 2014 5:04 pm

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);

Image
- - - OpenCart Upgrade Service - - -


User avatar
Active Member

Posts

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

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?

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.

New member

Posts

Joined
Mon Jul 14, 2014 11:36 pm

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


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.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

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

New member

Posts

Joined
Fri Jun 22, 2012 5:28 am

Post by pm-netti » Mon Dec 08, 2014 9:22 pm

oberheimer wrote:Hello i get this error when i log into admin. I have just upgraded so
http://forum.opencart.com/viewtopic.php ... 97#p530983

Image
- - - OpenCart Upgrade Service - - -


User avatar
Active Member

Posts

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

Users browsing this forum: No registered users and 7 guests