Thank you. Will use this now.
Just did, it passed that stage, though another error is encountered. This,
Code: Select all
General Error
SQL ERROR [ mysqli ]
Duplicate entry 'adsbot [google]' for key 'username_clean' [1062]
SQL
INSERT INTO phpbb_users (username, username_clean, user_password, 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_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 ('AdsBot [Google]', 'adsbot [google]', '', '', '00', 13, 2, '', 'UTC', 'D M d, Y g:i a', 'en', 1, '', '', 1571828067, 1571828067, 230271, 0, 0, 0, 1571828067, 0, 0, '', 0, '9E8DA7', '', '', 0, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 1, 0, '', '', '', 'aa8977f167bf7633')
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 852
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/includes/functions_user.php
LINE: 287
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/includes/functions_convert.php
LINE: 1929
CALL: user_add()
FILE: [ROOT]/install/install_convert.php(1688) : eval()'d code
LINE: 2
CALL: add_bots()
FILE: [ROOT]/install/install_convert.php
LINE: 1688
CALL: eval()
FILE: [ROOT]/install/install_convert.php
LINE: 823
CALL: install_convert->jump()
FILE: [ROOT]/install/install_convert.php
LINE: 214
CALL: install_convert->convert_data()
FILE: [ROOT]/install/index.php
LINE: 409
CALL: install_convert->main()
FILE: [ROOT]/install/index.php
LINE: 289
CALL: module->load()
Checked the convertor php file noticed there were two similar such entries in line 259 and line 738. Though, i dont know what they are doing, if that is the cause and which to delete if that happens to be the case. Would appreciate any help on this. Thanks all.