Forums

Unfortunately no one can be told what FluxBB is - you have to see it for yourself.

You are not logged in.

#1 2020-06-23 08:50:23

thetechguy
New member
Registered: 2020-06-23
Posts: 1

Unable to create table group when trying to install fluxbb.

Hi guys.
I have a server running ubuntu 20.04 with apache as the web server. When I try installing fluxbb, it gives me the error below.

An error was encountered
File: /install.php
Line: 940

FluxBB reported: Unable to create groups table

Database reported: 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 'groups ( g_id INT(10) UNSIGNED AUTO_INCREMENT NOT NULL, g_title VARCHAR(50) NOT ' at line 1 (Errno: 1064)

Failed query: CREATE TABLE groups ( g_id INT(10) UNSIGNED AUTO_INCREMENT NOT NULL, g_title VARCHAR(50) NOT NULL DEFAULT '', g_user_title VARCHAR(50), g_promote_min_posts INT(10) UNSIGNED NOT NULL DEFAULT 0, g_promote_next_group INT(10) UNSIGNED NOT NULL DEFAULT 0, g_moderator TINYINT(1) NOT NULL DEFAULT 0, g_mod_edit_users TINYINT(1) NOT NULL DEFAULT 0, g_mod_rename_users TINYINT(1) NOT NULL DEFAULT 0, g_mod_change_passwords TINYINT(1) NOT NULL DEFAULT 0, g_mod_ban_users TINYINT(1) NOT NULL DEFAULT 0, g_mod_promote_users TINYINT(1) NOT NULL DEFAULT 0, g_read_board TINYINT(1) NOT NULL DEFAULT 1, g_view_users TINYINT(1) NOT NULL DEFAULT 1, g_post_replies TINYINT(1) NOT NULL DEFAULT 1, g_post_topics TINYINT(1) NOT NULL DEFAULT 1, g_edit_posts TINYINT(1) NOT NULL DEFAULT 1, g_delete_posts TINYINT(1) NOT NULL DEFAULT 1, g_delete_topics TINYINT(1) NOT NULL DEFAULT 1, g_post_links TINYINT(1) NOT NULL DEFAULT 1, g_set_title TINYINT(1) NOT NULL DEFAULT 1, g_search TINYINT(1) NOT NULL DEFAULT 1, g_search_users TINYINT(1) NOT NULL DEFAULT 1, g_send_email TINYINT(1) NOT NULL DEFAULT 1, g_post_flood SMALLINT(6) NOT NULL DEFAULT 30, g_search_flood SMALLINT(6) NOT NULL DEFAULT 30, g_email_flood SMALLINT(6) NOT NULL DEFAULT 60, g_report_flood SMALLINT(6) NOT NULL DEFAULT 60, PRIMARY KEY (g_id) ) ENGINE = MyISAM CHARACTER SET utf8

How do I fix this error?

Offline

#2 2020-06-23 12:04:10

Visman
Member
From: Siberia
Registered: 2010-07-10
Posts: 1,383
Website

Re: Unable to create table group when trying to install fluxbb.

Offline

Board footer

Powered by FluxBB