one of my phpbb forums has an error

[hbalagh]

i have this forum http://www.islamisbeautiful.com/forum/ and i just went there and get this error on the screen i haven't done anything to it as far as editing since shortly after i bought it...can you tell me what could cause this error

[majinbuu1023]

UPDATE phpbb_users SET user_session_time = 1111552858, user_session_page = 0, user_lastvisit = 0, user_lastlogon = 1111552858, user_totallogon=user_totallogon+1 WHERE user_id = -1

Line : 171
File : /home/islamis/public_html/forum/includes/sessions.php

I dunno..
post on the phpbb forums

[websoft]

hbalagh. how bout if i help you solve the problem. what would you do for me

[Peter]

for some reason the user_lastlogon field in phpbb_users doesnt seem to exist, you may wish to open it up in phpmyadmin and check the actual table exists.

Were you using an old version of phpBB if so it may have been exploited (saying that there are several known exploits for the latest version atm)

[hbalagh]

i believe i was using 2.11

[PoorDoggie]

You may want to reinstall the phpbb software.

TO INSTALL PHPbb 2.0.13 WITH INTACT DATABASES:
if all your databases are still intact what you will need to is this:
1. keep all your tables named phpbb_*** and delete the forum on your server.
2. Copy the new (2.0.13) phpbb onto your server, and then install it with the table prefix temp_ (or something, just NOT phpbb_). Use the same table as the old tables! Witht the same details you put in.
3. Download and open [for editing] config.php, and just change the table prefix to "phpbb_".
4. Upload the new config.php file.

I would recomend upgrading to 2.0.13, as it is more security tight! If you databases aren't intact then you will want to re-install the forum all together, in which case just use the install form to do it!

Tom

[hbalagh]

ill llook into it thanks

[hotrod12]

This happened to me too and I am pretty sure I was hacked but my host gave me a backup of the database and it was all fixed. You might want to do that or use a backup on your pc.

[gamex]

I used to get errors on my Invision board similar to this, I went into phpmyadmin and just repaired all of the tables and that worked some of the times...

[Sergio965]

Uhm...just run the following in phpmyadmin.

UPDATE phpbb_users SET user_session_time = 1111626268, user_session_page = 0, user_lastvisit = 0, user_lastlogon = 1111626268, user_totallogon=user_totallogon+1 WHERE user_id = -1

should fix it....

[hotrod12]

Wow how did you know what code to use?

[gamex]

Its the code that was in your error in the second post

[Peter]

sergio965 that isnt going to accomplish anything the error message quite clearly states that the user_lastlogon field does not exist so trying to do the SQL again will FAIL. to fix this error that field will have to be recreated.

[hbalagh]

i was hacked.... i generated a backup and reinstlled it and this came up
You Have Been Hacked
From The Paradox Hacking Group


damn them lol
so i deleted it
ohh well i guess ill just have to redo do it....wish i could afford vbullitin

[hotrod12]

Yeah me too but for now phpbb is awesome. Install this mod (http://phpbb-tweaks.com/downloads.php?mode=sub&cid=916) and that should increase the security of your forum. I just installed it and it took about 30 minutes with little mod experience. Good luck!

[hbalagh]

yea i had that mod installed on another forum i just never made it to all my forums lol

[hotrod12]

Lol well it is a great mod and soon I will be able to know if somebody is trying to hack me.

[PoorDoggie]

phpbb 2.0.13 is supposed to be "hack-proof" - that is, the phpbb board, not the server. I suggest you install that version of phpbb.

[Sabre]

Originally Posted by PoorDoggie

phpbb 2.0.13 is supposed to be "hack-proof" - that is, the phpbb board, not the server. I suggest you install that version of phpbb.

Was going to mention same as Tom!

[Peter]

Originally Posted by PoorDoggie

phpbb 2.0.13 is supposed to be "hack-proof" - that is, the phpbb board, not the server. I suggest you install that version of phpbb.

That certainly isnt true there are already several vulnerabilities found in it.

[hotrod12]

Yeah I know I just saw today that the security mod I installed already blocked one attempt to hack my forum.