site not working

erosmembers
Posts: 97
Joined: Tue Mar 15, 2016 9:41 pm

site not working

Post by erosmembers »

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.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: site not working

Post by admin »

Hm.. how many traders do you have ?
Don't forget to run script update
erosmembers
Posts: 97
Joined: Tue Mar 15, 2016 9:41 pm

Re: site not working

Post by erosmembers »

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.
erosmembers
Posts: 97
Joined: Tue Mar 15, 2016 9:41 pm

Re: site not working

Post by erosmembers »

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?
erosmembers
Posts: 97
Joined: Tue Mar 15, 2016 9:41 pm

Re: site not working

Post by erosmembers »

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?
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: site not working

Post by admin »

Just 18 ? are you sure ?
Don't forget to run script update
erosmembers
Posts: 97
Joined: Tue Mar 15, 2016 9:41 pm

Re: site not working

Post by erosmembers »

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
erosmembers
Posts: 97
Joined: Tue Mar 15, 2016 9:41 pm

Re: site not working

Post by erosmembers »

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.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: site not working

Post by admin »

So what doesn't work now ?
Don't forget to run script update
erosmembers
Posts: 97
Joined: Tue Mar 15, 2016 9:41 pm

Re: site not working

Post by erosmembers »

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)
Post Reply