I have a problem with SQL

Mod that adds a birthday field to the users profile, theire age are displayed beside the posts, and on there birthday they will have a greeting popup
Forum rules
The content in this forum is dated Dec. 21 2005 and can be used as Archive only. This Forum is LOCKED and READ ONLY !

I have a problem with SQL

Postby Alexmp4 on Tue 26. Jul, 2005 18:49

Hello, I'm french and I try to install the MOD Birthday but I have this error :
Code: Select all
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 '999999', ''',0, '74ce9c')' 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_from_flag, 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_mood, user_level, user_allow_pm, user_vacances, user_birthday, user_next_birthday_greeting, user_active, user_actkey) VALUES (3, 'Fliza', 1122395653, '3a9aa4b36c0cff794c8a6aa475e75ce6', 'fliza@iol.pt', '', '', '', '', 'france.gif', '', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, 1, 'D M d, Y g:i a', 'french', 1, '7', 0, 1, '1, '999999', ''',0, '74ce9c')

Line : 670
File : usercp_register.php


I don't know how to do... It happen when e new member want to register but when I modify the registered members the problem don't appear.

Thank you for your help !
Alexmp4
Poster
Poster
 
Posts: 3
Joined: Tue 26. Jul, 2005 18:41

Postby Beeveer on Tue 26. Jul, 2005 19:35

Code: Select all
'''
Is standing somewhere, you did make a mistake on that line, check again :wink:
Nee, ik geef geen antwoorden in het Nederlands, die horen thuis op www.phpbb.nl ;)
User avatar
Beeveer
brilliant supporter
 
Posts: 264
Joined: Tue 30. Nov, 2004 19:13
Location: Boskoop, South-Holland, the Netherlands

Postby Alexmp4 on Tue 26. Jul, 2005 23:47

Thank you I haven't seen that... But where can I resolve the probleme ? In the SQL database or in a .php ?
Alexmp4
Poster
Poster
 
Posts: 3
Joined: Tue 26. Jul, 2005 18:41

Postby Beeveer on Wed 27. Jul, 2005 12:20

Line : 670
File : usercp_register.php
Nee, ik geef geen antwoorden in het Nederlands, die horen thuis op www.phpbb.nl ;)
User avatar
Beeveer
brilliant supporter
 
Posts: 264
Joined: Tue 30. Nov, 2004 19:13
Location: Boskoop, South-Holland, the Netherlands

Postby Alexmp4 on Wed 27. Jul, 2005 12:32

Thank you very much...

My probleme is resolved ! :P

Thank you for this MOD
Alexmp4
Poster
Poster
 
Posts: 3
Joined: Tue 26. Jul, 2005 18:41


Return to Birthday [2.0.10/EM]

Who is online

Users browsing this forum: No registered users and 1 guest

cron