Title: lebear's Replies | WordPress.org

---

# lebear

  [  ](https://wordpress.org/support/users/lebear/)

 *   [Profile](https://wordpress.org/support/users/lebear/)
 *   [Topics Started](https://wordpress.org/support/users/lebear/topics/)
 *   [Replies Created](https://wordpress.org/support/users/lebear/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/lebear/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/lebear/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/lebear/engagements/)
 *   [Favorites](https://wordpress.org/support/users/lebear/favorites/)

 Search replies:

## Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[wpForo Forum] Topic Add Error](https://wordpress.org/support/topic/topic-add-error/)
 *  [lebear](https://wordpress.org/support/users/lebear/)
 * (@lebear)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/topic-add-error/page/2/#post-8799470)
 *     ```
       CREATE TABLE IF NOT EXISTS wp_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) unsigned NOT NULL DEFAULT '0',
          order int(10) unsigned NOT NULL DEFAULT '0',
          PRIMARY KEY (forumid),
          UNIQUE KEY UNIQUE SLUG (slug(191)) 
       ) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
       ```
   
 *  **Error Code: 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
   int(10) unsigned NOT NULL DEFAULT ‘0’, PRIMARY KEY (forumid), UNIQUE’ at line
   20 0.063 sec**
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[wpForo Forum] Topic Add Error](https://wordpress.org/support/topic/topic-add-error/)
 *  [lebear](https://wordpress.org/support/users/lebear/)
 * (@lebear)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/topic-add-error/page/2/#post-8799454)
 * sorry, I don’t understand why this is flagged as being solved, while it’s clearly
   NOT. [@hide1825](https://wordpress.org/support/users/hide1825/) has not been 
   answered to since 2 weeks. I have the very same problem and can point you exactly
   to mysql error. You are using RESERVED WORDS as COLUMNS NAMES! How do you expect
   this to work?

Viewing 2 replies - 1 through 2 (of 2 total)