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
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
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.
Thank You!
I emptied the table and the box is now working. 🙂
Dawn
