leden kunnen niet registeren

[nijntje]

ik heb de verjaardags mod goed geinstalleerd maar leden kunnen niet lid worden na registratie krijgen ze dit

Code: Selecteer alles

 
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 ' user_birthday, user_next_birthday_greeting VALUES (32, 'St

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_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey), user_birthday, user_next_birthday_greeting VALUES (32, 'Stargirl', 1090493478, 'fd7cd77a13f02953e1146991eb0983ba', 'stargirl@hotmail.com', '', '', '', '', '', 'Geen enkele ster is zo mooi als Mijn Ster!', '8582c0ee41', '', 0, 0, '', '', 'stargirl@hotmail.com', 1, 1, 0, 1, 1, 0, 1, 1, 2, 'D M d, Y g:i a', 'dutch', 2, 0, 1, , '4952', '2004' 1, '')

Line : 598
File : /home/dreambutterfly.nl/1565/phpBB2/includes/usercp_register.php 
  

wat kan er fout zijn?

[eXo]

Database wel geupdate?

[nijntje]

mja heb ik


bij me vorige forum had ik hetzelfde probleem en mistte ik iets nu niet en me database is geupdated dus wat de probleem is weet ik niet

[mosymuis]

user_actkey), user_birthday,

Dit is de SQL fout waar de database over struikelt; je hebt een mod actie niet goed uitgevoerd:

Code: Selecteer alles

#
#-----[ FIND ]------------------------------------------------
#
# NOTICE - IMPORTENT SECURITY RISK
#
# If you some how do not preform the following VERY carefully you have the
# potential to compromise your forum SECURITY, your users may easyly get ADMIN access if you make mistake
# meny users do make mistake in the step, so please be very exact, if this fail, then do not run your code on live forum
#
			$sql = "INSERT INTO " . USERS_TABLE . "

#
#-----[ IN-LINE FIND ]----------------------------------------
#
, user_active, user_actkey)

#
#-----[ IN-LINE BEFORE, ADD ]---------------------------------
#
, user_birthday, user_next_birthday_greeting

^^je hebt het erachter geplaatst in plaats van ervoor (ondanks de waarschuwing)

[nijntje]

ow hahah snel veranderen dankje

[nijntje]

zit het ervoor krijg ik nog steeds dat probleem :S

[mosymuis]

Wat is nu de error? Als je het hebt aangepast (en hebt geupload) kan het nooit dezelfde zijn.

[nijntje]

Code: Selecteer alles

Could not insert data into users table

DEBUG MODE

SQL Error : 1136 Column count doesn't match value count at row 1

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_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (36, 'Annouska', 1090578190, 'a9d74d4018e45143163dde57e6a26815', 'annouskamiddelhoek@hotmail.com', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 2, 'D M d, Y g:i a', 'dutch', 2, 0, 1, '999999', '', 1, '')

Line : 598
File : /home/dreambutterfly.nl/1565/phpBB2/includes/usercp_register.php

[nijntje]

this wel anders ja maar kom er niet uit

[mosymuis]

De BEFORE, ADD actie van hierboven ontbreekt.