I help run a SMF forum for a hunting group, using smf 2.0.15

There is a problem with registration, when anyone tries to reg they get this error
Database Error
Please try again. If you come back to this error screen, report the error to an administrator.
this is the entry in the log
http://xxxxxx.com/forums/index.php?action=register2
Database Error: Field 'buddyList' doesn't have a default value
File: /home/xxxxxx/public_html/forums/Sources/Subs-Members.php
Line: 775
This is another error in the log, not sure if its related

Database Error: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxxxx_mno0725607345.a.attachment_type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

File: /home/xxxxxx/public_html/forums/Sources/Likes.php
Line: 38
They also run TP "TinyPortal 1.6.3 "

I think they are different errors to be honest. For the first one, if you go into your database and find buddyList and give it a value of null, that should take care of the error I would think. I'm not to sure about the second one though.

Quote from: Bigguy on Jul 04, 2019, 12:23 PMgo into your database and find buddyList and give it a value of null

it had "1" in there, so I tried '0' and cleared ' ' the box didnt work

What version of PHP is the server running?

Quote from: lurkalot on Jul 04, 2019, 01:15 PMWhat version of PHP is the server running?

PHP 7.0 (ea-php70)

Les. Setting a default value should cure the first error.

Re the second one, do you have the "Thumbnail on Topic Listing" mod installed?

this is what they are in the db, if that helps?

Les, sorry I was confusing your second error with something else I had seen lately.  I'm only guessing now, possibly related to that Likes Pro Mod you have installed there. 

I uninstalled the likes mod for a test, and the error is still there

Quote from: lesmond on Jul 04, 2019, 02:30 PMthis is what they are in the db, if that helps?

Is there one just called buddyList. This one is enable_buddyList. Just wondered if there was a different one there.

You need to set the DEFAULT value for the table field 'buddyList' to NULL.
You do that in the table structure definition...

Quote from: @rjen on Jul 05, 2019, 07:20 AMYou need to set the DEFAULT value for the table field 'buddyList' to NULL.
You do that in the table structure definition...

Sorry I am not sure how to do that

Quote from: lesmond on Jul 04, 2019, 02:30 PMthis is what they are in the db, if that helps?

You cannot view this attachment.

Changing it can be done in phpMyAdmid under 'structure' tab on the smf_members table, but tbh that will most likely not do you much good...

It looks like the server is on an SQL version in 'STRICT' mode. So changing this one filed will probably just get you to the next error.
The second error is also caused by the STRICT SQL mode...

What MySQL version is the forum on...?

MySQL Version   5.7.26

There is no  buddy_list under smf_members table, only under smf_settings