Announcement prob....

[Zombie]

This is the only prob that I have come across so far in my SMF.
Just wondering what it means and why I can't post announcements.

Code Select Expand

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 ' 30, 25)
GROUP BY mg.ID_GROUP
ORDER BY mg.minPosts, IF(mg.I
File: /home/*****/public_html/forum/Sources/Post.php
Line: 1475

This is a stock version of the post.php file.
Running version 4.3.9 php
Running version 4.022-standard MySQL

Anyone else come across this?

[[Unknown]]

Strange.  In Post.php, you'll see the following comment near the line that error occured on:

Code Select Expand

// Get all membergroups that have access to the board the announcement was made on.

Above it, please try adding:

Code Select Expand

echo 'Before: ', implode(', ', groups);
foreach ($groups as $id => $group)
$groups[$id] = (int) $group;
echo '<br />After: ', implode(', ', groups);

And, what does it say?

Thanks,
-[Unknown]

[Zombie]

I added it and came up with this one.

Code Select Expand

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 ' 30)
GROUP BY mg.ID_GROUP
ORDER BY mg.minPosts, IF(mg.ID_GR
File: /home/zombie65/public_html/forum/Sources/Post.php
Line: 1480

[[Unknown]]

Sorry, can you add right after what I had before...

die;

The point is, it should show the numbers that aren't working...

-[Unknown]

[Zombie]

I did.
Now all I get is this


Before:
After:

on a blank page.

[[Unknown]]

I'm sorry, please use:

Code Select Expand

echo 'Before: ', implode(', ', $groups);
foreach ($groups as $id => $group)
$groups[$id] = (int) $group;
echo '<br />After: ', implode(', ', $groups);
die;

-[Unknown]

[Zombie]

Thanks for the heads up.  I've changed the permissions and got it going.  I just wasn't able to decipher that error message so I had no direction to look for the problem.