URL to your eFiction: www.semperance.com/fanfiction
Version of eFiction:3.3 (new installation)
Have you bridged eFiction, if so with what?: I don't know
Version of PHP:5 can be found out from your host
Version of MySQL: MySQL 4.1.11
Have you searched for your problem:yes,
If so, what terms did you try: I have read threads in the installation help and the FAQ along with many of the read me-notepads
State the nature of your problem: receiving this error. not sure what I did wrong and no clue how to fix it.
Warning: Invalid argument supplied for foreach() in /home/www/semperance.com/fanfiction/header.php on line 86
A fatal MySQL error was encountered.
Query: SELECT n.*, UNIX_TIMESTAMP(n.time) as date, count(c.cid) as comments FROM fanfiction_news as n LEFT JOIN fanfiction_comments as c ON n.nid = c.nid GROUP BY n.nid ORDER BY time DESC LIMIT 0,
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Do you have a test account for us? have not gotten that far.
Make sure that all your files got uploaded right. (that means reupload them all. Sometimes an upload gets corrupted.)
Make sure that debugging is turned off in the settings of the admin panel.
What skin are you using as default?
Looking at this:
http://www.semperance.com/fanfiction/?skin=CSSZen
it looks like you are missing a site name.
Make sure that your categories block is on, and that all the items for the archive exist. Missing things could be making the error show up.
Your site should look more like this with that particular skin:
http://www.potionsandsnitches.net/fanfiction/index.php?skin=CSSZen
Also, change your site slogan from {Devoted to Each Other} to Devoted to Each Other. The {} could be contributing to the error.
Make sure your site info stats work by editing the SITEKEY as explained here: https://efiction.org/forums/index.php?topic=5375.msg29506#msg29506
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
Are you still having problems with this? Or has everything been resolved?
