Adult Script Pro Community Forums

The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!

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,022

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,022

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,501
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,501
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