MySQL Error 137 when adding htmlstate field to post table

[SBoards]

I can't seem to upgrade from 4.0.2 to 4.0.3, reason being that the upgrade script chokes out on adding that field to the post table. I can't even do it in myphpadmin using what looks to me like proper syntax. It keeps coming back with that error 137.

I've seen that others have had this issue, but I can't find a fix for it anywhere online.

Please help?

[Lynne]

What syntax are you using? If it's just one field, I usually just add it to the table instead of running a query to add it. Is that what you are doing?

[borbole]

It is the exact same error as this other guy here:

https://vborg.vbsupport.ru/showthread.php?t=242382

Upgrading shouldn''t remove columns from the db. I have seen such occurances a lot lately here and at vb.com. Maybe you should start a ticket at the member area so the vb staff can look into this if it is some bug.

[SBoards]

What syntax are you using? If it's just one field, I usually just add it to the table instead of running a query to add it. Is that what you are doing?I tried that as well. For some reason my post table just doesn't want to comply.

It is the exact same error as this other guy here:

https://vborg.vbsupport.ru/showthread.php?t=242382

Upgrading shouldn''t remove columns from the db. I have seen such occurances a lot lately here and at vb.com. Maybe you should start a ticket at the member area so the vb staff can look into this if it is some bug.
That's what I was afraid of. My backups aren't even restoring properly. I might have a major problem on my hands here. I can't see any posts in my forums. I know they're there somewhere, since I can still see them in the database. I'm just hoping I can fix this without losing all of our data. We've been up for almost 4 years, with over 100,000 threads.

I did see one person who claims to have fixed this issue, but I'm afraid I made it worse by trying to restore unsuccessfully.

[borbole]

I tried that as well. For some reason my post table just doesn't want to comply.


That's what I was afraid of. My backups aren't even restoring properly. I might have a major problem on my hands here. I can't see any posts in my forums. I know they're there somewhere, since I can still see them in the database. I'm just hoping I can fix this without losing all of our data. We've been up for almost 4 years, with over 100,000 threads.

I did see one person who claims to have fixed this issue, but I'm afraid I made it worse by trying to restore unsuccessfully.


It is very much fixable. That is not the problem. What I find odd is that it occurs in the first place.