Page 1 of 1

help... weird errors!

Posted: Fri Mar 26, 2004 12:44 pm
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

Posted: Fri Mar 26, 2004 1:06 pm
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.

Posted: Fri Mar 26, 2004 1:12 pm
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 :)

Posted: Fri Mar 26, 2004 1:32 pm
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!

Posted: Fri Mar 26, 2004 3:15 pm
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?

Posted: Fri Mar 26, 2004 3:39 pm
by Illusionist
Here is another link about this:
http://bugs.php.net/bug.php?id=11765

Posted: Fri Mar 26, 2004 3:48 pm
by Illusionist