Prediction Football Forum Index Prediction Football
Prediction Football
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Error just after new user registration

 
Post new topic   Reply to topic    Prediction Football Forum Index -> Bugs
View previous topic :: View next topic  
Author Message
stardog



Joined: 19 Feb 2010
Posts: 2

PostPosted: Fri Feb 19, 2010 1:14 pm    Post subject: Error just after new user registration Reply with quote

Hi! Very Happy
when a new user completes the signup process, he is redirected to a page that shows this error:"Unable to execute query: UPDATE pluserdata SET lastip='83.211.193.126:Unknown', lastlogin=now() where userid='2'
Data too long for column 'lastip' at row 1". Well, registration is successful, and in fact, just click the Back button of the browser to view the account. However, the error message is repeated every login. Any idea?
Thank you in advance! Razz
Back to top
View user's profile Send private message
JohnA
Site Admin


Joined: 11 Jul 2003
Posts: 4036
Location: Washington DC

PostPosted: Mon Feb 22, 2010 10:28 pm    Post subject: Reply with quote

That's a strange one. What version of PHP are you using?

Thanks
JohnA
_________________
Prediction Football
'You know the score'
Back to top
View user's profile Send private message Visit poster's website
stardog



Joined: 19 Feb 2010
Posts: 2

PostPosted: Tue Feb 23, 2010 1:55 pm    Post subject: Reply with quote

Hello JohnA, thanks for the answer. SmileI'm using PHP 5.3
Back to top
View user's profile Send private message
JohnA
Site Admin


Joined: 11 Jul 2003
Posts: 4036
Location: Washington DC

PostPosted: Tue Feb 23, 2010 2:23 pm    Post subject: Reply with quote

I will upgrade to 5.3 and take a look. Your port is longer than expected on the IP (unknown). I can either increase the column width or figure out why its setting unknown.

Cheers
JohnA
_________________
Prediction Football
'You know the score'
Back to top
View user's profile Send private message Visit poster's website
zippy



Joined: 26 May 2010
Posts: 7

PostPosted: Wed May 26, 2010 12:34 pm    Post subject: Log in script error Reply with quote

Was there a solution for this issue? I think I have the same problem.
I have recently installed 2.36 and get this error when a user logs in.

"Unable to execute query: UPDATE pluserdata SET lastip='212.135.141.66:Unknown', lastlogin=now() where userid='1'
Data too long for column 'lastip' at row 1"

If I hit back in my browser I get the Home screen and I am logged in.

I'm running PHP 5.2.10
Back to top
View user's profile Send private message
JohnA
Site Admin


Joined: 11 Jul 2003
Posts: 4036
Location: Washington DC

PostPosted: Wed May 26, 2010 3:58 pm    Post subject: Reply with quote

I will check this again tonight.

JohnA
_________________
Prediction Football
'You know the score'
Back to top
View user's profile Send private message Visit poster's website
JohnA
Site Admin


Joined: 11 Jul 2003
Posts: 4036
Location: Washington DC

PostPosted: Thu May 27, 2010 3:58 am    Post subject: Reply with quote

A fix for this is in 2.37. I will release within the next 24 hours.

JohnA
_________________
Prediction Football
'You know the score'
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Prediction Football Forum Index -> Bugs All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group