FUDforum: Bug Reports » Registration Error 2.3.0RC3

Home » FUDforum Development » Bug Reports » Registration Error 2.3.0RC3

Show: Today's Messages :: Polls :: Message Navigator

Registration Error 2.3.0RC3 [message #5117]

Wed, 21 August 2002 12:40

BugLaden

Messages: 216
Registered: February 2002
Location: Westminster, MD

Karma: 0

Senior Member

Whenever a new user tries to register:

Query Failed: INSERT INTO fud_users ( login, alias, passwd, name, email, display_email, notify, notify_method, ignore_admin, email_messages, pm_messages, gender, icq, aim, yahoo, msnm, jabber, append_sig, posts_ppg, time_zone, bday, invisible_mode, last_visit, conf_key, user_image, join_date, location, avatar, theme, coppa, occupation, interests, referer_id, show_sigs, show_avatars, show_im, last_read, avatar_loc, avatar_approved, sig, default_view, home_page, bio ) VALUES ( 'TestUser', 'TestUser', 'ed2822d77d04113401815dcaf353d697', 'Test User', 'bitbucket(at)CCGWorkshop(dot)com', 'Y', 'Y', 'EMAIL', 'N', 'Y', 'Y', 'UNSPECIFIED', NULL, NULL, NULL, NULL, NULL, 'Y', '0', 'America/New_York', 0000, 'N', 1029933585, '2c5fde2740d43c2b22b6aa14d220b82b', NULL, 1029933585, '', 0, 7, 'N', NULL, NULL, 2, 'Y', 'Y', 'Y', 1029933585, NULL, 'NO', NULL, 'msg', NULL, NULL )
Reason: Unknown column 'show_im' in 'field list'
From: /home/ccgwork/public_html/forum/index.php
Server Version: 3.23.44

-=BugLaden

[Updated on: Wed, 21 August 2002 12:55]

Report message to a moderator

Re: Registration Error 2.3.0RC3 [message #5119 is a reply to message #5117]

Wed, 21 August 2002 13:04

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

There was a slight bug in the upgrade script, that is already fixed, which is the cause for the problem you are seeing.
Run the following query, it'll fix the problem.

ALTER TABLE fud_users ADD show_im ENUM('Y', 'N') NOT NULL DEFAULT 'Y';

FUDforum Core Developer

Report message to a moderator

Previous Topic:	SECURITY HOLE in 2.0
Next Topic:	poll bug in 2.3.0rc1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 13:18:57 GMT 2024

Total time taken to generate the page: 0.02373 seconds