Upgrade smf forum

[Kindred]

Well, you need to talk to your host -- because all of the failures so far seem to be related to the host throttling your account's usage of the server....    that's why I asked about GoDaddy.

Who is your host?

[Snow-Man]

Well, you need to talk to your host -- because all of the failures so far seem to be related to the host throttling your account's usage of the server....    that's why I asked about GoDaddy.

Who is your host?

its not GoDaddy
i have tried to upgrade via CLI, everytimes it says network error: Connection refused

[Kindred]

Talk to your host

[Snow-Man]

I have made a lot of tables empty such as logs table and i ran the upgrader and finally it ended successfully. That happened by changing tables engine to InnoDB.
but now I have got another problem, adding packages (forum stop working) or making a post ( I get this error)

Field 'show_sig' doesn't have a default value
File: /home/Sources/Subs-Post.php
Line: 1897

Database Error: Field 'show_sig' doesn't have a default value


INSERT INTO smf_messages(`id_board`, `id_topic`, `id_member`, `subject`, `body`, `poster_name`, `poster_email`, `poster_time`, `poster_ip`, `smileys_enabled`, `modified_name`, `icon`, `approved`)
VALUES
(31, 13727, 44243, SUBSTRING('Re: About me', 1, 255), SUBSTRING('test', 1, 65534), SUBSTRING('Snow-Man', 1, 255), SUBSTRING('[email protected]', 1, 255), 1699729195, unhex('9a6c49f8'), 1, '', SUBSTRING('xx', 1, 16), 1)

[Kindred]

So give it a default value....

Do a search,  it's a common problem with upgrades to mysql and older mods

[Snow-Man]

Does it work with NULL as a default value?
Have done some research about it and didn't find anyone got same problem like mine

[Kindred]

It's been reported at least 10 dozen times in smf (mods) and other software as well...

And yes, NULL is usually the correct setting.

[Doug Heffernan]

Database Error: Field 'show_sig' doesn't have a default value


INSERT INTO smf_messages(`id_board`, `id_topic`, `id_member`, `subject`, `body`, `poster_name`, `poster_email`, `poster_time`, `poster_ip`, `smileys_enabled`, `modified_name`, `icon`, `approved`)
VALUES
(31, 13727, 44243, SUBSTRING('Re: About me', 1, 255), SUBSTRING('test', 1, 65534), SUBSTRING('Snow-Man', 1, 255), SUBSTRING('[email protected]', 1, 255), 1699729195, unhex('9a6c49f8'), 1, '', SUBSTRING('xx', 1, 16), 1)

The aforementioned filed is not part of the smf_messages table by default. Which means that it has been added by a third party mod. If you are still using the mod that has added that field, giving it a default value of null as advised above will solve the error.

However, if you don't use that mod anymore, it will be best imo to delete that custom field from the messages table. No use of cluttering the database with stuff left behind by old/uninstalled mods.

[Snow-Man]

It's been reported at least 10 dozen times in smf (mods) and other software as well...

And yes, NULL is usually the correct setting.

is there a way to change that through a php script or something?
cause i can not do it on phpmyadmin, when i do that it will freeze and will not change, cause that table got more that 2 million rows

[Snow-Man]

It's been reported at least 10 dozen times in smf (mods) and other software as well...

And yes, NULL is usually the correct setting.

is there a way to change that through a php script or something?
cause i can not do it on phpmyadmin, when i do that it will freeze and will not change, cause that table got more that 2 million rows

i have done that after several of tries but now i have got a lot of general errors.

like the following errors

2: Undefined array key "mediapro_copyremove"

2: Undefined array key "mediapro_copyremove"

Undefined array key "mediapro_admin"

Hook call: function "mentions_menu" in file /home/root/public_html/forum could not be called.

Hook call: function "mentions_bbc" in file /home/root/public_html/forum could not be called.

i have got like 5k errors about these

[Doug Heffernan]

It's been reported at least 10 dozen times in smf (mods) and other software as well...

And yes, NULL is usually the correct setting.

is there a way to change that through a php script or something?
cause i can not do it on phpmyadmin, when i do that it will freeze and will not change, cause that table got more that 2 million rows

i have done that after several of tries but now i have got a lot of general errors.

like the following errors

2: Undefined array key "mediapro_copyremove"

2: Undefined array key "mediapro_copyremove"

Undefined array key "mediapro_admin"

Hook call: function "mentions_menu" in file /home/root/public_html/forum could not be called.

Hook call: function "mentions_bbc" in file /home/root/public_html/forum could not be called.

i have got like 5k errors about these

They come from custom mods. If I were you I would uninstall all the mods, overwrite the forum files with a fresh set from the large upgrade package your version. The re-install the mods that you want to use.

[Snow-Man]

Thank you for your reply 🙏🏼
I have tried to re-install mods again but it breaks the forum, then i can no longer get access to the forum, it shows me the same error as low php version error and before installing it during the test it shows errors

[Kindred]

Uninstalling mods does not remove the tables...


In phpmyadmin run

Code Select Expand

ALTER TABLE smf_messages ALTER show_sig SET DEFAULT NULL;


[Snow-Man]

Uninstalling mods does not remove the tables...


In phpmyadmin run

Code Select Expand

ALTER TABLE smf_messages ALTER show_sig SET DEFAULT NULL;


I have dropped that column already but still have errors like I mentioned in my last post

[Doug Heffernan]

I have tried to re-install mods again but it breaks the forum, then i can no longer get access to the forum, it shows me the same error as low php version error and before installing it during the test it shows errors

It looks like the mods have left behind code that wasn't removed upon uninstallation. You should remove them manually.

[Snow-Man]

I have tried to re-install mods again but it breaks the forum, then i can no longer get access to the forum, it shows me the same error as low php version error and before installing it during the test it shows errors

It looks like the mods have left behind code that wasn't removed upon uninstallation. You should remove them manually.

Could you tell me how to do that?
Is it by removing mods on packages folder?

[Doug Heffernan]

Could you tell me how to do that?
Is it by removing mods on packages folder?

After you have uninstalled all the mods from the Package Manager, run the repair_settings.php tool to remove all hooks. Then overwrite your forum files with a fresh set from the large upgrade package your version. That would ensure that all the code that might have been left behind by mods that had file edits will be remoed too. Note that if you have made manual edits to the forum files, it would be best to make a backup of those files beforehand. Hope it helps.