problem in Mysql when i want go to one of forums or sub forums!

[SaBD]

Hi
I install smf 1.1rc2.
and i made some forums but when i want go to any forums i see this error:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 5)' at line 3
File: /home/popmusic/public_html/bashgah/Sources/MessageIndex.php
Line: 102

please see these links and help me!

http://popmusic.ir/bashgah/index.php?board=5.0
[nofollow]
http://popmusic.ir/bashgah/index.php?board=2.0 [nofollow]

http://popmusic.ir/bashgah/index.php?board=6.0 [nofollow]

and other sub forum's links!

[Fizzy]

You have zero members showing.

Can you try running all forum maintenance in Admin Panel and check your database settings.

[SaBD]

thanks!
I did your order and problem solved!

[Fizzy]

Glad you got it sorted

[ThisForumRules]

I had this exact same problem in a fresh install of SMF 1.1 RC2.  It seems to occur only if I delete the default board after freshly installing SMF and then create some boards.  Running the stuff in the "Forum Maintenance" section of the admin area of the forum fixed it for me, too.

[Benqo]

For some reason it did not for me. I also deleted the default board and the first message of the fresh installation and created two new boards having no message, none of them. The error is still there with the exact same error message. Any hints?

[Fizzy]

Hi Bengo,

Add a test message in them both if you can, then try running Forum Maintenance

[Benqo]

I'm sorry, I fixed it, forgot to delete or edit my message. Repairing the statistics solved the problem.