+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: archive error zenphoto 1.4.5.8 (/thread-11556.html)
archive error zenphoto 1.4.5.8 - zbudek - 29-12-2013
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...
archive error zenphoto 1.4.5.8 - acrylian - 29-12-2013
Please upgrade to the support build.
archive error zenphoto 1.4.5.8 - zbudek - 29-12-2013
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
archive error zenphoto 1.4.5.8 - acrylian - 29-12-2013
You really did upgrade to the support build?
archive error zenphoto 1.4.5.8 - zbudek - 29-12-2013
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)
archive error zenphoto 1.4.5.8 - acrylian - 29-12-2013
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.
archive error zenphoto 1.4.5.8 - zbudek - 29-12-2013
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?
archive error zenphoto 1.4.5.8 - acrylian - 29-12-2013
Better the theme is fixed. I am sure Vincent will do as soon as he can.
archive error zenphoto 1.4.5.8 - vincent3569 - 29-12-2013
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.
archive error zenphoto 1.4.5.8 - acrylian - 29-12-2013
@Vincent: Don't forget to update to the support build.
archive error zenphoto 1.4.5.8 - sbillard - 29-12-2013
Try again, new support build made today.
archive error zenphoto 1.4.5.8 - zbudek - 30-12-2013
hi works great! thanks everyone and Vincent. all the best in 2014 piotr
archive error zenphoto 1.4.5.8 - vincent3569 - 31-12-2013
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.
archive error zenphoto 1.4.5.8 - acrylian - 31-12-2013
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).