when im launch cronjob erosbook69.com/index.php?option=com_community&task=cron im see this: help me?


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 , 1' at line 1 SQL=SELECT id FROM `spxfo_community_activities` WHERE `archived`='0' AND DATEDIFF('2015-07-20 08:50:15',`created`)<= ORDER BY `id` DESC LIMIT , 1

Michel,

please goto jomsocial backend > configuration > site
and set
Maximum Days of Unarchived Activities
Unarchived Activities Limit

with big number: 999999999 instead of 0

I tried to put it true 999999999 page cron runs but there is no sight more 'all the information on the page you are limited I would if I put 0 and 0 instead you could see all the news also precedendi tell'utente how can I do?

I tried to put it true 999999999 page cron runs but there is no sight more 'all the information on the page you are limited I would if I put 0 and 0 instead you could see all the news even earlier tell'utente how can I do? if imposed a large number activities in the profile are not seen tuttte if instead I had left 0 and launched UPDATE rtug_community_activities archived SET = 0 = 0 WHERE archived see all the news in the user profile as I can run the page of cron for good but also show all the activities in the users profiles?

Hi Michel,

please put 999999999 for both, after that execute this query from phpmyadmin

UPDATE spxfo_community_activities SET archived=0

im put 99999999 to days and limit after im launch UPDATE spxfo_community_activities SET archived=0 but in profile user not show all activities why? when im put 0 and 0 and im launch UPDATE spxfo_community_activities SET archived=0 in profile user show all activities i want show all activities help me?

I'm sorry for my bad English I want in profiles users see all activities even that old so the page you need to update itself if imposed great number 9999999 page cronjob works but the activity in the user profile are not seen as all that? can you help me if I give you access ftp and database? or you tell me how can I do?

if you can help me I want the activity profiles and also all users see that the page does not give error cronjob

Hi,

please provide me FTP and phpmyadmin access detail. I will do it for you. and let you know what I did.
you can put credentials information by editing your first post at this topic, put it at site info form.

Regards

im add im attempt

Hi,

here the code that I put at line 705

if (($config->get('archive_activity_max_day') * 1) == 0 && ($config->get('archive_activity_limit') * 1) == 0) {
    return;
}

tnx