search

juju2143 / smf2-phpbb-convertor

SMF 2.x to phpBB 3.2 convertor
GNU General Public License v3.0
4 stars 4 forks source link

Unknown column 'members.gender' #4

Open gevv opened 5 years ago

gevv commented 5 years ago

Error after a long time

Unknown column 'members.gender' in 'field list' [1054]

How can I solve this problem?

Information

General Error: SQL ERROR [ mysqli ]

Unknown column 'members.gender' in 'field list' [1054]

SQL

SELECT members.id_member, members.id_member AS poster_id, members.is_activated, members.id_group, members.member_ip, members.date_registered, members.real_name, members.member_name, members.passwd, members.password_salt, members.posts, members.email_address, members.birthdate, members.gender, members.last_login, members.lngfile, members.time_offset, members.time_format, members.signature, membergroups.id_group, members.avatar, members.avatar AS avatar_type, members.unread_messages, members.hide_email FROM smf_members members LEFT JOIN smf_membergroups AS membergroups ON members.id_group = membergroups.id_group WHERE (members.id_member > 0) ORDER BY members.id_member ASC LIMIT 2000 in file C:\wamp\www\bb\phpbb\db\driver\driver.php on line 997

BACKTRACE

FILE: (not given by php) LINE: (not given by php) CALL: installer_msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 997 CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php LINE: 193 CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/mysql_base.php LINE: 45 CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 270 CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/install/convert/convertor.php LINE: 702 CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/install/convert/controller/convertor.php LINE: 370 CALL: phpbb\convert\convertor->convert_data()

FILE: (not given by php) LINE: (not given by php) CALL: phpbb\convert\controller\convertor->convert()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php LINE: 135 CALL: call_user_func_array()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php LINE: 57 CALL: Symfony\Component\HttpKernel\HttpKernel->handleRaw()

FILE: [ROOT]/install/app.php LINE: 61 CALL: Symfony\Component\HttpKernel\HttpKernel->handle()

Leinad4Mind commented 4 years ago

Delete this line: https://github.com/juju2143/smf2-phpbb-convertor/blob/master/install/convertors/convert_smf20.php#L754

basically your SMF doesn't have genders when it should. Maybe it is an older version.