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...

Please upgrade to the support build.

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

You really did upgrade to the support build?

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)

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.

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?

Better the theme is fixed. I am sure Vincent will do as soon as he can.

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.

@Vincent: Don't forget to update to the support build.

Try again, new support build made today.

hi works great! thanks everyone and Vincent. all the best in 2014 piotr

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.

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).