[bug]9.1.1 to 9.2.1 'user_email' doesn't have a default val

[RivaDragon]

Hey everyone-
Im very very new to mysql and php and I apologize in advance...

I inherited a 9.1.1 site. It was being run on a linux server. The only platform I am familiar with is Windows and IIS, so I have sucessfully ported the site to Windows/IIS/mysql. That took me about 2 days to figure out, along with alot of study on this website.

Now, I am trying to upgrade to the latest version. From what I was told, I have 4 addon modules. I have turned those off. Now it is my understanding that I copy the new release files over the top of my existing site. That goes fine. I then run install.php and I get the following error in the set config.php phase...

Executing the queries: . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

INSERT INTO df_users (user_id, name, username, user_email, femail, user_website, user_avatar, user_regdate, user_icq, user_occ, user_from, user_interests, user_sig, user_viewemail, user_aim, user_yim, user_skype, user_msnm, user_password, storynum, umode, uorder, thold, noscore, bio, ublockon, ublock, theme, commentmax, counter, newsletter, user_posts, user_attachsig, user_rank, user_level, user_active, user_session_time, user_lastvisit, user_timezone, user_dst, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_avatar_type, user_actkey, user_newpasswd, user_group_cp, user_group_list_cp, user_active_cp, susdel_reason) VALUES ('1',DEFAULT,'Anonymous',DEFAULT,DEFAULT,DEFAULT,'gallery/blank.gif','1206409204',DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,'10',DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,'4096',DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,'1','1',DEFAULT,DEFAULT,'-5',DEFAULT,DEFAULT,'english','D M d, Y g:i a',DEFAULT,DEFAULT,DEFAULT,DEFAULT,'1','1','1','1','1','1','1','1',DEFAULT,'3',DEFAULT,DEFAULT,'3','3','1',DEFAULT)
Field 'user_email' doesn't have a default value

Please contact the CPG-Nuke Dev Team about the error
You cannot continue with the installation




Thank you very much,
Steve

[WebSiteGuru]

What are the modules that you turned off? It might be related. Most modules should be about to take the upgrade without any problem.

[RivaDragon]

It is an Everquest 2 guild website.

The modules I turned off are..
Member List
[.] Content
GEM
Roster Master

[RivaDragon]

I have tried doing it with all the modules and blocks turned on, also with combinations of those on and off.

Each time I get the exact same error.

[WebSiteGuru]

Then it must be something else. Did you have everything uploaded, also did you deleted anything from the old installation?

[RivaDragon]

Thank you for the speedy responses.

I think I may have it resolved. I really took a close look at the error, and the problem seemed to be a field in the df_users table called 'user_email' expecting to be not null and there was no default value. So i when into phpmyadmin and manually put a default email address in that field of that table. I reran the install and it happened again with a different field in that same table. This happened 2 more times. After assigning a default value for these 'non null' fields, the install completed and it looks like my site is working on 9.2.1 now.

www.starofnorrath.com

yay!

i so suck at this stuff...

[NanoCaiordo]

bookmarked, next time use our bug report system please.