one of my phpbb forums has an error

hbalagh · 03-22-2005, 08:50 PM

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 · 03-22-2005, 09:39 PM

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 · 03-22-2005, 10:05 PM

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

Peter · 03-23-2005, 10:47 AM

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 · 03-23-2005, 10:53 AM

i believe i was using 2.11

PoorDoggie · 03-23-2005, 11:19 AM

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!

????: NamePros.com http://www.namepros.com/programming/77145-one-my-phpbb-forums-has-error.html

Tom

hbalagh · 03-23-2005, 11:23 AM

ill llook into it

thanks

hotrod12 · 03-23-2005, 02:03 PM

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 · 03-23-2005, 02:42 PM

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 · 03-23-2005, 06:03 PM

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 · 03-23-2005, 07:13 PM

Wow how did you know what code to use?

gamex · 03-23-2005, 07:54 PM

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

Peter · 03-24-2005, 01:02 AM

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 · 03-24-2005, 07:31 PM

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 · 03-24-2005, 07:53 PM

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 · 03-24-2005, 07:55 PM

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

hotrod12 · 03-25-2005, 08:26 AM

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

PoorDoggie · 03-25-2005, 02:43 PM

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 · 03-25-2005, 07:32 PM

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 · 03-26-2005, 06:20 AM

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 · 03-26-2005, 09:14 AM

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

03-22-2005, 08:50 PM	THREAD STARTER #1 (permalink)
hbalagh Senior Member Join Date: Dec 2004 Location: San Diego Posts: 1,472	one of my phpbb forums has an error 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 __________________ My Personal Blog

03-22-2005, 09:39 PM	#2 (permalink)
majinbuu1023 Senior Member Join Date: Jan 2005 Location: New Zealand Posts: 3,747	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 __________________ WowHumor.net - Funny World of Warcraft Pictures

03-23-2005, 10:47 AM	#4 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,069	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) __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

03-23-2005, 10:53 AM	THREAD STARTER #5 (permalink)
hbalagh Senior Member Join Date: Dec 2004 Location: San Diego Posts: 1,472	i believe i was using 2.11 __________________ My Personal Blog

03-23-2005, 11:23 AM	THREAD STARTER #7 (permalink)
hbalagh Senior Member Join Date: Dec 2004 Location: San Diego Posts: 1,472	ill llook into it thanks __________________ My Personal Blog

03-22-2005, 10:05 PM	#3 (permalink)
websoft Account Suspended Join Date: Jan 2005 Posts: 835	hbalagh. how bout if i help you solve the problem. what would you do for me

03-23-2005, 11:19 AM	#6 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,408	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! ????: NamePros.com http://www.namepros.com/programming/77145-one-my-phpbb-forums-has-error.html Tom

03-23-2005, 02:03 PM	#8 (permalink)
hotrod12 Senior Member Join Date: Jan 2005 Location: USA Posts: 1,149	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.

03-23-2005, 02:42 PM	#9 (permalink)
gamex NamePros Regular Join Date: Feb 2004 Location: Student @ UConn Posts: 411	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... __________________ Joe

03-23-2005, 06:03 PM	#10 (permalink)
Sergio965 Account Closed Join Date: Apr 2004 Location: ~root Posts: 1,091	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....

03-23-2005, 07:13 PM	#11 (permalink)
hotrod12 Senior Member Join Date: Jan 2005 Location: USA Posts: 1,149	Wow how did you know what code to use?

03-23-2005, 07:54 PM	#12 (permalink)
gamex NamePros Regular Join Date: Feb 2004 Location: Student @ UConn Posts: 411	Its the code that was in your error in the second post __________________ Joe

03-24-2005, 01:02 AM	#13 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,069	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. __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

03-24-2005, 07:31 PM	THREAD STARTER #14 (permalink)
hbalagh Senior Member Join Date: Dec 2004 Location: San Diego Posts: 1,472	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 __________________ My Personal Blog

03-24-2005, 07:53 PM	#15 (permalink)
hotrod12 Senior Member Join Date: Jan 2005 Location: USA Posts: 1,149	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!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Phpbb Forums	aal814	Web Design Discussion	7	04-11-2005 09:13 PM
ABSOLUTELY FREE: Web Hosting, Image Hosting, Forums, Web Proxy, Webmail & Short URLs!	IncognitoNet	For Sale / Advertising Board	0	02-06-2005 03:07 PM

03-24-2005, 07:55 PM	THREAD STARTER #16 (permalink)
hbalagh Senior Member Join Date: Dec 2004 Location: San Diego Posts: 1,472	yea i had that mod installed on another forum i just never made it to all my forums lol __________________ My Personal Blog

03-25-2005, 08:26 AM	#17 (permalink)
hotrod12 Senior Member Join Date: Jan 2005 Location: USA Posts: 1,149	Lol well it is a great mod and soon I will be able to know if somebody is trying to hack me.

03-25-2005, 02:43 PM	#18 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,408	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.

03-26-2005, 09:14 AM	#21 (permalink)
hotrod12 Senior Member Join Date: Jan 2005 Location: USA Posts: 1,149	Yeah I know I just saw today that the security mod I installed already blocked one attempt to hack my forum.