SmartCJ Support Forum

Code: Select all

Mysql error:: 1146 (Table 'example_scj.admin_access_log' doesn't exist) (db_link) in query select ip from admin_access_log where date > '2014-02-06 00:00:00' order by date desc. (example.com) Mysql error:: 1146 (Table 'example_scj.admin_access_log' doesn't exist) (db_link) in query insert into admin_access_log (ip, date) values ('1602617883', '2014-02-06 09:12:56'). (example.com) 

Code: Select all

CREATE TABLE IF NOT EXISTS `admin_access_log` (
  `ip` bigint(20) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;