Oct 30, 2020, 10:38 AM

News:

Have you backed up YOUR database today


registration error - smf 2.0.15

Started by lesmond, Jul 04, 2019, 03:05 PM

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, 05: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, 07: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, 12:20 PMYou 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, 01:52 PM #13 Last Edit: Jul 05, 2019, 01:54 PM by @rjen
Quote from: lesmond on Jul 04, 2019, 07: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

@rjen

There you go: STRICT mode is set default to ON in MySQL 5.7...

reference... https://www.percona.com/blog/2016/10/18/upgrading-to-mysql-5-7-beware-of-the-new-strict-mode/

You will have to ask the host to deactivate strict mode for you site...

lesmond

its not my site nore my host, but I have sent in a ticket to his hosting.

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


lesmond

Well they got there answer...not sure what to do now :(

QuoteHello,

Unfortunately this option is disabled for all accounts on shared/business hosting. Please consider upgrading to a VPS or a dedicated server.

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

@rjen

Upgrade to 2.1 quickly or find another host: they have upgraded their sql version causing the issues...

lesmond

Quote from: @rjen on Jul 05, 2019, 10:40 PMUpgrade to 2.1 quickly or find another host: they have upgraded their sql version causing the issues...
I don't think they will upgrade, they have almost 6000 members, and he just paid a year on his hosting.

I also tried to register a member manually, still get the same error!!

QuoteField 'buddyList' doesn't have a default value
File: /home/xxxxxx/public_html/forums/Sources/Subs-Members.php
Line: 775

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

@rjen

If they don't want to upgrade (understandably atm since 2.1 is still RC) then the options are very limited: go for the dedicated hosting plan or move hosts...

... and then turn off STRICT mode...

Seriously, SMF 2.0.x is not equiped to deal with the STRICT sql mode. You can still set that field default to NULL and hope that that next problem is not stopping people from registering, but it's not a long term fix...


lesmond

I made a copy on my hosting, and all works fine, so yes it his hosting thats the problem. problem is he just paid for a new year on his hosting plan!

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

@rjen

Quote from: lesmond on Jul 05, 2019, 08:19 PMHello,

Unfortunately this option is disabled for all accounts on shared/business hosting. Please consider upgrading to a VPS or a dedicated server.

too bad he did not check with his host before ...

Oldiesmann

Quote from: lesmond on Jul 06, 2019, 09:22 AMI don't think they will upgrade, they have almost 6000 members, and he just paid a year on his hosting.

I also tried to register a member manually, still get the same error!!


You need to find out what table the "buddyList" column is in, then set it to allow NULL values. The problem here is that you're not inserting any data into that column at that point but you told the database not to allow NULL values, so MySQL has no idea what to do with that field.

As far as the other error goes, if your host won't let you set custom SQL modes then your only option is to either have someone properly rewrite that query or keep adding columns to the "GROUP BY" clause until MySQL shuts up about it.
Cincy Space - now open! https://www.cincyspace.net