smf to phpbb3 conversion error

Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Forum rules
Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
stu83
Registered User
Posts: 12
Joined: Wed Feb 04, 2009 11:11 pm

smf to phpbb3 conversion error

Post by stu83 »

im trying to convert an smf board to phpbb3, i have both forums installed and working separately (the phpbb3 is blank) and the smf converter files in the correct folders and as soon as the conversion begins i get the following error messages

Code: Select all


General Error
SQL ERROR [ mysqli ]

Duplicate entry 'adsbot [google]' for key 2 [1062]

SQL

INSERT INTO phpbb_users (username, username_clean, user_password, user_pass_convert, user_email, user_email_hash, 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_inactive_reason, user_inactive_time, user_lastmark, user_lastvisit, user_lastpost_time, user_lastpage, user_posts, user_dst, user_colour, user_occ, user_interests, 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 ('AdsBot [Google]', 'adsbot [google]', '', 0, '', '00', 14, 2, '', 0, 'D M d, Y g:i a', 'en', 1, '', '', 1233868432, 1233868432, 895, 0, 0, 1233868432, 0, 0, '', 0, 0, '9E8DA7', '', '', '', 0, 0, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 1, 0, '', '', '', '10c764fa2a0f95c5')

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_user.php
LINE: 248
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_convert.php
LINE: 1866
CALL: user_add()

FILE: install/install_convert.php(1652) : eval()'d code
LINE: 2
CALL: add_bots()

FILE: install/install_convert.php
LINE: 1652
CALL: eval()

FILE: install/install_convert.php
LINE: 799
CALL: install_convert->jump()

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

FILE: install/index.php
LINE: 405
CALL: install_convert->main()

FILE: install/index.php
LINE: 282
CALL: module->load()

how can i fix this?

stu83
Registered User
Posts: 12
Joined: Wed Feb 04, 2009 11:11 pm

Re: smf to phpbb3 conversion error

Post by stu83 »

bump

User avatar
A_Jelly_Doughnut
Registered User
Posts: 1780
Joined: Wed Jun 04, 2003 4:23 pm

Re: smf to phpbb3 conversion error

Post by A_Jelly_Doughnut »

Hi,

Are you using the SMF 2.0 or SMF 1.1 convertor?
A_Jelly_Doughnut

stu83
Registered User
Posts: 12
Joined: Wed Feb 04, 2009 11:11 pm

Re: smf to phpbb3 conversion error

Post by stu83 »

tbh im not 100% sure, i downloaded it via searching for it on google then viewing it using the cached link

the file name is - SMF_phpBB3_convertor_B5 - if that helps?

User avatar
A_Jelly_Doughnut
Registered User
Posts: 1780
Joined: Wed Jun 04, 2003 4:23 pm

Re: smf to phpbb3 conversion error

Post by A_Jelly_Doughnut »

That would be the SMF 1.1 convertor.

I am, however, quite unsure why you're getting this message at the beginning of the conversion. The bots aren't supposed to be added until the very end :shock:
A_Jelly_Doughnut

stu83
Registered User
Posts: 12
Joined: Wed Feb 04, 2009 11:11 pm

Re: smf to phpbb3 conversion error

Post by stu83 »

there wouldnt be something wrong with my install or database structure to cause that would there?

where can i download the v2 converter?

stu83
Registered User
Posts: 12
Joined: Wed Feb 04, 2009 11:11 pm

Re: smf to phpbb3 conversion error

Post by stu83 »

bump

bolverk
I've been banned
Posts: 280
Joined: Mon Feb 02, 2009 5:39 pm

Re: smf to phpbb3 conversion error

Post by bolverk »

What version of smf are you running?

stu83
Registered User
Posts: 12
Joined: Wed Feb 04, 2009 11:11 pm

Re: smf to phpbb3 conversion error

Post by stu83 »

1.1.8

stu83
Registered User
Posts: 12
Joined: Wed Feb 04, 2009 11:11 pm

Re: smf to phpbb3 conversion error

Post by stu83 »

bump

Locked