ik heb kort geleden de easy ucp mod geinstalleerd.
het is een 1064 sql error, het gebeurt als je de registreer informatie wilt verzenden...
ps. kort geleden werkten mn poll's niet en na een tijdje weer wel (niks veranderd toen ofzo) dat was ook met de sql, de resultaten.
wie kan mij helpen?
registreren: fout in mn sql
Forumregels
Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.
Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.
dit is van dat registreren:
Could not insert data into users table
DEBUG MODE
SQL Error : 1064 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 ',,,,0, '999999', '', 1, '')' at line 2
INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_allow_viewprofile, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_gender, user_level, user_allow_pm, user_class, user_hpmax, user_hp, user_mpmax, user_mp, user_att, user_def, user_birthday, user_next_birthday_greeting, user_active, user_actkey) VALUES (14, 'bat', 1104581640, '02149faf3ca7853fc2060a27c2588a62', 'bat@bat.nl', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 1, 0, 1, 1, 2, 'D M d, Y g:i a', 'english', 1, '0', 0, 1,'',,,,,,0, '999999', '', 1, '')
Line : 719
File : /home/www/icforum.mybesthost.com/phpbb/includes/usercp_register.php
nu kom ik er net achter dat er ook een fout zit bij mn topic review:
Could not obtain topic information
DEBUG MODE
SQL Error : 1064 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 '; attach_setup_viewtopic_auth(, ); AND f.forum_id = t.for
SELECT t.topic_title, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments FROM phpbb_topics t, phpbb_forums f WHERE t.topic_id = 23 = ''; attach_setup_viewtopic_auth(, ); AND f.forum_id = t.forum_id
Line : 61
File : /home/www/icforum.mybesthost.com/phpbb/includes/topic_review.php
Could not insert data into users table
DEBUG MODE
SQL Error : 1064 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 ',,,,0, '999999', '', 1, '')' at line 2
INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_allow_viewprofile, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_gender, user_level, user_allow_pm, user_class, user_hpmax, user_hp, user_mpmax, user_mp, user_att, user_def, user_birthday, user_next_birthday_greeting, user_active, user_actkey) VALUES (14, 'bat', 1104581640, '02149faf3ca7853fc2060a27c2588a62', 'bat@bat.nl', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 1, 0, 1, 1, 2, 'D M d, Y g:i a', 'english', 1, '0', 0, 1,'',,,,,,0, '999999', '', 1, '')
Line : 719
File : /home/www/icforum.mybesthost.com/phpbb/includes/usercp_register.php
nu kom ik er net achter dat er ook een fout zit bij mn topic review:
Could not obtain topic information
DEBUG MODE
SQL Error : 1064 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 '; attach_setup_viewtopic_auth(, ); AND f.forum_id = t.for
SELECT t.topic_title, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments FROM phpbb_topics t, phpbb_forums f WHERE t.topic_id = 23 = ''; attach_setup_viewtopic_auth(, ); AND f.forum_id = t.forum_id
Line : 61
File : /home/www/icforum.mybesthost.com/phpbb/includes/topic_review.php