Jump to content

Database Field error EX1054


Heosforo

Recommended Posts

Posted

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.

Posted

Run the database checker.  ACP > System > Support > Something Isn't Working > Continue.  

Looks like a table wasn't created correctly for some reason.

Posted

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)

 

Posted

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 :rofl:

So I think I'm gonna reinstall MAMP and see what's happen.

Thanks mate.

 

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...