This site uses cookies and similar technologies.

If you don't change browser settings, you agree to it.

I understand
Announcement: Please use Github, to report any new issue or pull request.
None
Wedal
2013-10-25
All
PHP 5.3

Input:

  • Joomla 3.1.5
  • Seblod 3.1.5
  • The simplest content type "Ads"(fields "ads_title, ads_text")
  • Free data store(table #__seblod_ads created manually through PhpMyAdmin):

1.jpg

Goal:

List of ads in backend.

Simplest search type:

2.jpg

In a backend created menu with this search type.

Result:

1064 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 'exact' at line 7 SQL=SELECT t0.id as pid, t0.pk as pk, t0.pkb as pkb,t0.cck as cck, t0.storage_location as loc,tt.id AS type_id, tt.alias AS type_alias FROM `ylnxi_cck_core` AS t0 LEFT JOIN `ylnxi_seblod_ads` AS t1 ON t1.id = t0.pk LEFT JOIN `ylnxi_cck_core_types` AS tt ON tt.name = t0.cck WHERE t0.cck = 'obyavleniya' GROUP BY t0.pk ORDER BY t0.cck exact 

3.jpg

---------------------------------------------

Without exact sql-query performed correctly.

With skeleton Article  sql-query performed correctly anytime.

Files & Images

123
Need some help?

Comments

Comment
3 years ago
Old issue, already fixed. To be closed.
Klashttp://joogpot.eu