Author Topic: error in forums when trying to Modify a post  (Read 3544 times)

0 Members and 1 Guest are viewing this topic.

Offline madscijr

  • Seasoned Forum Regular
  • Posts: 295
    • View Profile
error in forums when trying to Modify a post
« on: December 29, 2021, 11:40:45 am »
If I try to modify a post on the forums, when I click save, I get
Code: [Select]
Database Error
Please try again. If you come back to this error screen, report the error to an administrator.
Back
The message doesn't include a link or instructions for how to report the error to an administrator,
and I tried looking around to find such a link or instructions, but no luck,
so I am just posting here that I'm getting the error
(it happens both from my desktop PC and smartphone).
Hope this helps?

Offline odin

  • Administrator
  • Newbie
  • Posts: 92
  • I am.
    • View Profile
Re: error in forums when trying to Modify a post
« Reply #1 on: January 28, 2022, 03:13:53 am »
Turns out the table that holds the edit histories had a smaller field for the message body than the main "live" table did, so you couldn't edit big messages. This should be fixed now.

Offline madscijr

  • Seasoned Forum Regular
  • Posts: 295
    • View Profile
Re: error in forums when trying to Modify a post
« Reply #2 on: January 28, 2022, 03:30:28 pm »
Turns out the table that holds the edit histories had a smaller field for the message body than the main "live" table did, so you couldn't edit big messages. This should be fixed now.

Awesome - thanks for looking into this!

Would that also have affected how big a message you can post?

Offline luke

  • Administrator
  • Seasoned Forum Regular
  • Posts: 324
    • View Profile
Re: error in forums when trying to Modify a post
« Reply #3 on: January 28, 2022, 09:24:45 pm »
No, it wouldn't have effected the size of new posts. Posts are only written to the history table when you make an edit. For a fresh post, it only exists in the live table which was already set to the larger limit.

You'll note that forum itself counts your characters. The database should be able to handle any post within that limit.

Offline madscijr

  • Seasoned Forum Regular
  • Posts: 295
    • View Profile
Re: error in forums when trying to Modify a post
« Reply #4 on: January 29, 2022, 12:32:55 am »
You'll note that forum itself counts your characters. The database should be able to handle any post within that limit.

Thanks. I'll keep an eye on the character count and see where it's at if I have a problem posting again.