help... weird errors!

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Vikki82
Forum Newbie
Posts: 3
Joined: Fri Mar 26, 2004 12:44 pm
Location: NY, USA

help... weird errors!

Post by Vikki82 »

hey guys! i just installed eFiction v1.1 ...

and im getting these errors up top, i dont know much about php so any help would be most appreciated! thanks :)

Warning: mysql_query(): Unable to save result set in /home2/fatone/public_html/fiction/index.php on line 110

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/fatone/public_html/fiction/index.php on line 111

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/fatone/public_html/fiction/blocks.php on line 71
Chambrln
Forum Commoner
Posts: 43
Joined: Tue Dec 02, 2003 10:45 am
Location: Oregon

Post by Chambrln »

The second and third errors are being caused by the first error.

I would check your database user rights and make sure the username and password combination you are using for your site have the correct rights for your database. The username needs to have write permissions for the database.

I don't know what eFiction is so this is just a stab in the dark.
Vikki82
Forum Newbie
Posts: 3
Joined: Fri Mar 26, 2004 12:44 pm
Location: NY, USA

Post by Vikki82 »

no i dont think thats the problem... ive worked with MySQL before and i already set the username to "All Privlages"

thank you though :)
TheBentinel.com
Forum Contributor
Posts: 282
Joined: Wed Mar 10, 2004 1:52 pm
Location: Columbus, Ohio

Post by TheBentinel.com »

Here's a link that discusses this error:
http://bugs.php.net/bug.php?id=16906

One thing that's mentioned as a possible cure is:
Run a:
SET SQL_BIG_TABLES=1;

I don't know what that means, where you run it, etc, but the link will help explain it.

Hope it helps!
Vikki82
Forum Newbie
Posts: 3
Joined: Fri Mar 26, 2004 12:44 pm
Location: NY, USA

Post by Vikki82 »

:( i dont know what they mean either... lol, I thought I understood MySQL better than I really do I guess.

does anyone think they can help me out? one on one?
Illusionist
Forum Regular
Posts: 903
Joined: Mon Jan 12, 2004 9:32 pm

Post by Illusionist »

Here is another link about this:
http://bugs.php.net/bug.php?id=11765
Illusionist
Forum Regular
Posts: 903
Joined: Mon Jan 12, 2004 9:32 pm

Post by Illusionist »

Post Reply