FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » install rc4 create table error
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
icon4.gif  install rc4 create table error [message #5237] Sat, 24 August 2002 08:28 Go to next message
ezdb is currently offline  ezdb   China
Messages: 158
Registered: May 2002
Location: china
Karma: 0
Senior Member

mysql 3.22.32


Failed to create table fud_msg.tbl (CREATE TABLE fud21_msg ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, thread_id INT UNSIGNED NOT NULL, poster_id INT UNSIGNED NOT NULL DEFAULT 0, reply_to INT UNSIGNED NOT NULL DEFAULT 0, ip_addr CHAR(15) NOT NULL DEFAULT '0.0.0.0', host_name CHAR(255), post_stamp INT UNSIGNED NOT NULL, update_stamp INT UNSIGNED NOT NULL DEFAULT 0, updated_by INT UNSIGNED NOT NULL DEFAULT 0, icon CHAR(100), subject CHAR(100) NOT NULL, attach_cnt INT UNSIGNED NOT NULL DEFAULT 0, poll_id INT UNSIGNED NOT NULL DEFAULT 0, approved ENUM('Y', 'N') NOT NULL DEFAULT 'N', show_sig ENUM('Y', 'N') NOT NULL DEFAULT 'Y', smiley_disabled ENUM('Y', 'N') NOT NULL DEFAULT 'N', foff INT UNSIGNED NOT NULL DEFAULT 0, length INT UNSIGNED NOT NULL DEFAULT 0, file_id INT UNSIGNED NOT NULL DEFAULT 1, offset_preview INT UNSIGNED NOT NULL DEFAULT 0, length_preview INT UNSIGNED NOT NULL DEFAULT 0, file_id_preview INT UNSIGNED NOT NULL DEFAULT 0, mlist_msg_id VARCHAR(100), INDEX(thread_id,approved), INDEX(post_stamp), INDEX(poster_id,approved), INDEX(approved), INDEX(attach_cnt), INDEX(poll_id), INDEX(ip_addr, post_stamp), INDEX(mlist_msg_id), INDEX(subject) )), SQL Reason: Column 'mlist_msg_id' is used with UNIQUE or INDEX but is not defined as NOT NULL
Re: install rc4 create table error [message #5241 is a reply to message #5237] Sat, 24 August 2002 16:16 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Aha, I think I see the problem.

The MySQL server you are using is version 3.22, FUDforum requires you to have version 3.23 or higher to operate correctly.


FUDforum Core Developer
Re: install rc4 create table error [message #5258 is a reply to message #5241] Sun, 25 August 2002 02:04 Go to previous message
ezdb is currently offline  ezdb   China
Messages: 158
Registered: May 2002
Location: china
Karma: 0
Senior Member

i see,thanks Cool
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Iam quite a newbie and have step 2 installation issues...
Next Topic: is there a way to install fudforum with a ms sql server database?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 28 13:31:01 GMT 2024

Total time taken to generate the page: 0.02456 seconds