Version 1.9 – Server Error 503

I have also the same problem

here is what I got,
———————————————————-
Problems Found in Database
Table name _____________________ Problem description
Table: wplo_wpforo_logs ________ Doesn’t exists
———————————————————-

and the [Solve database problems] button doesn’t solve the issues as well

I tried creating the table with the script as below

SET AUTOCOMMIT = 0;
CREATE TABLE IF NOT EXISTS wplo_wpforo_logs(
logid BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
sessionid VARCHAR (255) NOT NULL,
key VARCHAR (255) NOT NULL,
value MEDIUMTEXT NOT NULL,
PRIMARY KEY (logid),
KEY sessionid_key (sessionid, key)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

SET AUTOCOMMIT = 1;

but,

MySQL said:
#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 ‘SET
AUTOCOMMIT = 1’ at line 8

FYI, my hosting provides MyISAM type of the DBMS, while in script is InnoDB

I tried change InnoDB with MyISAM, but there again the message as above (#1064)

ps.
deactivating and deleting and then installing the wpForo doesn’t help.

• This reply was modified 2 years, 5 months ago by formviewflow.
• This reply was modified 2 years, 5 months ago by formviewflow.

as you suggested, but still have some errors:

Error
Static analysis:

3 errors were found during analysis.

A comma or a closing bracket was expected. (near “NOT NULL” at position 147)
Unexpected beginning of statement. (near “logid” at position 199)
Unrecognized statement type. (near “KEY” at position 208)
SQL query:

CREATE TABLE IF NOT EXISTS wplo_wpforo_logs( logid BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, sessionid VARCHAR (255) NOT NULL, key VARCHAR (255) NOT NULL, value MEDIUMTEXT NOT NULL, PRIMARY KEY (logid), KEY sessionid_key (sessionid, key) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

MySQL said: Documentation

#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 ‘VARCHAR (255) NOT NULL,
value MEDIUMTEXT NOT NULL,
PRIMARY KEY (logid),
KE…’ at line 4

I tried also with this variation:

SQL query:

CREATE TABLE IF NOT EXISTS wplo_wpforo_logs(
logid BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
sessionid VARCHAR (255) NOT NULL,
key VARCHAR (255) NOT NULL,
value MEDIUMTEXT NOT NULL,
PRIMARY KEY (logid),
KEY sessionid_key (sessionid, key)
) ENGINE=INNODB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

MySQL said: n
#1071 – Specified key was too long; max key length is 1000 bytes

very well, @blackraz
succeeded in creating the log table

there are minor warnings:
Warning: #1286 Unknown storage engine ‘InnoDB’
Warning: #1266 Using storage engine MyISAM for table ‘wplo_wpforo_logs’

now in Debug –> Table tab just show ” No Problems Found in Database ”

thank you for your kind help on this.

• This reply was modified 2 years, 5 months ago by formviewflow.
• This reply was modified 2 years, 5 months ago by formviewflow.