Heosforo Posted July 21, 2016 Share Posted July 21, 2016 When creating a new database field, I receive this error: A configuration or server error has occurred. EX1054 Something went wrong. Please try again. UPDATE `cms_database_fields` cms_database_fields SET `field_position`=3,`field_key`='article_image',`field_database_id`=1,`field_id`=5,`field_type`='Text',`field_allowed_extensions`=NULL,`field_is_multiple`=NULL,`field_max_length`=0,`field_validator`=0,`field_validator_custom`=NULL,`field_format_opts`=NULL,`field_unique`=false,`field_filter`=NULL,`field_required`=NULL,`field_html`=false,`field_display_listing`=0,`field_truncate`=false,`field_display_display`=false,`field_display_commentform`=false,`field_display_json`=0 WHERE field_id=false IPS\Db\Exception: Unknown column 'field_unique' in 'field list' (1054) #0 /Applications/MAMP/htdocs/Invision/system/Db/Db.php(836): IPS\_Db->preparedQuery('/*IPS\\Node\\_Mod...', Array) #1 /Applications/MAMP/htdocs/Invision/system/Patterns/ActiveRecord.php(474): IPS\_Db->update('`cms_database_f...', '`field_position...', 'WHERE field_id=...') #2 /Applications/MAMP/htdocs/Invision/system/Node/Model.php(2013): IPS\Patterns\_ActiveRecord->save() #3 /Applications/MAMP/htdocs/Invision/applications/cms/sources/Fields/Fields.php(2566): IPS\Node\_Model->save() #4 /Applications/MAMP/htdocs/Invision/system/Node/Model.php(2652): IPS\cms\_Fields->save() #5 /Applications/MAMP/htdocs/Invision/system/Node/Controller.php(376): IPS\Node\_Model->saveForm(Array) #6 [internal function]: IPS\Node\_Controller->form() #7 /Applications/MAMP/htdocs/Invision/system/Dispatcher/Controller.php(85): call_user_func(Array) #8 /Applications/MAMP/htdocs/Invision/system/Node/Controller.php(63): IPS\Dispatcher\_Controller->execute() #9 /Applications/MAMP/htdocs/Invision/applications/cms/modules/admin/databases/fields.php(44): IPS\Node\_Controller->execute() #10 /Applications/MAMP/htdocs/Invision/system/Dispatcher/Dispatcher.php(129): IPS\cms\modules\admin\databases\_fields->execute() #11 /Applications/MAMP/htdocs/Invision/admin/index.php(13): IPS\_Dispatcher->run() #12 {main} Has anyone else had this issue? Is a fresh installation. Link to comment Share on other sites More sharing options...
Aiwa Posted July 21, 2016 Share Posted July 21, 2016 Run the database checker. ACP > System > Support > Something Isn't Working > Continue. Looks like a table wasn't created correctly for some reason. Link to comment Share on other sites More sharing options...
Heosforo Posted July 21, 2016 Author Share Posted July 21, 2016 Done but nothing happens, I get the same error I'm on localhost, could be that? Link to comment Share on other sites More sharing options...
Aiwa Posted July 21, 2016 Share Posted July 21, 2016 I'm assuming you're using the latest version? 4.1.13.2? If not, install it and run the Support tool again. You're missing a column in a default table. Unknown column 'field_unique' in 'field list' (1054) Link to comment Share on other sites More sharing options...
Heosforo Posted July 21, 2016 Author Share Posted July 21, 2016 This is weird, I have made another local installation and the problem continues. (4.1.13.2) But I also have my site with v4.1.13.2, and everything works fine So I think I'm gonna reinstall MAMP and see what's happen. Thanks mate. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.