Not signed in (Sign In)

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

General Support: MySQL error

Bottom of Page

1 to 4 of 4

  1.  
    • CommentAuthorMichlis
    • CommentTimeJun 21st 2008 edited
     
    Hi,
    I am running Plogger Version 3.2.LastChangedRevision Beta on MySQL 4.1.22-standard-log and when trying to view the gallery I get an 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 ') GROUP BY parent_id' at line 3
    SELECT parent_id,COUNT(*) AS albumcount FROM `plogger_albums` WHERE `parent_id` IN (-1) AND `id` IN () GROUP BY parent_id

    I have check Plogger before on my laptop running MySQL 5.0.51a and it worked ok. Is it not compatible with 4.* ? Can I fix it somehow to work with older MySQL?
    •  
      CommentAuthorsidtheduck
    • CommentTimeJun 21st 2008
     
    Hi Michlis,

    I need to add the code to the SVN to fix this error. Basically, it will go away once you add one photo to your gallery (right now it's empty, correct?). Sorry about that.
    • CommentAuthorMichlis
    • CommentTimeJun 21st 2008
     
    Hi,
    Yes, I don't have any pictures yet because the upload doesn't work ;) Let me know when the fix is ready and what to do. Thanks!
    •  
      CommentAuthorsidtheduck
    • CommentTimeJun 22nd 2008
     
    You can still use it. Just upload a picture and the error will go away. I'm going to add the code to the SVN so the error never shows up. But it still works without it anyway as soon as you upload a picture.

1 to 4 of 4

  1.