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

Home » FUDforum » FUDforum Installation Issues » step 2 eror
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
step 2 eror [message #5616] Tue, 10 September 2002 18:17 Go to previous message
testy is currently offline  testy   United Kingdom
Messages: 3
Registered: September 2002
Karma:
Junior Member
Downloaded .tar.gz file, gunzipped and tar -xf the file.
chmod 777 server root folder and created and chmod 777 Forum Data Root.

When getting to step 2 i enter my user details on fro the mysql server.

clicking next on step 2 i get the error message

"Failed to create table fud_users.tbl (DROP TABLE IF EXISTS fud21_users), SQL Reason: No Database Selected"


after creating the database table manually i then get the error message

"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
"

any ideas ??
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: upgrade script for postgresql users?
Next Topic: Help! File not found
Goto Forum:
  

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

Current Time: Sun Nov 24 14:56:25 GMT 2024

Total time taken to generate the page: 0.04018 seconds