URL to your eFiction: http://drfa.seventh-star.net
Version of eFiction: 3.3
Have you bridged eFiction, if so with what?: N/A
Version of PHP: 5
Version of MySQL: 4.1.21-standard
Have you searched for your problem: yes
If so, what terms did you try: PHP5
State the nature of your problem: See below.
Do you have a test account for us? No.
I recently upgraded the PHP on my shared server to version 5 using CGI, as it was necessary to run the latest installation of MediaWiki. But when I went to my eFiction archive ( http://drfa.seventh-star.net), I noticed this error at the top:
Warning: mysql_query() [function.mysql-query]: Access denied for user '**'@'localhost' (using password: NO) in /home/**/public_html/drfa/blocks/featauth/featauth.php on line 7
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/**/public_html/drfa/blocks/featauth/featauth.php on line 7
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/**/public_html/drfa/blocks/featauth/featauth.php on line 8
Is this a wrong password somewhere, incompatibility with the 3.3 version of the Featured Author block (which was working until this), or something with PHP5?
ETA: Even though I disabled the Featured Author block (made it inactive), my header is still missing, even though I have it set to display an image in CSSZen. In Elegance, it looks fine, though, as far as I can tell.
Archive: Dragonfayth
eFiction: 3.5.5/6
Latest Patch(es): Yes
bridged?: No
modified?: Yes
PHP: 7.4.25
MySQL: 5.7.32-35-log
Please don't post specific installation problems to the bugs forum. Please post them in the support forum. I just went to the link you provided and the site came up fine so I assume you got this fixed.
Sorry about that, I wasn't sure what it fit into, exactly, since it was a post-installation/upgrade issue, more related to the individual block, as far as I could tell.
It looked fine when I went there, but when I re-enabled the Featured Author block, the error came up again. But this time, my header is back, too. Debug is also turned off, so I don't know why the error would be popping up unless it is some sort of bug with the Featured Author block in relation to PHP5 (the only change I made recently).
Archive: Dragonfayth
eFiction: 3.5.5/6
Latest Patch(es): Yes
bridged?: No
modified?: Yes
PHP: 7.4.25
MySQL: 5.7.32-35-log
You need to update the block. It's not one of the standard blocks. See the 3.3 news article. You probably need to replace $tableprefix with TABLEPREFIX.
Okay, I did that-- here's the updated code from lines 7 and 8 in featauth.php, though I also updated about 2 more instances of $tableprefix to TABLEPREFIX. I left the periods before and after the original intact. Still, I'm getting the same error:
$query = mysql_query("SELECT author.*, UNIX_TIMESTAMP(author.date) as date, COUNT(s.sid) as stories FROM ".TABLEPREFIX."fanfiction_authors as author, ".TABLEPREFIX."fanfiction_stories as s WHERE author.uid = s.uid AND s.validated > 0 AND author.uid = '".$blocks['featauth']['author']."' GROUP BY s.uid DESC LIMIT 1");
while($a = mysql_fetch_array($query))
Looking at the list posted in the 3.3 news update, is there something else that should be changed here? I couldn't spot any, but maybe I wasn't looking carefully enough? The error seems to keep referencing any lines with the $query tag in it.
Archive: Dragonfayth
eFiction: 3.5.5/6
Latest Patch(es): Yes
bridged?: No
modified?: Yes
PHP: 7.4.25
MySQL: 5.7.32-35-log
Looks correct to me.
It looks like that file is not connecting to the database. Check the call to the database or the call to the file that connects to the database in that file.
What might the call to the database or the file look like, or where might it be? I'm not really sure what to look for. Thank you!
Archive: Dragonfayth
eFiction: 3.5.5/6
Latest Patch(es): Yes
bridged?: No
modified?: Yes
PHP: 7.4.25
MySQL: 5.7.32-35-log
