General Error :: Unknown column 'users.user_birthday'

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Anti-Spam Guide
Locked
smileymattj
Registered User
Posts: 7
Joined: Wed Dec 12, 2007 1:54 am

General Error :: Unknown column 'users.user_birthday'

Post by smileymattj » Mon Jun 23, 2008 7:16 am

While trying to convert my phpbb2 to phpbb3, I get the following error.

found a post on the german phpbb forum, but i guess i am misunderstanding the translation:
http://translate.google.com/translate?u ... n&ie=UTF-8
(in the phpbb3 database I set allow_birthdays to -2 thats what i assumed they where talking about)
that did not resolve the issue.

Code: Select all

 Return to the index page
General Error
SQL ERROR [ mysql4 ]

Unknown column 'users.user_birthday' in 'field list' [1054]

SQL

SELECT users.user_id, users.user_id AS poster_id, users.user_active, users.user_level, users.user_regdate, users.username, users.user_password, users.user_posts, users.user_email, users.user_birthday, users.user_lastvisit, users.user_lang, users.user_timezone, users.user_dateformat, users.user_interests, users.user_occ, users.user_website, users.user_msnm, users.user_yim, users.user_aim, users.user_icq, users.user_from, users.user_rank, users.user_avatar, users.user_avatar_type, users.user_new_privmsg, users.user_last_privmsg, users.user_emailtime, users.user_notify, users.user_notify_pm, users.user_allow_pm, users.user_allow_viewonline, users.user_viewemail, users.user_actkey, users.user_popup_pm AS popuppm, users.user_allowhtml AS html, users.user_allowbbcode AS bbcode, users.user_allowsmile AS smile, users.user_attachsig AS attachsig, users.user_sig, users.user_sig_bbcode_uid AS old_bbcode_uid, users.user_regdate AS post_time FROM phpbb_users users WHERE (users.user_id <> -1) ORDER BY users.user_id LIMIT 2000

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 205
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 159
CALL: dbal_mysql->_sql_query_limit()

FILE: install_temp/install_convert.php
LINE: 1233
CALL: dbal->sql_query_limit()

FILE: install_temp/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: install_temp/index.php
LINE: 402
CALL: install_convert->main()

FILE: install_temp/index.php
LINE: 274
CALL: module->load()
anyone know how to resolve this?

smileymattj
Registered User
Posts: 7
Joined: Wed Dec 12, 2007 1:54 am

Re: General Error :: Unknown column 'users.user_birthday'

Post by smileymattj » Mon Jun 23, 2008 7:49 am

found it, staying up too late, made a dumb mistake...

didn't look on the 3 page of the config table, wasn't paying attention :lol:

Locked

Return to “[3.0.x] Convertors”