hide1825
Forum Replies Created
-
Forum: Plugins
In reply to: [wpForo Forum] Topic Add ErrorHi,
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 20Thank you.