SmartCJ Support Forum

If I try to visit my site then I get following error:
Check path in CJPAGES and make sure you've setup crontab job

I have seen that the cronjob is not working any longer.
I get following error from cronjob:
<br />
<b>Fatal error</b>: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32251
bytes) in <b>/var/..../domain/www/scj/includes/libs/cj_functions.php</b> on
line <b>0</b><br />
err

Please could you give ma an advice, why this happens?
I did not change anything since some weeks.

Hm.. how many traders do you have ?

It was set to create traders (option “add notrade as feed traders” is set.)
So this might be possible, that I have now a lot of traders in my system.

You are so good

If I try to list tades. then I get following error:
Fatal error: Out of memory (allocated 51904512) (tried to allocate 24 bytes) in /var/home/malinet/eros-members.com/www/scj/includes/db_modules/mysql.php on line 230

The traders table contains 1687 rows.
Can I empty this table?

I empty this table, and now the site is working.

But if I list trades the I get following warning:
You have a lot of traders and low php memory limit. It does NOT affect trade, just a speed of this admin part and a little bit functionality of this page. You can add more memory in php.ini (memory limit)

Table traders contains 18 rows.

So is there any other memory poblem?

Just 18 ? are you sure ?

Yes, now I have 134 trades.
But the cron stopped working.

Now I deleted some trades, and it is working...

But there must be something else, I think.
Do you have any idea?

Now I am getting following cron error:
<br />
<b>Fatal error</b>: Uncaught exception 'Exception' with message 'Mysql error:: 1062 (Duplicate
entry 'greatxhamster.com' for key 'PRIMARY') (db_link) in query insert into day (h)
values('greatxhamster.com'). (ca.eros-members.com) ' in
/var/home/domain/www/scj/includes/db_modules/mysql.php:62
Stack trace:
#0 /var/home/malinet/domain/www/scj/includes/db_modules/mysql.php(75): db_error('insert
into day...', 1062, 'Duplicate entry...', 'db_link')
#1 /var/home/domain/www/scj/bin/cron.php(0): db_query()
#2 /var/home/domain/www/scj/bin/cron.php(0): do_sql()
#3 {main}
thrown in <b>/var/home/domain/www/scj/includes/db_modules/mysql.php</b> on
line <b>62</b><br />
err

I am using following setting to count productivity from feeders:
“add notrade as feed traders” in Cj settings - Processed Data.

As you said in http://smartcj.com/wiki/doku.php?id=hin ... om_feeders

I changed this to no.

So what doesn't work now ?

It seems that it is working after last change of “add notrade as feed traders”.

But this can only be a temporary solution.
Or am I wrong?

The warning on List Trades still exists:
You have a lot of traders and low php memory limit. It does NOT affect trade, just a speed of this admin part and a little bit functionality of this page. You can add more memory in php.ini (memory limit)