News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Problem registration New Member

Started by Panoulis64, November 21, 2021, 11:28:51 AM

Previous topic - Next topic

Panoulis64

Good evening, I read some topics, but I did not find one similar to mine.

The problem is the registration of a new member.
You do not become at all. When he completes it, he presses acceptance and gets a database error
I looked at the logs and found this error many times.
Visitor
Filter application: Display error messages for this IP address only   
  Reverse chronological order of the list Today at 05:09:20 PM
Apply filter: Show error messages for this session only cdf76ec73ff58c25779781bc3c9a2680
Apply filter: Show errors of this type only Error type: Database
Apply filter: Show error messages of this URL onlyhttps://triglianoi.gr/index.php?action=register2Apply filter: Show only errors with the same messageDatabase error: Field 'post_color' does not have a default valueApply filter: Show only errors from this fileFile: /home/triglian/public_html/Sources/Subs-Members.php
Line: 771

Line 771 is this    array('id_member')

I also looked at the file of critical errors, he says:
Guest 94.66.134.42
Filter application: Display error messages for this IP address only   
  Reverse chronological order of the list November 19, 2021, 11:19:49 AM
Apply filter: Show error messages for this session only 9c7a1ff663be281466495ca2e1b3f8bd
Apply filter: Show errors of this type only Error Type: Critical
Apply filter: Show error messages of this URL onlyhttps://triglianoi.gr/index.php?action=register2Apply filter: Show only errors with the same messageWrong value type sent to the database. Date expected. (birthdate)
Function: registerMemberApply filter: Show only errors from this fileFile: /home/triglian/public_html/Sources/Subs-Members.php
Line: 771

Note that I also tried to register, before asking for your help and I had the same results, although I had completed all the required.
I also turned off the birthday app, but to no avail again.

What do you think is wrong?

shadav

not sure about the second one, sounds like they didn't fill in the birthdate

the first one
Field 'post_color' does not have a default value
you will need to log into your hosting account and go to your database
find in your database wherever the post_color is located and change it's default to NULL
without knowing what mod it is from, I'm going to assume it's either going to be in the members table (click on (prefix)_members then click on structure and look for post_color, click on change for post_color, then under where it says default, set it to NULL then save
if it's not under the members table look in messages, possible membergroups,

Panoulis64

Unfortunately, I come back to the subject.
Sorry I did not reply earlier.
With the administrator I have in the forum and he also has the server, we made some efforts and changed some values from the PHP my admin.
No result, only the messages in the database are different, but on the same line 771
6 months ago, we had done the big upgrade and everything worked fine, registrations were done normally.
I can not understand, that suddenly, there is such a serious problem.
I attach photos with the message after unfortunate registration and that of the Database in the forum management.

Kindred

The "... does not have a default value"  problem is because your HOST updated your mySQL version and the new version requires default values (a setting that was formerly "STRICT" only)

You will have to go into the database and update each failing database field to SET a default value (normally default = NULL)
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Panoulis64

Thank you for your response. This problem has been fixed. But there is another issue, which concerns the registration agreement.
When I activate it, (image 1) the simple members, when they log in, see the registration agreement, as text and can not navigate the forum !!! (image 2)
Any idea about that?
keep in mind that I have mysql 5.5 and I have the question, if it is supported by the smf.
Thanks.

Kindred

That would not be a database issue, IMO.... that seems to be a broken display.

Does that only happen for current users who need to re-accept the changed agreement or does it happen for new users as well?

What SMF version?
What mods do you have installed?
What theme is that?
What is the forum URL?
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Panoulis64

I have located it in the old members, when they enter. In new registrations, I did not manage to check.
Note that I have the registration agreement deactivated, so that old members can log in.

I have the version SMF 2.0.18

The applications are
1.   Spiders Don't Increase Topic Views   2.0
2.   Ultimate Menu   1.0.3   
3.   Hide User Names from Guests   1.1   
4.   Welcome Topic Mod   2.3b   
5.   Topic Viewers   1.0   
6.   Threads Participated In   1.0   
7.   Thank-o-matic   3.0   
8.   Smush.it! For SMF   1.1   
9.   Simple Audio Video Embedder   6.0.3   
10.   ENotify   3.0   
11.   Disable Right Click   4.1.2   
12.   Alternate User Posting   1.0.1   
13.   Birthday On Register   1.0   
14.   Custom Copyright   1.0.4   
15.   SMF Gallery Pro   9.0b   
16.   Age And Location   1.0   
17.   SimplePortal   2.3.7   
18.   SimplePortal - Greek   2.3.5   

My issue is Ostara

The address of the website, which operates in Greek, is https://triglianoi.gr/

Panoulis64

I did a test and the new members do not have a problem.

Kindred

ok, since it does not trigger for new users --- in order to debug this, I'd need you to
a- set up a test account
b- change/update the agreement to trigger the "must re-accept"
c- turn on the agreement so that I can see the issue...



because I just checked on my 2.0.18 installation and can not recreate the issue.
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Panoulis64

OK you want an old account or a new one
Can you make a new one and make you an administrator, would that help?

Panoulis64

Today, I did tests again. I saw that the acceptance button appeared, first trying it in English and then it was in Greek as well.
Thus, by clicking and logging out and reconnecting, sometimes perhaps with a second attempt, the forum appears normally to older members. The news had no problem.
The last action I took (I do not know if this was ultimately to blame) was to update the management of the agreement text.

Kindred

Sorry I didn't have a chance to get to look at your site. Some real-life job stuff got crazy.

but if that was solved as you say, then I suspect there was a cache issue -- and any old users who still have issues should do a CTRL-F5 reload of the page.
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Advertisement: