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 :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
admuser.php:359 ) 1054: Unknown column 'last_used_ip' in 'field list' [message #167526] Fri, 06 July 2012 02:38 Go to next message
DaveQB is currently offline  DaveQB   Australia
Messages: 109
Registered: January 2006
Location: Sydney
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user

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
Re: admuser.php:359 ) 1054: Unknown column 'last_used_ip' in 'field list' [message #167531 is a reply to message #167526] Fri, 06 July 2012 09:17 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3654
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Strange, after upgrading I don't have a single 'last_known_ip' left in any of the files.

Try to upgrade again, ensure you use the latest 'upgrade.php' AND 'fudforum_archive' files.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Sat Jun 23 00:12:42 EDT 2018

Total time taken to generate the page: 0.00508 seconds