I get this message? I followed the above instructions...SQL ERROR [ mysql4 ]
Column 'config_value' cannot be null [1048]
SQL
INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('newest_user_colour', NULL, 1)
BACKTRACE
FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()
FILE: [ROOT]/includes/functions.php
LINE: 157
CALL: dbal_mysql->sql_query()
FILE: [ROOT]/includes/functions_user.php
LINE: 325
CALL: set_config()
FILE: [ROOT]/users_add.php
LINE: 96
CALL: user_add()
Code: Select all
SQL ERROR [ mysqli ]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '7) VALUES ('example', 'example', '$2y$10$jNTAW3sXd4dwWtIijcVnGeAajw0D3hdW4' at line 1 [1064]
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, 7) VALUES ('example', '1983.nidhi', '$2y$10$jNTAW3sXd4dwddefdefdfywwrajw0D3hdW4.VfeGyuxGEqweZ3O8iU2', '[email protected],', '134889696521', '2', '0', '', 'Asia/Kolkata', 'd M Y, H:i', 'en', 1, '', '', 1443249161, 1443249161, 230271, 0, 0, 0, 1443249161, 0, 0, '', 0, '', '', '', 0, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 1, 1, '', '', '', '5f0ea084da6eb9ad', '0')
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]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/includes/functions_user.php
LINE: 275
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/users_add.php
LINE: 96
CALL: user_add()
user_form_salt, 7)
, 7
shouldn't be there.Lumpy Burgertushie wrote:see this in your code:user_form_salt, 7)
that, 7
shouldn't be there.
robert