MyBB Community Forums

i install the new version of mybb (1.2.9) there is not error on index but when i wanto showthread it say

Warning: Division by zero in /srv/www/vhosts/mydomain.net/httpdocs/showthread.php on line 650

Warning: Division by zero in /srv/www/vhosts/mydomain.net/httpdocs/inc/functions.php on line 590
MySQL error: 1064
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 'yes' at line 1
Query: SELECT p.pid FROM mybb_posts p WHERE p.tid='3' AND (p.visible='0' OR p.visible='1') ORDER BY p.dateline LIMIT 0, yes


server= linux
mysql=4.1.13
phpmyadmin= 2.8.2.4

what is the problem?

Hi,

Can you please check in your User CP under Edit Options that you have a valid number of posts per page selected? Also check in the Admin CP under Board Settings > Change > Show Thread Settings to see if your board default is correctly set as a numeric value.

thanks.

the Admin CP under Board Settings > Change > Show Thread Settings was not numeric. was written "yes" i change it with numeric "10"

now there is not any error.

thanks a lot.