Jul 15, 2019, 08:03 PM

News:

How many easter eggs have you found....


registration error - smf 2.0.15

Started by lesmond, Jul 04, 2019, 11:05 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

lesmond

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 "

The only person who got all his work done by Friday was Robinson Crusoe

Bigguy

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.

lesmond

Quote from: Bigguy on Jul 04, 2019, 01: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 :(

The only person who got all his work done by Friday was Robinson Crusoe

lurkalot

What version of PHP is the server running?

lesmond


The only person who got all his work done by Friday was Robinson Crusoe

lurkalot

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

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

lesmond

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



The only person who got all his work done by Friday was Robinson Crusoe

lesmond


The only person who got all his work done by Friday was Robinson Crusoe

lurkalot

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. 

lesmond

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

The only person who got all his work done by Friday was Robinson Crusoe

Bigguy

Quote from: lesmond on Jul 04, 2019, 03: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.

@rjen

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

lesmond

Quote from: @rjen on Jul 05, 2019, 08: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 :(

The only person who got all his work done by Friday was Robinson Crusoe

@rjen

Jul 05, 2019, 09:52 AM #13 Last Edit: Jul 05, 2019, 09:54 AM by @rjen
Quote from: lesmond on Jul 04, 2019, 03:30 PMthis is what they are in the db, if that helps?



You cannot see attachments on this board.

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...?

lesmond

MySQL Version   5.7.26

There is no  buddy_list under smf_members table, only under smf_settings

The only person who got all his work done by Friday was Robinson Crusoe