1. carnalimr
  2. Bug Report
  3. Friday, March 27 2015, 12:36 AM
Hello,
I am trying to add a new field and I get the following error:

jos-Error: Unknown column 'introtext' in 'field list' SQL=INSERT INTO `f0l1k_jsn_fields` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`id`,`title`,`description`,`published`,`type`,`required`,`profile`,`edit`,`register`,`search`,`access`,`accessview`,`params`,`created_user_id`,`created_time`,`introtext`) VALUES ('2','2','26','27','year_profession','0','Year/Profession','','1','selectlist','0','0','1','0','0','1','1','{\"titleprofile\":\"\",\"titlesearch\":\"\",\"hidetitle\":\"0\",\"hidetitleedit\":\"0\",\"privacy\":\"0\",\"privacy_default\":\"0\",\"condition_operator\":\"0\",\"condition_field\":\"_custom\",\"condition_custom\":\"\",\"condition_action\":\"hide\",\"condition_operator1\":\"0\",\"condition_field1\":\"_custom\",\"condition_custom1\":\"\",\"condition_action1\":\"hide\",\"condition_operator2\":\"0\",\"condition_field2\":\"_custom\",\"condition_custom2\":\"\",\"condition_action2\":\"hide\",\"condition_operator3\":\"0\",\"condition_field3\":\"_custom\",\"condition_custom3\":\"\",\"condition_action3\":\"hide\",\"condition_operator4\":\"0\",\"condition_field4\":\"_custom\",\"condition_custom4\":\"\",\"condition_action4\":\"hide\",\"condition_operator5\":\"0\",\"condition_field5\":\"_custom\",\"condition_custom5\":\"\",\"condition_action5\":\"hide\",\"condition_operator6\":\"0\",\"condition_field6\":\"_custom\",\"condition_custom6\":\"\",\"condition_action6\":\"hide\",\"condition_operator7\":\"0\",\"condition_field7\":\"_custom\",\"condition_custom7\":\"\",\"condition_action7\":\"hide\",\"condition_operator8\":\"0\",\"condition_field8\":\"_custom\",\"condition_custom8\":\"\",\"condition_action8\":\"hide\",\"condition_operator9\":\"0\",\"condition_field9\":\"_custom\",\"condition_custom9\":\"\",\"condition_action9\":\"hide\",\"checkbox_defaultvalue\":\"\",\"checkbox_options\":\"\",\"checkbox_inline\":\"0\",\"date_default\":\"\",\"date_placeholder\":\"\",\"date_format\":\"Y-m-d\",\"date_type\":0,\"date_viewmode\":\"days\",\"date_span\":0,\"date_span_year\":0,\"date_span_month\":0,\"date_span_day\":0,\"email_defaultvalue\":\"\",\"email_placeholder\":\"\",\"filetype_ext\":\"pdf|zip|doc|docx\",\"filetype_label\":\"\",\"gmap_placeholder\":\"\",\"gmap_showmap\":\"1\",\"gmap_radius\":10,\"gmap_unit\":\"Km\",\"hide_defaultvalue\":\"\",\"image_width\":200,\"image_height\":200,\"image_thumbwidth\":75,\"image_thumbheight\":75,\"image_defaultvalue\":\"\",\"image_alt\":\"\",\"image_class\":\"\",\"image_cropwebcam\":\"0\",\"link_defaultvalue\":\"\",\"link_placeholder\":\"\",\"link_maxlength\":255,\"numeric_defaultvalue\":\"\",\"numeric_max\":999999,\"numeric_min\":0,\"numeric_step\":1,\"password_placeholder\":\"\",\"password_placeholder2\":\"\",\"phone_defaultvalue\":\"\",\"phone_placeholder\":\"\",\"radio_defaultvalue\":\"\",\"radio_options\":\"\",\"radio_inline\":\"0\",\"select_defaultvalue\":\"\",\"select_placeholder\":\"\",\"select_options\":\"Freshman\\r\\nSophomore\\r\\nJunior\\r\\nSenior\\r\\nMasters\\r\\nPHD\\r\\nProfessor\\r\\nProfessional \",\"select_multiple\":\"0\",\"select_dbopttable\":\"\",\"select_dboptvalue\":\"\",\"select_dbopttext\":\"\",\"select_dboptwhere\":\"\",\"text_defaultvalue\":\"\",\"text_placeholder\":\"\",\"text_maxlength\":255,\"text_regex\":\"\",\"text_customregex\":\"\",\"text_readonly\":\"0\",\"textarea_defaultvalue\":\"\",\"textarea_type\":\"textarea\",\"usermail_placeholder\":\"\",\"usermail_placeholder2\":\"\",\"username_placeholder\":\"\",\"video_defaultvalue\":\"\",\"video_placeholder\":\"\",\"video_maxlength\":255}','272','2015-03-26 23:38:36','')
admin Accepted Answer
Admin
Hi,
strange we not use column "introtext" in our system, it never declared in our package.

Can you please post me your site details? you can use the form below the reply in "Site Details" tab.
  1. more than a month ago
  2. Bug Report
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.