Fatal error in indexpage

[AmigaLink]

The Displays Birthdays on Calendar lite 1.4.6 needs the Birthday MOD from Niels! You must install that MOD to use the Displays Birthdays on Calendar lite.

[demingel]

I installed the mod butt I have this error

Code: Alles auswählen

Parse error: parse error in /home/httpd/vhosts/carpflashes.nl/httpdocs/board/includes/usercp_register.php on line 781

[Morun]

try it by replacing:

Code: Alles auswählen

VALUES ($user_id, '", . str_replace("\'", "''", $username) .

with:

Code: Alles auswählen

VALUES ($user_id, '" . str_replace("\'", "''", $username) .

I think there's a comma too much

[demingel]

almost

I have now this error

Code: Alles auswählen

Could not update users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' user_aim = '', user_yim = '', user_msnm = '', user_skype = '', user_attachsig =' at line 2

UPDATE phpbb_users SET user_email = '', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_birthday = '999999', user_next_birthday_greeting = '', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = , user_aim = '', user_yim = '', user_msnm = '', user_skype = '', 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_active = 1, user_actkey = '' WHERE user_id = 

Line : 657
File : usercp_register.php

[Morun]

Apparently the whole data that your forum tries to save is absolutely empty, times are on 999999, the rest on '' (empty string) or NULL/nothing. There has not even the user_id of the profile that should be updated been transmitted, so it can't find the data set that is supposed to be updated.

Which profile related files did you change lately?

(edit: Maybe there's something wrong with the profile_add_body.tpl?)

[demingel]

well the last mod that I installed was the msn messenger mod from
this site http://phpbb-login.sourceforge.net
I don't no if this means anyting???

[Morun]

Well, it might have to do something with that, I never installed it myself as it was already part of my premodded version, but I know from the skype-Mod that these mods are pretty substancial.. so maybe something with that went wrong.

can you attach the profile_add_body.tpl, maybe that's where you have the problems with the data transfer..

The last error you posted, was that during a registration or while changing a profile?

[demingel]

the problem is wenn I view/change my profile on the indexpage.
wenn i'm viewing it in viewtopic there is no problem
(only the wrong date is visible)

[Morun]

I'm not sure how you view/change your profile on the index or the viewtopic, as far as I know you can only change it in the profile.php?!

In the template I didnt see anything wrong on first view. Can I visit your forum to get a better impression of whats happening?

[demingel]

okay

this is my forum
http://www.carpflashes.nl/board/index.php

it's in dutch

wenn i view my profile on this page >

http://www.carpflashes.nl/board/profile ... ditprofile

I gett that error

wenn I'm viewing my profile from viewtopic there is no error.
and on this page >http://www.carpflashes.nl/board/profile ... greed=true

I gett this error

Code: Alles auswählen

Could not insert data into users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' user_birthday = '999999', user_next_birthday_greeting = '' '', '', '', 0, 0, ''' 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_skype, 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 (249, '', 1144009091, '', '', '', '', '', '', '',, user_birthday = '999999', user_next_birthday_greeting = '' '', '', '', 0, 0, '', '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, 0, 'D M d, Y g:i a', 'dutch', 1, 0, 1, '999999', '' 0, 'bb2c5a7b061')

Line : 781
File : usercp_register.php

parts of the mod work

in the live statistics you see a birthday
also wenn I look in my profile in the ACP the mod work also in parts

[Morun]

I think it might help to replace in that line

Code: Alles auswählen

, user_active, user_actkey, user_birthday, user_next_birthday_greeting

with

Code: Alles auswählen

, user_birthday, user_next_birthday_greeting, user_active, user_actkey

because the values for user_active and user_actkey ar added to the sql-query in the if-statemnt afterwards... therefore they need to be at the end.

[demingel]

well a placed the code at the end butt stil not working

Code: Alles auswählen

$sql = "INSERT INTO " . USERS_TABLE . "	(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_skype, 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_birthday, user_next_birthday_greeting,user_active, user_actkey)
				VALUES ($user_id, '" . str_replace("\'", "''", $username)  . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', user_birthday = '$birthday', user_next_birthday_greeting = '$next_birthday_greeting' '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', '" . str_replace("\'", "''", $skype) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popup_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, '$birthday', '$next_birthday_greeting' ";
			if ( $board_config['require_activation'] == USER_ACTIVATION_SELF || $board_config['require_activation'] == USER_ACTIVATION_ADMIN || $coppa )
			{

[oxpus]

Did you still get an error message?

[demingel]

Jip I still have the same errors

on phpBB.nl the told my to change this

Code: Alles auswählen

$user_active, 

Code: Alles auswählen

user_next_birthday_greeting ='', 

so I did butt no effect ^q

[Morun]

Can you post your error message as it is now? I doubt that it is exactly the same.., there must be some difference (hopefully)..

[demingel]

Code: Alles auswählen

Could not update users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '' user_sig = '', user_sig_bbcode_uid = '', user_viewemail = , user_aim = '', use' at line 2

UPDATE phpbb_users SET user_email = '', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_birthday = '999999', user_next_birthday_greeting ='',' user_sig = '', user_sig_bbcode_uid = '', user_viewemail = , user_aim = '', user_yim = '', user_msnm = '', user_skype = '', 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_active = 1, user_actkey = '' WHERE user_id = 

Line : 657
File : usercp_register.php

the user table

Code: Alles auswählen

$sql = "UPDATE " . USERS_TABLE . "
				SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) ."', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_birthday = '$birthday', user_next_birthday_greeting ='',$next_birthday_greeting' user_sig = '" . str_replace("\'", "''", $signature) . "', user_sig_bbcode_uid = '$signature_bbcode_uid', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_skype = '" . str_replace("\'", "''", $skype) . "', user_attachsig = $attachsig, user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popup_pm, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_active = $user_active, user_actkey = '" . str_replace("\'", "''", $user_actkey) . "'" . $avatar_sql . "
				WHERE user_id = $user_id";
			if ( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
			}

[Morun]

Besides that you still don't get any data into that update-statement, the mistakes seems to come from the ' in front of user_sig:

user_next_birthday_greeting ='',' user_sig = '', user_sig_bbcode_uid

However, I can't explain the ocurrence of that ' from the user_register.php you posted before. Did you do any changes so you got that ' there?

EDIT: I just saw the 2nd code-part that you posted. Change:

Code: Alles auswählen

user_next_birthday_greeting ='',$next_birthday_greeting' user_sig =

with:

Code: Alles auswählen

user_next_birthday_greeting ='$next_birthday_greeting', user_sig =

When you do changes, take care that you replace things exactly! YOu have constantly commas and stuff somewhere where they don't belong. I'm sure that you didn't take that much care when installing your mods, and that way you really f***ed up your board.

[demingel]

on phpBB.nl the told me to change this

Code: Alles auswählen

user_next_birthday_greeting = ''

into this

Code: Alles auswählen

user_next_birthday_greeting ='', 

and this

Code: Alles auswählen

$user_active

into this

Code: Alles auswählen

$user_active,

and now you telling me to change this again
in the install instruction they say:

Code: Alles auswählen

#
#-----[ IN-LINE FIND ]---------------------------------------- 
#
str_replace("\'", "''", $interests) . "'

# 
#-----[ IN-LINE AFTER, ADD ]----------------------------------
#
, user_birthday = '$birthday', user_next_birthday_greeting = '$next_birthday_greeting'

#

and this is now my line butt this stupid mod will not work so I don't no wat I'm doing wrong

the code is correct following the install I think

Code: Alles auswählen

str_replace("\'", "''", $interests) . "', user_birthday = '$birthday', user_next_birthday_greeting = '$next_birthday_greeting', user_sig = '" . 

[/code]

[Morun]

If your line is now like that, than this part should be ok. However, what you posted in Post 41 was different, i just told you what you need to change in that part of your code.

When you still get mistakes, that's because you have mistakes in other parts as well and it won't work until you removed all these typos.

If you still have the files from before installing the mod (hopefully!!), I would suggest that you do all the changes from the mod again, giving this time more attention to add new elements EXACTLY where they are meant to be added, instead of maybe having a comma infront that should be afterwards, etc.

Dont blame the mod, it's probably ok, the author of the mod didnt have these kind of problems because he did the changes more carefully.

[demingel]

:bday

it works finnely

[Morun]

I found some more mistakes in this file, but I couldn't try out if it is working in my test board (I got a blank page), I guess it's too different sice I installed a shitload of Mods.

Try it, and post any error messages you get. I guess I wont be online before tomorrow thou.


EDIT: hm, I guess you figured it out yourself?! Congratulations!!
(I did changes in the INSERT and the UPDATE statement, as both had some errors how the birthday-data was inserted..)

[demingel]

I still have a small problem with the calender
wenn I'm viewing this page http://www.carpflashes.nl/board/cal_lit ... e=View_New
I see this for 12 page long
that's the only (problem) a have..

that's wenn you press "toon komende evenementen"

Code: Alles auswählen

Geboortedatum 01 Jan 2007 12:00 am 01 Jan 2007 12:00 am Cookies 
Gefeliciteerd! Cookies 

[oxpus]

The same error:
The field user_birthday isn't filled correctly.
Check the installation of the Birthday MOD on usercp_register.php to fix this bug.

[demingel]

I had this problem before I installed the birthday mod

[oxpus]

?
Okay, I think, the field can be empty or NULL.
Check this please and fill all empty fields with '999999', like this:

Code: Alles auswählen

UPDATE phpbb_users SET user_birthday = 999999 WHERE user_birthday = '' OR user_birthday IS NULL;

This will first fix the missing default value in the users table and fix the script, too.