Unable to split topic - database error

[jack001]

Hello,

First of all thanks for this lovely beta release of smf 2.1. Love it!
I am facing an error as below:

Code Select Expand

Field 'add_authors' doesn't have a default value
File: /*..*/Sources/SplitTopics.php
Line: 646

Any idea on how to solve this.

Thanks,

[br360]

What mods do you have installed?

[jack001]

none. i just updated from 2.0.15 to 2.1.4.
Also i see many errors in my error log in admin.

[Arantor]

ask in the thread for the Addtitional Authors mod where it puts things in the database, once we know that I can write you the SQL to fix it.

[jack001]

the same error encountered while posting
Field 'add_authors' doesn't have a default value
File: /home/*.*/public_html/Sources/Subs-Post.php
Line: 1780

[jack001]

ask in the thread for the Addtitional Authors mod where it puts things in the database, once we know that I can write you the SQL to fix it.

ok

[Shambles]

What mods do you have installed?

none.

[Arantor]

The reason is, that mod added a database column, and didn't do it properly. But I'm on an iPad so I can't sit and look at the installer to see where it makes the column that now needs fixing or removing.

The upgrade doesn't clean house in case the mods are going to be updated/reinstalled.

[jack001]

is there a way to reset everything without loosing posts and members?

[Arantor]

Not really, and you don't need to reset it, just fix that one thing...

[jack001]

not sure when the author is going to reply. :/

[Kindred]

Please do note that there is a real reason that we tell people not to use the BETA on a production site....

[jack001]

Please do note that there is a real reason that we tell people not to use the BETA on a production site....

yes understood. learned from experience
but the work you people are doing is really great! 2.1 is awesome

[Arantor]

@Kindred, this would have happened irrespective of the upgrade if the mod had been uninstalled. It's a problem with the mod.

[jack001]

@Kindred, this would have happened irrespective of the upgrade if the mod had been uninstalled. It's a problem with the mod.

wish i knew before upgrading...

[Arantor]

Code Select Expand

ALTER TABLE smf_topics CHANGE add_authors add_authors NULL;

[jack001]

Code Select Expand

ALTER TABLE smf_topics CHANGE add_authors add_authors NULL;

i am sorry. i don't get it. can you tell me what should i do? i am not good with all this. where should i change this.

[Illori]

in phpmyadmin or similar to manage your database.

[jack001]

kudo it worked!!!!