Database Error Please try again.

Started by perfec2, June 14, 2020, 07:53:56 AM

Previous topic - Next topic

Arantor

It's not a table called that, it's going to be the smf_members table looking at the error you have.

And please, no, I don't want cPanel logins - ever.

perfec2

Please give steps on how to locate the breeze_profile_views column, and allow it to be null.

Thank you for your assistance.

Kindred

those are tables, not columns.

As Arantor said -- in the smf_members table, find the  breeze_profile_views  column and give it a default value of 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."

perfec2

Quote from: Kindred on June 19, 2020, 09:52:58 AM
those are tables, not columns.

As Arantor said -- in the smf_members table, find the  breeze_profile_views  column and give it a default value of NULL
I understand, the question is how could I do that? Please put me through step by step and let me know the query to run or what?

Arantor

So you went into phpMyAdmin, right? Click on smf_members in the list of tables, then the Structure tab in that, you should then see the breeze_profile_views column. You can then edit that column, tick the box next to 'null' and hit save.

perfec2

Quote from: Arantor on June 19, 2020, 03:01:05 PM
So you went into phpMyAdmin, right? Click on smf_members in the list of tables, then the Structure tab in that, you should then see the breeze_profile_views column. You can then edit that column, tick the box next to 'null' and hit save.


This solved it. 
Now new members can signup without issues.

Thank you Arantor, Sir Osis of Liver, Doug Heffernan, and all that contributed.


Advertisement: