Error when adding new field
- pjstander
- OFFLINE
-
New Member
- Posts: 4
- Thanks: 0
- Karma: 0
13 years 4 months ago #147238
by pjstander
Error when adding new field was created by pjstander
Hi
I am using the lates Joomla version and cb 1.2.3 and have addes allot of field and when I try to add a new field I get this error:
moscomprofilerFields::store failed: CBSQLupgrader::changeColumn (ADD) of Table #__comprofiler Column cb_socialworker failed with SQL error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `jos_comprofiler`\n ADD `cb_socialworker` varchar(255) DEFAULT NULL Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `jos_comprofiler`\n ADD `cb_socialworker` varchar(255) DEFAULT NULL
I saw a part of the forum where this problem was discussed and have seen that I have to change the varchar(255) to text.
I have done this but when I try to ad a field a get a new error.
Please help
I am using the lates Joomla version and cb 1.2.3 and have addes allot of field and when I try to add a new field I get this error:
moscomprofilerFields::store failed: CBSQLupgrader::changeColumn (ADD) of Table #__comprofiler Column cb_socialworker failed with SQL error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `jos_comprofiler`\n ADD `cb_socialworker` varchar(255) DEFAULT NULL Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `jos_comprofiler`\n ADD `cb_socialworker` varchar(255) DEFAULT NULL
I saw a part of the forum where this problem was discussed and have seen that I have to change the varchar(255) to text.
I have done this but when I try to ad a field a get a new error.
Please help
Please Log in to join the conversation.
- pjstander
- OFFLINE
-
New Member
- Posts: 4
- Thanks: 0
- Karma: 0
13 years 4 months ago #147252
by pjstander
Replied by pjstander on topic Re:Error when adding new field
I have tried to make the fixes, I have tried to replace (255) with 100, and 150 and text. When I do this I get the following errors when I click on Check Community Builder User Fields Database.
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 193: parser error : Unescaped '<' not allowed in attributes values in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: idateForbiddenList_register" type="text" default="http:,https:,mailto:,//., in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 193: parser error : attributes construct error in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: idateForbiddenList_register" type="text" default="http:,https:,mailto:,//., in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 193: parser error : Couldn't find end of Start Tag param line 193 in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: idateForbiddenList_register" type="text" default="http:,https:,mailto:,//., in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 193: parser error : error parsing attribute name in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ateForbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 193: parser error : attributes construct error in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ateForbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 193: parser error : Couldn't find end of Start Tag a line 193 in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ateForbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 193: parser error : Opening and ending tag mismatch: params line 176 and a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: rbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a,</a> in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 195: parser error : Opening and ending tag mismatch: field line 174 and params in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: </params> in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 196: parser error : Opening and ending tag mismatch: fieldtypes line 40 and field in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: </field> in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 218: parser error : Unescaped '<' not allowed in attributes values in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: idateForbiddenList_register" type="text" default="http:,https:,mailto:,//., in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 218: parser error : attributes construct error in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: idateForbiddenList_register" type="text" default="http:,https:,mailto:,//., in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 218: parser error : Couldn't find end of Start Tag param line 218 in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: idateForbiddenList_register" type="text" default="http:,https:,mailto:,//., in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 218: parser error : error parsing attribute name in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ateForbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 218: parser error : attributes construct error in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ateForbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 218: parser error : Couldn't find end of Start Tag a line 218 in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ateForbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 218: parser error : Opening and ending tag mismatch: params line 205 and a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: rbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a,</a> in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 220: parser error : Opening and ending tag mismatch: field line 197 and params in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: </params> in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 221: parser error : Opening and ending tag mismatch: cbinstall line 2 and field in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: </field> in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 222: parser error : Extra content at the end of the document in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: <field type="editorta" label="Editor Text Area"> in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php:730 Stack trace: #0 C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php(730): SimpleXMLElement->__construct('<?xml version="...') #1 C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php(2180): cbPluginHandler->loadPluginXML('editField', 'counter', '1') #2 C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php(2195): cbFieldHandler->_loadXML(Object(moscomprofilerFields)) #3 C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php(2346): cbFieldHandler->_loadFieldXML(Object(moscomprofilerFields)) #4 C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\library\cb\cb.dbchecker.php(223): cbFieldHandler->checkFixSQL(Object(CBSQLupgrader), Object(moscomprofilerFields), false) #5 C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\cont in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 193: parser error : Unescaped '<' not allowed in attributes values in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: idateForbiddenList_register" type="text" default="http:,https:,mailto:,//., in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 193: parser error : attributes construct error in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: idateForbiddenList_register" type="text" default="http:,https:,mailto:,//., in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 193: parser error : Couldn't find end of Start Tag param line 193 in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: idateForbiddenList_register" type="text" default="http:,https:,mailto:,//., in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 193: parser error : error parsing attribute name in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ateForbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 193: parser error : attributes construct error in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ateForbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 193: parser error : Couldn't find end of Start Tag a line 193 in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ateForbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 193: parser error : Opening and ending tag mismatch: params line 176 and a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: rbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a,</a> in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 195: parser error : Opening and ending tag mismatch: field line 174 and params in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: </params> in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 196: parser error : Opening and ending tag mismatch: fieldtypes line 40 and field in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: </field> in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 218: parser error : Unescaped '<' not allowed in attributes values in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: idateForbiddenList_register" type="text" default="http:,https:,mailto:,//., in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 218: parser error : attributes construct error in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: idateForbiddenList_register" type="text" default="http:,https:,mailto:,//., in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 218: parser error : Couldn't find end of Start Tag param line 218 in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: idateForbiddenList_register" type="text" default="http:,https:,mailto:,//., in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 218: parser error : error parsing attribute name in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ateForbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 218: parser error : attributes construct error in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ateForbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 218: parser error : Couldn't find end of Start Tag a line 218 in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ateForbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 218: parser error : Opening and ending tag mismatch: params line 205 and a in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: rbiddenList_register" type="text" default="http:,https:,mailto:,//.,<a,</a> in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 220: parser error : Opening and ending tag mismatch: field line 197 and params in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: </params> in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 221: parser error : Opening and ending tag mismatch: cbinstall line 2 and field in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: </field> in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 222: parser error : Extra content at the end of the document in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: <field type="editorta" label="Editor Text Area"> in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: ^ in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php:730 Stack trace: #0 C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php(730): SimpleXMLElement->__construct('<?xml version="...') #1 C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php(2180): cbPluginHandler->loadPluginXML('editField', 'counter', '1') #2 C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php(2195): cbFieldHandler->_loadXML(Object(moscomprofilerFields)) #3 C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php(2346): cbFieldHandler->_loadFieldXML(Object(moscomprofilerFields)) #4 C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\library\cb\cb.dbchecker.php(223): cbFieldHandler->checkFixSQL(Object(CBSQLupgrader), Object(moscomprofilerFields), false) #5 C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\cont in C:\xampp\htdocs\kohin\administrator\components\com_comprofiler\plugin.class.php on line 730
Please Log in to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68482
- Thanks: 9075
- Karma: 1434
13 years 4 months ago #147276
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Re:Error when adding new field
You have too many fields, you've reached the maximum amount of columns a database table can sustain. You'll need to remove some fields or edit all the fields columns to be of different types such as "text". Please also upgrade to CB 1.3.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in to join the conversation.
- pjstander
- OFFLINE
-
New Member
- Posts: 4
- Thanks: 0
- Karma: 0
13 years 4 months ago #147278
by pjstander
Replied by pjstander on topic Re:Error when adding new field
Is there no other way to add more fields, I am using CB to make my database and need more fields.
Please Log in to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68482
- Thanks: 9075
- Karma: 1434
13 years 4 months ago #147328
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Re:Error when adding new field
pjstander wrote:
I recommend upgrading to CB 1.3 before making any changes and trying again as believe some adjustments were made to improve this already.
You'll need to search and make edits to cb.core.xml to adjust the type of fields to something like text instead of varchar(255) then run CB tools to fix all fields to that new type. This is a limitation of MYSQL and not really a workaround other then changing the columns type to something smaller in size. We've plans in later release to adjust how fields are stored in order to allow for more fields.Is there no other way to add more fields, I am using CB to make my database and need more fields.
I recommend upgrading to CB 1.3 before making any changes and trying again as believe some adjustments were made to improve this already.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in to join the conversation.
- pjstander
- OFFLINE
-
New Member
- Posts: 4
- Thanks: 0
- Karma: 0
13 years 4 months ago #147647
by pjstander
Replied by pjstander on topic Re:Error when adding new field
I have tried it but it does not work, I get a long error page when I try to add a new field and when I check the CB database.
I have replaces the vacrchar(255) with text lik you suggested, I have changed the 255 to 150 like suggested in other posts but it still does not want to work
I have replaces the vacrchar(255) with text lik you suggested, I have changed the 255 to 150 like suggested in other posts but it still does not want to work
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.182 seconds
