SMF 2.1.4 has been released! Take it for a spin! Read more.
Started by Sudhakar Arjunan, March 03, 2023, 05:19:35 PM
Quote from: Illori on March 16, 2015, 05:24:04 AMdid you use repair_settings.php or fix_packages.php to remove hooks? if you have not uninstall all your mods and use one of those files to remove the hooks and try again.
Quote from: Steve on March 04, 2023, 08:31:43 AMI've split this off. Please don't respond to 8-year-old solved topics, even if your problem is similar to the original topic's.
Quote from: Oldiesmann on March 05, 2023, 09:08:42 PMThere are two solutions to this:1. Modify whatever query is causing that error and make it actually insert data into those columns (even if it's an empty string or a 0)2. Modify the database structure and give those columns default values. Even if it's a TEXT column, it can have a default value as long as you're not running an ancient version of MySQL or MariaDB (MySQL has supported it since 8.0.13, which was released in October of 2018, and MariaDB since 10.2.1, which was released in July of 2016)
Quote from: Sudhakar Arjunan on March 15, 2023, 04:48:04 PMbut I don't not able to fix. Any assistance to fix please.
Quote from: Sudhakar Arjunan on March 03, 2023, 05:19:35 PMDatabase Error: Field 'description' doesn't have a default valueINSERT INTO smf_messages
Quote from: Sudhakar Arjunan on March 03, 2023, 05:19:35 PMDatabase Error: Field 'lastView' doesn't have a default valueREPLACE INTO sms_log_topics
Quote from: Doug Heffernan on March 15, 2023, 05:27:54 PMRegarding your errors, both fields mentioned there are not part of default smf. They must have been added by custom mods. Do you still use those mods? If you do, follow the advice given above. However, if you don't use those mods anymore, you can drop those custom fields from the database. No need to clutter the database with unused stuff left over from unused mods imo.
Quote from: Sudhakar Arjunan on March 23, 2023, 04:36:38 AMnoted, will check for commands online to drop those fields.
Quote from: Sudhakar Arjunan on April 02, 2023, 12:57:47 AMAlter table work, issue resolved. Could able to post / reply now. Thank you Dougeffernan.