phpBB • Free and Open Source Forum Software

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()

Is the underline an invalid characters in oracle?

the underscore? Not that I'm aware of. Wouldn't I have gotten a SQL error when I added the custom field? It doesn't seem to be the case as when I view the field name I see the '_'

here is a copy and paste from the Databse GUI

Code: Select all: Column Name Data Type Nullable Default Primary Key USER_ID NUMBER(8,0) No '0' 1 _ebayid VARCHAR2(255) Yes - - _ebaylink VARCHAR2(255) Yes - -

they can only start with letters and numbers with oracle.. the rest can have as many _ as we want. Can't we just suffix the col instead of prefix it?

then profile fields never worked for oracle. Very Happy

We could either suffix or use pf_ as the prefix, choose the one easier to maintain code-wise (since we already have a prefix it should be easier to extend this prefix than rewrite everything to cope with a suffix). Smile

	What:	Where:	Country:
vacatures php arbeit php jobs php lavoro php emploi php trabajo php jobs php arbeit php

Custom Profile Field update returns SQL error (fix completed in vcs)

Comments / History

Ticket details

Related SVN changesets

Advertisements