SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db0006045844.pwk_sequence' doesn't exist


(Rene) #1

Hey Guys,

how could i fix this?

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘db0006045844.pwk_sequence’ doesn’t exist

Best René


(Kuba Bomba) #2

You have to recreate this table. It stores the max idarchive for each of the archive_numberic tables. What happened with this table? Did you maybe remove it?

In your case there should be such records:
name = pwk_archive_numeric_2016_01, value = max idarchive from pwk_archive_numeric_2016_01 table

Table schema:

CREATE TABLE `pwk_sequence` (
  `name` varchar(120) NOT NULL,
  `value` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`name`)
);

But of course my recommendation is to recover this table from a backup.


(Rene) #3

I dont know why the table is gone. I have not delete the table.

thx for help.