Post by begonya » Wed Aug 23, 2017 1:06 am

Hi everybody.
I tried to upgrade 2.3.0.2 to 3.0 but the error. I don't have a sql backup but i have a full site backup. I need help:
-----
Fatal error: Uncaught exception 'Exception' with message 'Error: Table 'begonya_db.session' doesn't exist<br />Error No: 1146<br />SELECT `data` FROM `session` WHERE session_id = 'c41a1c893acad8af69dd7a2f03' AND expire > 1503432386' in /home/begonya/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/begonya/public_html/system/library/db.php(45): DB\MySQLi->query('SELECT `data` F...') #1 /home/begonya/public_html/system/library/session/db.php(21): DB->query('SELECT `data` F...') #2 /home/begonya/public_html/system/library/session.php(72): Session\DB->read('c41a1c893acad8a...') #3 /home/begonya/public_html/system/framework.php(106): Session->start('') #4 /home/begonya/public_html/system/startup.php(104): require_once('/home/begonya/p...') #5 /home/begonya/public_html/index.php(19): start('catalog') #6 {main} thrown in /home/begonya/public_html/system/library/db/mysqli.php on line 40

Fatal error: Uncaught exception 'Exception' with message 'Error: Table 'begonya_db.session' doesn't exist<br />Error No: 1146<br />REPLACE INTO `session` SET session_id = 'c41a1c893acad8af69dd7a2f03', `data` = '[]', expire = '2017-08-22 21:06:26'' in /home/begonya/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/begonya/public_html/system/library/db.php(45): DB\MySQLi->query('REPLACE INTO `s...') #1 /home/begonya/public_html/system/library/session/db.php(32): DB->query('REPLACE INTO `s...') #2 /home/begonya/public_html/system/library/session.php(81): Session\DB->write('c41a1c893acad8a...', Array) #3 [internal function]: Session->close() #4 {main} thrown in /home/begonya/public_html/system/library/db/mysqli.php on line 40
---

Newbie

Posts

Joined
Wed Aug 23, 2017 1:00 am

Post by pm-netti » Thu Aug 24, 2017 3:00 pm

Hi

Your missing table session:

Code: Select all

CREATE TABLE `session` (
  `session_id` varchar(32) NOT NULL,
  `data` text NOT NULL,
  `expire` datetime NOT NULL,
  PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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 225 guests