PDA

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.

kip
11-16-2006, 05:14 PM
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?

kip
11-20-2006, 10:58 PM
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: