Site visitors block problem

Nuke Cadet Joined: Aug 27, 2003 Posts: 7

Ive just upgraded from 6.0 with phpbb to 6.5.

Everything went fine except i get an error on top of my site visitors block saying "Unknown column 'time' in 'where clause'".

The block itself seems to work fine although one user has complained when he tries to post on the forum it says "invalid session"

The block is from nukecops

The site is at www.bangorcruise.co.uk/main/ you can see the error there

Can anyone help?

Posted: Wed Aug 27, 2003 8:39 am

Invalid Session info can be found at http://www.phpbb.com/kb/article.php?article_id=54

-sting

Posted: Wed Aug 27, 2003 9:50 am

Upgarding to the most recent release of the phpBB portal will fix the invalid session error(supposedly) Wink

As for your block problem, try this one instead and see if it works.

Nuke Cadet Joined: Aug 27, 2003 Posts: 7

mikem wrote:

Upgarding to the most recent release of the phpBB portal will fix the invalid session error(supposedly) Wink

how would i go about doing that then? where could i download it from?

got a site visitors block that works Smile

Nuke Cadet Joined: Aug 27, 2003 Posts: 7

So no one can tell me where i can download the most recent release of the phpBB portal?

Posted: Tue Sep 02, 2003 6:03 am

If the phpBB portal is what I think it is (ie the product itself), I would check http://www.phpbb.com/ first but that's just me.

You guys may be talking about something altogether separate though.

Laughing

-sting

Posted: Tue Sep 02, 2003 6:47 am

http://nukecops.com/downloads-file-128-details-BBtoNuke_NC-2.0.5.html

Posted: Tue Sep 02, 2003 6:55 am

Open blocks/block-Site_Visitors.php
find:

Code:

sql_query( "DELETE FROM $prefix"._users." WHERE time < '$past'", $dbi);

Replace with:

Code:

sql_query( "DELETE FROM $prefix"._session." WHERE time < '$past'", $dbi);

Nuke Cadet Joined: Aug 27, 2003 Posts: 7

Thanks a lot people everything is working now! Cheers for the help!

Alan
BangorCruise.co.uk