7.10.1 Edit no longer working

[dev77]

What a mess.

I just upgraded to 7.10.1 and now the Edit functions does not work on either Leads or Accounts.

I’ve looked at the permissions via FTP, I’ve done a Quick Repair and a Relationship Repair and a Javascript Repair… and it does not work.

Any idea how to fix this?

If you have not upgraded to 7.10.1… DON’T!!

[pgr]

I can’t reproduce this, on my test system I just successfully edited both a Lead and an Account.

What exactly do you edit? Do you use the Edit view, or inline edit? And what happens, is it ignored, or do you get an error?

Maybe you can also try it on the live demo to see if it looks different there

suitecrm.com/demo

[dev77]

I’ve been using Suite for a number of years now. I did the update to 7.10.1.

I pull up a record, click the Edit button… and nothing happens. Wherever the javascript is for this code… is not executing:

<input title="Edit" accessKey="i" class="button primary" onclick="var _form = document.getElementById('formDetailView'); _form.return_module.value='Accounts'; _form.return_action.value='DetailView'; _form.return_id.value='7aac6862-b01b-4a4b-e139-59ef929d4797'; _form.action.value='EditView';SUGAR.ajaxUI.submitForm(_form);" type="button" name="Edit" id="edit_button" value="Edit"> 

The only button that works is the Delete button in that it at least pops up a Javascript ‘alert’.

Most of the drop-down menu items don’t work either.

The site’s javascript is not working. I’ve tried to rebuild it but so far no luck.

I do a Quick Repair and at the end of the listing I get this:

/* Table : oauth2clients */
/COLUMNS/
/*MISMATCH WITH DATABASE - duration_value - ROW [name] => ‘duration_value’ [type] => ‘int’ [len] => ‘11’ /
/ VARDEF - duration_value - ROW[name] => ‘duration_value’ [type] => ‘integer’ [required] => ‘’ [reportable] => ‘’ [api-visible] => ‘’ [inline_edit] => ‘’ [dbType] => ‘integer’ [len] => ‘’ */
/*MISMATCH WITH DATABASE - duration_amount - ROW [name] => ‘duration_amount’ [type] => ‘int’ [len] => ‘11’ /
/ VARDEF - duration_amount - ROW[name] => ‘duration_amount’ [vname] => ‘LBL_DURATION_AMOUNT’ [type] => ‘integer’ [required] => ‘’ [reportable] => ‘’ [api-visible] => ‘’ [inline_edit] => ‘’ [dbType] => ‘integer’ [len] => ‘’ /
/ INDEXES */
ALTER TABLE oauth2clients modify COLUMN duration_value integer NULL , modify COLUMN duration_amount integer NULL ;

This update has totally hosed my entire Suite system.

Is there a way to do a re-install but keep the old database? If not, it looks like I’m done here.

Thanks.

[pgr]

You can track the database issue here
https://github.com/salesagility/SuiteCRM/issues/5404

Do you have any ERROR or FATAL messages in php_errors.log or in suitecrm.log?

Sometimes a single error can break lots of javascript, if it’s interrupting the screen generation…

[dev77]

@pgr

You can track the database issue here
7.10.1 – recurring database sync script when running Quick Repair and Rebuild · Issue #5404 · salesagility/SuiteCRM · GitHub

Do you have any ERROR or FATAL messages in php_errors.log or in suitecrm.log?

Sometimes a single error can break lots of javascript, if it’s interrupting the screen generation…

I’m not sure where to find the php_errors.log. There is no suitecrm.log only a sugarcrm.log and in it is:

Mon Mar 5 13:26:04 2018 [63085][1][FATAL] Query Failed: ALTER TABLE email_addresses ADD confirm_opt_in VARCHAR(255) DEFAULT ‘opt-in’ NULL: MySQL error 1060: Duplicate column name ‘confirm_opt_in’
Mon Mar 5 13:37:29 2018 [59905][1][FATAL] ERROR: rmdir_recursive(): argument cache/themes/SuiteP/modules is not a file or a dir.

If I go to any of the drop-down menus (Accounts, Leads, etc.) all I get is the gray box starting with:

SuiteCRM has been written and assembled by SalesAgility. The Program is provided AS IS, without warranty. Licensed under AGPLv3.

I started with Suite in 2014 right after Sugar dropped their community edition and I’ve never had the system break as badly as this update broke my install. Even Sugar never broke this badly.

I can bring up records from from the “My Accounts” dash-let on the home page, but I can’t edit it once it comes up,

I’ll try anything to get my system back.

It is a good thing I have a full backup using espocrm.com or I’d be in deep, deep trouble.

I like Suite better… but not today!!!

[pgr]

There is a fix for some of your errors on that GitHub Issue, maybe you can try them. They’re easy to apply manually.

[dev77]

I did the above new method to create a new intance (including the install) and things are working again in the clean install.

What a mess!

But it is good to have it working again.