Post by fork » Tue Jun 07, 2016 1:01 am

Hi,

On my new website on all product pages on top there are errors as below:

Notice: 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 's Reagent'' at line 1
Error No: 1064
SELECT * FROM oc_url_alias WHERE `query` = 'tag=0' OR `qu-ery` = 'Simon's Reagent' in /home/**********/public_html/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /home/**********/public_html/catalog/controller/common/seo_url.php on line 110

How resolve it?

thanks

New member

Posts

Joined
Sun May 08, 2016 5:32 am

Post by i2Paq » Tue Jun 07, 2016 1:32 am

What did you change?

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by straightlight » Tue Jun 07, 2016 1:40 am

This error is based on an installed contribution or altered query compared to the original. The reason why you're seeing this error is due to quote string characters not being escaped.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com Administrator / Quality Assurance Analyst / Programmer


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by AlexDW » Tue Jun 07, 2016 1:42 am

Use only alfabet A-z & numerical 0-9 symbols for file names and seourl.
All other symbols (include space) need change to dash ( - ) or underscore ( _ ) or even skip.

Useful Opencart extensions


User avatar
New member

Posts

Joined
Sun Jun 05, 2016 3:32 am
Who is online

Users browsing this forum: No registered users and 44 guests