[Solved] The portal page gives an MySQL error.

Current Version: 1.0.6
Released: 09.01.10
Forum rules
Before creating a new support thread, please take a look in the board3 Portal FAQ and use the search!
Many questions have already been answered.
Locked

Topic author
MicroBoy
Active Member
Posts: 17
Joined: 28. December 2008 22:41
phpBB.de User: MicroBoy
phpBB.com User: MicroBoy

[Solved] The portal page gives an MySQL error.

Post by MicroBoy »

Your Portal Version: 1.0.6
Your phpBB Type: Standard phpBB3
MODs installed: Yes
Your knowledge: Basic Knowledge
Boardlink: http://ministryofmath.co.cc/forumi/

What have you done before the problem was there?
Lately changed some forums permissions and some templates.

What have you already tryed to solve the problem?
Nothing.

Description and Message
When I try to go to my portal page it gives me an error "Unknown column 't.forum_id' in 'where clause' [1054]" it just shows when the user is not logged, when I log using the forum page not portal page then even if I go to portal page everything it is all right.
Last edited by MicroBoy on 24. November 2010 17:59, edited 1 time in total.
User avatar

Marc
Dev
Posts: 2504
Joined: 17. July 2008 21:08
phpBB.de User: marc1706
phpBB.com User: Marc
Location: Clausthal-Zellerfeld / München
Contact:

Re: The portal page gives an MySQL error.

Post by Marc »

Did you recently update your Portal? If yes, check if you copied all files mentioned in the udpate instructions.

By the way, it would be good to see the complete error message. Could you maybe enable debug mode? That should show the complete message.

If that does not work, try turning of every block one after one. Check the portal page every time you disabled a block. If the error message does not show after you disabled the block, we should know what is causing this error.

Also, you could try to open the Error Log in the ACP, maybe the complete error message is saved there.

Topic author
MicroBoy
Active Member
Posts: 17
Joined: 28. December 2008 22:41
phpBB.de User: MicroBoy
phpBB.com User: MicroBoy

Re: The portal page gives an MySQL error.

Post by MicroBoy »

I recently updated phpBB version not portal version. I can not change the php.ini file for errors showing, cause I have a shared host. There is not any problem at LOGs at ACP.
User avatar

Marc
Dev
Posts: 2504
Joined: 17. July 2008 21:08
phpBB.de User: marc1706
phpBB.com User: Marc
Location: Clausthal-Zellerfeld / München
Contact:

Re: The portal page gives an MySQL error.

Post by Marc »

You have to enable Debug in your config.php and not in your php.ini.

Topic author
MicroBoy
Active Member
Posts: 17
Joined: 28. December 2008 22:41
phpBB.de User: MicroBoy
phpBB.com User: MicroBoy

Re: The portal page gives an MySQL error.

Post by MicroBoy »

Thanks a lot, I know noticed that the problem was with "Recent Topics", I did not believe at first that this can be the problem because I made some changes there while ago, but did not noticed the problem cause it just shows if you are not logged in.
User avatar

Marc
Dev
Posts: 2504
Joined: 17. July 2008 21:08
phpBB.de User: marc1706
phpBB.com User: Marc
Location: Clausthal-Zellerfeld / München
Contact:

Re: The portal page gives an MySQL error.

Post by Marc »

Could you maybe upload your portal/block/recent.php inside a zip file?

Topic author
MicroBoy
Active Member
Posts: 17
Joined: 28. December 2008 22:41
phpBB.de User: MicroBoy
phpBB.com User: MicroBoy

Re: The portal page gives an MySQL error.

Post by MicroBoy »

I fixed it, I made some changes trying to show Recent Posts instead of Recent Topics but it did not work, but now I modified "News Compact" and via it I'm showing recent posts. Everything it is all right now.
Locked

Return to “board3 Portal 1.0.x - English Support”