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

Title: problem in Mysql when i want go to one of forums or sub forums!
Post by: SaBD on January 22, 2006, 02:22:50 AM

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

QuoteYou 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
(http://popmusic.ir/bashgah/index.php?board=5.0)
http://popmusic.ir/bashgah/index.php?board=2.0 (http://popmusic.ir/bashgah/index.php?board=2.0)

http://popmusic.ir/bashgah/index.php?board=6.0 (http://popmusic.ir/bashgah/index.php?board=6.0)

and other sub forum's links!

Title: Re: problem in Mysql when i want go to one of forums or sub forums!
Post by: Fizzy on January 22, 2006, 04:46:25 AM

You have zero members showing.

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

Title: Re: problem in Mysql when i want go to one of forums or sub forums!
Post by: SaBD on January 22, 2006, 05:40:04 AM

thanks!
I did your order and problem solved!

Title: Re: problem in Mysql when i want go to one of forums or sub forums!
Post by: Fizzy on January 22, 2006, 05:30:39 PM

Glad you got it sorted ;)

Title: Re: problem in Mysql when i want go to one of forums or sub forums!
Post by: ThisForumRules on February 03, 2006, 12:05:58 AM

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.

Title: Re: problem in Mysql when i want go to one of forums or sub forums!
Post by: Benqo on February 07, 2006, 06:05:22 PM

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?

Title: Re: problem in Mysql when i want go to one of forums or sub forums!
Post by: Fizzy on February 07, 2006, 06:53:35 PM

Hi Bengo,

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

Title: Re: problem in Mysql when i want go to one of forums or sub forums!
Post by: Benqo on February 08, 2006, 01:20:58 AM

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

Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: SaBD on January 22, 2006, 02:22:50 AM