Shoutbox Error
 
Notifications
Clear all

Shoutbox Error

4 Posts
3 Users
0 Reactions
1,441 Views
(@kittsbud)
Posts: 9
Active Member
Topic starter
 

Hi

My site shoutbox is suddenly giving this error when anyone tries to post

A fatal MySQL error was encountered.
Query: INSERT INTO fanfiction_shoutbox(`shout_name`, `shout_message`, `shout_datestamp`) VALUES('1', 'test', '1200425007')
Error: (1062) Duplicate entry '65535' for key 1

A link  to the page is here: http://supernaturalville.net/index.php

The shotbox is on the right hand side.

Thanks


 
Posted : 15/01/2008 3:39 pm
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

Check with phpmyadmin to make sure that you didn't install it twice or something. You should have one table called fanfiction_shoutbox, and it should have four fields. It you have a duplicate shoutbox table, delete it. If not, try emptying it (NOT DROPPING it).

If that doesn't work (or if you don't know how to do it), redownload the files and try reuploading them. Uninstall and reinstall the shoutbox.


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 : 15/01/2008 6:58 pm
(@tammy)
Posts: 2577
Member Moderator
 

I think Jan's got the right idea in emptying the table.  It looks like you've reached the limit of messages.  You could also use the admin page and purge some of the messages.


 
Posted : 16/01/2008 11:28 am
(@kittsbud)
Posts: 9
Active Member
Topic starter
 

Thank You!

I emptied the table and the box is now working. πŸ™‚

Dawn


 
Posted : 16/01/2008 4:28 pm
Share: