Post by mishu_ku » Mon Feb 05, 2018 9:07 pm

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!

www.coverstore.ro


User avatar
New member

Posts

Joined
Thu Jan 24, 2013 5:55 am

Post by florinsith » Sun Feb 11, 2018 3:16 pm

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.

Image
My Extensions - SuperTheme - Opencart templates - Opencart modules


User avatar
Expert Member

Posts

Joined
Fri May 14, 2010 2:36 am


Post by mishu_ku » Wed Feb 14, 2018 12:05 am

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

eroare-500.png (108.76 KiB) Viewed 63 times


www.coverstore.ro


User avatar
New member

Posts

Joined
Thu Jan 24, 2013 5:55 am

Post by florinsith » Mon Feb 19, 2018 5:23 pm

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

Image
My Extensions - SuperTheme - Opencart templates - Opencart modules


User avatar
Expert Member

Posts

Joined
Fri May 14, 2010 2:36 am

Who is online

Users browsing this forum: No registered users and 6 guests