I am not able to use latest version on xampp php 7.2 - neverending update, database check says that tables are missing, but update says it can't update because tables already exists. It started with featurebox (installed with installation), after unistalling, core tables have problem.
The reason is at the end, this is report.
Without debug mode:
Just to show how long is this:
It starts:
Update Unsuccessful [CREATE TABLE `e107_admin_log` (dblog_id int(10) unsigned NOT NULL auto_increment, dblog_datestamp int(10) unsigned NOT NULL default '0', dblog_microtime int(10) unsigned NOT NULL default '0', dblog_type tinyint(3) NOT NULL default '0', dblog_eventcode varchar(10) NOT NULL default '', dblog_user_id int(10) unsigned NOT NULL default '0', dblog_ip varchar(45) NOT NULL default '', dblog_title varchar(255) NOT NULL default '', dblog_remarks text NOT NULL, PRIMARY KEY (dblog_id), KEY dblog_datestamp (dblog_datestamp)) ENGINE=MyISAM;]
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'e107_admin_log' already exists
Update Unsuccessful [CREATE TABLE `e107_audit_log` (dblog_id int(10) unsigned NOT NULL auto_increment, dblog_datestamp int(10) unsigned NOT NULL default '0', dblog_microtime int(10) unsigned NOT NULL default '0', dblog_eventcode varchar(10) NOT NULL default '', dblog_user_id int(10) unsigned NOT NULL default '0', dblog_user_name varchar(100) NOT NULL default '', dblog_ip varchar(45) NOT NULL default '', dblog_title varchar(255) NOT NULL default '', dblog_remarks text NOT NULL, PRIMARY KEY (dblog_id), KEY dblog_datestamp (dblog_datestamp)) ENGINE=MyISAM;]
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'e107_audit_log' already exists
With debug mode:
Missing table on db-verify: admin_log
Missing table on db-verify: audit_log
Missing table on db-verify: banlist
Missing table on db-verify: comments
Missing table on db-verify: core
Missing table on db-verify: core_media
Missing table on db-verify: core_media_cat
Missing table on db-verify: cron
Missing table on db-verify: dblog
Missing table on db-verify: generic
Missing table on db-verify: links
Missing table on db-verify: mail_recipients
Missing table on db-verify: mail_content
Missing table on db-verify: menus
Missing table on db-verify: news
Missing table on db-verify: news_category
Missing table on db-verify: online
Missing table on db-verify: page
Missing table on db-verify: page_chapters
Missing table on db-verify: plugin
Missing table on db-verify: rate
Missing table on db-verify: submitnews
Missing table on db-verify: tmp
Missing table on db-verify: upload
Missing table on db-verify: user
Missing table on db-verify: userclass_classes
Missing table on db-verify: user_extended
Missing table on db-verify: user_extended_struct
Update required in update_routines.php on line 554 (Database Tables require updating: admin_log, audit_log, banlist, comments, core, core_media, core_media_cat, cron, dblog, generic, links, mail_recipients, mail_content, menus, news, news_category, online, page, page_chapters, plugin, rate, submitnews, tmp, upload, user, userclass_classes, user_extended, user_extended_struct)
Check database validity:
after attempt to fix:
Update Unsuccessful [CREATE TABLE e107_admin_log (dblog_id int(10) unsigned NOT NULL auto_increment, dblog_datestamp int(10) unsigned NOT NULL default '0', dblog_microtime int(10) unsigned NOT NULL default '0', dblog_type tinyint(3) NOT NULL default '0', dblog_eventcode varchar(10) NOT NULL default '', dblog_user_id int(10) unsigned NOT NULL default '0', dblog_ip varchar(45) NOT NULL default '', dblog_title varchar(255) NOT NULL default '', dblog_remarks text NOT NULL, PRIMARY KEY (dblog_id), KEY dblog_datestamp (dblog_datestamp)) ENGINE=MyISAM;]
SQL debug:
Array
(
[0] => Array
(
[file] => G:\php72\htdocs\e107-gaia\e107_handlers\mysql_class.php
[line] => 551
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] => SHOW TABLES FROM e107-gaia LIKE 'e107_%'
)
)
After using query directly in phpmyadmin:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-gaia LIKE 'e107_%'' at line 1
After changing the database to e107gaia - without dash, it works. No idea why this is a problem now, I used a database with dash on localhost very often.
The reason is at the end, this is report.
Without debug mode:
Just to show how long is this:
It starts:
With debug mode:
Check database validity:
after attempt to fix:
Update Unsuccessful [CREATE TABLEe107_admin_log(dblog_id int(10) unsigned NOT NULL auto_increment, dblog_datestamp int(10) unsigned NOT NULL default '0', dblog_microtime int(10) unsigned NOT NULL default '0', dblog_type tinyint(3) NOT NULL default '0', dblog_eventcode varchar(10) NOT NULL default '', dblog_user_id int(10) unsigned NOT NULL default '0', dblog_ip varchar(45) NOT NULL default '', dblog_title varchar(255) NOT NULL default '', dblog_remarks text NOT NULL, PRIMARY KEY (dblog_id), KEY dblog_datestamp (dblog_datestamp)) ENGINE=MyISAM;]SQL debug:
After using query directly in phpmyadmin:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-gaia LIKE 'e107_%'' at line 1After changing the database to e107gaia - without dash, it works. No idea why this is a problem now, I used a database with dash on localhost very often.