Error SQL in custom profile fields

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Daniel Walker
Registered User
Posts: 3
Joined: Wed May 16, 2018 1:41 pm

Error SQL in custom profile fields

Post by Daniel Walker » Wed May 16, 2018 1:45 pm

Hi! (Sorry for my english) im have a error in my Foro nextnationrp.com/foro when im use a profile fields, give me a error any can help me? :) Thanks!

Code: Select all

SQL ERROR [ mysqli ]

Field 'pf_phpbb_interests' doesn't have a default value [1364]

SQL

INSERT INTO phpbb1m_profile_fields_data (pf_phpbb_facebook, pf_enlace, user_id) VALUES ('', 'http://nextnationrp.com', 2)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 996
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/profilefields/manager.php
LINE: 249
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/includes/ucp/ucp_profile.php
LINE: 407
CALL: phpbb\profilefields\manager->update_profile_field_data()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: ucp_profile->main()

FILE: [ROOT]/ucp.php
LINE: 394
CALL: p_master->load_active()

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50512
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Error SQL in custom profile fields

Post by stevemaury » Wed May 16, 2018 3:00 pm

After backing up the profile_fields_data table, run this SQL ( Executing SQL Queries in phpMyAdmin )

Code: Select all

ALTER TABLE `phpbb1m_profile_fields_data` CHANGE `pf_phpbb_interests` `pf_phpbb_interests` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

Daniel Walker
Registered User
Posts: 3
Joined: Wed May 16, 2018 1:41 pm

Re: Error SQL in custom profile fields

Post by Daniel Walker » Wed May 16, 2018 3:30 pm

stevemaury wrote:
Wed May 16, 2018 3:00 pm
After backing up the profile_fields_data table, run this SQL ( Executing SQL Queries in phpMyAdmin )

Code: Select all

ALTER TABLE `phpbb1m_profile_fields_data` CHANGE `pf_phpbb_interests` `pf_phpbb_interests` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
Hi my friend thanks for support, the problem is in new account TEST acconut im cant see the Profiile Fields, but in admin account the error continues

Thanks for help, From Colombia :) :D

Post Reply

Return to “[3.2.x] Support Forum”