| View previous topic :: View next topic |
| Author |
Message |
stardog
Joined: 19 Feb 2010 Posts: 2
|
Posted: Fri Feb 19, 2010 1:14 pm Post subject: Error just after new user registration |
|
|
Hi!
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!  |
|
| Back to top |
|
 |
JohnA Site Admin
Joined: 11 Jul 2003 Posts: 4036 Location: Washington DC
|
Posted: Mon Feb 22, 2010 10:28 pm Post subject: |
|
|
That's a strange one. What version of PHP are you using?
Thanks
JohnA _________________ Prediction Football
'You know the score' |
|
| Back to top |
|
 |
stardog
Joined: 19 Feb 2010 Posts: 2
|
Posted: Tue Feb 23, 2010 1:55 pm Post subject: |
|
|
Hello JohnA, thanks for the answer. I'm using PHP 5.3 |
|
| Back to top |
|
 |
JohnA Site Admin
Joined: 11 Jul 2003 Posts: 4036 Location: Washington DC
|
Posted: Tue Feb 23, 2010 2:23 pm Post subject: |
|
|
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 |
|
 |
zippy
Joined: 26 May 2010 Posts: 7
|
Posted: Wed May 26, 2010 12:34 pm Post subject: Log in script error |
|
|
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 |
|
 |
JohnA Site Admin
Joined: 11 Jul 2003 Posts: 4036 Location: Washington DC
|
Posted: Wed May 26, 2010 3:58 pm Post subject: |
|
|
I will check this again tonight.
JohnA _________________ Prediction Football
'You know the score' |
|
| Back to top |
|
 |
JohnA Site Admin
Joined: 11 Jul 2003 Posts: 4036 Location: Washington DC
|
Posted: Thu May 27, 2010 3:58 am Post subject: |
|
|
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 |
|
 |
|