HQ NETWORK:   XBOX ONE |  XBOX 360 |  AIDELUXE HQ Network: 8,352 | Guests: 2224 | Members: 2 


   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 error!!! [solution]
Xbox-Hq.Com Forum Index -> pnFlashGames Beta Testers/Bug Reports
Post new topic Reply to topic  Goto page Previous  1, 2, 3, 4  Next  
 SQL error!!! [solution] View previous topic :: View next topic  
 
 
 
 
Virgin_Steel
Xbox-HQ User
Xbox-HQ User



Joined: Feb 16, 2005
Posts: 11

Post Posted: Thu Feb 17, 2005 1:26 pm   
Post subject:
Reply with quote
 
First of all thanks for the quick replay.
I cant become VIP, not Yet...i really like this features and 10$ per year cost nothing...but not yet!
Hm i didn't understand you'll try to adapted the admin files from 0.4beta(free).. to 0.5beta ???
I have an idea if there are no bugs in 0.4beta(free) you could give this version plus admin files...i am not pretentious! But i can wait ,i understand your hard workin` traffic! Great Job btw!
If i can help you with something i'll be glad!Language pack translation,themes icon,information...You're welcome

URL: http://www.novavalna.org

PS.Sorry for my terrible english:)


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



Joined: Jan 12, 2005
Posts: 9

Post Posted: Sat Feb 19, 2005 2:44 am   
Post subject:
Reply with quote
 
so, Im getting this shit, when upgrading from 0.5 to 0.2++

Code:

PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Ensim\Sitedata\kimmi\Inetpub\wwwroot\includes\sql_layer.php on line 342

Im now just in my adminpanel....

I have nuke 7.5
and I have nuke_ as prefixx, and chmod 777 on all dirs...
I have not done anything with the database tabels from 0.5 to 0.2++ do I need to install all over again??

Kimmi

_________________
pnFlashGames for PHPNUKE Translator


View user's profile Send private message Send e-mail
 
 
 
 
forahobby
Administrator
Administrator


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

Post Posted: Sat Feb 19, 2005 5:40 am   
Post subject:
Reply with quote
 
Hi kimmi,

to upgrade from the FREE version to the FULL VERSION (++) you have to use the free version admin tools to REMOVE (uninstall) the database. Then use the new admin to re-install..

Basically remove the whole free module as if it was never there and reinstall the ++ module..

im sure you will get it working. If not just reply and ill give you a hand.

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
 
 
 
 
Kimmi
V.I.P. Lifetime



Joined: Jan 12, 2005
Posts: 9

Post Posted: Sat Feb 19, 2005 1:03 pm   
Post subject:
Reply with quote
 
lol I cant uninstall all the databases from flash_games, then all games and scores will be lost??? I cant live with that...

but I did it just to test... and the error
Code:

PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Ensim\Sitedata\kimmi\Inetpub\wwwroot\includes\sql_layer.php on line 342

Is still here...

_________________
pnFlashGames for PHPNUKE Translator


View user's profile Send private message Send e-mail
 
 
 
 
forahobby
Administrator
Administrator


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

Post Posted: Sat Feb 19, 2005 2:44 pm   
Post subject:
Reply with quote
 
Quote:
lol I cant uninstall all the databases from flash_games, then all games and scores will be lost??? I cant live with that...
but I did it just to test... and the error


So you did do a FULL UNINSTALL??? DId you check your database after the uninstall to double check all tables have been removed??

The v0.2b module is working great on quite a few sites.. It sounds like you didnt uninstall it fully. We all know it works.

Hang in there.. If you still cant get it ill come and have a look.


btw.. its very easy to backup your hi-scores by loggin into your mysql server and doing a export of only the HI-SCORES Smile. Then you can inject back in after you have upgraded!


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
 
 
 
 
Kimmi
V.I.P. Lifetime



Joined: Jan 12, 2005
Posts: 9

Post Posted: Sat Feb 19, 2005 4:28 pm   
Post subject:
Reply with quote
 
Quote:

btw.. its very easy to backup your hi-scores by loggin into your mysql server and doing a export of only the HI-SCORES . Then you can inject back in after you have upgraded!

This is things that go waaayy over my head and knowlegede...
Im just a poor translater... :p

edit:
in root/header.php i had to do this for the error to go away:
//include("includes/my_header.php");

I deleted includes/my_header.php

again, I have no idee what Im doing...

_________________
pnFlashGames for PHPNUKE Translator


View user's profile Send private message Send e-mail
 
 
 
 
forahobby
Administrator
Administrator


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

Post Posted: Sat Feb 19, 2005 5:33 pm   
Post subject:
Reply with quote
 
Hi Kimmi,

I found why your having that error.. Do this for me.. Go back and add that line that you commented out to remove the error and then do this.

OPEN includes/my_header.php and fine:
Code:
#############################################################
## THIS FILE IS ONLY NEEDED FOR PHPNUKE 7.6+ INSTALLATIONS ##
#############################################################


DELETE THIS CODE and then save.. I must have been very tired and forgot to comment this OUT.

that will fix your probs instantly.

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
 
 
 
 
forahobby
Administrator
Administrator


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

Post Posted: Sat Feb 19, 2005 5:38 pm   
Post subject:
Reply with quote
 
ive also just fixed those files my_header.php and custom_header.php so that error is now gone..

Sorry about that.. Sometimes you need another set of eyes to go over your code..

l8r and enjoy

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
 
 
 
 
Kimmi
V.I.P. Lifetime



Joined: Jan 12, 2005
Posts: 9

Post Posted: Sat Feb 19, 2005 6:32 pm   
Post subject:
Reply with quote
 
now we`re talking... Smile

thanx... and yes works fine now...
think my gramma and translations are okey too... havent found anything wierd yet... :p

Kimmi

_________________
pnFlashGames for PHPNUKE Translator


View user's profile Send private message Send e-mail
 
 
 
 
Virgin_Steel
Xbox-HQ User
Xbox-HQ User



Joined: Feb 16, 2005
Posts: 11

Post Posted: Sat Feb 19, 2005 9:27 pm   
Post subject: re:
Reply with quote
 
sorry for my impatience, forahobby, but what about my request?
Just tell me if you preffer to do the admin files for 0.5 ok, i'll wait!
Blessings!


View user's profile Send private message
 
 
 
 
forahobby
Administrator
Administrator


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

Post Posted: Sun Feb 20, 2005 6:40 am   
Post subject:
Reply with quote
 
Hi Kimmi,


0.5b is just about the final.. Im only going to bring out 1 more free version.. The next free version will be called version 1.0final and it will not have any additional features. Plenty of guys here running the ++ version so im guessing kimmi but i think its user error.

I dont see why your having any problems with the plusplus version kimmi unless you not following the instructions correctly..

Whats the error your getting. If you got rid of that small error why bother removing.. That error is only for active users.


1. you should totally remove the older module
2. you should be overwriting all the files and admin files when install the new ++ module??
3. Then your done..

Its exactly the same as 0.5b installation except it has extra features..
I just uploaded those FIXES to the 0.2++ version so go and try again.

sorry for any inconvenice but you have to have some idea how to install a module.

cheers,

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
 
 
 
 
zynthax
Guest





Post Posted: Tue Nov 01, 2005 12:08 am   
Post subject: sql error
Reply with quote
 
i installed free pnflashgames v.06b and seems like everything is fine until i activated the flashgame arcade block... the block is fine but there is an error above it saying
Code:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/vhosts/phalspirates.hostinplace.com/includes/sql_layer.php on line


i'm using php nuke v 7.6 and this is the url
http://phalspirates.hostinplace.com


 
 
 
 
Guest






Post Posted: Tue Nov 01, 2005 10:08 am   
Post subject:
Reply with quote
 
It looks like you have to inject some tables, because they're missing.


 
 
 
 
zynthax
Xbox-HQ Newbie
Xbox-HQ Newbie



Joined: Oct 31, 2005
Posts: 4

Post Posted: Tue Nov 01, 2005 3:23 pm   
Post subject:
Reply with quote
 
Anonymous wrote:
It looks like you have to inject some tables, because they're missing.


what tables? i think i did install everything already. If i missed something, can you tell me exactly what i missed?


View user's profile Send private message
 
 
 
 
forahobby
Administrator
Administrator


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

Post Posted: Tue Nov 01, 2005 6:17 pm   
Post subject:
Reply with quote
 
The FlashGames arcade block may still have some VIP ONLY tables still in the code.. I am a one man band working on everything here.. Give me a screenshot of the error and i will check out the block- file for you and fix it simple.

talk soon and sorry for any inconvience.

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
 
Display posts from previous:   
  Post new topic  
 
  Reply to topic  
Goto page Previous  1, 2, 3, 4  Next |
 All times are GMT | Page 3 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
 


Get Xbox Game Pass Ultimate