Not signed in (Sign In)

Vanilla 1.1.10 is a product of Lussumo. More Information: Documentation, Community Support.

General Support: SQL Error When Posting a Comment

Bottom of Page

1 to 2 of 2

  1.  
    •  
      CommentAuthorctlsmite
    • CommentTimeJun 20th 2006
     
    Normally everything works fine on my site, but out of the blue, I'm getting a new error when I post a comment to any photo. Any ideas?

    Here's the text of the error:

    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 'ORDER BY `date_submitted` ASC' at line 1

    SELECT id FROM `plogger_pictures` WHERE parent_album = ORDER BY `date_submitted` ASC
  2.  
    from what you've posted, it appears that the WHERE section isn't complete... parent_album needs to = something before you can ORDER it. And I think you'll need to add parent_album to the SELECT if you use it in the WHERE.

1 to 2 of 2

  1.