SQL Error in import.php

[Ba7ebahaaa]

Hello,

this is the "freecade.sql" that i'm running now

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
`totalgames` mediumint(25) NOT NULL default '0',
`totalplays` mediumint(25) NOT NULL default '0',
`todaysplays` mediumint(25) NOT NULL default '0',
`guests` smallint(5) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table `cache`
--

INSERT INTO `cache` VALUES (1102, 3517, 5, 0);

-- --------------------------------------------------------

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
`cId` mediumint(9) NOT NULL auto_increment,
`cName` varchar(200) NOT NULL default '',
`cOrder` bigint(20) NOT NULL default '0',
`gamesnumber` mediumint(35) NOT NULL default '0',
UNIQUE KEY `cId` (`cId`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1, 'Cars', 0, 92);
INSERT INTO `categories` VALUES (33, 'Weird', 0, 2);
INSERT INTO `categories` VALUES (27, 'Funny', 0, 3);
INSERT INTO `categories` VALUES (25, 'Babe', 0, 22);
INSERT INTO `categories` VALUES (24, 'Amazing', 0, 43);
INSERT INTO `categories` VALUES (23, 'LMAO', 0, 1);
INSERT INTO `categories` VALUES (18, 'Gross', 0, 106);
INSERT INTO `categories` VALUES (16, 'Misc', 0, 61);
INSERT INTO `categories` VALUES (103, 'crashes', 0, 31);
INSERT INTO `categories` VALUES (2, 'Sports', 0, 124);
-- --------------------------------------------------------

--
-- Table structure for table `config`
--

CREATE TABLE `config` (
`site_title` text NOT NULL,
`site_url` text NOT NULL,
`number_of_latest_game` tinyint(4) NOT NULL default '10',
`number_of_most_popular_games` tinyint(4) NOT NULL default '10',
`googleid` text NOT NULL,
`cache_update` tinyint(1) NOT NULL default '1',
`admin_address` text NOT NULL,
`seo_support` tinyint(1) NOT NULL default '1',
`cookie_time` mediumint(9) NOT NULL default '86400',
`dropdown_limit` smallint(5) NOT NULL default '50'
) TYPE=MyISAM;

--
-- Dumping data for table `config`
--

INSERT INTO `config` VALUES ('Free Movies', 'www.fastfreemedia.com/free', 15, 20, 'pub-1431272220441420', 5, 'admin@iamnotageek.com', 1, 86400, 50);

-- --------------------------------------------------------

--
-- Table structure for table `games`
--

CREATE TABLE `games` (
`gId` bigint(20) NOT NULL auto_increment,
`gInCategory` mediumint(9) NOT NULL default '0',
`gName` varchar(100) NOT NULL default '',
`gThumb` varchar(200) NOT NULL default '',
`gDescription` text NOT NULL,
`gplays` mediumint(45) NOT NULL default '0',
`location` text NOT NULL,
UNIQUE KEY `gId` (`gId`),
UNIQUE KEY `gName` (`gName`)
) TYPE=MyISAM AUTO_INCREMENT=1283 ;


--
-- Table structure for table `gamestoday`
--

CREATE TABLE `gamestoday` (
`Date` varchar(6) NOT NULL default '',
`GamesPlayed` bigint(20) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table `gamestoday`
--


-- --------------------------------------------------------

--
-- Table structure for table `guest_log`
--

CREATE TABLE `guest_log` (
`id` mediumint(50) NOT NULL auto_increment,
`time` bigint(30) NOT NULL default '0',
`ip` varchar(16) NOT NULL default '',
UNIQUE KEY `id` (`id`),
UNIQUE KEY `ip` (`ip`)
) TYPE=MyISAM AUTO_INCREMENT=13146 ;

--
-- Dumping data for table `guest_log`
--


-- --------------------------------------------------------

--
-- Table structure for table `links`
--

CREATE TABLE `links` (
`id` tinyint(5) NOT NULL auto_increment,
`link` text NOT NULL,
`name` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

--
-- Dumping data for table `links`
--

INSERT INTO `links` VALUES (5, 'http://www.iamnotageek.com', 'I Am Not A Geek');
INSERT INTO `links` VALUES (2, 'http://www.msusenet.com', 'MS Usenet');
INSERT INTO `links` VALUES (6, 'http://www.iamnotageek.com/a/file_info.php', 'Process Help');

-- --------------------------------------------------------

--
-- Table structure for table `ratings`
--

CREATE TABLE `ratings` (
`gid` mediumint(7) NOT NULL default '0',
`votes` mediumint(10) NOT NULL default '0',
`total` mediumint(10) NOT NULL default '0',
`rating` tinyint(3) NOT NULL default '0',
UNIQUE KEY `gid` (`gid`)
) TYPE=MyISAM;

--
-- Dumping data for table `ratings`
--

i got this error when opening "install.php"

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:\1\xampp\htdocs\vids\config.php on line 14
Upgrading from V.5 to V.6

that was a clean install as i didn't have any previous versions of this script


however, i found the tables in the db ( 8 tables )

also, i get this error when opening "import.php"


Warning: Invalid argument supplied for foreach() in D:\1\xampp\htdocs\vids\admin\import.php on line 32

running php 4.4.4. and mysql 5.0.24a

[blank]

looks like "warning" type messages? Whats your URL and is everything showing up properly?

[Ba7ebahaaa]

I've it installed on a localhost

yes, everything in the main page is fine except mysql error in Random Videos table

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:\1\xampp\htdocs\vids\templates\index_content.tpl on line 55

i'll try it on a linux live server and send more feedback