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.
Pages: 1
Hi
I recently uploaded some videos under the wrong channel. When I went in to edit the video and correct the channel I got an error message...
UPDATE aspchannel SET total_videos = total_videos+1, last_add_time = 1424103698 WHERE channel_id = 15 LIMIT 11
Query: UPDATE aspchannel SET total_videos = total_videos-1 WHERE channel_id = 14 LIMIT 1
Error Message: BIGINT UNSIGNED value is out of range in '(`hdfet_asps`.`aspchannel`.`total_videos` - 1)'
Error Number: 1690
I got the error when trying to bulk edit all affected videos plus also when I tried to change channel on each individual video as well
Offline
Edit admin/modules/video/components/edit.php and change:
$this->db->query("UPDATE #__channel
SET total_videos = total_videos-1
WHERE channel_id = ".$o_channel_id."
LIMIT 1");
with:
$this->db->query("UPDATE #__channel
SET total_videos = CASE WHEN total_videos > 0 THEN total_videos-1 ELSE 0 END
WHERE channel_id = ".$o_channel_id."
LIMIT 1");
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Didn't change anything unfortunately. However I noticed that when doing change individually it gives error but when refeshing video the channel has changed
l
Offline
There are 2 occurences of the above code. Did you replace them both?
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Pages: 1