Post by SEE » Mon Jun 25, 2018 1:37 am

I try to migrate an opencart on localhost and when I set up the shop, I made a new db. Now I Imported the db from Cpanel, but how and where do I confic on OC which db to use?

SEE
Newbie

Posts

Joined
Fri Jun 15, 2018 3:17 am

Post by kestas » Mon Jun 25, 2018 1:54 am

You need edit config.php and admin/config.php

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 kestas » Mon Jun 25, 2018 1:55 am

You need edit config.php and admin/config.php

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 SEE » Mon Jun 25, 2018 6:20 pm

Fatal error: Uncaught Exception: Error: Table 'oceanic_team.oc_session' doesn't exist<br />Error No: 1146<br />SELECT `data` FROM `oc_session` WHERE session_id = '9ca3fd848c6741b50e63c4e34b' AND expire > 1529921931 in C:\xampp\htdocs\content\system\library\db\mysqli.php:40 Stack trace: #0 C:\xampp\htdocs\content\system\library\db.php(45): DB\MySQLi->query('SELECT `data` F...') #1 C:\xampp\htdocs\content\system\library\session\db.php(21): DB->query('SELECT `data` F...') #2 C:\xampp\htdocs\content\system\library\session.php(72): Session\DB->read('9ca3fd848c6741b...') #3 C:\xampp\htdocs\content\system\framework.php(106): Session->start('9ca3fd848c6741b...') #4 C:\xampp\htdocs\content\system\startup.php(104): require_once('C:\\xampp\\htdocs...') #5 C:\xampp\htdocs\content\admin\index.php(19): start('admin') #6 {main} thrown in C:\xampp\htdocs\content\system\library\db\mysqli.php on line 40

Fatal error: Uncaught Exception: Error: Table 'oceanic_team.oc_session' doesn't exist<br />Error No: 1146<br />REPLACE INTO `oc_session` SET session_id = '9ca3fd848c6741b50e63c4e34b', `data` = '[]', expire = '2018-06-25 10:42:51' in C:\xampp\htdocs\content\system\library\db\mysqli.php:40 Stack trace: #0 C:\xampp\htdocs\content\system\library\db.php(45): DB\MySQLi->query('REPLACE INTO `o...') #1 C:\xampp\htdocs\content\system\library\session\db.php(32): DB->query('REPLACE INTO `o...') #2 C:\xampp\htdocs\content\system\library\session.php(81): Session\DB->write('9ca3fd848c6741b...', Array) #3 [internal function]: Session->close() #4 {main} thrown in C:\xampp\htdocs\content\system\library\db\mysqli.php on line 40



any clue ??

SEE
Newbie

Posts

Joined
Fri Jun 15, 2018 3:17 am

Post by paulfeakins » Mon Jun 25, 2018 7:26 pm

SEE wrote:
Mon Jun 25, 2018 6:20 pm
Table 'oceanic_team.oc_session' doesn't exist
There's your clue.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by SEE » Tue Jun 26, 2018 5:32 pm

what do you mean?
if you follow the chat we have here....
I uploaded the new db (oceanic_team), renamed the db in the old config.php, and the result is..it does not recognize it... so not very helpfull your answer, but thanks

SEE
Newbie

Posts

Joined
Fri Jun 15, 2018 3:17 am

Post by xxvirusxx » Tue Jun 26, 2018 5:52 pm

You changed database prefix from both configs?

From: oc_ to oceanic_ ?

Or...post a screnshoot from phpmyadmin database.

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România
Who is online

Users browsing this forum: No registered users and 222 guests