News:

Wondering if this will always be free?  See why free is better.

Main Menu

Database Error

Started by info33, March 03, 2022, 10:31:06 AM

Previous topic - Next topic

info33

After upgrade SMF 2.0.19 to SMF 2.1.1 i have this problem when  take post,please help.

Database Error
Field 'ua_os' doesn't have a default value
File: /home/pkdi4tgwdqko/public_html/Sources/Subs-Post.php
Line: 1896
My SMF forum:
https://www.romaniafotovoltaice.com [nofollow]

Doug Heffernan

Quote from: info33 on March 03, 2022, 10:31:06 AMAfter upgrade SMF 2.0.19 to SMF 2.1.1 i have this problem when  take post,please help.

Database Error
Field 'ua_os' doesn't have a default value
File: /home/pkdi4tgwdqko/public_html/Sources/Subs-Post.php
Line: 1896


That is not a default smf field a.f.a.i.k. It must have come from a custom mod. You can either change it to allow a default value, or drop it altogether if you do not use the mod that adds it.


Arantor

Do you still use a mod for identifying the user agent and operating system used to make a post?

That's the mod that produces the ua_os column - and if you're not using it, you can safely delete it. But if you plan on using that mod in future the correct solution is to change the column in phpMyAdmin (go to smf_messages, to Structure, edit the ua_os column, untick "NOT NULL" and save)

info33

Quote from: Arantor on March 03, 2022, 10:39:16 AMDo you still use a mod for identifying the user agent and operating system used to make a post?

That's the mod that produces the ua_os column - and if you're not using it, you can safely delete it. But if you plan on using that mod in future the correct solution is to change the column in phpMyAdmin (go to smf_messages, to Structure, edit the ua_os column, untick "NOT NULL" and save)

Thank you sow mutch,i delete all  the ua_os column from phpMyAdmin,and now working great,thank you again!
My SMF forum:
https://www.romaniafotovoltaice.com [nofollow]

Advertisement: