wow i got but got a error helppp

Trinity · New Member Joined: Jan 22, 2004 Posts: 17

Oh big Raven can u please help ,
I d/l your php 7.0 file and installed it like it should be. but when i open my site and make a admin i get this error( the admin made is no problem at all)

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/.sites/65/site131/web/includes/sql_layer.php on line 286

when i change my site the error stays on it . do you have any idea to fix this problem.

Trinity · New Member Joined: Jan 22, 2004 Posts: 17

nvm found a other topic about it on this forum let me try that first

Trinity · New Member Joined: Jan 22, 2004 Posts: 17

i did exactly what u said in another post Raven but i get another error

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/.sites/65/site131/web/includes/sql_layer.php on line 286
Table 'extreme.nuke_iptracking' doesn't exist

i also checked the C and A on database but thats oke

Can u help me please with this problem

Trinity · New Member Joined: Jan 22, 2004 Posts: 17

i just set back the old file and the other error comes back lol

hmm Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/.sites/65/site131/web/includes/sql_layer.php on line 286

so i must be doing something wrong

Raven · Posted: Thu Jan 22, 2004 11:33 am

This distro is to be a virign install. No previous files or tables. Is that your scenario?

Trinity · New Member Joined: Jan 22, 2004 Posts: 17

yes i had 6.9 installed but i removed it completely and start over again with a blank database and blank website. i started using php nuke a few weeks ago and was just testing and waited for 7. version.

Raven · Posted: Thu Jan 22, 2004 1:08 pm

Are you using the Installer? I have not heard of any other problems like this. Try editing sql_layer.php and set DEBUG=1 and just above where the warning is given will be the sql code that is causing the error.

Trinity · New Member Joined: Jan 22, 2004 Posts: 17

i dont get in i need to set DEBUG=1 but i dont see that kind of sentence and if i set DEBUG=1 infront of the line like on line 284 it doesnt work only gives a extra error
i will pm you my site details so u can have a look if u want

Raven · Posted: Thu Jan 22, 2004 1:37 pm

Sorry - I didn't mean a literal variable named DEBUG. Find $sql_debug=0; and miodify it to $sql_debug=1;

Trinity · New Member Joined: Jan 22, 2004 Posts: 17

SQL query: insert into nuke_iptracking (username, date_time, ip_address, hostname, page) values ('dbonten', '2004-01-22 21:19:33', '80.57.77.151', 'g77151.upc-g.chello.nl', '/index.php')
SQL query: select count(*) from nuke_iptracking

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/.sites/65/site131/web/includes/sql_layer.php on line 286

this is the error when i set the debug to 1 like u said, i changed the debug to 1
hmmm this is getting weird lol Sad

Raven · Posted: Thu Jan 22, 2004 2:34 pm

Make sure that you have a table called iptracking.

Trinity · New Member Joined: Jan 22, 2004 Posts: 17

lol how do i do that ??? i am not that good with msql hahaha

Raven · Posted: Thu Jan 22, 2004 3:02 pm

Use phpMyAdmin. Your cPanel or Plesk has an icon for that.

Trinity · New Member Joined: Jan 22, 2004 Posts: 17

yes i know but it tells me to fill in cells but i dont know what do to next i have to make certain cells but i dont know how ! i use phpmyadmin and i also can find tables and to create one but how in earth do i do that . sorry that i am such a pain in the a.... (u know) lol

Trinity · New Member Joined: Jan 22, 2004 Posts: 17

never mind i am going to install php nuke 7.0 and not yours because i only get errors in it ffs everything i do something i get new errors lol maybe the clean version of it hasnt got that if its the same i will install ravens again and find out whats the problem if you have any other ideas please tell me Thanks anyway

Trinity · New Member Joined: Jan 22, 2004 Posts: 17

i have installed php nuke 7.0 from your site also downloaded and i have no errors anymore so it must be something in your mod. If you find out what it was or the explanation for it to undo it please reply anyway so i can try again

Raven · Posted: Thu Jan 22, 2004 4:20 pm

When you installed it, did it come up ok (w/o errors)? Could you navigate it w/o errors - at all? If so, what exactly do you do that causes the error? No one else, at all, has reported any issues, so this one will be a little bit harder to debug.

Trinity · New Member Joined: Jan 22, 2004 Posts: 17

list of things i did :

- nuke.sql file setup to set it to right db
- config.php setup with right settings (dbusername,db,dbpass)
- upload whole html map (33 mb+-)
- set chmod to 777
- run nuke.sql on phpMyAdmin

done !
What do i mis here. Thats all i did and at the nuke file i used the original one wich is included in the download.

Greets

TriniTy

Raven · Posted: Thu Jan 22, 2004 5:06 pm

That's not my customized version. My customized version sql is raven-nuke sql .

Trinity · New Member Joined: Jan 22, 2004 Posts: 17

lol so i used the wrong sql file to create the tables ?
but where can i define wich database the tables must go in dont see that sentence or can i add it myself ?

Raven · Posted: Thu Jan 22, 2004 5:16 pm

Either use the Installer or just do what you did before. Create the database and then use phpMyAdmin to load the sql.

Trinity · New Member Joined: Jan 22, 2004 Posts: 17

Hi Raven,

9 oclock here, when i woke up i right started where we left last night,
Did same as before only i used your nuke and it worked Very Happy

All the time thinking what i did wrong, next time i just need to read more files lol.
Thanks for your support !!

Greets

Trinity

Raven · Posted: Fri Jan 23, 2004 4:34 am

Glad it got resolved!