Notifications
Clear all

[SOLVED] Fatal mySQL error after block initialisations

6 Posts
3 Users
0 Reactions
2,521 Views
(@guest1448)
Posts: 0
 

Hello,

here I am again with a new error. After I initialiced some of the blocks via the admin interface, I'mm geting this when opening the site:

A fatal MySQL error was encountered.
Query: SELECT shouts.*, author.penname as penname FROM fanfiction_shoutbox as shouts LEFT JOIN fanfiction_authors as author ON author.uid =
shouts.shout_name ORDER BY shout_datestamp DESC
Error: (1054) Unknown column 'shouts.shout_name' in 'on clause'

Thanks
Steffen


 
Posted : 12/12/2006 3:07 pm
(@tammy)
Posts: 2577
Member Moderator
 

Go read the instructions for posting a support request.


 
Posted : 12/12/2006 3:38 pm
(@tammy)
Posts: 2577
Member Moderator
 

Bump.  If the original poster doesn't reply with further information (as requested in the instructions for posting help requests) in a week this is going to be closed.


 
Posted : 29/12/2006 8:32 pm
(@guest1448)
Posts: 0
 

Oh sorry, I forgot this topic :-). The error has been fixed, it wasn't a bug.


 
Posted : 30/12/2006 5:47 am
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

What was wrong with it, and how did you fix it? πŸ™‚


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 : 30/12/2006 5:51 am
(@guest1448)
Posts: 0
 

Hmm, something was wrong with the shoutbox table. I looked at my database and there was an old 1.5 alpha table installed - don't know why :-). I dropped the table and inserted it manually, now everything is OK.


 
Posted : 30/12/2006 6:02 am
Share: