Re: [campsite-support] Problem posting comments following upgrade
  • Vote Up0Vote Down importimport
    Posts: 0Member
    hi!

    is that the error you get when trying to post a comment? if not, what
    action were you trying to execute?

    thanks


    On 4/3/07, phorum@code.campware.org wrote:
    > Author: myers
    > Link: http://code.campware.org/phorum/read.php?8,5434,5434#msg-5434
    > --------------------------------------------------------------------------------
    >
    > Hi all,
    >
    > I have just upgraded from Campsite 2.6.1 to 2.6.7, running on a Debian server and MySQL 4.0.24.
    >
    > Comments worked perfectly before but I now get this error (email/host details changed):
    >
    > 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 ' parent_id=16, author='Admin', : Insert into phorum_messages set forum_id = 1, datestamp=1175613265, thread=, parent_id=16, author='Admin', subject='Admin', email='email@domain.com', ip='host-1.2.3.4.com', user_id=1, moderator_post=0, status=2, sort=2, msgid='13104fe65d836a5dcb62e82ec2d044bf', body='test', closed=0
    >
    > Any suggestions?
    >
    > Thanks in advance,
    >
    > myers
    >
    > --
    > Sent from Campware Forums
    > http://code.campware.org/phorum
    >


    --
    /holman
  • 1 Comment sorted by
  • Vote Up0Vote Down importimport
    Posts: 0Member
    Hi,

    It was on posting comments, but I have located the problem.

    It was not the upgrade that caused the problem - that was a coincidence. I had previously deleted a comment thread used for testing on the forum and then when I upgraded I tried to post a comment via the article page, which generated the error.

    I hope that makes sense!

    Many thanks,

    myers
Add a Comment