HQ NETWORK:   XBOX ONE |  XBOX 360 |  AIDELUXE HQ Network: 8,528 | Guests: 2503 | Members: 0 


   Current Location: Forums please help. trying to use core ftp   |   need help on an og XBOX modchip   |   Replacing A Broken HDD   |   Help Identifying: 2ND Hand XB Chip   |   A box without the X?   |   20 years ago...   |   No HD   |   Can I reduce F: partition to increase E:?   |   (Solved) Game's crash if custom music is played   |   New Game - Fursan al-Aqsa - Knights of al-Aqsa Mosque   |   
  Home | Active Topics | CD/DVD Media | Downloads | Forums | Feedback | Games | HardDrives | Homebrew | My Profile | ModChips | Reviews | Search | SoftMods | Tutorials

Xbox Forums

Discuss all aspects of the original Xbox Console in our Interactive Xbox Forums..

Get Xbox Game Pass Ultimate
Xbox-Hq.Com :: View topic - SQL database error
Xbox-Hq.Com Forum Index -> pnFlashGames Project
Post new topic Reply to topic    
 SQL database error View previous topic :: View next topic  
 
 
 
 
tommas
Xbox-HQ Newbie
Xbox-HQ Newbie



Joined: May 19, 2006
Posts: 9

Post Posted: Tue May 23, 2006 6:20 pm   
Post subject: SQL database error
Reply with quote
 
I have PHP nuke 7.4 running and have installed PnFlashgames_v0.4plusplus(++). No problem so far, as soon as I put in this bit
Quote:
Copy file /!ROOT!/includes/my_header.php to the /includes/ directory of you
phpnuke installation. You will have to replace the existing my_header.php or
you can edit the file supplied to copy and paste code into your existing
index.php. All code is clearly commented.
I get Mysql errors at the top off the website.
First question is do I need to edit the index or my_header.php file?
I get Mysql errors at the top off the website and inside the module on opening I get
Quote:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/starwars101/public_html/includes/sql_layer.php on line 238
The database is installed I just can't figure it out. Confused
I also get a totally white screen when clicking on the 'ADMIN Tools'
web address www.whf-clan.co.uk


View user's profile Send private message
 
 
 
 
tommas
Xbox-HQ Newbie
Xbox-HQ Newbie



Joined: May 19, 2006
Posts: 9

Post Posted: Wed May 24, 2006 9:59 pm   
Post subject:
Reply with quote
 
Fixed by manually installing all the files in their correct folders.

Only problem now is some of the SQL tables didn't get properly written Confused


View user's profile Send private message
 
 
 
 
scetter
V.I.P. Lifetime



Joined: Oct 14, 2005
Posts: 28
Location: Vermont

Post Posted: Sat May 27, 2006 4:03 am   
Post subject:
Reply with quote
 
What do you mean by the tables didn't get properly written.

Are you getting a database error?

_________________
My web site running the latest build of pnFlashGames(hq) for Dragonfly CMS.
http://www.skeeterspub.com

DEV site(Modules and webmaster resources)
http://www.skpdev.net


View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
 
 
 
 
forahobby
Administrator
Administrator


Joined: May 22, 2003
Posts: 23945
Location: NSW, Australia

Post Posted: Sat May 27, 2006 7:46 am   
Post subject:
Reply with quote
 
Hi,

If you search through the forums here you will find that most probs have been answered.. Ive already started work on the new HQ pnFlashGames for PHPNUKE which will be much smaller and bug fixed it also has many more free features..

The VIP Version will ofcourse still be the cream of the crop with so many add-ons and mods that you will want it anyway. lol

The my header file is really only need to track active users on the flashgames site.. Make sure you have the table (SQL) something like flashgames_activeusers setup.. If not thats the prob.

I would edit your my_header.php file and not just copy and replace.

hope that helps

hobbs
http://www.xbox-hq.com

_________________
HQ Network:
www.xbox-hq.com | www.xboxone-hq.com | www.360-hq.com | www.c64-hq.com


View user's profile Send private message Send e-mail Visit poster's website
 
 
 
 
tommas
Xbox-HQ Newbie
Xbox-HQ Newbie



Joined: May 19, 2006
Posts: 9

Post Posted: Sat May 27, 2006 8:33 am   
Post subject:
Reply with quote
 
Flash Games Installation Status:
- Create nuke_flashgames_active_users - 100% Successful
- Create nuke_flashgames_hiscores - 100% Successful
- Create nuke_flashgames_hiscores_alltime - 100% Successful
- Create nuke_flashgames_cat - 100% Successful
- Insert Action Category nuke_flashgames_cat Failed
- Insert Arcade Category nuke_flashgames_cat Failed
- Insert Other Category nuke_flashgames_cat Failed
- Create nuke_flashgames_favorites - 100& Successfully
- Create nuke_flashgames_games - 100% Successful
- Insert Bloody Pingu Gamenuke_flashgames_games - 100% Successful
- Create nuke_flashgames_comments - 100% Successful
- Create nuke_flashgames_admin - 100% Successful
- Insert Admin Switches nuke_flashgames_admin - 100% Successful
- Create nuke_flashgames_gtype_cat - 100% Successful
- Insert Highest Score Wins Category nuke_flashgames_gtype_cat Failed
- Insert Lowest Score Wins Category nuke_flashgames_gtype_cat Failed
- Insert No Hi-Scores Available Category nuke_flashgames_gtype_cat Failed
- Create nuke_flashgames_leaderboard - 100% Successful
- Create nuke_flashgames_leaderboard_alltime - 100% Successful

This is what I'm getting each time, any ideas?


View user's profile Send private message
 
 
 
 
forahobby
Administrator
Administrator


Joined: May 22, 2003
Posts: 23945
Location: NSW, Australia

Post Posted: Sat May 27, 2006 8:39 am   
Post subject:
Reply with quote
 
maybe try unstalling or manually removing the SQL..
Go into the downloads area and there should be a .sql inject file available to download. It may be a error in my admin.php scripts.. I cant remember sorry.

anyway, in the very near future you will have a nicer version. I can guarantee you that..

You can run the flashgames without that file anyway just to see how it goes.. It only tracks active users.. thats it..

_________________
HQ Network:
www.xbox-hq.com | www.xboxone-hq.com | www.360-hq.com | www.c64-hq.com


View user's profile Send private message Send e-mail Visit poster's website
 
 
 
 
tommas
Xbox-HQ Newbie
Xbox-HQ Newbie



Joined: May 19, 2006
Posts: 9

Post Posted: Sat May 27, 2006 11:23 am   
Post subject:
Reply with quote
 
ok cheers, just pull your finger out and get the new version done Wink




Great work btw Very Happy


View user's profile Send private message
 
 
 
 
forahobby
Administrator
Administrator


Joined: May 22, 2003
Posts: 23945
Location: NSW, Australia

Post Posted: Sat May 27, 2006 2:00 pm   
Post subject:
Reply with quote
 
tommas wrote:
ok cheers, just pull your finger out and get the new version done Wink




Great work btw Very Happy


heheh.. lol.. thanks.. will do..
The sites are nearly error free which means i can work fulltime on the flashgames module.. Smile

anyway, you just hang in there for me too.. I do my best to keep this stuff error free but there is just so many different versions of nuke out there.. hehhe

hobbs
http://www.xbox-hq.com

_________________
HQ Network:
www.xbox-hq.com | www.xboxone-hq.com | www.360-hq.com | www.c64-hq.com


View user's profile Send private message Send e-mail Visit poster's website
 
Display posts from previous:   
  Post new topic  
 
  Reply to topic  
|
 All times are GMT | Page 1 of 1
Jump to:  
 

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum
 


Get Xbox Game Pass Ultimate