Pages (2): 1 2   
Member
Member
zbudek   29-12-2013, 09:12
#1

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

Administrator
Administrator
acrylian   29-12-2013, 09:54
#2

Please upgrade to the support build.

Member
Member
zbudek   29-12-2013, 10:19
#3

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

Administrator
Administrator
acrylian   29-12-2013, 11:36
#4

You really did upgrade to the support build?

Member
Member
zbudek   29-12-2013, 11:54
#5

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)

Administrator
Administrator
acrylian   29-12-2013, 12:34
#6

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.

Member
Member
zbudek   29-12-2013, 13:35
#7

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?

Administrator
Administrator
acrylian   29-12-2013, 15:45
#8

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

Member
Member
vincent3569   29-12-2013, 18:15
#9

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.

Administrator
Administrator
acrylian   29-12-2013, 18:32
#10

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

Pages (2): 1 2   
  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.