[Fixed] Existing members can't update their profile

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 !

[Fixed] Existing members can't update their profile

Postby Swanee on Sun 06. Nov, 2005 20:00

I have been searching and changing codes, checking and checking again. But I can't seem to find the problem.
When I register as a new user, there is no problem adding my birthday in my profile. But as an existing member I can not add it.

First of all, the letters are white on a white pulldown menu.

But when you go over it with the mouse you can see it, fill it in and try to update the profile. Then I get the error message:

Could not update 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 'd M Y h:i a', user_lang = 'english', user_style = 3, user_activ

UPDATE phpbb_users SET user_email = 'forum@ourwebsite.com', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_birthday = '3751', user_next_birthday_greeting = '2006, user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 0, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 0, user_notify = 1, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 0, user_dateformat = 'd M Y h:i a', user_lang = 'english', user_style = 3, user_active = 1, user_actkey = '' WHERE user_id = 2

Line : 589
File : usercp_register.php


I can't figure it out where the problem is.

Please, help me out with the colour and the code error!!!

I did it all very carefully, especially in the part where they tell you to be carefull. And as far as I can see, it's all correct. :cry:
Last edited by Swanee on Tue 08. Nov, 2005 11:59, edited 2 times in total.
Swanee
Poster
Poster
 
Posts: 10
Joined: Sun 06. Nov, 2005 19:14

Postby Katmassive on Mon 07. Nov, 2005 20:26

i had a similar problem i removed all birthday mod modifications from includes/usercp_register.php ran the db_update for birthday mod and added the mods for includes/usercp_register.php over but now i'm getting a different error

Code: Select all
Parse error: parse error in /data/members/free/tripod/uk/c/a/r/cartyaxafamily/htdocs/phpBB2/includes/usercp_register.php on line 974
Katmassive
Poster
Poster
 
Posts: 7
Joined: Mon 07. Nov, 2005 19:58

Postby Swanee on Mon 07. Nov, 2005 22:10

@ Katmassive

Well, I did what you said: applying the MODS to the includes/usercp_register.php again. Bit by bit! I swear I didn't see any changes.

But... it works now!!! *starts dancing around*

But now for the next "problem".
As this MOD is based upon the light templates I get a white background with white letters. Underneath the users names there should be Age: 20 or whatever age they are! But you only see a white square. If you go over it with your mouse and left button clicked to select it, you are able to see it.

Image

Where do I change that color setting???
I think it will also change my "problem" with the pulldown menu for entering the birthday in the profiles, I guess?????

This is the only thing and then it's perfect!

Thanks in advance...
Swanee
Poster
Poster
 
Posts: 10
Joined: Sun 06. Nov, 2005 19:14

Postby Beeveer on Mon 07. Nov, 2005 22:51

You have the problem in viewtopic to search in viewtopic_body.tpl and the other in usercp_register.php

I'll need a weblink to study the template I think.
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 Swanee on Mon 07. Nov, 2005 23:16

Hey thanks!!!! Dank je wel (hoef je niet te beantwoorden :P )

I have changed the code in both files you suggested and it works absolutely perfect!!!

First of all there was indeed a part in the viewtopic_body.tpl that set a white background and border. I removed the color=#FFFFFF completely. Also the bordercolor I removed so that the background color of the forum template itself is used.

For the pulldown menu I needed to remove the two class setting class="gensmall" in the usercp_register.php.

Now it works.

Thanks to everyone that helped or at least tried. I hope my solution helps others to.
Swanee
Poster
Poster
 
Posts: 10
Joined: Sun 06. Nov, 2005 19:14

Postby Katmassive on Mon 07. Nov, 2005 23:32

can anyone help with my error
Katmassive
Poster
Poster
 
Posts: 7
Joined: Mon 07. Nov, 2005 19:58

Postby Swanee on Mon 07. Nov, 2005 23:38

I wish I could, Katmassive!!! I would be glad to help you, but if I see the error you get I truly can't understand what is happening.

Like I said, I added the MODS to the includes/usercp_register.php again and it solved the problem. Have you tried it again???
Swanee
Poster
Poster
 
Posts: 10
Joined: Sun 06. Nov, 2005 19:14

Postby Katmassive on Mon 07. Nov, 2005 23:41

yep many times i'm also getting the error in admin_users
Katmassive
Poster
Poster
 
Posts: 7
Joined: Mon 07. Nov, 2005 19:58


Return to Birthday [2.0.10/EM]

Who is online

Users browsing this forum: No registered users and 1 guest

cron