Page 1 of 1

[Solved] The portal page gives an MySQL error.

Posted: 23. November 2010 02:47
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.

Re: The portal page gives an MySQL error.

Posted: 23. November 2010 16:01
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.

Re: The portal page gives an MySQL error.

Posted: 23. November 2010 17:47
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.

Re: The portal page gives an MySQL error.

Posted: 23. November 2010 20:58
by Marc
You have to enable Debug in your config.php and not in your php.ini.

Re: The portal page gives an MySQL error.

Posted: 23. November 2010 21:53
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.

Re: The portal page gives an MySQL error.

Posted: 24. November 2010 11:06
by Marc
Could you maybe upload your portal/block/recent.php inside a zip file?

Re: The portal page gives an MySQL error.

Posted: 24. November 2010 16:14
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.