My Site: www.inthemoonlightfiction.com
eFiction: v3.3.1
PHP: 5.2.4
MySQL: 5.0.27-standard
Mods: Challenges
Did you search? Yes. Used "out of memory".
State the nature of your problem:
Went to go browse the authors on my site this morning as I do every morning to look at new member profiles (just to see) and I received the error below. I went into the mysql_fucntions.php file and couldn't see what error they were talking about. And as I have to be in class relatively soon, I didn't have much time to really check around in MySQL database. All the other links on my home page (ie. Home, Most Recent, Series, Challenges etc) work fine.
Warning: mysqli_query() [function.mysqli-query]: (HY000/5): Out of memory (Needed 1048548 bytes) in /home/inthemoo/public_html/includes/mysqli_functions.php on line 19
A fatal MySQL error was encountered.
Query: SELECT count(distinct stories.uid) FROM (efictionfanfiction_stories as stories, efictionfanfiction_authors as author) WHERE stories.validated > 0 AND (FIND_IN_SET(author.uid, stories.coauthors) > 0 OR stories.uid = author.uid)
Error: (5) Out of memory (Needed 1048548 bytes)
I guess it just needed a little rest as it's showing up now.
My Site:
eFiction: v3.4.3
PHP: 5.2.4
MySQL: 5.0.27-standard
Mods: Challenges, Submit Time and Word Count
This seems to be working now. I think this is the same as some other people are getting because, as they are written, the queries for the author page seem to take a lot of server resources.
Here is the topic, but I'm not sure there is a workable solution in there: https://efiction.org/forums/index.php?topic=5697.msg30899
Thanks Carissa...sigh..back to Antigone I must go.
My Site:
eFiction: v3.4.3
PHP: 5.2.4
MySQL: 5.0.27-standard
Mods: Challenges, Submit Time and Word Count
We're testing a solution now, but there's quite a few things that touch on that issue so I want to make sure I find them all before releasing it.
