Finally figured it out, I noticed there are quite a number of postings regarding siteinfo
Findings so far
1. fanfiction_stats table is empty. Table is created properly but does not contain any data. If you insert single line (with phpmyadmin or similar) without other info than sitekey, and recalculate stats it works -> install should insert that dummy line.
2. block template for siteinfo, is it really working out of the box? I think not, I had to add {members} etc to every line for siteinfo actually displaying something - and still, newestmember and wordcount does not work.
Hmm.. time for quick patch any1? This needs some kind of permanent fix in next release, I'd say.
Comments?
Motor-Ed
Motor-Ed, are you using 3.2, or the newly released 3.3 when installing the fiction_stats? There should not be any bug reports on this already for 3.3. It was just released today.
To report a bug on the database for 3.3, you have to reinstall the tables.
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
Latest 3.3, since I had to start completely over with empty database - and yes, it's still issue in 3.3.
Motor-Ed
You've got something wrong in your install then because the install script should have added the row with the sitekey automatically.
Hi,
same problem here. The table row doesn't contain the sitekey, onley the word "SITEKEY". Don't know if this apears on a running site since I haven't updated my site, but at a blank installation on my localhost the block isn't working.
The thing is, where to look what is wrong since this happened when I downloaded the package directly from this website, and created empty mysql database using mysqladmin - well, I'll dig into this and if something more detailed comes up, I'll post follow-up.
Motor-Ed
OK, I found a quick way to fix this for new installations. Open install.php and go to line 746 or search for:
dbquery("INSERT INTO ".$tableprefix."fanfiction_stats(`sitekey`, `newestmember`) VALUES('".SITEKEY."', '1')");
Change to:
dbquery("INSERT INTO ".$tableprefix."fanfiction_stats(`sitekey`, `newestmember`) VALUES('".$sitekey."', '1')");
This should insert the sitekey correctly into the stats table.
Tested, works on here too 🙂
Motor-Ed
https://efiction.org/forums/index.php?topic=5247.msg28370
According to this, the change to SITEKEY from $sitekey was intentional as a security update, but it seems not all the variables are equal therefor it messes up. Have we tried changing all instances of $sitekey to SITEKEY across the code yet? I believe thats even a suggestion in that post. I'm holding off on updating untiil things settle down ^^ thanks so much for it btw.
I am rebuilding efiction! Join us on irc! #efiction at
Just updating- I have a new install with the site info problem if you want to mess with it Tammy.
http://genficrecs.freehostia.com/
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
To just fix the stat info and make it update, all you have to do is copy the site key info from the database table fanfiction_settings and paste it into the database table fanfiction_stats for the sitekey. It will otherwise say SITEKEY.
I did this for someone's archive who installed it a couple of days ago. It works.
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
I think this is fixed for 3.3.1. Can someone check?
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
This is fixed for new installs. Thank you so much Tammy!
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
