Since 7.4 upgrade : query on custom field randomly failed

📦 Install & Upgrade Help
1

Since, i update from 7.2 to 7.4 (through 7.3.2 but no test in the mean time), some query using custom field randomly fail.

For example i see a lot of this in my debug log :
Thu Nov 5 13:09:27 2015 [20977][386b3bf7-92d1-54a5-680c-5579135c8c1d][FATAL] Error retrieving MA_AnomyzedEmail list: Query Failed: SELECT ma_anomyzedemail.id , ma_anomyzedemail.name , ma_anomyzedemail.anomized_email_c , ma_anomyzedemail.assigned_user_id FROM ma_anomyzedemail where (name = "xxxxx@vvvvv.com") AND ma_anomyzedemail.deleted=0 LIMIT 0,10: MySQL error 1054: Unknown column ‘ma_anomyzedemail.anomized_email_c’ in ‘field list’

Thu Nov 5 13:06:09 2015 [17899][eee98276-0677-b6ad-2697-5590d263c154][FATAL] Error inserting into table: opportunities: Query Failed: INSERT INTO opportunities (id,name,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,campaign_id,lead_source,amount,amount_usdollar,currency_id,date_closed,sales_stage,probability,pax_traveling_c,travel_description_c,previous_travels_c,interest_vehicle_c,date_of_tour_end_c,date_of_tour_start_c,hotness_scale_c,escort_guide_c,interest_travel_name_c)
VALUES (‘54fa02bc-eb3f-5706-ebd2-563b4622276b’,‘Legendre moto USA’,‘2015-11-05 12:06:09’,‘2015-11-05 12:06:08’,‘eee98276-0677-b6ad-2697-5590d263c154’,‘eee98276-0677-b6ad-2697-5590d263c154’,’’,0,‘ef9ca017-71a6-ff79-4050-55c47a50b244’,‘aa7c1c6c-0e04-62e3-a509-547c1ea7d5d5’,‘Web Site’,4400,4400,’-99’,‘2015-12-17’,‘Needs Analysis’,10,‘1’,’’,’’,‘moto’,’’,’’,‘5’,‘not_provided’,‘yyyY’): MySQL error 1054: Unknown column ‘pax_traveling_c’ in ‘field list’

Of course fields exist in CRM and in the corresponding table in mysql, i checked.

It happen like 50% of the time on those select and insert.

2

Hi,

Run a Quick Repair and Rebuild from the Admin > Repair Menu.

On the page that loads, the Repair results page, scroll to the bottom.
If there is a box with commands and an “Execute” button, click “Execute”.

3

Hi,

I did it multiple time. Nothing appear at the bottom of the page and problem still hapen. I also reapplied the permissions on all folders.

4

Hi,

If you wish, you may want to create backups of your DB and CRM before trying these:

If the column “anomized_email_c” doesn’t exist in the table “ma_anomyzedemail”, You may wish to create it. You could do this through the PHPMyAdmin UI.

Or, you may wish to delete the field in the CRM, Run a Quick Repair & rebuild and execute any changes.
Then, re-create the field and run a Quick Repair & rebuild and Execute any changes.

5

Sorry i think my first message was unclear. Those field exist but not where SuiteCRM is looking them for;

I mean :
- anomized_email_c exist in ma_anomyzedemail_cstm not in ma_anomyzedemail
- pax_traveling_c exist in opportunities_cstm not in opportunities

As their both custom field i was assuming this is their expected place, no?

6

I don t understand why there is no " left join opportunities_cstm " & “left join ma_anomyzedemail_cstm” on those request.

And 50% of the time update and select work so i guess left join is done 50% of the time.

7

Just the same error here.
After upgrading from 7.3.1 to 7.4
I guess the error rate is a bit lower than 50%.

Here a log entry:
Error updating table: accounts: Query Failed: UPDATE accounts
SET name=‘news GmbH’,date_modified=‘2015-11-10 15:29:04’,modified_user_id=‘b770067b-e0df-5e40-51d9-53a984591356’,created_by=‘b770067b-e0df-5e40-51d9-53a984591356’,description=‘bla’,assigned_user_id=‘b770067b-e0df-5e40-51d9-53a984591356’,account_type=NULL,industry=NULL,annual_revenue=NULL,phone_fax=‘040-4’,billing_address_street=‘Weg 144’,billing_address_city=‘Hamburg’,billing_address_state=NULL,billing_address_postalcode=‘12345’,billing_address_country=‘DEUTSCHLAND’,rating=NULL,phone_office=‘040-40’,phone_alternate=NULL,website=‘www.news.de’,ownership=NULL,employees=NULL,ticker_symbol=NULL,shipping_address_street=NULL,shipping_address_city=NULL,shipping_address_state=NULL,shipping_address_postalcode=NULL,shipping_address_country=NULL,parent_id=’’,sic_code=NULL,campaign_id=’’,=NULL,=NULL,=NULL,=NULL,='DE',=NULL,``=NULL
WHERE accounts.id = ‘90d469ee-45bc-e683-90eb-56420c749b9b’ AND deleted=0: MySQL error 1054: Unknown column ‘’ in ‘field list’

Quick Repair & rebuild doesn’t helped.

8

I just figured out that activating the developper mode seems the prevent the issue from happening. It might be cache related or something…

Still looking for a real solution because i m stuck with my slow developper mode.

9

Upgrading from 7.4.0 to 7.4.1 seems to help.

Can’t find the release notes to see if this error is mentioned.

10

Hi Guys,

Dethlefs, Good to hear that the Upgrade has resolved it!. You can find the current release information here: https://suitecrm.com/forum/announcements/6994-suitecrm-7-4-1-released#25223

pac, If turning on Developer mode resolves this, then it likely is a caching issue.
If you turn off Developer mode, Clear your Browser’s cache, Press CTRL+F5 and try it again. If it works then it is probably a cache issue.

It may be worth your while upgrading to 7.4.1 and seeing if this resolves it. 7.4.1 is a bugfix release, so it may be resolved by upgrading.

11

Hi John,

Already tried the Crlt+ F5 multiple time. I ve just updated to 7.4.1 and turned off the developper mode. Looks better but i need more time to be sure. I let you guys know how it turns.

12

5 days of test later. nobody complains anymore. So install 7.4.1 + quick rebuild made it !

thanks