Quote from: Sir Osis of Liver on December 06, 2023, 08:59:13 PMThat may be the wrong table, I'd expect to see karma in members. Run this query to find the column -
SELECT table_name,table_schema
FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_name='karma_bad'
Don't see a karma mod for 2.1, and 2.0 karma feature was removed from 2.1, so you shouldn't need either karma column. You can click on "Structure" for the table where you find it, and drop the columns.
Just checking 2.0, karma_good and karma_bad are in members table.
SELECT table_name,table_schema
FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_name='karma_bad'
Quote from: Sir Osis of Liver on December 06, 2023, 08:26:24 PMIn phpmyadmin, click on your forum database in left panel. If you don't know your database name, look for $db_name in Settings.php. When database tables are displayed in right panel, click on "SQL" in top menu, copy Kindred's query into the text box and click "Go" bottom left. Backup the database before attempting this.
Quote from: Arantor on May 04, 2023, 04:40:24 PMSince id_draft is autoincrement, why not just insert without even that (no need to truncate the current table if you're not porting draft ids over and you don't need to)
Quote from: Kindred on December 06, 2023, 10:53:03 AMmost mods do not uninstall the database updates -- because the method to UDPATE most mods is to uninstall the old version and reinstall the new version.
The **CODE** has nothing to do with this issue. Your issue is that a database column exists and has not had a default defined. The default is required by modern versions of mySQL.ALTER TABLE `smf_messages` ALTER `karma_bad` SET DEFAULT NULL;
or...Quote from: Shambles on May 12, 2013, 02:04:39 PMThat mod doesn't seem to make any edits in Subs-post.php, tho it does add two columns to the DB.
If this were me, I'd delete those two DB columns 'karma_bad' and 'karma_good' from {db_prefix)messages.