Sign in to follow this  
fisnik

Fatal error: Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table

Recommended Posts

Does anyone know why i am getting this error on some site today, no changes were made?

 

 

Error: Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table '%%.sessions' doesn't exist (in wire/core/WireDatabasePDO.php line 454)

#0 wire/core/WireDatabasePDO.php(454): PDOStatement->execute()
#1 wire/modules/Session/SessionHandlerDB/SessionHandlerDB.module(74): WireDatabasePDO->execute(Object(PDOStatement))
#2 [internal function]: SessionHandlerDB->read('vvvciffpban8u80...')
#3 wire/core/Session.php(267): session_start()
#4 Wire.php(380): Session->___init()
#5 wire/core/WireHooks.php(698): Wire->_callMethod('___init', Array)
#6 wire/core/Wire.php(442): WireHooks->runHooks(Object(Session), 'init', Array)
#7 wire/core/Session.php(166): Wire->__call('init', Array)
#8 /wire/core/Session.php(166): Session->init()
#9 public_html/w

 

Share this post


Link to post
Share on other sites
7 hours ago, fisnik said:

Session

[%%.sessions] Error: Table '%%.sessions' doesn't exist
[%%.sessions] status: Operation failed

I dont know why this happend but i also cannot create new tabel with name "sessions" on same database.

Workaround:

I did create new database, imported old one (sessions does not exist here)

then i run:

CREATE TABLE `sessions` (
  `data` mediumtext NOT NULL,
  `id` int(11) NOT NULL,
  `ip` varchar(256) NOT NULL,
  `pages_id` varchar(256) NOT NULL,
  `ts` varchar(256) NOT NULL,
  `ua` varchar(256) NOT NULL,
  `user_id` varchar(256) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.