When I click on contest as the admin I get this error message. I also have the newest patch installed.
Quote
Dman
Fatal error: Call to a member function on a non-object in /hsphere/local/home/********/windycitygamers.com/modules/pnFlashGames/ pnuserapi.php on line 1573
*my username
Quote
Dman
I believe this is the line 1573 in the pnuserapi in flashgames
Quote: › for (; !$contests->EOF; $contests->MoveNext()) {
Quote
Leason
That means there is some kind of SQL error caused a few lines before it. Do me a favor and do a SQL structure dump of your nuke_pnFlashGames_contests table for me and post it here. You can do that with phpMyAdmin.
Quote
Dman
**I hid these areas**
-- phpMyAdmin SQL Dump
-- version 2.6.2-RC1
-- http://www.phpmyadmin.net
--
-- Host: mysql.**host***.net
-- Generation Time: May 18, 2005 at 10:47 PM
-- Server version: 4.0.24
-- PHP Version: 4.3.10
--
-- Database: `**login**_windycitygamers_com`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_pnFlashGames_contests`
--
CREATE TABLE `nuke_pnFlashGames_contests` (
`contid` int(11) NOT NULL auto_increment,
`name` tinytext NOT NULL,
`description` text NOT NULL,
`image` tinytext NOT NULL,
`startdate` datetime NOT NULL default '0000-00-00 00:00:00',
`enddate` datetime NOT NULL default '0000-00-00 00:00:00',
`nuke_pnFlashGames_contestsrepeat` int(11) NOT NULL default '0',
`nuke_pnFlashGames_contestsrepeatuntil` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`contid`)
) TYPE=InnoDB AUTO_INCREMENT=5 ;
--
-- Dumping data for table `nuke_pnFlashGames_contests`
--
INSERT INTO `nuke_pnFlashGames_contests` VALUES (4, 'BREAKOUT', 'Back to our gaming roots. Nothing special about these games. Get all the blocks. Make sure you registered and logged in to make those scores count!\r\n\r\nLET THE GAMES BEGIN', 'modules/pnFlashGames/pnimages/contest.gif', '2005-01-31 13:00:00', '2005-02-07 13:00:00', 0, '0000-00-00 00:00:00');
Quote
Leason
That is the correct dump, but I don't see anything wrong with it. I'll have to do some investigating here to try and figure out what is wrong.
