If the history setting in cfg.db.php is active ($keep_history = true;), the old version is
marked as deprecated, but the new version is not saved because of the following error:
MySQL: 1054: Unknown column 'middlename' in 'field list'
A column 'middlename' does not exist in the table.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
you can also add the entry for the missing column directly to your database. You need not to change your history settings.
ALTER TABLE addressbook ADD middlename varchar(255) default NULL AFTER firstname;
I don´t know why this column has not been inserted by updating the tables from version 80 to 82. It is listed in the file "addressbook_upgrade_v80_v82.sql".
It is better to add the column. Otherwise you may get problems when updating to a new version in the future.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi - I have an issue when editing existing contacts.
Once edited, and updated, the contact disappears from all page views.
Looking in the 'addressbook' table I can see that my changes have not been applied but the 'deprecated' field now has a date and time inserted.
Hi David,
in version 8.2.5, I noticed the same error.
If the history setting in cfg.db.php is active ($keep_history = true;), the old version is
marked as deprecated, but the new version is not saved because of the following error:
MySQL: 1054: Unknown column 'middlename' in 'field list'
A column 'middlename' does not exist in the table.
Hello how can i limit the number of entries displyed in the first page? in
what query i have to insert the LIMIT code?
Thank you very much
Thanks Christian - not that bothered about the history so I have modified cfg.db.php to ($keep_history = false;),
Hi David,
you can also add the entry for the missing column directly to your database. You need not to change your history settings.
ALTER TABLE
addressbookADDmiddlenamevarchar(255) default NULL AFTERfirstname;I don´t know why this column has not been inserted by updating the tables from version 80 to 82. It is listed in the file "addressbook_upgrade_v80_v82.sql".
It is better to add the column. Otherwise you may get problems when updating to a new version in the future.
Hi, the column is in the "addressbook.sql" script as well as in the "addressbook_upgrade_v80_v82.sql" script.
=> How did you install the book?
Hi,
I updated the software from an old version 6.2.x and processed all SQL scripts through phpmyadmin.
Curiously, like David, the column "middlename" was missing at the end of the process.