Salut,
Am o problema cu site-ul si anume ca atunci cand navighez pe pagini si dau back sau ex. daca sunt pe pagina 3 si apas pe pagina inferioara 2, 1 imi apare eroare 500. Ma poate ajuta cineva cu rezolvarea erorii? Contracost evident.
Site-ul este www.coverstore.ro.
Multumesc!
Daca e 500, verifica logul de erori ca sa vezi ce eroare primesti mai precis. M-am plimbat un pic pe site si nu am primit niciun 500, doar connection reset de vreo 2 ori.
Apare aceasta eroare:
"tack trace:
#0 /home/covers/public_html/system/storage/modification/system/library/db.php(16): DB\ in /home/covers/public_html/system/library/db/mysqli.php on line 40
[13-Feb-2018 17:58:57 Europe/Bucharest] PHP Fatal error: Uncaught exception 'Exception' with message 'Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-12, 12' at line 1<br />Error No: 1064<br /> SELECT p.product_id, p.sort_order, "1" AS match_filters, pp.sort_order FROM `oc_product` AS p INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id) INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id) INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id) INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id) INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id) WHERE p2s.store_id = '0' AND p2c.category_id = '326' AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1 ORDER BY pp.sort_order ASC, pd.name ASC LIMIT -12, 12' in /home/covers/public_html/system/library/db/mysqli.php:40
Stack trace:
#0 /home/covers/public_html/system/storage/modification/system/library/db.php(16): DB\ in /home/covers/public_html/system/library/db/mysqli.php on line 40"
Daca intri pe o categorie de produse Ex. iPhone 8 si navighezi pe pagini...daca dai inapoi pe o pagina inferioara de jos apare aceasta eroare.
"tack trace:
#0 /home/covers/public_html/system/storage/modification/system/library/db.php(16): DB\ in /home/covers/public_html/system/library/db/mysqli.php on line 40
[13-Feb-2018 17:58:57 Europe/Bucharest] PHP Fatal error: Uncaught exception 'Exception' with message 'Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-12, 12' at line 1<br />Error No: 1064<br /> SELECT p.product_id, p.sort_order, "1" AS match_filters, pp.sort_order FROM `oc_product` AS p INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id) INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id) INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id) INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id) INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id) WHERE p2s.store_id = '0' AND p2c.category_id = '326' AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1 ORDER BY pp.sort_order ASC, pd.name ASC LIMIT -12, 12' in /home/covers/public_html/system/library/db/mysqli.php:40
Stack trace:
#0 /home/covers/public_html/system/storage/modification/system/library/db.php(16): DB\ in /home/covers/public_html/system/library/db/mysqli.php on line 40"
Daca intri pe o categorie de produse Ex. iPhone 8 si navighezi pe pagini...daca dai inapoi pe o pagina inferioara de jos apare aceasta eroare.
Attachments
eroare-500.png (108.76 KiB) Viewed 1030 times
Nu reusesc sa reproduc din butoane, decat daca pun eu page=-1 in url. Probabil e vreun mic bugla paginatie, problema mai mare e in extensia de filtre care nu valideaza startul. Cel mai mic start posibil trebuie sa fie 0, la tine se poate si pe minus.
ORDER BY pp.sort_order ASC, pd.name ASC LIMIT -12, 12
Who is online
Users browsing this forum: No registered users and 51 guests