HQ NETWORK:   XBOX ONE |  XBOX 360 |  AIDELUXE HQ Network: 8,529 | Guests: 2482 | 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 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  
 
 
 
 
jokerd
Xbox-HQ User
Xbox-HQ User



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

Post Posted: Mon Feb 14, 2005 11:39 pm   
Post subject:
Reply with quote
 
Also my table prefix is electro_, not nuke_. I have updated the config.php file so in theory it should still work, could this be causing the problem (the fact I'm using electro as table prefix?????)


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


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

Post Posted: Mon Feb 14, 2005 11:39 pm   
Post subject:
Reply with quote
 
dont DROP any tables.. you only want to EMPTY the data from inside using the EMPTY LINK..

email sent!

_________________
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: Mon Feb 14, 2005 11:43 pm   
Post subject:
Reply with quote
 
jokerd,

yes.. It could definately be causing problems.
I have not tested with changing the main NUK_ prefix.

Is there anyway you can change your main NUKE_ prefix back to normal and is there any reason why you would be using that anyway. It doenst offer any better security or anything.

let me know

thanks for looking into it too.. Its good to know for future purposes.

talk soon

your mate from down under,

FH (kent)
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 11:43 pm   
Post subject:
Reply with quote
 
I have made everything CHMOD 777 all folders and files with no change.

It was also a fresh phpnuke install


View user's profile Send private message 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 11:47 pm   
Post subject:
Reply with quote
 
I have 3 nuke sites on one database sharing users. Hense electro is the prefix.

Also I just noticed this error on the module

SQL query: select * from electro_flashgames_games WHERE gcid='1'
Action Games

0 Game(s) Available

0 page views

Action games where the fastest, most accurate clicker wins!
SQL query: select * from electro_flashgames_games WHERE gcid='2'
Arcade Games

SQL query: select * from electro_flashgames_games WHERE gcid='3'


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


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

Post Posted: Mon Feb 14, 2005 11:49 pm   
Post subject:
Reply with quote
 
ok.. So it sounds like the main PREFIX is the problem..
Do you want to try installing it with the standard NUKE_ prefix to see if thats the prob??

If it is i will have to look into for next release of ++.

thanks for the update.

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



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

Post Posted: Tue Feb 15, 2005 7:58 am   
Post subject:
Reply with quote
 
I'll try tonight


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


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

Post Posted: Tue Feb 15, 2005 10:56 am   
Post subject:
Reply with quote
 
good stuff.. Just let us know how you go and if you happy or not..

It does sound like your table prefix is causing the problem now.. The ++ version has been installed on over 10 sites now and working perfectly..

Im sorry for all the trouble but i never would have guessed to test for your kind of setup.. Im sure its only something simple but at this stage god knows without doing the same here and setting up a similar database.

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: Tue Feb 15, 2005 9:57 pm   
Post subject:
Reply with quote
 
Just installing a clean, fresh nuke install with the new nuke prefix...


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


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

Post Posted: Tue Feb 15, 2005 10:05 pm   
Post subject:
Reply with quote
 
have any luck jokerd??? The ++ module fine on every other site.. I hope we get this sorted soon for you!

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: Tue Feb 15, 2005 11:07 pm   
Post subject:
Reply with quote
 
Thanks so much. Seems the problem was the prefix.

Thanks so much for your help. My site should be online in a week or two and I'll show you when its ready Very Happy

VIP reccommended - best money I have spent in ages


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



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

Post Posted: Tue Feb 15, 2005 11:44 pm   
Post subject:
Reply with quote
 
Got a VIP testermonial section


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


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

Post Posted: Wed Feb 16, 2005 12:43 am   
Post subject: Xbox-Hq VIP Member Testimonials
Reply with quote
 
i do actually but its only in the forums.. Ill link you too it.. Thanks for making any comments..

Xbox-Hq VIP Member Testimonials:
http://xbox-hq.com/html/postt2003.html#26360

cant wait to see your site up.

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
 
 
 
 
Virgin_Steel
Xbox-HQ User
Xbox-HQ User



Joined: Feb 16, 2005
Posts: 11

Post Posted: Thu Feb 17, 2005 11:45 am   
Post subject:
Reply with quote
 
Ok I just installed 050204_pnFlashGames v0.5beta-forahobby(free)
and get actually the same error...my prefix is not changed, it's still 'nuke'???But I want to ask...i havent found any admin files in the ROOT and also any sql files???Just
Quote:
/images
/modules
/blocks
index.php

Where i can get these files and try again?
I'm using php-Nuke 7.0

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


View user's profile Send private message
 
 
 
 
forahobby
Administrator
Administrator


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

Post Posted: Thu Feb 17, 2005 12:46 pm   
Post subject:
Reply with quote
 
Quote:
Ok I just installed 050204_pnFlashGames v0.5beta-forahobby(free)
and get actually the same error...my prefix is not changed, it's still 'nuke'???


The reason you are getting a SQL error is because you DO NOT have the admin files for your version of phpnuke and since you dont have the admin files you cant setup the database..

The admin files needed have all the .sql inside the admin.php ready to setup your nuke site.. Anyway, read on.

Quote:
i havent found any admin files in the ROOT and also any sql files???


We did have the admin files available but only for 0.4beta(free).. Now the free version is up to 0.5beta(free) but i havent had the time to do the ew admin file..

If you sign up as a VIP MEMBER i have included the admin files for the latest 0.2++ (VIP) version.. Its hard to keep up at the moment but ill hopefully get the older admin files for 7.4 and older up for you if you cant become a vip by the end of this weekend.

just hang in there.. Im a one man band working on this project and im supporting everyone and all versions.. Just need the time to get them all working.

btw. whats your websites url...??


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 Previous  1, 2, 3, 4  Next |
 All times are GMT | Page 2 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