Search found 412 matches

by happydg
Wed Dec 02, 2020 3:15 pm
Forum: SmartCJ Support Forum
Topic: Site slow because of big database
Replies: 5
Views: 6317

Re: Site slow because of big database

I just have in scj folder:

ioncube_fallback.php
scj2.free.lic
sitemap.php
scj2.sql
scjwebmaster.php
rotation.log
rss.php
scj2.lic

and subfolders

I really think the problem is mysql. The database has 3 millions galleries and the db size is 27 gb which is huge.
by happydg
Wed Dec 02, 2020 10:51 am
Forum: SmartCJ Support Forum
Topic: Site slow because of big database
Replies: 5
Views: 6317

Re: Site slow because of big database

Server LA is about 4. Mysql is taking most of the usage.

Also after update. When I go to https://www.domain.com/scj/admin/?operation=main&sub=& I get this error:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 67108872 bytes) in /data/domain.com/html/scj/includes ...
by happydg
Wed Dec 02, 2020 9:45 am
Forum: SmartCJ Support Forum
Topic: Site slow because of big database
Replies: 5
Views: 6317

Site slow because of big database

Hello,

I updated to latest version.

When not cached, my site and access to the admin is loading slow because it has a lot of galleries to the database.

When connecting to scj/admin/ it sometimes go to 504 Gateway Time-out after loading for a while.

1) I see you can optimize database in scj admin ...
by happydg
Mon Nov 30, 2020 9:28 am
Forum: SmartCJ Support Forum
Topic: Set not importing all galleries
Replies: 25
Views: 20394

Re: Set not importing all galleries

In import Sets, does period = 0 means it will be imported just one time?

If not, how to make it only import galleries once in set ( big csv file )?

Thank you.
by happydg
Mon Nov 30, 2020 7:35 am
Forum: SmartCJ Support Forum
Topic: Feeder traffic
Replies: 3
Views: 4847

Re: Feeder traffic

Trafficshop is providing a tag {referrer} to get referrers domains.

For example I buy skimmed traffic from trafficshop. I would like to know which domain sources have the best productivity.

I would add https://www.mydomain.com/?id=trafficshop-skimmed-{referrer}.com as feeder which would output for ...
by happydg
Sun Nov 29, 2020 4:04 pm
Forum: SmartCJ Support Forum
Topic: Set not importing all galleries
Replies: 25
Views: 20394

Re: Set not importing all galleries

Hello,

1) I'm sorry but this thumb is working fine for me.

2) Why is there more than 14000 galleries inactive?

When I check gallery_checker it says:

2020-11-26 13:43:59: Got https://xh.video/x/xhdgRXs Speed 103907 (13315.20472002, 1.0096850395203)
2020-11-26 13:44:00: https://xh.video/x/xhdgRXs ...
by happydg
Sat Nov 28, 2020 1:49 pm
Forum: SmartCJ Support Forum
Topic: Set not importing all galleries
Replies: 25
Views: 20394

Re: Set not importing all galleries

You have access to admin. Please for example search for "xhcxe3b" in List thumbs.
by happydg
Sat Nov 28, 2020 10:13 am
Forum: SmartCJ Support Forum
Topic: Set not importing all galleries
Replies: 25
Views: 20394

Re: Set not importing all galleries

For example: 2020-11-27 05:00:11: Importing gallery line: xhcxe3b|<iframe width="640" height="480" src="https://xh.video/p/xhcxe3b" frameborder="0" scrolling="no"></iframe>|https://thumb-v4.xhcdn.com/a/YqVoOBkO0XRzEvNlRAp5Kw/016/655/354/320x240.5.jpg;https://thumb-v4.xhcdn.com/a/9xwd ...
by happydg
Fri Nov 27, 2020 2:49 pm
Forum: SmartCJ Support Forum
Topic: Feeder traffic
Replies: 3
Views: 4847

Feeder traffic

Hello,

I added a feeder trade name: "trafficshop_tier1"

I tried domain.com/?id=trafficshop_tier1 but the stats remain at 0.

This is my header:

Response (in 0.0684s)
HTTP/1.1 200 OK

Cache-Control: no-store, no-cache, must-revalidate

Connection: keep-alive

Content-Type: text/html; charset=UTF-8 ...
by happydg
Fri Nov 27, 2020 11:32 am
Forum: SmartCJ Support Forum
Topic: Set not importing all galleries
Replies: 25
Views: 20394

Re: Set not importing all galleries

"Large file has been processed. Importset paused."

But only about half of the galleries have been added.

I reuploaded the rotation.log at the same spot.

Also i don't understand why 1/3 of the galleries added went to inactive.