Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-1758

Custom Profile Field update returns SQL error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • None
    • 3.0.B2
    • None
    • PHP Environment:
      Database:

      I added two custom profile fields...
      one called:
      ebayid
      textline : 20 character limit

      other:
      ebayurl
      textline : 30 character limit

      I tried to update my ebayid and got a SQL error

      General Error
      SQL ERROR [ oracle ]

      ORA-00911: invalid character [911]

      SQL

      UPDATE bb3_profile_fields_data SET _ebayid = NULL, _ebaylink = NULL WHERE user_id = 2

      BACKTRACE

      FILE: includes/db/oracle.php
      LINE: 124
      CALL: dbal->sql_error()

      FILE: includes/ucp/ucp_profile.php
      LINE: 319
      CALL: dbal_oracle->sql_query()

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

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

            DavidMJ DavidMJ
            southcross southcross
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: