Zikula Community

• **unknown user**
  
  

  • Rank: Softmore
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 117

  Posted: Mar 20, 2005 - 03:13 AM

  I downloaded the 1.5 upgrade last night and now my flash games are not working. After checking pnflashgames website I have notice that several other people are having the same problem. We all seemed to be getting this error message:
  
  Items load failed: Unknown column 'nuke_pnFlashGames_games.pn_status' in 'field list'

  • 
  •  
• **unknown user**
  
  

  • Rank: Senior
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 2330

  Posted: Mar 20, 2005 - 06:47 AM

  What it means is that the pn_status column isn't being found in the nuke_pnFlashGames_games table...but it's being called in the field list.
  
  I don't use the mod and don't know your fix, but what you can do is to check your database's nuke_pnFlashGames_games table and see for yourself if the column does not exist...(the error pretty much says it doesn't) but I always prefer to look myself. Then, head over to the pnFlashGames site and make a new post with "pn_status column missing" in the title so they can see you've at least done your homework and aren't just chiming in with a "help" or "not working" post...

  • 
  •  
• **unknown user**
  
  

  • Rank: Softmore
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 117

  Posted: Mar 20, 2005 - 10:37 AM

  Yeah, I posted there also late last night along with others. Perhaps it hasnt been seen yet. Its a great mod but right now its down on my site.
  
  I dont know to much about DB's so I dont want to tinker to much with it and possibly make things worse. Guess Ill just wait and see

  • 
  •  
• jmvedrine
  
  

  • Rank: Helper
  • Registered: Jan 12, 2004
  • Last visit: Jan 20, 2010
  • Posts: 590

  Posted: Mar 20, 2005 - 07:19 PM

  Hello,
  There is some problem in the pninit.php file.
  If you havent already upgraded you can avoid the problem making these changes before upgrade.
  The first one isn't severe but as I found you can correct it as well ! In pninit.php line 932 change :
  

  Code

  pnModSetVar('pnFlashGames', 'commericalFirst', 1);

  
  to :
  

  Code

  pnModSetVar('pnFlashGames', 'commercialFirst', 1);

  
  And this one is the one causing the problem because upgrade 1.1.0 -> 1.5 isn't executed
  lines 973-974 change :
  

  Code

  pnModSetVar('pnFlashGames', 'banPolicy', "Insert your site's ban policy here.");
              break;

  
  to :
  

  Code

  pnModSetVar('pnFlashGames', 'banPolicy', "Insert your site's ban policy here.");
              return pnFlashGames_upgrade('1.1.0');
              break;

  
  For those having already upgraded, you need to look in pninit and do manually all the changes that are in the 1.1.0 -> 1.5 upgrade, namely :
  
  - add a field pn_status INT DEFAULT '1' NOT NULL to the (your_prefix)_pnFlashGames_games table
  - add a field pn_status INT DEFAULT '1' NOT NULL to the (your_prefix)_pnFlashGames_contests table
  - create the mod variable showUserRank and set it to 1
  
  --
  Visit my live reef aquarium.
  
  My Amazon wish list.

  • 
  •  
• **unknown user**
  
  

  • Rank: Softmore
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 117

  Posted: Mar 21, 2005 - 03:24 AM

  pnflashgames.com has a post on how to fix this here also.
  
  http://www.pnflashga…wtopic-t-1045.phtml

  • 
  •  
•  
•  

Users on-line

• 0 users

This list is based on users active over the last 60 minutes.