Your Account Error

Rider · **Your Account Error -** 02-04-2003, 01:33 AM

When I load the main page of the module "Your Account" at the top of the page I see:

Code:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rider/public_html/includes/sql_layer.php on line 357

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rider/public_html/includes/sql_layer.php on line 357

It won't load it on ANY other page that I am aware of.

-Rider

Martin · 02-04-2003, 06:58 AM

Have you added any your account mods, or are you using the original default PHP-Nuke Your Account module? Is this a new install or nuke, or have you been up for a while with it working and you started getting this error?
That error is usually caused by not having sql tables in the database of mysql. So if you have modded it you need to add the tables supplied with the mod.
Just trying to sort out the variables here.
Martin

Rider · **I did... -** 02-04-2003, 01:05 PM

Yes, my friend and I added in a couple of fields to fit the design of my gaming site. I installed nuke in November and probably early Jan we did the mod. I am using the Your Accoutn Tweak.

Do you know what I need to add to correct this?

http://www.fla-gamers.com

-Rider

Martin · 02-04-2003, 01:15 PM

Hold the wagon!! I see you are using nsn your account, so like I said you will have to install it. Read the instructions on how to install the tables for mysql. It's in there. Just read it.
Let me know if you need more help, cause I have done that one on my site before.

The instructions show you how to type in a url so set up the tables. It is simple.

Rider · **But.. -** 02-04-2003, 01:37 PM

If I do the tables again, will it mess up the mod I implemented?

-Rider

Martin · 02-04-2003, 01:45 PM

Do the tables Again?
Did this stop working after you modded the "nsn your account" ? If it was working and then you changed something that made it stop working you will have to un do your changes.

Rider · **Well... -** 02-04-2003, 01:49 PM

Everything works perfectly, though. I just have this at the top of the main page:

Code:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rider/public_html/includes/sql_layer.php on line 357

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rider/public_html/includes/sql_layer.php on line 357

It is just rather annoying.

-Rider

mikem · 02-04-2003, 01:52 PM

If you started getting that error AFTER you modified the Your Account module, then more than likely NOT everyhting is working fine.

Can you show us what you did to the Your Accoutn module to add the new fields?
More than likely, that is where the problem is.

mikem

mikem · 02-04-2003, 01:56 PM

Can you do this for me. So we can see what is causing that error?

Open includes/sql_layer.php go to line 300 or so and change:

Code:

case "MySQL": 
$row = mysql_fetch_row($res); 
return $row; 
break;;

to this

Code:

case "MySQL": 
if ($row = mysql_fetch_row($res)) { 
return $row; 
} else { 
print (mysql_error()); 
} 
break;;

then upload the changed file. Backup your original first. That should give you the debug on what the SQL is stopping on.

mikem

Rider · **Hmm -** 02-04-2003, 02:06 PM

Now I have this at the top of the page:

Code:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rider/public_html/includes/sql_layer.php on line 360

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rider/public_html/includes/sql_layer.php on line 360

and where it would tell you the information on the main page it says:

Code:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/rider/public_html/includes/sql_layer.php on line 253

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/rider/public_html/includes/sql_layer.php on line 253
There is no available info for Rider