Installing & SQL Problem :(

[Dustin]

Hi,
I really like to run your script but i have some problems by using it!
i tried to install it and just got this:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/vhosts/nflash.org/httpdocs/video/config.php on line 16
DB file imported

I Chmod'ed the Directory you told. ;)

So i tried to add a game in the controllpanel and got this message:

Bad query: Table 'video.games' doesn't exist

I don't know what to do..
Maybe u can support me :)

Here is the Link to my page:
http://www.nflash.org/video/


Dustin

(Sorry for my bad english)

[nowares]

u need to create the SQL info in your database, or run the install.php file :)

[Dustin]

i didi both...
you can see it here:
http://www.nflash.org/video/install.php

and the sql:
http://nflash.org/uploads/zuio1164717379B.JPG

help me :confused:

Dustin

[nowares]

go into phpmyadmin, drop all tables etc.... then reinstall sql.
use either the installer or the sql file.

i suggest using the sql file as youll be in phpmyadmin anyway :)
and itll give more info if an error occurs!

http://www.nflash.org/video/ Seems fine to me, just try adding content


EDIT ::...
your home page has errors too.....
Parse error: parse error, unexpected '<' in /srv/www/vhosts/nflash.org/httpdocs/index.php on line 84

Feel free to post or pm me line 83->85 :)

[Dustin]

thx for reply :)
my mainpage (www.nflash.org) is currently under construction so i guess this doesnt cause the fastfreemedia script bug...

Just try to add a video/game :
http://www.nflash.org/video/admin/

no pw.
if i try to add something it get this:

Bad query: Table 'video.games' doesn't exist

Thx agai for supporting me !

[nowares]

this may look basic, but just so u know.....

http://magicforum.9999mb.com/images/temp_sqlerror.jpg

1 select all fields.
2 select drop and confirm on the next page
3 click sql and add the contents of the sql file
4 click enter and pray :)

Hope it helps.... if not i can do it for u, then just change SQL DB user + pass

[nowares]

mmmmmmm, i just checked the .sql file and eeeeeeerrrrrrrrrrr


"video.games" actually doesnt exist ROFL..... admin help needed i think :(

[nowares]

u should also lock your admin folder with .htacess + .htpasswd...

http://www.flash.net/cgi-bin/pw.pl

[blank]

open admincp/index.php and find: @mysql_query("INSERT INTO `games` ( `mId` , `mCategory1` , `mName` , `mThumb` , `mDescription` , `mviews` , `location` )
VALUES ( '', '$category', '$gname', '$img', '$description', '0', '$url' );")or die("Bad query: ".mysql_error());


change games to media

[blank]

This will be fixed in the V.61 being posted tonight... closing since its resolved