What version of phpBB are you using? phpBB 3.3.14
What is your board's URL? http://coloradoclassicbroncos.com
Who do you host your board with? HostGator
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? No
What version of phpBB3 did you update from? phpBB 3.0.11
What styles do you currently have installed? prosilver
What language(s) is your board currently using? British English
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? I was upgrading from 3.0.11 for our forum to 3.3.14. Everything was going smoothly until the step to update the DB. It got to 90% and posted a SQL error (pasted below).
I can restore the DB if needed but this seems like something that would happen again if I did.
Please describe your problem.
Code: Select all
General Error:SQL ERROR [ mysqli ]Incorrect integer value: '' for column 'user_avatar_type' at row 1 [1366]SQLINSERT INTO coloradoclassicbroncos_users (username, username_clean, user_password, user_email, group_id, user_type, user_permissions, user_timezone, user_dateformat, user_lang, user_style, user_actkey, user_ip, user_regdate, user_passchg, user_options, user_new, user_inactive_reason, user_inactive_time, user_lastmark, user_lastvisit, user_lastpost_time, user_lastpage, user_posts, user_colour, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_message_rules, user_full_folder, user_emailtime, user_notify, user_notify_pm, user_notify_type, user_allow_pm, user_allow_viewonline, user_allow_viewemail, user_allow_massemail, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield, user_form_salt) VALUES ('DuckDuckGo [Bot]', 'duckduckgo [bot]', '', '', '6', 2, '', 0, 'D M d, Y g:i a', 'en', '17', '', '', 1734311263, 1734311263, 230271, 0, 0, 0, 1734311263, 0, 0, '', 0, '9E8DA7', '', '', 0, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 1, 0, '', '', '', 'i1j3pndtnq081gyh') in file /home1/zillacon/public_html/phpbb/db/driver/driver.php on line 1028