SugarCRM Forums - Installation and Upgrade Help

Cannot load DB manager

shoover56 — Sun, 19 May 2013 03:44:17 GMT

Hello everybody. I get this error while attempting to install after I hit 'Next' when specifying the admin username and admin password.

Was upgrading from 6.5.12 to 6.5.13

How should I approach fixing this? Thanks.

upgrade failure with browser crash at upgrade_connectors_end how to recover or finish

battle — Fri, 17 May 2013 15:06:56 GMT

I'm trying to upgrade 6.2.4 to 6.4.1 in order to restore a database from a failed upgrade of 6.4.1 to 6.5.9.

The upgrade from 6.2.x to 6.3.2 was successful.
The upgrade from 6.3.x to 6.4.1 failed.

There seems to be a loop that caused the upgrade wizard to crash and Safari 5.0.5 on OSX 10.6.8 to crash.

The last few lines of the upgradWizard.log are pasted below.

Presumably this is a problem going forward since there was no unlinking from previous upgrade, update of the license, unlinking from TempFiles(), remove directories, finish notice, and clean up notice, and resetting of the $_SESSION var.

Is there a way to finish the upgrade manually from a command line, etc....

Thanks,
Battle

log portion, see loop on upgrading connectors below.
Fri, 17 May 2013 10:00:14 -0400 [UpgradeWizard] - Layout Commits completed successfully
Fri, 17 May 2013 10:00:24 -0400 [UpgradeWizard] - setting session variables...
Fri, 17 May 2013 10:00:26 -0400 [UpgradeWizard] - [At end.php]
Fri, 17 May 2013 10:00:26 -0400 [UpgradeWizard] - About to repair the database.
Fri, 17 May 2013 10:00:28 -0400 [UpgradeWizard] - Running sql:/* Table : users */
/*COLUMNS*/
/*MISSING IN DATABASE - show_on_employees - ROW*/
/* INDEXES */
ALTER TABLE users add COLUMN show_on_employees bool DEFAULT '1' NULL

Fri, 17 May 2013 10:00:29 -0400 [UpgradeWizard] - database repaired
Fri, 17 May 2013 10:00:29 -0400 [UpgradeWizard] - Start Rebuilding the config file again
Fri, 17 May 2013 10:00:29 -0400 [UpgradeWizard] - Finish Rebuilding the config file again
Fri, 17 May 2013 10:00:29 -0400 [UpgradeWizard] - Upgrading multienum data
Fri, 17 May 2013 10:00:29 -0400 [UpgradeWizard] - Begin upgrade_connectors
Fri, 17 May 2013 10:00:29 -0400 [UpgradeWizard] - End upgrade_connectors
Fri, 17 May 2013 10:00:38 -0400 [UpgradeWizard] - setting session variables...
Fri, 17 May 2013 10:00:40 -0400 [UpgradeWizard] - [At end.php]
Fri, 17 May 2013 10:00:40 -0400 [UpgradeWizard] - About to repair the database.
Fri, 17 May 2013 10:00:42 -0400 [UpgradeWizard] - database repaired
Fri, 17 May 2013 10:00:42 -0400 [UpgradeWizard] - Start Rebuilding the config file again
Fri, 17 May 2013 10:00:42 -0400 [UpgradeWizard] - Finish Rebuilding the config file again
Fri, 17 May 2013 10:00:42 -0400 [UpgradeWizard] - Upgrading multienum data
Fri, 17 May 2013 10:00:42 -0400 [UpgradeWizard] - Begin upgrade_connectors
Fri, 17 May 2013 10:00:42 -0400 [UpgradeWizard] - End upgrade_connectors
Fri, 17 May 2013 10:00:52 -0400 [UpgradeWizard] - setting session variables...
Fri, 17 May 2013 10:00:53 -0400 [UpgradeWizard] - [At end.php]
Fri, 17 May 2013 10:00:53 -0400 [UpgradeWizard] - About to repair the database.
Fri, 17 May 2013 10:00:56 -0400 [UpgradeWizard] - database repaired
Fri, 17 May 2013 10:00:56 -0400 [UpgradeWizard] - Start Rebuilding the config file again
Fri, 17 May 2013 10:00:56 -0400 [UpgradeWizard] - Finish Rebuilding the config file again
Fri, 17 May 2013 10:00:56 -0400 [UpgradeWizard] - Upgrading multienum data
Fri, 17 May 2013 10:00:56 -0400 [UpgradeWizard] - Begin upgrade_connectors
Fri, 17 May 2013 10:00:56 -0400 [UpgradeWizard] - End upgrade_connectors
Fri, 17 May 2013 10:01:05 -0400 [UpgradeWizard] - setting session variables...
Fri, 17 May 2013 10:01:06 -0400 [UpgradeWizard] - [At end.php]
Fri, 17 May 2013 10:01:06 -0400 [UpgradeWizard] - About to repair the database.
Fri, 17 May 2013 10:01:09 -0400 [UpgradeWizard] - database repaired
Fri, 17 May 2013 10:01:09 -0400 [UpgradeWizard] - Start Rebuilding the config file again
Fri, 17 May 2013 10:01:09 -0400 [UpgradeWizard] - Finish Rebuilding the config file again
Fri, 17 May 2013 10:01:09 -0400 [UpgradeWizard] - Upgrading multienum data
Fri, 17 May 2013 10:01:09 -0400 [UpgradeWizard] - Begin upgrade_connectors
Fri, 17 May 2013 10:01:09 -0400 [UpgradeWizard] - End upgrade_connectors

Installation problems - Navigation not working

karraway2 — Tue, 14 May 2013 10:37:12 GMT

I just installed SugarCRM CE onto my hosted site through Jumba. Upon completion i had the much discussed graphics issues. Searching i found a page regarding permissions and passed this on to the techs at Jumba to make some changes. They did so and i could access the crm program as it is meant to be shown.

However i started wondering where the features such as calendar are and how to add meetings etc,,, After many many hours of scratching my head and searching online i realise there is a major problem in that the navigation is stuck on Sales and i can't even click on the marketing button nor support, activities etc (can't see other modules listed either). For the life of me I can't find the problem anywhere else on the web and desperately seek your help.

I do notice also that when i click on home a thinking box comes up witht he word undefined, then when it displays the home screen i get a pop up box in the software titled undefined with the following written in the box:

{"content":"\n

Please help....

Regards
Andrew

Install problem

LaFortuna — Mon, 13 May 2013 07:11:09 GMT

Hello,

I copied an existing install from a backup into a new server. When trying to navegate to the application I see the following error:

Code:

Warning: require_once(include/HTMLPurifier/HTMLPurifier.autoload.php) [function.require-once]: failed to open stream: No such file or directory in /home/mycompany/public_html/clients/client/sugar/include/clean.php on line 39



Fatal error: require_once() [function.require]: Failed opening required 'include/HTMLPurifier/HTMLPurifier.autoload.php' (include_path='/home/mycompany/public_html/clients/client/sugar/include/HTMLPurifier/standalone:/home/mycompany/public_html/clients/client/sugar/include/..:.:/usr/lib/php:/usr/local/lib/php') in /home/mycompany/public_html/clients/client/sugar/include/clean.php on line 39

Google couldn't help me this time around....

Error when upgrading from 6.4.4 to 6.5.12

mamboleo — Sun, 12 May 2013 23:50:10 GMT

I am getting the following errors when I tried to upgrade from 6.4.4 to 6.5.12, via the upgrade wizard. I am running MySSQL db on Windows Server 2008.

Warning: include(include/MVC/preDispatch.php) [function.include]: failed to open stream: No such file or directory in C:\Inetpub\vhosts\....\httpdocs\index.php on line 39

Warning: include(include/MVC/preDispatch.php) [function.include]: failed to open stream: No such file or directory in C:\Inetpub\vhosts\...\httpdocs\index.php on line 39

Warning: include() [function.include]: Failed opening 'include/MVC/preDispatch.php' for inclusion (include_path='.;./includes;./pear') in C:\Inetpub\vhosts\...\httpdocs\index.php on line 39

Warning: require_once(include/HTMLPurifier/HTMLPurifier.standalone.php) [function.require-once]: failed to open stream: No such file or directory in C:\Inetpub\vhosts\...\httpdocs\include\clean.php on line 38

Fatal error: require_once() [function.require]: Failed opening required 'include/HTMLPurifier/HTMLPurifier.standalone.php' (include_path='C:\Inetpub\vhosts\...\httpdocs\incl ude/..;.;./includes;./pear') in C:\Inetpub\vhosts\...\httpdocs\include\clean.php on line 38

Any help will be very much appreciated.

Thank you.

On Premises Hardening Guide?

mdisher@seapine.com — Thu, 09 May 2013 01:15:09 GMT

Is there an On Premises Hardening guide or best practices guide?

We assume standard IIS lock-down procedures but we don't want to do anything that's unnecessary and hurts performance.

I assume we should nuke the install directory at the least, anything else?

Kinda shocked my google-fu turned up nadda.

-MD

Should I virtualise Ubuntu server?

morecw — Sun, 05 May 2013 21:45:31 GMT

Hi all,

I'm planning to make the leap from Windows 2008 to Ubuntu 12.04 LTS Server as I'm sick of the poor performance issues of Windows.

This server will be dedicated to hosting OTRS and SugarCRM CE for 10-20 agents/users (plus 5 OTRS customers at any one time).

Dell Poweredge R300
Quad Core Xeon L5410 (2.33GHZ)
8GB RAM

My question is: Should I install Ubuntu server directly on the server or within VMware (workstation 9), AND if so what is the ideal host o/s to run vmware on? Perhaps running on top of Ubuntu Desktop 12.04? I see the obvious vm benefits; snapshots, flexibility etc. but I don't want to risk compromising performance too much. Yes I will probably try both out anyway however I'm just interested in gathering some opinions from some experts out there.

Thanks in advance for any advice.

Morecw

Installation of SugarCE-6.5.12 Unauthorized access to administration

vbondoux — Tue, 30 Apr 2013 12:46:06 GMT

Hi,

I tried to install on OVH pro hosting SugarCE-6.5.12, at the last level of installation, the installation stop and the error :

Creating Sugar application tables, audit tables and relationship metadata
.................Unauthorized access to administration.

I verified that the tables begin to be created and just those tables re created :

acl_actions
acl_roles
bugs
bugs_audit
campaigns
campaigns_audit
campaign_log
campaign_trkrs
cases
cases_audit
emailman
email_marketing
leads
leads_audit
project
project_task
project_task_audit
prospects
prospect_lists
relationships
releases
users

Any idea to finish the install ?

Many thanks

How to find 6.0.1 and start upgrade path

sugar43geek — Fri, 26 Apr 2013 16:33:06 GMT

I was unable to upgrade an existing installation. SugarCRM had been installed using bitnami and wouldn't upgrade because the bitnami php installation did not have zip enabled--which was strange because other updates had gone OK. Since I needed a new serve installation anyway I backed up the database and reinstalled everything.

Now come to find out I can't just install the latest version of SugarCRM and use my existing DB.

Looks like upgrade_history in the DB backup is telling me my latest version is 6.0.1:

'Select * from upgrade_history" tells me inter alia:

Quote:

cache/upload/upgrades/patch/SugarCE-Upgrade-5.5.1-to-6.0.1.zip | f8509fd8cfb3db55578da9d0d05efdd2 | patch | installed | 6.0.1

So where do I download 6.0.1 so I can install it and start the upgrade path? I haven't been able to find it either on the SugarCRM site or on SourceForge and Googling it doesn't come up with any live links to download it.

AllowOverride-Sugar installation directory in httpd.conf

sugar43geek — Thu, 25 Apr 2013 18:12:47 GMT

The installation instructions say:

Quote:

Before you install Sugar, set AllowOverride to All for the Sugar installation directory in thehttpd.conf file.

(Sugar Community Edition 6.5.0 Installation Guide - SugarCRM Support Site)

Does one have to create this directory? It's not there before one installs SugarCRM..

Detailview of accounts is bugged

s.cohen.anyflex — Thu, 25 Apr 2013 09:05:21 GMT

Hi,

I just installed this awesome CRM, but I am having some problems. When I open the accounts page for detailed information, I get an error:

Actions: Create Account Create Account View Accounts View Accounts Import Accounts Import Accounts

{* /************************************************** ******************************* * SugarCRM Community Edition is a customer relationship management program developed by * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. * * This program is free software; you can redistribute it and/or modify it under * the terms of the GNU Affero General Public License version 3 as published by the * Free Software Foundation with the addition of the following permission added * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS. * * This program is distributed in the hope that it will be useful, but WITHOUT * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more * details. * * You should have received a copy of the GNU Affero General Public License along with * this program; if not, see Licenses - GNU Project - Free Software Foundation (FSF) or write to the Free * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA * 02110-1301 USA. * * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road, * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com. * * The interactive user interfaces in modified source and object code versions * of this program must display Appropriate Legal Notices, as required under * Section 5 of the GNU Affero General Public License version 3. * * In accordance with Section 7(b) of the GNU Affero General Public License version 3, * these Appropriate Legal Notices must retain the display of the "Powered by * SugarCRM" logo. If the display of the logo is not reasonably feasible for * technical reasons, the Appropriate Legal Notices must display the words * "Powered by SugarCRM". ************************************************** ******************************/ *} {* /************************************************** ******************************* * SugarCRM Community Edition is a customer relationship management program developed by * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. * * This program is free software; you can redistribute it and/or modify it under * the terms of the GNU Affero General Public License version 3 as published by the * Free Software Foundation with the addition of the following permission added * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS. * * This program is distributed in the hope that it will be useful, but WITHOUT * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more * details. * * You should have received a copy of the GNU Affero General Public License along with * this program; if not, see Licenses - GNU Project - Free Software Foundation (FSF) or write to the Free * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA * 02110-1301 USA. * * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road, * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com. * * The interactive user interfaces in modified source and object code versions * of this program must display Appropriate Legal Notices, as required under * Section 5 of the GNU Affero General Public License version 3. * * In accordance with Section 7(b) of the GNU Affero General Public License version 3, * these Appropriate Legal Notices must retain the display of the "Powered by * SugarCRM" logo. If the display of the logo is not reasonably feasible for * technical reasons, the Appropriate Legal Notices must display the words * "Powered by SugarCRM". ************************************************** ******************************/ *}

I have attached phpinfo()
phpinfo.zip

I hope someone can help me out. I have disabled the AjaxUI for accounts too, as it gives me an error.

Attached Files

phpinfo.zip (11.1 KB)

SugarCRM offline problem

pierre.hanauer@gmail.Com — Wed, 24 Apr 2013 13:17:07 GMT

Hello,

I have many problems installing the sugarCRM offline client on my windows 7 machine:

With the all-in-one client:

- i put all the information correctly in the setup and after a successfully installation, my account seams to be not valid and i can not login....
silent.log is clean
apache and mysql are installed correctly but in the database the user that should be used for the login is not inserted.
(i have tried to insert it by myself but i get problem during the sync after and i think it's not the way to do it :))

With a WAMP installing sugarcrm in offline mode:

- installation is fine providing the same information as the all-in-one client but the customs for the allowed modules are not syncronized.
i get a couple of logs in sugarcrm.log:
[FATAL] Query Failed: INSERT INTO fields_meta_data_cstm()
[FATAL] Query Failed: ALTER TABLE accounts_cstm add COLUMN varchar(255) NULL
[FATAL] Query Failed: ALTER TABLE contracts_cstm add COLUMN varchar(255) NULL
[FATAL] Query Failed: ALTER TABLE tasks_cstm add COLUMN varchar(255) NULL
[FATAL] Query Failed: SHOW INDEX FROM does_not_exist: MySQL error 1146: Table 'sugarcrm.does_not_exist' doesn't exist
[FATAL] Query Failed: INSERT INTO team_memberships_cstm() VALUES: MySQL error 1064
[FATAL] SYNC: An error has occurred:(0)

[FATAL] Response not of type text/xml: text/html

the server is using sugarcrm enterprise 6.5.12 and is fully accessible
the folders of sugarcrm are with the corrects rights.

i was using:

the all-in-on enterprise 6.5.0 offline client
or
the sugarcrm enterprise 6.5.12 on a WAMP server

At your disposition for more infomation, if you have any question.

Pierre

Install of SUGARCE 6.5.12 - Database Failure

ladaistok — Wed, 24 Apr 2013 08:35:25 GMT

Please can anybody help to me?
I am just trying to isntall fresh and new install of SugarCE 6.5.12.
Apache 2.2.8 and PHP 5.2.9-2 installed and working fine. I am trying to use SQL connetion to MS SQL Express 2005.
Before installation I created needed DB through SQL console - with some DBname and SQLUser - user is db_owner.
I made installation of Sugar but on the end I got error : Database failure refer sugarcrm.log
Here is what I found in the log:
04/24/13 10:19:56 [5020][-none-][FATAL] Failed to load user preferences Query Failed:SELECT contents FROM user_preferences WHERE assigned_user_id=N'seed_jim_id' AND category = N'global' AND deleted = 0::: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'user_preferences'.

04/24/13 10:19:56 [5020][-none-][FATAL] Retrieving record WHERE assigned_user_id = 'seed_jim_id' AND category = 'global' AND deleted=0: Query Failed:SELECT TOP 1 user_preferences.* FROM user_preferences WHERE assigned_user_id = N'seed_jim_id' AND category = N'global' AND deleted=0::: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'user_preferences'.
When I checked my database then I found that user_preferences table is missing.

Thanks for any idea.

J.