"created_from" and "created_by" fields missing from 2.1.27

Hi,

Trying to upgrade from 2.1.23 to 2.1.27. After waiting 8 hours for "finalization", everything "seemed" OK but the moment I went to upgrade apps and/or actually USE akaunting, I got hammered by a throng of errors complaining that the fields "created_from" and/or "created_by" were missing from many, many tables. I manually added them because I have a CS degree but, seriously, would a regular business owner not be completely crippled by this?

Update: I see from another thread that 2.1.125 added the 2 columns, so there's a chance that by going straight from .23 to .27 I missed the intermediary step but, seriously, does this mean that if I miss one version I get left behind? Also, what happens if the .23 to .25 upgrade is buggy (which it was)?

How did this get overlooked?
-Scott.

Can somebody please tell me what these field definitions in the database should be? I have created_by set as int(10) and created_from set as varchar(191), but I'm totally guessing.

I am not a Laravel Developer but I believe there must be some kind Migrations in latest release for previous one to update tables with new fields.

However, to overcome the above mentioned errors, I made some table comparisons between old and latest table definitions, found differences and applied them to my database. It's working perfect now.

Pasting here for your considerations, may help in someone in future. My unique table identifier was 81o, you must change them according to yours.

ALTER TABLE 81o_accounts ADD COLUMN created_from VARCHAR(100) AFTER enabled;

ALTER TABLE 81o_categories ADD COLUMN created_from VARCHAR(100) AFTER enabled;

ALTER TABLE 81o_companies ADD COLUMN created_from VARCHAR(100) AFTER enabled;

ALTER TABLE 81o_contacts ADD COLUMN city VARCHAR(191) AFTER address;
ALTER TABLE 81o_contacts ADD COLUMN zip_code VARCHAR(191) AFTER city;
ALTER TABLE 81o_contacts ADD COLUMN state VARCHAR(191) AFTER zip_code;
ALTER TABLE 81o_contacts ADD COLUMN country VARCHAR(191) AFTER state;
ALTER TABLE 81o_contacts ADD COLUMN created_from VARCHAR(100) AFTER reference;

ALTER TABLE 81o_currencies ADD COLUMN created_from VARCHAR(100) AFTER enabled;

ALTER TABLE 81o_dashboards ADD COLUMN created_from VARCHAR(100) AFTER enabled;

ALTER TABLE 81o_document_histories ADD COLUMN created_from VARCHAR(100) AFTER description;
ALTER TABLE 81o_document_histories ADD COLUMN created_by VARCHAR(30) AFTER created_from;

ALTER TABLE 81o_document_item_taxes ADD COLUMN created_from VARCHAR(100) AFTER amount;
ALTER TABLE 81o_document_item_taxes ADD COLUMN created_by VARCHAR(30) AFTER created_from;

ALTER TABLE 81o_document_items ADD COLUMN created_from VARCHAR(100) AFTER total;
ALTER TABLE 81o_document_items ADD COLUMN created_by VARCHAR(30) AFTER created_from;

ALTER TABLE 81o_document_totals ADD COLUMN created_from VARCHAR(100) AFTER sort_order;
ALTER TABLE 81o_document_totals ADD COLUMN created_by VARCHAR(30) AFTER created_from;

ALTER TABLE 81o_documents ADD COLUMN contact_city VARCHAR(191) AFTER contact_address;
ALTER TABLE 81o_documents ADD COLUMN contact_zip_code VARCHAR(191) AFTER contact_city;
ALTER TABLE 81o_documents ADD COLUMN contact_state VARCHAR(191) AFTER contact_zip_code;
ALTER TABLE 81o_documents ADD COLUMN contact_country VARCHAR(191) AFTER contact_state;
ALTER TABLE 81o_documents ADD COLUMN created_from VARCHAR(100) AFTER parent_id;

ALTER TABLE 81o_email_templates ADD COLUMN created_from VARCHAR(100) AFTER params;
ALTER TABLE 81o_email_templates ADD COLUMN created_by VARCHAR(30) AFTER created_from;

ALTER TABLE 81o_item_taxes ADD COLUMN created_from VARCHAR(100) AFTER tax_id;
ALTER TABLE 81o_item_taxes ADD COLUMN created_by VARCHAR(30) AFTER created_from;

ALTER TABLE 81o_items ADD COLUMN created_from VARCHAR(100) AFTER enabled;

ALTER TABLE 81o_media ADD COLUMN created_from VARCHAR(100) AFTER original_media_id;
ALTER TABLE 81o_media ADD COLUMN created_by VARCHAR(30) AFTER created_from;

ALTER TABLE 81o_mediables ADD COLUMN created_from VARCHAR(100) AFTER `order`;
ALTER TABLE 81o_mediables ADD COLUMN created_by VARCHAR(30) AFTER created_from;

ALTER TABLE 81o_module_histories ADD COLUMN created_from VARCHAR(100) AFTER description;
ALTER TABLE 81o_module_histories ADD COLUMN created_by VARCHAR(30) AFTER created_from;

ALTER TABLE 81o_modules ADD COLUMN created_from VARCHAR(100) AFTER enabled;
ALTER TABLE 81o_modules ADD COLUMN created_by VARCHAR(30) AFTER created_from;

ALTER TABLE 81o_reconciliations ADD COLUMN created_from VARCHAR(100) AFTER reconciled;

ALTER TABLE 81o_recurring ADD COLUMN created_from VARCHAR(100) AFTER count;
ALTER TABLE 81o_recurring ADD COLUMN created_by VARCHAR(30) AFTER created_from;

ALTER TABLE 81o_reports ADD COLUMN created_from VARCHAR(100) AFTER settings;

ALTER TABLE 81o_roles ADD COLUMN created_from VARCHAR(100) AFTER description;
ALTER TABLE 81o_roles ADD COLUMN created_by VARCHAR(30) AFTER created_from;

ALTER TABLE 81o_settings ADD COLUMN deleted_at timestamp AFTER value;

ALTER TABLE 81o_taxes ADD COLUMN created_from VARCHAR(100) AFTER enabled;

ALTER TABLE 81o_transactions ADD COLUMN created_from VARCHAR(100) AFTER parent_id;

ALTER TABLE 81o_transfers ADD COLUMN created_from VARCHAR(100) AFTER income_transaction_id;

ALTER TABLE 81o_user_companies drop COLUMN user_type;

ALTER TABLE 81o_user_dashboards drop COLUMN user_type;

ALTER TABLE 81o_users ADD COLUMN created_from VARCHAR(100) AFTER enabled;
ALTER TABLE 81o_users ADD COLUMN created_by VARCHAR(30) AFTER created_from;

ALTER TABLE 81o_widgets ADD COLUMN created_from VARCHAR(100) AFTER settings;

First of all, THANK YOU!!! And, hey, look at that, aside from a type declaration and length adjustment, I almost had it!