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.
there is no solution?
Offline
This is not script related i think.....i delete 200 videos and takes like 1 minute.What is your server spects?
Offline
I upgraded to the rear ASP2.0. This happens!
Previously used batch delete function, deleting very fast
Offline
adrian
Please help me fix this problem
More than 1000 videos need to be removed
Offline
What version u are using now?
Offline
2.0.8
Offline
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
Edit module/videos/helpers/manage.php and find #_playlist and replace with #__playlist
It has been replaced
Is there another place?
Offline
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
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
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
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
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
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