thordur
26-05-2008, 15:10
w komponencie artbanner 2 PL mam ustawione 2 robocze kategorie(Banners 100x100 i Banners 468x60). po podaniu pierwszej z nich w zakładce kategorie modułu artbanners 2 PL na stronie wyswietla mi sie takie cus:
DB function failed with error number 1064
Something is wrong in your syntax obok '100x100)) AND (('2008-05-26' <= SUBSTRING(publish_down,1,10' w linii 1 SQL=SELECT * FROM jos_artbanners WHERE (tid IN (Banners 100x100)) AND (('2008-05-26' <= SUBSTRING(publish_down,1,10) OR publish_down = '0000-00-00 00:00:00' ) AND '2008-05-26' >= SUBSTRING(publish_up,1,10) AND ( (reccurtype = 0) OR (reccurtype = 1 AND reccurweekdays LIKE '%1%') ) AND '14:05:30' >= SUBSTRING(publish_up,12) AND ('14:05:30' <= SUBSTRING(publish_down,12) OR SUBSTRING(publish_down,12) = '00:00:00') AND access <= '0' AND state = '1') ORDER BY last_show ASC, msec ASC
nie bardzo wiem o co chodzi. z góry dziekuje za pomoc
DB function failed with error number 1064
Something is wrong in your syntax obok '100x100)) AND (('2008-05-26' <= SUBSTRING(publish_down,1,10' w linii 1 SQL=SELECT * FROM jos_artbanners WHERE (tid IN (Banners 100x100)) AND (('2008-05-26' <= SUBSTRING(publish_down,1,10) OR publish_down = '0000-00-00 00:00:00' ) AND '2008-05-26' >= SUBSTRING(publish_up,1,10) AND ( (reccurtype = 0) OR (reccurtype = 1 AND reccurweekdays LIKE '%1%') ) AND '14:05:30' >= SUBSTRING(publish_up,12) AND ('14:05:30' <= SUBSTRING(publish_down,12) OR SUBSTRING(publish_down,12) = '00:00:00') AND access <= '0' AND state = '1') ORDER BY last_show ASC, msec ASC
nie bardzo wiem o co chodzi. z góry dziekuje za pomoc