Forum Replies Created

Viewing 1 replies (of 1 total)
  • Hi,
    I am facing the same issue. I have checked MySQL version is 5.6.34 that I am now using. I tried pasting the code into my phpAdmin but it vomited syntax errors at line 20.

    *I have replaced all of the prefix to wpwq_ that is being used in my db.

    Here is the error message :
    Error
    SQL query:

    CREATE TABLE IF NOT EXISTS wpwq_wpforo_forums ( forumid int(10) unsigned NOT NULL AUTO_INCREMENT, title varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, slug varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, description longtext COLLATE utf8mb4_unicode_ci, parentid int(10) unsigned NOT NULL DEFAULT ‘0’, icon varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, last_topicid int(10) unsigned NOT NULL DEFAULT ‘0’, last_postid int(10) unsigned NOT NULL DEFAULT ‘0’, last_userid int(10) unsigned NOT NULL DEFAULT ‘0’, last_post_date datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, topics int(11) NOT NULL DEFAULT ‘0’, posts int(11) NOT NULL DEFAULT ‘0’, permissions text COLLATE utf8mb4_unicode_ci, meta_key text COLLATE utf8mb4_unicode_ci, meta_desc text COLLATE utf8mb4_unicode_ci, status tinyint(1) unsigned NOT NULL DEFAULT ‘0’, is_cat tinyint(1) unsigned NOT NULL DEFAULT ‘0’, cat_layout tinyint(1) […]

    MySQL said: Documentation

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘order by int(10) unsigned NOT NULL DEFAULT ‘0’,
    PRIMARY KEY (forumid),
    ‘ at line 20

    Thank you.

Viewing 1 replies (of 1 total)