Beta 6: Can't save Accounts after Installing from Scratch

[oroinc]

Beta 6: Can't save Accounts after Installing from Scratch

[hugeval]

Can't reproduce. My environment:

• Ubuntu 13.04
• nginx version: nginx/1.2.6 (Ubuntu)
• PHP 5.4.9-4ubuntu2.4 (fpm-fcgi) (built: Dec 12 2013 04:38:26)
  Copyright (c) 1997-2012 The PHP Group
  Zend Engine v2.4.0, Copyright (c) 1998-2012 Zend Technologies
• mysql Ver 14.14 Distrib 5.5.34, for debian-linux-gnu (x86_64) using readline 6.2
• Firefox 26.0

[astorm]

See Issue 22 for a better set of steps to reproduce this problem.

[davidlukac]

I had the very similar issue on my DEV machine when displaying Contact details (e.g. /web/app_dev.php/contact/view/102). Uncaught exception was:

An exception has been thrown during the rendering of a template ("An exception occurred while executing 'SELECT t0.field_extend_description AS field_extend_description1, t0.field_extend_phone AS field_extend_phone2, t0.field_extend_email AS field_extend_email3, t0.field_extend_fax AS field_extend_fax4, t0.field_extend_website AS field_extend_website5, t0.field_extend_employees AS field_extend_employees6, t0.field_extend_ownership AS field_extend_ownership7, t0.field_extend_ticker_symbol AS field_extend_ticker_symbol8, t0.field_extend_rating AS field_extend_rating9, t0.id AS id10, t0.name AS name11, t0.createdAt AS createdAt12, t0.updatedAt AS updatedAt13, t0.user_owner_id AS user_owner_id14, t0.shipping_address_id AS shipping_address_id15, t0.billing_address_id AS billing_address_id16, t0.default_contact_id AS default_contact_id17 FROM orocrm_account t0 INNER JOIN orocrm_account_to_contact ON t0.id = orocrm_account_to_contact.account_id WHERE orocrm_account_to_contact.contact_id = ?' with params [103]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.field_extend_description' in 'field list'") in C:\xampp183\htdocs\orocrm\vendor\oro\crm\src\OroCRM\Bundle\ContactBundle/Resources/views/Contact/widget/info.html.twig at line 107. 

The issue occurred after a while of playing around on freshly installed instance (I'm not aware of any changes except creating some data).

Resolved by running

$ php app/console doctrine:schema:update --force --dump-sql                                                                                                     
ALTER TABLE oro_search_item CHANGE changed changed TINYINT(1) NOT NULL;                                                                                         
DROP INDEX value ON oro_search_index_text;                                                                                                                      
ALTER TABLE oro_search_index_text ADD CONSTRAINT FK_A0243539126F525E FOREIGN KEY (item_id) REFERENCES oro_search_item (id);                                     
ALTER TABLE orocrm_account ADD field_extend_description LONGTEXT DEFAULT NULL, ADD field_extend_phone VARCHAR(255) DEFAULT NULL, ADD field_extend_email VARCHAR(
255) DEFAULT NULL, ADD field_extend_fax VARCHAR(255) DEFAULT NULL, ADD field_extend_website VARCHAR(255) DEFAULT NULL, ADD field_extend_employees INT DEFAULT NU
LL, ADD field_extend_ownership VARCHAR(255) DEFAULT NULL, ADD field_extend_ticker_symbol VARCHAR(255) DEFAULT NULL, ADD field_extend_rating VARCHAR(255) DEFAULT
 NULL;                                                                                                                                                          

Updating database schema...                                                                                                                                     
Database schema updated successfully! "←[32m4←[0m" queries were executed                                                                                        

[dxops]

Hi, @astorm !

Accounts table is ok now. Thanks!