Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

error 1064 SQL syntax

7 years 8 months ago
  • Teemu's Avatar
    Topic Author
  • Teemu
  • Offline
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 0
Licenses:
JomSocial Active iSEO Expired Socialize Expired

ISSUE SUMMARY: When delete Event, Group, User or whatever my site get this error: error 1064 SQL syntax and no one can login.


STEPS TO REPLICATE:
1: Greate user and delete. Whole site goes down.
2: Restoring from backup works.
3
4
5
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 ')) OR ( a.`permission` = '0' AND a.`contentid` > '0' AND c.`approvals` = '0') O' at line 1 SQL=SELECT a.* FROM `#__community_events` AS a INNER JOIN `#__community_events_category` AS b ON a.`catid` = b.`id` LEFT JOIN `#__community_groups` AS c ON a.`contentid` = c.`id` WHERE a.`published` = '1' AND ( ( a.`permission` = '0' AND a.`contentid` = '0') OR ( a.`permission` = '1' AND a.`id` IN ()) OR ( a.`permission` = '0' AND a.`contentid` > '0' AND c.`approvals` = '0') OR ( a.`contentid` > '0' AND c.`approvals` = '1' AND c.`id` IN (1,2,3,5,6)) ) AND a.`enddate` > DATE(NOW()) ORDER BY a.`id` DESC LIMIT 0, 1
It appears that the page you were looking for does not exist.
Other things to try

Go back home

If you came here by mistake, try going back to home page.


EXPECTED RESULT
BROWSER

7 years 8 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

Hi Teemu,

Your FTP is not working, can you check again, please?

thank you!

7 years 8 months ago
  • Teemu's Avatar
    Topic Author
  • Teemu
  • Offline
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 0
Licenses:
JomSocial Active iSEO Expired Socialize Expired

Hello Dimas,

Now it works with same username and Pass what I write. Try it.

// Teemu

7 years 8 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

Hi Teemu,

This issue caused by this module "Minitek Wall module" I disabled it and your site is working fine.

thank you!

7 years 8 months ago
  • Teemu's Avatar
    Topic Author
  • Teemu
  • Offline
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 0
Licenses:
JomSocial Active iSEO Expired Socialize Expired

Thank you Dimas. We will test it and be back if we get any similar issues.

// Teemu

7 years 8 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

you're welcome

Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW