HQ NETWORK:   XBOX ONE |  XBOX 360 |  AIDELUXE HQ Network: 1,324 | Guests: 333 | Members: 1 


   Current Location: Forums New Game - Fursan al-Aqsa - Knights of al-Aqsa Mosque   |   Where are the websites listing the files you can delete from   |   Hello everyone   |   Installing a new Dashboard on an Chip modded XBox   |   error 5 on xbox   |   HELP! replacement motherboard with XECUTER 2 BIOS   |   1.2 Board spitting Christmas lights   |   new member   |   Seagate Momentus XT   |   MY PROFILE -> MY GAMES now available on XBOX-HQ!   |   
  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 error!!! [solution]
Xbox-Hq.Com Forum Index -> pnFlashGames Beta Testers/Bug Reports
Post new topic Reply to topic  Goto page 1, 2, 3, 4  Next  
 SQL error!!! [solution] View previous topic :: View next topic  
 
 
 
 
jokerd
Xbox-HQ User
Xbox-HQ User



Joined: Feb 13, 2005
Posts: 17
Location: UK

Post Posted: Sun Feb 13, 2005 5:36 pm   
Post subject: SQL error!!! [solution]
Reply with quote
 
I have php nuke 7.5 and just got your VIP games module (good work) /The only problem is that in admin I get the following error in catagorys

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/davenweb/public_html/electrob/includes/sql_layer.php on line 238 No Existing Categories

And this error in games

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/davenweb/public_html/electrob/includes/sql_layer.php on line 238

I have installed the tables ect. and updated the index.php file (and the header). I have activated the module ect. When filling in an new game form or a new catagory form I just get a blank page. PLEASE HELP


View user's profile Send private message Visit poster's website
 
 
 
 
forahobby
Administrator
Administrator


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

Post Posted: Sun Feb 13, 2005 7:01 pm   
Post subject:
Reply with quote
 
Hi,

I would personally re-install from scratch.. You have obviously missed something in the INSTALLATION INSTRUCTIONS.. DID YOU READ THEM?

I have ++ running on both of my websites:
http://www.xbox-hq.com
http://www.satellite--tv.info

Kimmi and another few testers will have it on their own site veyr soon.. I can tell you now that there is nothing wrong with the ++ module as i am using it on HQ and it gets tonnes of visitors.. Go and have a look. Its no different to what you are using.

anyway, let me know how you go.. If you can give me admin login i would be please to come and check it out for you since you have become a VIP MEMBER!

regards,

forahobby
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
 
 
 
 
jokerd
Xbox-HQ User
Xbox-HQ User



Joined: Feb 13, 2005
Posts: 17
Location: UK

Post Posted: Sun Feb 13, 2005 8:06 pm   
Post subject:
Reply with quote
 
I sent the details in the ticket, love the module and the site. Just hope you can spot the fault.

Love your VIP system!!!!!!! Very Happy


View user's profile Send private message Visit poster's website
 
 
 
 
forahobby
Administrator
Administrator


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

Post Posted: Sun Feb 13, 2005 11:57 pm   
Post subject:
Reply with quote
 
thanks for that but i get a error saying unauthorised.. I live in Australia too if that has anytihng to do with it. Maybe your server only allows certain ip ranges.. (i dont know).. Very strange.

anyway, as soon as i can access the site ill help no probs.. Another thing to try would be to first install the pnFlashGames v0.5b (free version) and see if that works..

Are you certain your running phpnuke 7.5??

talk soon

l8r

forahobby
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
 
 
 
 
jokerd
Xbox-HQ User
Xbox-HQ User



Joined: Feb 13, 2005
Posts: 17
Location: UK

Post Posted: Mon Feb 14, 2005 12:04 am   
Post subject:
Reply with quote
 
I just installed a special module to check my php nuke version and it confirms its 7.5,


I checked the beta 5 module version and get the same error

Everything works except the admin for adding and editing catagorys and games,

I used phpmyadmin to confirm the tabels are there and they are.


I have re-installed the VIP version (love the tell a friend feature)

Just seems its a admin fault and it is 100% phpnuke 7.5


View user's profile Send private message Visit poster's website
 
 
 
 
forahobby
Administrator
Administrator


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

Post Posted: Mon Feb 14, 2005 5:47 am   
Post subject:
Reply with quote
 
Hi,

i left some replies in your VIP TICKET with what to try.
First try chmodding all the files and folders in the Flash_Games folder..
Give them full read/write permissions.

Then remove all your cache and try again.. if it still plays up follow that link i gave you to the topic talking about SQL DEBUGING.. it tells you how to turn on the SQL DEBUG in PHPNUKE so it displays the exact error.

If the error isnt chmod related i bet its something on your server. Who are you hosting with and on what sort of box?? Running apache what?

anyway, i could send you a .sql inject file to get you out of trouble until you sort it out.. Its definately not the module mate because every other site is using it too..

talk soon

FH

_________________
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
 
 
 
 
Thrill
Xbox-HQ Experienced
Xbox-HQ Experienced

Xbox Version: V1.1
Modded: Xecuter 2 lite

Joined: Feb 13, 2005
Posts: 138
Location: UK

Post Posted: Mon Feb 14, 2005 6:17 am   
Post subject:
Reply with quote
 
forahobby wrote:
thanks for that but i get a error saying unauthorised.. I live in Australia too if that has anytihng to do with it. Maybe your server only allows certain ip ranges.. (i dont know).. Very strange.

anyway, as soon as i can access the site ill help no probs.. Another thing to try would be to first install the pnFlashGames v0.5b (free version) and see if that works..

Are you certain your running phpnuke 7.5??

talk soon

l8r

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


unauthorised.. problem.

Just like to say I had this same problem when updating from 0.4beta to 0.5 beta. It turned out to be the index.php in the main root. I backed up that file before upgrade.. replaced it with my old backup one and 0.5 beta worked fine and the site too..?? maybe there is a added mod I installed or something that needed a pease of code in the index.php file.. Try this you might be able to get forahobby on your site to help Laughing

wish i could get into the VIP downloads. signed up for a year but still cant get in?

_________________
Mega Flash Game packs @ http://main.games4nuke.com


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

Xbox Version: V1.1
Modded: Xecuter 2 lite

Joined: Feb 13, 2005
Posts: 17
Location: UK

Post Posted: Mon Feb 14, 2005 8:14 am   
Post subject:
Reply with quote
 
index.php is fine, and so is the header include

Thanks though, this is frustrating. I installed it on another 7.5 nuke and got no SQL error, just a blank screen when I post new games ect


View user's profile Send private message Visit poster's website
 
 
 
 
jokerd
Xbox-HQ User
Xbox-HQ User

Xbox Version: V1.1
Modded: Xecuter 2 lite

Joined: Feb 13, 2005
Posts: 17
Location: UK

Post Posted: Mon Feb 14, 2005 5:35 pm   
Post subject:
Reply with quote
 
Debuggin gave me

Quote:
SQL query: select gid, gname from nuke_flashgames_games

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/davenweb/public_html/electrob/includes/sql_layer.php on line 238
No Existing Games


and



Quote:
SQL query: select cid, cname from nuke_flashgames_cat

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/davenweb/public_html/electrob/includes/sql_layer.php on line 238
No Existing Categories


View user's profile Send private message Visit poster's website
 
 
 
 
forahobby
Administrator
Administrator


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

Post Posted: Mon Feb 14, 2005 11:01 pm   
Post subject:
Reply with quote
 
Quote:
Thanks though, this is frustrating. I installed it on another 7.5 nuke and got no SQL error, just a blank screen when I post new games ect


If you installed on another phpnuke instlalation then thats telling you there is something wrong with your current phpnuke install..

Hey, i was just thinking too.. You dont have your forums enabled.. The FlashGames uses som escripts from the forums.. Maybe try enabling the FORUMS (activating the module) and then go back to FLASHGAMES ADMIN..

I just dont know how this is happening.. It has to be your phpnuke..

anyway, sorry for all the inconveniece but hopefully we will have you sorted soon.

_________________
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
 
 
 
 
jokerd
Xbox-HQ User
Xbox-HQ User

Xbox Version: V1.1
Modded: Xecuter 2 lite

Joined: Feb 13, 2005
Posts: 17
Location: UK

Post Posted: Mon Feb 14, 2005 11:24 pm   
Post subject:
Reply with quote
 
Can I get a SQL file with the tables, maybe the actual tables are setup wrong, maybe my mysql database is diffrent.

A sql file for me to add the tables with may solve the prob


View user's profile Send private message Visit poster's website
 
 
 
 
forahobby
Administrator
Administrator


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

Post Posted: Mon Feb 14, 2005 11:31 pm   
Post subject:
Reply with quote
 
hi mate,

Ill zip up a SQL Injection file for you.
It will just be a HEAP of games injected into the games tables.

Is that ok??

What you will have to do is first:
1. Delete all RECORDS in the nuke_flashgames_cat table
2. Delete all RECORDS in the nuke_flashgames_games table

just clikc on 'EMPTY' option when browsing either table in MYSQL.

Then you can inject the sql file im sending you via email.
This will inject around 80 games or so and setup the categories.

hope it helps

talk soon

FH
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
 
 
 
 
jokerd
Xbox-HQ User
Xbox-HQ User

Xbox Version: V1.1
Modded: Xecuter 2 lite

Joined: Feb 13, 2005
Posts: 17
Location: UK

Post Posted: Mon Feb 14, 2005 11:35 pm   
Post subject:
Reply with quote
 
thanks, I have also activated the forums with no effect.


View user's profile Send private message Visit poster's website
 
 
 
 
jokerd
Xbox-HQ User
Xbox-HQ User

Xbox Version: V1.1
Modded: Xecuter 2 lite

Joined: Feb 13, 2005
Posts: 17
Location: UK

Post Posted: Mon Feb 14, 2005 11:37 pm   
Post subject:
Reply with quote
 
Or I could drop the tables and you could get thedatabase to re-create the tables


View user's profile Send private message Visit poster's website
 
 
 
 
forahobby
Administrator
Administrator


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

Post Posted: Mon Feb 14, 2005 11:38 pm   
Post subject:
Reply with quote
 
joker,

before i send you these sql files to inject.. Are you sure you have the FLASH_GAMES directory and all files under it as READ/WRITE CHMOD 777??

Just give all files read/write access in the FLASHGAMES module.
Im can tell you now after a couple of other users have install the ++ version is that you have issues with your phpnuke.

Either you have upgraded from a older version say 6.5 or something using upgrade scripts and sometihng is missing or you have manually edited and added/removed some main code..

You still are the only person with this issue and i know there are quite a few ++ installations out there..

anyway, email now.

l8r

forahobby
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  
Goto page 1, 2, 3, 4  Next |
 All times are GMT | Page 1 of 4
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 cannot attach files in this forum
You cannot download files in this forum
 

 Members Online (1) / Guests Online (333)
Members Browsing
mrcosine,

Legend
Administrator  Moderator  VIP Member  Registered User  Banned Users

Pre-order Microsoft Flight Simulator