View Full Version : dead movies
entnetwork.com
11-16-2006, 10:29 AM
I noticed after the last import, i now have alot of dead movies...
example:
http://www.thatwascrazy.com/play-3236.html
NetworkTown.Net
11-16-2006, 11:35 AM
I found that too, run the following query in phpmyadmin:
DELETE FROM `media` WHERE link = 'http://www.fastfreemedia.com/flvplayer.swf?file=&autoStart=true'
I done it it worked deleted all dead movies.
entnetwork.com
11-16-2006, 02:43 PM
thank you for the fix ;)
NetworkTown.Net
11-16-2006, 02:43 PM
Np, i hope it helps you. i want to ask do you have a prob where images are missing?
entnetwork.com
11-16-2006, 02:45 PM
I get an error when I do that
Error
SQL query:
DELETE FROM `media` WHERE link = 'http://www.fastfreemedia.com/flvplayer.swf?file=&autoStart=true'
MySQL said: Documentation
#1054 - Unknown column 'link' in 'where clause'
entnetwork.com
11-16-2006, 02:46 PM
Np, i hope it helps you. i want to ask do you have a prob where images are missing?
not that I know of... I just know it is using the reel.gif image more than actual thumbnails...
NetworkTown.Net
11-16-2006, 02:46 PM
lol forgot to change it, here you go:
DELETE FROM `media` WHERE remote_url = 'http://www.fastfreemedia.com/flvplayer.swf?file=&autoStart=true'
entnetwork.com
11-16-2006, 02:48 PM
lol forgot to change it, here you go:
DELETE FROM `media` WHERE remote_url = 'http://www.fastfreemedia.com/flvplayer.swf?file=&autoStart=true'
i get this error now
Error
SQL query:
DELETE FROM `media` WHERE remote_url = 'http://www.fastfreemedia.com/flvplayer.swf?file=&autoStart=true'
MySQL said: Documentation
#1054 - Unknown column 'remote_url' in 'where clause'
NetworkTown.Net
11-16-2006, 02:50 PM
can you tell me what system you are using? or give me the structure of your media database.
entnetwork.com
11-16-2006, 02:56 PM
using v0.6
* Browse categories - cId - cName - cOrder - gamesnumber -
* Browse config
* Browse gamestoday
* Browse guest_log
* Browse links
* Browse media - mCategory1 - mName - mThumb - mDescription - mviews - location - adult
* Browse ratings
NetworkTown.Net
11-16-2006, 02:59 PM
ok try this:
DELETE FROM `media` WHERE location = 'http://www.fastfreemedia.com/flvplayer.swf?file=&autoStart=true'
entnetwork.com
11-16-2006, 03:03 PM
cool, that worked. went down from 3000 vids to like 1800 LOL
NetworkTown.Net
11-16-2006, 03:03 PM
Yep there are alot of missing videos. well atleast you have working videos instread of non working ones.
For Gamescript you would want to run:
DELETE FROM `games` WHERE remote_url = 'http://www.fastfreemedia.com/flvplayer.swf?file=&autoStart=true'
blank
11-16-2006, 11:56 PM
so it looks like an update I did isn't working right then? Please pause your imports for 24-48 hours until I can look into thisfurther and fix it.
bigarte
11-17-2006, 02:30 AM
Bugger....lol....and I just imported before reading this post. Oh well; off to PHPMyAdmin as suggested.
blank
11-17-2006, 11:53 AM
This should now be fixed.... It was because of a MAJOR content update that I did. It put in some extra things that I needed to code into export.php and export_full.php.
NetworkTown.Net
11-17-2006, 01:03 PM
So dose the missing images work aswell?
entnetwork.com
11-20-2006, 04:44 PM
This should now be fixed.... It was because of a MAJOR content update that I did. It put in some extra things that I needed to code into export.php and export_full.php.
So we need to update these files then?
No these are on our server, you do not need to do anything. Besides you can run import.php now.
NetworkTown.Net
11-21-2006, 04:21 PM
Hmm i think i found another error the videos that contain . ' ect in the name do not work.
hiphop
11-28-2006, 06:28 PM
I noticed after the last import, i now have alot of dead movies...
example:
http://www.thatwascrazy.com/play-3236.html
How did you add your yahoo ads next to your videos?:eek:
vBulletin® v3.7.3, Copyright ©2000-2010, Jelsoft Enterprises Ltd.