Unknow SQL ERROR

Rate this topic: Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.1.00 out of 6 based on 1 vote(s)
GK User
Sat Apr 05, 2014 5:07 pm
Reply with quote
Report this post
Hi all,
i have some strange problem with categories K2:

SQL=UPDATE `dzaot_finder_terms` AS t INNER JOIN `dzaot_finder_tokens_aggregate` AS ta ON ta.term_id = t.term_id SET t.`links` = t.links + 1


it show me when i try to save new settings in some category...
can anyone know how to fix it ??


my site : www.brzozowiana.pl/portal
User avatar
Expert Boarder

teitbite
Sat Apr 05, 2014 7:09 pm
Reply with quote
Report this post
Hi

Is this all of the message, becuase it's not an error, just a dump of database query. Please check if debug in joomla configuration is disbled. Has anyone made any modifications to code ? Maybe they have left a dump request there.
User avatar
Moderator

GK User
Sat Apr 05, 2014 8:17 pm
Reply with quote
Report this post
teitbite wrote:Hi

Is this all of the message, becuase it's not an error, just a dump of database query. Please check if debug in joomla configuration is disbled. Has anyone made any modifications to code ? Maybe they have left a dump request there.


it is all code - i try to save new settings in K2 categories.... and after about 1 minut it display this error...
in configuration - debug mode is OFF
and no one modificate anything in code....

any other ideas ?
User avatar
Expert Boarder

teitbite
Mon Apr 07, 2014 7:28 pm
Reply with quote
Report this post
Hi

Try reinstall K2, maybe some files got corrupted and if this will not work try disable finder component. Send me an access to joomla panel if none of them will work.
User avatar
Moderator

GK User
Tue Apr 08, 2014 6:07 pm
Reply with quote
Report this post
hi, all passes was sent.

now i wondering is it can be problem with last update of joomla ?...
User avatar
Expert Boarder

teitbite
Wed Apr 09, 2014 4:16 pm
Reply with quote
Report this post
Hi

Plese check if new account is published:

Ostrzeżenie
Login denied! Your account has either been blocked or you have not activated it yet.
User avatar
Moderator

GK User
Thu Apr 10, 2014 9:39 pm
Reply with quote
Report this post
Sorry - now is ok
User avatar
Expert Boarder

teitbite
Fri Apr 11, 2014 6:12 pm
Reply with quote
Report this post
Hi

I was able to login, but saving category parameters has not revaled the error so I could not check what is causing it since it looks to be random. Anyway the name of the table in error point to Smart Search component which is disabled in Your case, so probably disabling also the K2 part of this component will help. Please check the screen and disable all plugins mentioned. This should keep the tables from errors out of the K2.
User avatar
Moderator

GK User
Sat Apr 12, 2014 9:46 am
Reply with quote
Report this post
Hi, but i do not have any smartsearch... i check in plugins and in components also in manage all instaled things...
User avatar
Expert Boarder

GK User
Sat Apr 12, 2014 1:13 pm
Reply with quote
Report this post
Wolak wrote:Hi, but i do not have any smartsearch... i check in plugins and in components also in manage all instaled things...


ok - i found it - i forgot that i have all translate in PL - i disable it
User avatar
Expert Boarder

teitbite
Sun Apr 13, 2014 9:52 pm
Reply with quote
Report this post
Hi

Ok. Let me know if error will show again.
User avatar
Moderator

GK User
Fri May 02, 2014 12:19 pm
Reply with quote
Report this post
Hi,
so i saw this error again... and i I do not know what it depends on....

and next thing when i checking a propereties in right click on my site (with firebug) i see this 2 errors:

Failed to load resource: the server responded with a status of 404 (Not Found) https://ajax.googleapis.com/ajax/libs/j ... -ui.min.js

Failed to load resource: the server responded with a status of 1062 (Duplicate entry 'http://brzozowiana.pl/<script>var _prum = [['id', '536346deabe53' for key 'idx_link_old' SQL=INSERT INTO `dzaot_redirect_links` (`old_url`,`new_url`,`referer`,`comment`,`hits`,`published`,`created_date`) VALUES ('http://brzozowiana.pl/<script>var _prum = [[\'id\', \'536346deabe53db479a1be82\'], [\'mark\', \'firstbyte\', (new Date()).getTime()]];(function() { var s = document.getElementsByTagName(\'script\')[0] , p = document.createElement(\'script\'); p.async = \'async\'; p.src = \'//rum-static.pingdom.net/prum.min.js\'; s.parentNode.insertBefore(p, s);})();</script>', '' ,'http://brzozowiana.pl/', '',1,0, '2014-05-02 09:59:45'))
User avatar
Expert Boarder

teitbite
Mon May 05, 2014 8:47 pm
Reply with quote
Report this post
Hi

Ok so it means a link to jquery library is wrong. Plese try using a local library or use Easy jQuery Plugin to replace the link with new one. The other error is a duplicated redirect for the same page. Please simply check redirection links list in joomla panel and remove the one which is pointing to 2 different urls.
User avatar
Moderator


cron