Heosforo Posted July 21, 2016 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.
Aiwa Posted July 21, 2016 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.
Heosforo Posted July 21, 2016 Author Posted July 21, 2016 Done but nothing happens, I get the same error I'm on localhost, could be that?
Aiwa Posted July 21, 2016 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)
Heosforo Posted July 21, 2016 Author 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.