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.

Cron job returns 1064 - You have an error in your SQL syntax

9 years 9 months ago
  • Michael's Avatar
    Topic Author
  • Michael
  • Offline
  • Fresh Boarder
  • Posts: 36
  • Thank you received: 0
Licenses:
JomSocial Expired 

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 'ORDER BY `id` DESC LIMIT 100 , 1' at line 1 SQL=SELECT id FROM `jos_community_activities` WHERE `archived`='0' AND DATEDIFF('2014-07-29 17:43:07',`created`)<= ORDER BY `id` DESC LIMIT 100 , 1

I get this error when executing the cron job from the Mail queue in the admin and when running this manually also.

This started after I "cleared" my JS installation meaning that I deletes all test posts in the stream, all photos, videos and some test users.

Thanks.

JS: 3.2.1.1
J!: 3.3.3

9 years 9 months ago
Licenses:

Hi, Michael.

Please provide us with working administrator credentials.
I can't login to your site.
Please, edit your first post and add credentials to corresponding fields.

- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
9 years 9 months ago
  • Michael's Avatar
    Topic Author
  • Michael
  • Offline
  • Fresh Boarder
  • Posts: 36
  • Thank you received: 0
Licenses:
JomSocial Expired

Hi Michal,
The user is updated now.

Thanks

9 years 9 months ago
Licenses:

Hi, Michael.

Please, edit your first post and add PHPmyAdmin credentials.
I assign developer to this thread.

- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
9 years 9 months ago
  • Michael's Avatar
    Topic Author
  • Michael
  • Offline
  • Fresh Boarder
  • Posts: 36
  • Thank you received: 0
Licenses:
JomSocial Expired

Hi,
Phpmyadmin has been appended the first post.

Thank you.

9 years 9 months ago
Licenses:

Hi Michael,

please input the value for Maximum Days of Unarchived Activities at Jomsocial backend - configuration - site



Regards,
Albert

Attachments:
The following user(s) said Thank You: Michael
9 years 9 months ago
  • Michael's Avatar
    Topic Author
  • Michael
  • Offline
  • Fresh Boarder
  • Posts: 36
  • Thank you received: 0
Licenses:
JomSocial Expired

Hi,
The cron job works now. Was this the problem causing the MySQL error?
I was trying different settings for this parameter as I didn't quite now what this did... Now I know ;-)

Thanks,
Michael

9 years 9 months ago
Licenses:

Hi Michael,

yes that setting if blank will make MySql error. Because that value using for query.

Regards,
Albert

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

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere

© JomSocial.com All Rights Reserved