Search found 85 matches

by Fett
Wed Jan 31, 2018 12:13 pm
Forum: SmartCJ Support Forum
Topic: Nginx\Apache
Replies: 3
Views: 2543

Re: Nginx\Apache

I didn't try EasyApache 4
best option I think is nginx + php-fpm

agreed ;)

Nginx\Apache is also great, I use this setup, because in this way Apache does not do any "muscle work" but it is still there so you can use all of its mods. Then for php: php-fpm.

I use Direct Admin.
by Fett
Wed Jan 31, 2018 10:54 am
Forum: SmartCJ Support Forum
Topic: cron based dynamic skim with pattern
Replies: 1
Views: 1800

cron based dynamic skim with pattern

hello

How to do this


from ( server time )

2:00 to 11:59 skim is 100,0,100,0,0 (repeat)

and

12:00 to 1:59 skim is 100,0 (repeat)

?
by Fett
Tue Nov 07, 2017 11:39 am
Forum: SmartCJ Support Forum
Topic: maintenance --> optimize Database as sh script or cron
Replies: 1
Views: 2005

maintenance --> optimize Database as sh script or cron

How can I achieve the same thing:

maintenance --> optimize database

running as a .sh script via cron job?

I am dealing with corrupted databases time after time because I have MYISAM tables (my mysql version does not support innodb)

So can I please run repair service function somehow by cron?
by Fett
Wed Oct 18, 2017 11:16 am
Forum: SmartCJ Support Forum
Topic: mysql crash?
Replies: 8
Views: 4827

Re: mysql crash?

thank you for tips so far. I still have trouble,

Mysql error:: 126 (Incorrect key file for table './scj-database/settings.MYI'; try to repair it)


I checked with phpmyadmin but I dont find this table, where is it?
by Fett
Mon Oct 16, 2017 3:10 pm
Forum: Bug Report
Topic: syncing quality settings and system trades does not work
Replies: 3
Views: 10148

Re: syncing quality settings and system trades does not work

Thank you for quick fix as always!
by Fett
Sun Oct 15, 2017 1:02 pm
Forum: SmartCJ Support Forum
Topic: mysql crash?
Replies: 8
Views: 4827

Re: mysql crash?

by the way I want to ask on this note is this possible to create backup at a a different time, not midnight because ALL my scjs start to create backup in the same time PLUS interestingly all my streamrotators also choose the exact same minute to create backups, and guess this is a HUGE load ony my s...
by Fett
Sun Oct 15, 2017 12:58 pm
Forum: SmartCJ Support Forum
Topic: mysql crash?
Replies: 8
Views: 4827

Re: mysql crash?

update: managed to repair corrupt tables in phpmyadmin by running this command:


repair table table_name use_frm

...

It was a power failure at host company! So not to do anything with scj :-)
by Fett
Sun Oct 15, 2017 12:42 pm
Forum: SmartCJ Support Forum
Topic: mysql crash?
Replies: 8
Views: 4827

Re: mysql crash?

the following tables are corrupt. On all my sites on this server?????

corrupted tables:

browsers
ips
language
links
out_ips
out_ips2trader
refs


Trying to access them in phpmyadmin,

#130 - incorrect file format
by Fett
Sun Oct 15, 2017 12:35 pm
Forum: SmartCJ Support Forum
Topic: mysql crash?
Replies: 8
Views: 4827

Re: mysql crash?

Can you help me? What is this? and mysql error log (from scj admin panel) full of data
by Fett
Sun Oct 15, 2017 10:54 am
Forum: SmartCJ Support Forum
Topic: mysql crash?
Replies: 8
Views: 4827

Re: mysql crash?

try to repair database in bash, I get this: Repairing tables blackhat_KNOscj.browsers Error : Incorrect file format 'browsers' error : Corrupt blackhat_CZAscj.ips Error : Incorrect file format 'ips' error : Corrupt blackhat_CZAscj.language Error : Incorrect file format 'language' error : Corrupt bla...