[SOLVED] Fatal SQL ...
 
Notifications
Clear all

[SOLVED] Fatal SQL error and warnings when viewing the site after the upgrade

6 Posts
3 Users
0 Reactions
3,047 Views
(@gokugirl)
Posts: 60
Trusted Member
Topic starter
 

URL to your eFiction: http://www.gokugirl.com/test2
Version of eFiction: 3.0
Have you bridged eFiction, if so with what?: no
Version of PHP: 4.4.1
Version of MySQL: 12.22 Distrib 4.0.16
Have you searched for your problem: n/a
If so, what terms did you try: n/a
Have you looked at the FAQs: n/a
State the nature of your problem: I'm not sure if this is the right place to post this, but since it happened right after the upgrade (and nothing is showing on the site but this)...

Warning: Division by zero in /home/gokugirl/public_html/test2/blocks/categories/categories.php on line 29

Warning: main(timefunctions.php): failed to open stream: No such file or directory in /home/gokugirl/public_html/test2/blocks/news/news.php on line 5

Warning: main(timefunctions.php): failed to open stream: No such file or directory in /home/gokugirl/public_html/test2/blocks/news/news.php on line 5

Warning: main(): Failed opening 'timefunctions.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/gokugirl/public_html/test2/blocks/news/news.php on line 5
A fatal MySQL error was encountered.
Query: SELECT n.*, DATE_FORMAT(n.time, ' - %h:%i%p') as date, count(c.cid) as comments FROM test2fanfiction_news as n LEFT JOIN test2fanfiction_comments as c ON n.nid = c.nid GROUP BY n.nid ORDER BY n.time DESC LIMIT
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

- My eFiction Skins: http://www.gokugirl.com/efiction.php
- The Otaku Institute: http://oi.gokugirl.com
- The OI Same-Sex Archive: http://oisa.gokugirl.com
- The Dragon Ball Fanfiction Library: http://dbfl.gokugirl.com

 
Posted : 10/12/2006 2:20 pm
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

Something went wrong. Are you sure that all your folders and such are uploaded? Especially the folders and files in the blocks.


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

 
Posted : 10/12/2006 2:33 pm
(@tammy)
Posts: 2577
Member Moderator
 

I don't think you loaded the blocks folder either.  That seems to be the 2.0 category block throwing that error.


 
Posted : 10/12/2006 3:45 pm
(@gokugirl)
Posts: 60
Trusted Member
Topic starter
 

I re-uploaded many of the folders, the block one included, since I'd forgotten the install folder before.

Edit: I re-uploaded the blocks folder again just to be sure and I still receive these errors.


- My eFiction Skins: http://www.gokugirl.com/efiction.php
- The Otaku Institute: http://oi.gokugirl.com
- The OI Same-Sex Archive: http://oisa.gokugirl.com
- The Dragon Ball Fanfiction Library: http://dbfl.gokugirl.com

 
Posted : 11/12/2006 2:23 pm
(@tammy)
Posts: 2577
Member Moderator
 

Well I'd delete the blocks folder then re-upload it.  That's definitely the 2.0 news block.  The timefunctions.php file has been totally removed from 3.0.


 
Posted : 11/12/2006 3:18 pm
(@gokugirl)
Posts: 60
Trusted Member
Topic starter
 

That fixed it. Thank you.


- My eFiction Skins: http://www.gokugirl.com/efiction.php
- The Otaku Institute: http://oi.gokugirl.com
- The OI Same-Sex Archive: http://oisa.gokugirl.com
- The Dragon Ball Fanfiction Library: http://dbfl.gokugirl.com

 
Posted : 12/12/2006 3:42 pm
Share: