Pagina 1 van 1

registreren: fout in mn sql

Geplaatst: 01 jan 2005, 12:21
door B-sTyLe
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?

Geplaatst: 01 jan 2005, 12:32
door ElbertF
Kun je de foutmelding laten zien?

Geplaatst: 01 jan 2005, 13:13
door B-sTyLe
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