I just installed the rc4 shoutbox on my forum the install part went fine but when I try and open the shoutbox I get:
Code:
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 '-24, 24' at line 1
Query: SELECT * FROM mybb_shouts ORDER BY dateline LIMIT -24, 24
thanks for any help
.
Chris
That's strange, as it would appear that MySQL is counting -19 rows in the shouts table. O_o
The best thing I can suggest at the moment is that you use a MySQL database administration tool such as phpMyAdmin to empty the table mybb_shouts. I'm not sure if it will work but I think it's worth a try.
Or, you can just run the following query (to be safe)...
Code:
TRUNCATE TABLE mybb_shouts
Basically just empties the table mybb_shouts for you.
eXauls, that query would truncate all entries in the posts table. Do you mean the shoutbox table?
Woops, yeah. I'll fix that now.
thanks for the help but I opened phpMyAdmin ran the query TRUNCATE TABLE mybb_shouts and it ran but didn't work(same error when opening the shoutbox) anymore suggestion on what the problem could be? thnaks
.
Chris
Update: I just installed the "tweaked" shout box and when I post in it says
Quote: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 '-5, 5' at line 1
Query: SELECT * FROM mybb_shouts ORDER BY sid DESC LIMIT -5, 5
I'm getting the same error you mentioned in your first post:
Quote: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 '-24, 24' at line 1
Query: SELECT * FROM mybb_shouts ORDER BY dateline LIMIT -24, 24