Home› General support

archive error zenphoto 1.4.5.8

zbudek Member
in General support
after upgrading from 1.4.5.7 to 1.4.5.8 error Archive:

Fatal error: MySQLi Error: ( SELECT DISTINCT `id`, `show`,`title`,`titlelink` FROM `[prefix]news` WHERE `show` = 1 AND (`date` >= "2013-12-01 00:00:00" AND `date` < "2014-01-01 00:00:00") ORDER BY ``date`` desc ) failed. MySQLi returned 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 'date`` desc' at line 1

how to fix? (where to find what file?)
thanks...

Comments

  • acrylian Administrator, Developer
    Please upgrade to the support build.
  • zbudek Member
    ok thanks but update did not help ... same
    Fatal error: MySQLi Error: ( SELECT DISTINCT `id`, `show`,`title`,`titlelink` FROM `[prefix]news` WHERE `show` = 1 AND (`date` >= "2013-12-01 00:00:00" AND `date` < "2014-01-01 00:00:00") ORDER BY ``date`` desc ) failed. MySQLi returned 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 'date`` desc' at line 1 in ....

    .../zp -core/functions-db-MySQLi.php on line 78
  • acrylian Administrator, Developer
    You really did upgrade to the support build?
  • zbudek Member
    I upgrade only:
    index.php
    and
    /Zp-core
    admin site info: 1.4.5.8 [676d2dec8b] (Official build)
    Is it enough? (PS. sorry for my simple English language)
  • acrylian Administrator, Developer
    That is actually correct. If you use a custom theme please try a official included one. I cannot reproduce any issues with the support build. Also clear browser caches.
  • zbudek Member
    so, the problem is probably in THEAM zpArdoise 1.4.5 on defoult works ok. if I go back to version 1.4.5.7 zenphoto?
  • acrylian Administrator, Developer
    Better the theme is fixed. I am sure Vincent will do as soon as he can.
  • vincent3569 Member, Translator
    hi

    I have a look.
    With official zenpage theme, there is the same issue.

    step to reproduce :
    in search field, set an unknown value
    then, the html flow is broken.
  • acrylian Administrator, Developer
    @Vincent: Don't forget to update to the support build.
  • sbillard Member
    Try again, new support build made today.
  • zbudek Member
    hi works great! thanks everyone and Vincent. all the best in 2014 piotr
  • vincent3569 Member, Translator
    there is a hot fix with my theme to avoid an issue with zenphoto 1.4.5.8.

    http://www.vincentbourganel.fr/news/zpArdoise-a-ZenPhoto-ZenPage-theme

    but really, I don't know what are you playing with some core functions...
    there is not always backward compatibility and I have to adapt my themes painfully.

    I think there is a residual issue with the news archive.
    step to reproduce with official themes (garland and zenpage) :
    - go to archives
    - in archive list, select a monthly news archive.
    then, all news counter is wrong (it display the count for the monthly news archive)
    in all other case (news page, search page,...) the news counter is right with all news value.
  • acrylian Administrator, Developer
    Sorry, that you have trouble updating. Feel free to ask if you need help. But sometimes it is needed if things have been wrong from the beginning.

    The guide is always our official themes and also our site's theme which is heavily customized and quite more complex than the official themes. We did not encounter any really serious update issues with that. (The last issue was the search issue but that was not a theme one).
Sign In or Register to comment.