| admuser.php:359 ) 1054: Unknown column 'last_used_ip' in 'field list' [message #167526] |
Fri, 06 July 2012 06:38  |
DaveQB
Messages: 109
Registered: January 2006
Location: Sydney
Karma: 0
|
Senior Member |
|
|
Hi,
I haven't seen this before and I upgraded the forum months ago and then MySQL a few weeks ago and thought I cured all issues.
Full error is:
Fatal error: Uncaught exception 'Exception' with message '(/home/wspirates/domains/forums.wspirates.com/FUDforumwsp/include/theme/default/db.inc:110
/home/wspirates/domains/forums.wspirates.com/public_html/adm/admuser.php:359
) 1054: Unknown column 'last_used_ip' in 'field list'
Query: SELECT id, alias, email, last_visit, last_used_ip, posted_msg_count FROM ausers WHERE login LIKE '%' ORDER BY last_login DESC LIMIT 40 OFFSET 0
_GET: array ( 'S' => '################', 'SQ' => '################', 'usr_login' => '*', 'usr_email' => '', )
Database version: 5.5.20
[Referring Page] http://forums.wspirates.com/adm/index.php?S=#############Q=#################
' in /home/wspirates/domains/forums.wspirates.com/FUDforumwsp/include/core.inc:259 Stack trace: #0 /home/wspirates/domains/forums.wspirates.com/FUDforumwsp/include/theme/default/db.inc(110): fud_sql_error_handler('SELECT id, alia...', 'Unknown column ...', 1054, '5.5.20') #1 /home/wspirates/domains/forums.wspirates.com/public_html/adm/admuser.php(359): uq('SELECT id, alia...') #2 {main} thrown in /home/wspirates/domains/forums.wspirates.com/FUDforumwsp/include/core.inc on line 259
Checking the DB I have the field "last_known_ip" in the users table, no "last_used_ip"
Ohh ok this pertains to this patch:
http://fudforum.org/forum/index.php?t=msg&th=120486&goto=167376& ;#msg_167376
So it seems last_known_ip was changed to last_used_ip at some stage but not in my installation; searching for last_known_ip finds it in many other files just in the adm folder alone.
I have changed back all instances of last_used_ip to last_known_ip in admuser.php
FUDforum version: 3.0.3
PHP version: 5.3.10
Database type: mysql (mysql)
Database version: 5.5.20
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]