Website: https://amalthia.mediawood.org/ebooks/
Problem: I can't access any portion of the archive, every page I go to says "A fatal MySQL error was encountered." There are no other details as to what is causing the fatal MySQL error message.
Here is an example page: https://amalthia.mediawood.org/ebooks/browse.php?type=recent
I'm not sure where to start to fix this problem.
Here is what I've done so far:
1) I've already reviewed my "config.php" file and the database information looks accurate.
2) compared this archive to the other efiction archives I'm hosting, those are fine.
3) Looked through this forum archive for people with similar problems.
I'm not sure why the site would just break, I haven't made any edits in months and it was working the last time I visited the website.
I'd appreciate any and all help.
Thanks,
Amalthia
@Amaltia
check your PHP version, and check the PHP logs on your server/hosting.
You can set manually debug in the database, table fanfiction_settings field debug to 1.
What version of efiction are you using?
Never say that something is impossible because there will be always some dummy who will do it.
URL for efiction site: https://www.hpfanfiction.cz/
php: 8.1.33 MariaDB 10.5
efic version: 4.0.x
mods: storyimage, notifications, storyend
I'm on eFiction 3.5.5 and PHP 7.4.33. I have updated my debug setting in phpMyAdmin to "1" but no debug information appeared on the website. I'll see what I can find out in the server hosting/php logs. My next thought was to upgrade my eFiction to 3.5.7.
Okay I found the PHP error log.
[01-Apr-2024 00:05:09 America/Anchorage] PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; TemplatePower has a deprecated constructor in /homedir/dir/www/amalthia.mediawood.org/public_html/ebooks/includes/class.TemplatePower.inc.php on line 451
[01-Apr-2024 15:56:05 America/Anchorage] PHP Deprecated: Unparenthesized `a ? b : c ? d : e` is deprecated. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` in /homedir/dir/www/amalthia.mediawood.org/public_html/ebooks/series.php on line 142[10-Jun-2024 21:37:43 America/Anchorage] PHP Notice: Undefined index: featuredblock in /homedir/dir/www/amalthia.mediawood.org/public_html/ebooks/includes/class.TemplatePower.inc.php on line 701
[10-Jun-2024 21:37:43 America/Anchorage] PHP Notice: Undefined index: in /homedir/dir/www/amalthia.mediawood.org/public_html/ebooks/includes/class.TemplatePower.inc.php on line 701
It looks like I do need to update efiction, if it addresses the deprecated PHP.
Your debug is displayed, press F12 and roll down on the Elements tab. No error there, only executed queries.
That PHP error is not the reason for this. Are you able to contact me?
Never say that something is impossible because there will be always some dummy who will do it.
URL for efiction site: https://www.hpfanfiction.cz/
php: 8.1.33 MariaDB 10.5
efic version: 4.0.x
mods: storyimage, notifications, storyend
I found a solution.
In phpMyAdmin I went to the table "fanfiction_blocks" and turned off "featured author" and any other block I wasn't currently using. After that the pages worked again.
The thing that helped the most was realizing if the errors weren't displaying on the website, I could still find the information in the php_errorlog in my cpanel File Manager.
This article helped as well: https://efiction.org/community/version-3-x-general-support/undefined-index-php-error/
@jimmi I ended up finding the solution by reviewing this article. https://efiction.org/community/postid/17028/ Once I did what the article recommended the site worked again. I'm now looking into how to remove blocks I'm not using from efiction.
Thanks so much for your help. I didn't realize the error messages would be available through File Manager in cpanel. That gave me something to work with in regards to finding a solution.
