FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » admuser.php:359 ) 1054: Unknown column 'last_used_ip' in 'field list' (Clicking on "User Manager")
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
admuser.php:359 ) 1054: Unknown column 'last_used_ip' in 'field list' [message #167526] Fri, 06 July 2012 06:38 Go to previous message
DaveQB is currently offline  DaveQB   Australia
Messages: 109
Registered: January 2006
Location: Sydney
Karma:
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
[Message index]
 
Read Message
Read Message
Previous Topic: Mailing List to Forum
Next Topic: Upgrade from 2.3.5 to 3.0.0 not working
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 14:50:27 GMT 2024

Total time taken to generate the page: 0.05142 seconds