Upgrade wizard fails during system check (Error 404 page) from 7.7 tp 7.7.1

Aryeh · 11 August 2016 13:22

Ran Quick Repair and Rebuild, still no joy.

Please help

mikebeck · 11 August 2016 19:12

Check your logs you will find something there, suitecrm.log, sugarcrm.log, apache2/error.log

best regards

Aryeh · 12 August 2016 14:22

[b]Hi Mike,

Thank you for your response.

Small correction, page displayed after clickin 1st “Next” in upgrade is as follows:[/b]

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at webmaster@crm.planforsafety.co.uk to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Apache/2.4.23 (Unix) Server at crm.planforsafety.co.uk Port 80

Sugarcrm.log last updated Fri Sep 11 18:24:23 2015 - NO relevant entries

Suitcrm.log last entries
Wed Aug 10 10:22:01 2016 [20219][62f580f8-d03b-78cb-3ddc-55f4626f802a][FATAL] Exception in Controller: Index doesn’t exists in the specified directory.
Wed Aug 10 10:22:24 2016 [20527][62f580f8-d03b-78cb-3ddc-55f4626f802a][FATAL] Exception in Controller: Index doesn’t exists in the specified directory.
Wed Aug 10 13:50:13 2016 [34381][b0b2e744-9832-bf49-6e1d-55f40ffdf227][FATAL] Error running count query for Contact List: Query Failed: SELECT count(*) c FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c LEFT JOIN users jt0 ON contacts.modified_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 LEFT JOIN users jt1 ON contacts.created_by=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 LEFT JOIN users jt2 ON contacts.assigned_user_id=jt2.id AND jt2.deleted=0

AND jt2.deleted=0 LEFT JOIN contacts jt5 ON contacts.reports_to_id=jt5.id AND jt5.deleted=0

AND jt5.deleted=0 LEFT JOIN campaigns jt6 ON contacts.campaign_id=jt6.id AND jt6.deleted=0

AND jt6.deleted=0 where ((contacts.name LIKE ‘info@xn–tsukanovrtollection-xopxy.xn–om-nmc%’ OR contacts.id in ( select eab.bean_id from email_addresses ea, email_addr_bean_rel eab where ea.email_address = ‘info@xn–tsukanovrtollection-xopxy.xn–om-nmc’ and eab.email_address_id=ea.id and eab.bean_module = ‘Contacts’ and ea.deleted = 0 and eab.deleted = 0 )) ) AND contacts.deleted=0: MySQL error 1054: Unknown column ‘contacts.name’ in ‘where clause’
Wed Aug 10 13:50:20 2016 [34478][b0b2e744-9832-bf49-6e1d-55f40ffdf227][FATAL] Error running count query for Lead List: Query Failed: SELECT count(*) c FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c LEFT JOIN users jt0 ON leads.modified_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 LEFT JOIN users jt1 ON leads.created_by=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 LEFT JOIN users jt2 ON leads.assigned_user_id=jt2.id AND jt2.deleted=0

AND jt2.deleted=0 LEFT JOIN campaigns jt3 ON leads.campaign_id=jt3.id AND jt3.deleted=0

AND jt3.deleted=0 where ((leads.name LIKE ‘info@xn–tsukanovrtollection-xopxy.xn–om-nmc%’ OR leads.id in ( select eab.bean_id from email_addresses ea, email_addr_bean_rel eab where ea.email_address = ‘info@xn–tsukanovrtollection-xopxy.xn–om-nmc’ and eab.email_address_id=ea.id and eab.bean_module = ‘Leads’ and ea.deleted = 0 and eab.deleted = 0 )) ) AND leads.deleted=0: MySQL error 1054: Unknown column ‘leads.name’ in ‘where clause’

Cannot find apache2/error.log

Thank you

mikebeck · 12 August 2016 14:53

[quote]Exception in Controller: Index doesn’t exists in the specified directory.[/quote

do you have your permissions set correctly? what system you have?

best regards

Aryeh · 12 August 2016 15:25

CRM running on Web hosts server.

SuiteCrm 7.7

PHP 5.5

Rights set to 755

Regards,

Aryeh · 15 August 2016 13:22

Hi,

Just logged fault call with Web Host.

They report server error log as follows:
“crm.planforsafety.co.uk [Fri Aug 12 15:19:36 2016] [error] [client 77.103.186.188:41658] End of script output before headers: index.php”

Still not working.

Best Regards,
Aryeh

Aryeh · 16 August 2016 09:17

Update!!!

I have had 3rd line support at Web Host looking at this issue, following is response from them:

Hi Aryeh,

Thanks for your reply.

So the problem here is that there is a PHP timeout happening, as you can see by this error :

crm.planforsafety.co.uk [Mon Aug 15 20:18:47 2016] [error] [client 80.90.193.161:57791] End of script output before headers: index.php

I have tried to make adjustments to get this to complete but it has not worked -

max_execution_time = 1000
memory_limit=512M

I have set this above what they recommend there -

max_execution_time = 2000
memory_limit=1024M
post_max_size=60M
upload_max_filesize=60M
max_input_time=2000

Unfortunately, still getting the same error. Have you ever ran an upgrade on crm here before?

I am also worried here, with how long the script is taking to run, it may get flagged as a permanent process before it completes which would disable the site automatically.

Instead of upgrading, can you try reinstalling and then restoring?

Please advise

samus-aran · 16 August 2016 09:32

The Error End of script output before headers: index.php doesn’t sound like it is a limit as upgrades should not be that long especially since you are upgrading from 7.7.0 - to 7.7.1. This does sound like permissions rather than your php limits.

Recommend the following permissions settings.

sudo chown -R www-data:www-data .
sudo chmod -R 755 .
sudo chmod -R 775 cache custom modules themes data upload config_override.php

Also have a look at your upgradeWizard.log and see at what point is it failing.

If those permissions do not work then do 777 on the folder and try again.

Aryeh · 18 August 2016 13:03

Hi, I have received the following response from our Web Host support team:

Hi Aryeh,

Thanks for your patience.

I’ve tried all the changes suggested here but it’s failed to make a difference. We can’t perform their last suggestion of changing the permissions to 777, as this isn’t allowed on the server I’m afraid.

Should I try installing full package rather than upgrade?

Regards,
Aryeh

Aryeh · 18 August 2016 14:14

Just tried again.

upgradewizard.log shows the following:
Thu, 18 Aug 2016 15:08:54 +0100 [UpgradeWizard] - setting session variables…
Thu, 18 Aug 2016 15:08:54 +0100 [UpgradeWizard] - -----------------------------------------------------------------------------
Thu, 18 Aug 2016 15:08:54 +0100 [UpgradeWizard] - Upgrade started. At start.php
Thu, 18 Aug 2016 15:08:54 +0100 [UpgradeWizard] - at unlinkUWTempFiles()
Thu, 18 Aug 2016 15:08:54 +0100 [UpgradeWizard] - finished!
Thu, 18 Aug 2016 15:08:54 +0100 [UpgradeWizard] - resetting $_SESSION
Thu, 18 Aug 2016 15:08:57 +0100 [UpgradeWizard] - setting session variables…
Thu, 18 Aug 2016 15:08:57 +0100 [UpgradeWizard] - [At systemCheck.php]
Thu, 18 Aug 2016 15:08:57 +0100 [UpgradeWizard] - Starting file permission check…
Thu, 18 Aug 2016 15:10:28 +0100 [UpgradeWizard] - setting session variables…
Thu, 18 Aug 2016 15:10:28 +0100 [UpgradeWizard] - -----------------------------------------------------------------------------
Thu, 18 Aug 2016 15:10:28 +0100 [UpgradeWizard] - Upgrade started. At start.php
Thu, 18 Aug 2016 15:10:28 +0100 [UpgradeWizard] - at unlinkUWTempFiles()
Thu, 18 Aug 2016 15:10:28 +0100 [UpgradeWizard] - finished!
Thu, 18 Aug 2016 15:10:28 +0100 [UpgradeWizard] - resetting $_SESSION

Aryeh · 22 August 2016 09:49

OK Guys,

After trying everything sugested here and still no joy, I have downloaded the full 7.7.1 package and after unzipping, copied all the files to the server overwriting the existing files.

This has resolved the issue of the Calander but not the Upgrade Wizard issue.

I suppose I should realy reinstall properly to get it all working properly.

Any ideas???

Regards,
Aryeh