• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Stop wasting time looking for files and revisions. Connect your Gmail, DriveDropbox, and Slack accounts and in less than 2 minutes, Dokkio will automatically organize all your file attachments. Learn more and claim your free account.


Database error - Unknown column 'id' in 'field list'

Page history last edited by spyroinc@gmail.com 11 years, 9 months ago

If you are installing CodeExtinguisher on an exsiting database you my run into an error that is similar to this:


A Database Error Occurred

Error Number: 1054

Unknown column 'id' in 'field list'

SELECT `ad_id`, `id` FROM (`ads`) ORDER BY `id` desc


CodeExtinguisher assumes that all tables have a primary key with a column name of id.


You may have tables that have a primary key in which the column name is not id. In the example error above the primary key happened to be ad_id.


To fix this error you can add primary_id: {primary_key_column_name} to the yaml file corresponding to the table.

Comments (0)

You don't have permission to comment on this page.