Invalid SQL error

[The Librarian]

I have exactly the same error message that this guy reported in this thread:

http://www.vbadvanced.com/forum/showthread.php?p=91041&highlight=error+sql+syntax+1064#post91041

But the info there doesn't seem to answer my questions.

I got this error a few days ago when I tried to update the smilie paths for some new post icons I added. It occurred when I hit "next" to go to the second page of smilies (It actually didn't make sense to me that there was more than one page since I thought they were all up to date already except the 3 new post icons I'd just installed.)

All of my smilies and post icons seem to be working fine, so my questions are:

- Do I need to fix this error? If so, how do I go about it?

and

- Will I get the same error if I add more new post icons?

TIA!

[Brian]

Which version of the CMPS are you running?
And no, that error should not have hurt anything as long as your smilies are appearing ok.

[Our Sponsors]

[The Librarian]

Which version of the CMPS are you running?
And no, that error should not have hurt anything as long as your smilies are appearing ok.

The latest version CMPS v2.2.1 (vB 3.6)

So does that mean I don't need to do anything to fix it?

[Brian]

Nope, as long as your images are appearing ok then you shouldn't have any problems. If you do need to update your images again, just look in the vbacmps_install.php file for 2 instances of this code:
if ($minlimit < 0)

And replace each with this:
if ($minlimit < 1)

[Our Sponsors]

[The Librarian]

Nope, as long as your images are appearing ok then you shouldn't have any problems. If you do need to update your images again, just look in the vbacmps_install.php file for 2 instances of this code:
if ($minlimit < 0)

And replace each with this:
if ($minlimit < 1)

Thanks Brian!