Adult Script Pro Community Forums

Create, help and share your ideas with the community!

You are not logged in.

#1 2015-08-14 14:54:04

sauce
Member
Registered: 2014-07-20
Posts: 71

[NOT A BUG] Batch delete video slow (10 video, it may take 30 minutes)

there is no solution?

Offline

#2 2015-08-14 15:15:38

thiva7
Member
Registered: 2011-04-30
Posts: 1,021

Re: [NOT A BUG] Batch delete video slow (10 video, it may take 30 minutes)

This is not script related i think.....i delete 200 videos and takes like 1 minute.What is your server spects?

Offline

#3 2015-08-14 15:30:05

sauce
Member
Registered: 2014-07-20
Posts: 71

Re: [NOT A BUG] Batch delete video slow (10 video, it may take 30 minutes)

I upgraded to the rear ASP2.0. This happens!


Previously used batch delete function, deleting very fast

Offline

#4 2015-08-14 16:02:56

sauce
Member
Registered: 2014-07-20
Posts: 71

Re: [NOT A BUG] Batch delete video slow (10 video, it may take 30 minutes)

adrian

Please help me fix this problem
More than 1000 videos need to be removed

Offline

#5 2015-08-14 16:22:35

thiva7
Member
Registered: 2011-04-30
Posts: 1,021

Re: [NOT A BUG] Batch delete video slow (10 video, it may take 30 minutes)

What version u are using now?

Offline

#6 2015-08-15 09:36:28

sauce
Member
Registered: 2014-07-20
Posts: 71

Re: [NOT A BUG] Batch delete video slow (10 video, it may take 30 minutes)

2.0.8

Offline

#7 2015-08-15 09:37:42

sauce
Member
Registered: 2014-07-20
Posts: 71

Re: [NOT A BUG] Batch delete video slow (10 video, it may take 30 minutes)

Query: DELETE FROM #_playlist_videos WHERE video_id = 4672
Error Message: 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 '' at line 1
Error Number: 1064

Offline

#8 2015-08-15 17:43:28

Eri
Member
Registered: 2011-03-18
Posts: 977

Re: [NOT A BUG] Batch delete video slow (10 video, it may take 30 minutes)

Adding delete videos, convert videos as a background task will save time.


Best Adult Affilitate Network:
ExoClick
Best Deals on Dedicated Servers - CDN
INXY

Offline

#9 2015-08-16 09:27:58

sauce
Member
Registered: 2014-07-20
Posts: 71

Re: [NOT A BUG] Batch delete video slow (10 video, it may take 30 minutes)

Edit module/videos/helpers/manage.php and find #_playlist and replace with #__playlist



It has been replaced
Is there another place?

Offline

#10 2015-08-16 09:43:17

symtab
Administrator
Registered: 2010-08-23
Posts: 7,495
Website

Re: [NOT A BUG] Batch delete video slow (10 video, it may take 30 minutes)

That should bot be the problem for the actual delete delay. It should return a error (also i do not have that bug in the files). Do you use multi server? Any tables that are very big (you cancheck in /var/lib/mysql)?


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#11 2015-08-16 10:40:02

sauce
Member
Registered: 2014-07-20
Posts: 71

Re: [NOT A BUG] Batch delete video slow (10 video, it may take 30 minutes)

symtab wrote:

That should bot be the problem for the actual delete delay. It should return a error (also i do not have that bug in the files). Do you use multi server? Any tables that are very big (you cancheck in /var/lib/mysql)?

Multi-server has been closed

Offline

#12 2015-08-17 22:00:48

sauce
Member
Registered: 2014-07-20
Posts: 71

Re: [NOT A BUG] Batch delete video slow (10 video, it may take 30 minutes)

symtab wrote:

That should bot be the problem for the actual delete delay. It should return a error (also i do not have that bug in the files). Do you use multi server? Any tables that are very big (you cancheck in /var/lib/mysql)?



I have updated the database tables,
The following statement is executed, it should not be a problem, right?   (Videos have all been transferred to the main server)
I have backed up database
UPDATE `video` SET` server` = '0' WHERE `server` = 1 and` status` = 0;


Return message:
mysql> UPDATE `video` SET` server` = '0' WHERE `server` = 1 and` status` = 0;
Query OK, 1026 rows affected (0.02 sec)
Rows matched: 1026 Changed: 1026 Warnings: 0

Last edited by sauce (2015-08-17 22:26:17)

Offline

#13 2015-08-17 22:08:21

sauce
Member
Registered: 2014-07-20
Posts: 71

Re: [NOT A BUG] Batch delete video slow (10 video, it may take 30 minutes)

mysql> UPDATE `video` SET `server` ='0' WHERE `server` =1 and `status` =1;
Query OK, 2858 rows affected (0.04 sec)
Rows matched: 2858  Changed: 2858  Warnings: 0

Offline

#14 2015-08-18 06:22:50

symtab
Administrator
Registered: 2010-08-23
Posts: 7,495
Website

Re: [NOT A BUG] Batch delete video slow (10 video, it may take 30 minutes)

Yes, that should work, but if you need the multi-server the delete must work and it works for other. A timeout for ftp connection could be a explication.


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#15 2015-08-18 08:51:00

sauce
Member
Registered: 2014-07-20
Posts: 71

Re: [NOT A BUG] Batch delete video slow (10 video, it may take 30 minutes)

symtab wrote:

Yes, that should work, but if you need the multi-server the delete must work and it works for other. A timeout for ftp connection could be a explication.


More than 1,000 videos have all been deleted

Offline

Board footer

Powered by FluxBB