Jump to content


Photo
- - - - -

MYSQL Error 0


  • This topic is locked This topic is locked
3 replies to this topic

#1 renee

renee
  • JBZoo User
  • User rate: 0
  • posts: 72
  • topics: 26

Posted 05 August 2013 - 09:24

I am working with JBZOO and get the following intermittent error on a module filter:

SQL=INSERT INTO `jos_rsseo_pages` SET `url` = 'case-studies?e[_itemname]=&e[ca7f0627-6ec0-4413-
8dd9-de8c4298b817][]=Legal services&limit=20&order=alpha&logic=or&send-form=Search&controller=
search&Itemid=475&option=com_zoo&task=filter&exact=1&type=case-study&app_id=6' , `title` = 
'Case Studies' , `keywords` = '' , `description` = '' , `sitemap` = 0 , `crawled` = 0 , `level`
 = 127 , `date` = '2013-08-05 08:08:43'

Joomla Version: 3.1.5

ZOO 3.0.13

JBZOO Current as of today

 

I'm not sure why the SQL statement is referecing RSSEO - a third party SEO extension from RS JOOMLA.

 

Is this perhaps to do with the ordering of plugins?


  • 0

#2 SmetDenis

SmetDenis
  • Administrators
  • User rate: 139.4
  • posts: 16232
  • topics: 200

Posted 05 August 2013 - 10:09

Hi

Sorry, but RSSEO is not our product.
As I see it incorrectly created a query to the database.

Maybe, you better ask a support of RSSEO component.
  • 0
JBZoo v4.0 и новый чудный мир Open Source GPL
Отключайте проверку лицензий как можно скорее!



— Есть два типа людей: Кто еще не делает бекапы и кто уже делает бекапы.


#3 renee

renee
  • Topic Starter
  • JBZoo User
  • User rate: 0
  • posts: 72
  • topics: 26

Posted 05 August 2013 - 11:16

The query does not occur spontaneously.

 

It is created by your filter module on pressing the search button IN YOUR PRODUCT.


  • 0

#4 SmetDenis

SmetDenis
  • Administrators
  • User rate: 139.4
  • posts: 16232
  • topics: 200

Posted 06 August 2013 - 10:08

Hi

Request is generated using the current page address.
RSSEO not properly escapes special characters in the address.

The address is formed for the filter correctly, all the characters used meet the web-standards.

Sorry, but it's not our error. We can not in any way affect to this database query.
It generated not in our code.
  • 0
JBZoo v4.0 и новый чудный мир Open Source GPL
Отключайте проверку лицензий как можно скорее!



— Есть два типа людей: Кто еще не делает бекапы и кто уже делает бекапы.





Click to return to top of page in style!