My Featured Author block hasn't worked since I upgraded it to 3.3. I have turned the block on and off to see if that would help and nothing.
On the main page when it's turned on I get:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/.mally/dhowler/rq.citadelofthewolf.com/blocks/featauth/featauth.php on line 8
When I click on options, I get:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/.mally/dhowler/rq.citadelofthewolf.com/blocks/featauth/featauth.php on line 8
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/.mally/dhowler/rq.citadelofthewolf.com/blocks/featauth/featauth.php on line 8
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/.mally/dhowler/rq.citadelofthewolf.com/blocks/featauth/admin.php on line 23
I saw a couple of other things on this block, but nothing seemed to cover this particular error. Any help would be appreciated.
Thanks!
Current Version: 3.4.2
PHP 4
Mods: Challenges, Recommendations, Storyend, Display Word, Beta Reader, Bad Reviewer
A SQL query on line 8 of the file featauth.php is expected to return some records and it doesn't.
I can't really help you without seeing the query. Where is the featauth block from? - it isn't in the efiction33 distribution.
I think the Featured Author block comes from Tammy's site. you have to be logged in to see the downloads.
http://efiction.hugosnebula.com/downloads.php
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word
The block hasn't been updated for 3.3. It still uses the old global variables like $tableprefix from version 3.2 rather than the replacement constants.
I think you can fix it by replacing all instances of $tableprefix with TABLEPREFIX in all files in the featauth folder.
Thanks! That worked great!
*HUGS*
Dreamy
Current Version: 3.4.2
PHP 4
Mods: Challenges, Recommendations, Storyend, Display Word, Beta Reader, Bad Reviewer
I don't know what happened, but I looked at the site today, and this block had taken over EVERY skin on the site. As soon as I disabled it, the skins went back to normal. I had to disable it again. Any idea what happened?
Current Version: 3.4.2
PHP 4
Mods: Challenges, Recommendations, Storyend, Display Word, Beta Reader, Bad Reviewer
I was getting mostly the same error with my installation-- I think I mentioned this before, but afaik, Tammy has yet to update the block to 3.3.
Here's my error-- I'm running 3.3.1 with PHP5:
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
Lines 7 & 8:
$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))
So I'm using the latest constants (I *think*) but it's still not working. When I enable the block, the title appears in the proper space, but the error appears in the header. Nothing appears in the actual featured author BOX, though I'm guessing it's because it can't pull the data, hence the error. I am worried about it "taking over my skins," though.
I'm going to disable it again, but I just wanted to voice my two cents that this was a great block that really should be updated for 3.3.1!
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
