Bug tracker

This ticket has been moved to our new tracker. Open Ticket PHPBB3-1874 now.

Long costum profile field (fix completed in vcs)

I get an SQL error:
General Error
SQL ERROR [ mysqli ]

Unknown column 'pf_nieuwsbrief_ontvange' in 'field list' [1054]

SQL

UPDATE phpbb_profile_fields_data SET pf_nieuwsbr = '1', pf_nieuwsbrief_ontvange = 1 WHERE user_id = 2

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 116
CALL: dbal->sql_error()

FILE: includes/ucp/ucp_profile.php
LINE: 329
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_module.php
LINE: 361
CALL: ucp_profile->main()

FILE: ucp.php
LINE: 321
CALL: p_master->load_active()

steps to reproduce:
1. create an costum profile field with a name longer then 20 characters (I tried it with boolean)
2. try to change it in your ucp

Comments / History

Posted by pc-tutorials on Oct 18th 2006, 13:30

Additional information:
In the database the field exist, with the long name (longer then 20 characters i mean) Olypus is trying to query an item that is broken up after the 23st characters

Posted by DavidMJ (Former Team Member) on Oct 18th 2006, 22:01

meh, I know why this happens...

Linked ticket with changeset: r6510

Action performed by DavidMJ (Former Team Member) on Oct 18th 2006, 23:58

Ticket details

Related SVN changesets