–– Support ––

Community Forum

This forum has now moved to https://suitecrm.com/forum

You can still use the forum below to look at historical SuiteCRM and SugarCRM issues and fixes.

Welcome, Guest
Username: Password:
Please post all questions or issues about AOP 1.x here
  • Page:
  • 1
  • 2

TOPIC: Database failure.

Database failure. 5 years 11 months ago #3963

  • Will
  • Will's Avatar
  • Offline
  • Administrator
  • Posts: 953
  • Thank you received: 79
  • Karma: 0
Hi dpw,

Which modules have you tried to install before installing AOP? The table lg_portaluser is not part of the AOP module.

Thanks,

Will.
Software Support Engineer
SalesAgility - SugarCRM Consultants and Developers
The administrator has disabled public write access.

Database failure. 5 years 10 months ago #4094

  • Bouwsma
  • Bouwsma's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 8
  • Karma: 0
Hey Will,

I too am having DB already exists errors. Seems to be related to previous failed installation related to assigned_user_id char(36). Please advise?

Nate

Tue Nov 5 15:01:08 2013 [21326][1][DEBUG] ModuleInstaller:Installing Bean : AOP_Case_Events
Tue Nov 5 15:01:08 2013 [21326][1][DEBUG] Creating Tables Bean : AOP_Case_Events
Tue Nov 5 15:01:08 2013 [21326][1][INFO] tableExists: aop_case_events
Tue Nov 5 15:01:08 2013 [21326][1][INFO] Query:SHOW TABLES LIKE 'aop_case_events'
Tue Nov 5 15:01:08 2013 [21326][1][INFO] Query Execution Time:0.00097298622131348
Tue Nov 5 15:01:08 2013 [21326][1][INFO] Query:CREATE TABLE aop_case_events (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,case_id char(36) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci
Tue Nov 5 15:01:08 2013 [21326][1][INFO] Query Execution Time:0.0096659660339355
Tue Nov 5 15:01:08 2013 [21326][1][FATAL] Error creating table: aop_case_events: Query Failed: CREATE TABLE aop_case_events (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,case_id char(36) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci: MySQL error 1050: Table '`sugarcrm`.`aop_case_events`' already exists
The administrator has disabled public write access.

Database failure. 5 years 10 months ago #4096

  • Will
  • Will's Avatar
  • Offline
  • Administrator
  • Posts: 953
  • Thank you received: 79
  • Karma: 0
Hi Bouwsma,

Please remove/drop any related AOP tables and try re-installing AOP. How did the installation fail previously?

Thanks,

Will.
Software Support Engineer
SalesAgility - SugarCRM Consultants and Developers
The administrator has disabled public write access.

Database failure. 5 years 10 months ago #4100

  • Bouwsma
  • Bouwsma's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 8
  • Karma: 0
That is the interesting part, I do not have any AOP tables left in my sugarcrm db. I had AOP installed prior but I disabled it, then later uninstalled. The uninstall hung but looked to complete. Trying to install it back is failing.
The administrator has disabled public write access.

Database failure. 5 years 10 months ago #4101

  • Will
  • Will's Avatar
  • Offline
  • Administrator
  • Posts: 953
  • Thank you received: 79
  • Karma: 0
Hi Bouwsma,

Which version of AOP did you have installed previously? Have you tried a quick repair & rebuild and rebuild relationships?

Thanks,

Will.
Software Support Engineer
SalesAgility - SugarCRM Consultants and Developers
The administrator has disabled public write access.

Database failure. 5 years 10 months ago #4102

  • Bouwsma
  • Bouwsma's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 8
  • Karma: 0
I have tried to get AOP going since 1.0 was launched. Had issues with the homepage issue I previously posted and ultimately didn't have time to get Joomla going so I placed it a ways back on my property list. I have tried everything I can think of to repair the app including quick repair, rebuild relationships,etc.
The administrator has disabled public write access.

Database failure. 5 years 10 months ago #4103

  • Bouwsma
  • Bouwsma's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 8
  • Karma: 0
Here is the quick repair. Note I have no reference of "aop" in mysql.

Clearing Vardefs from cache...done
Clearing language files from cache...done
Clearing Template files from cache...done
Clearing JS files from cache...done
Clearing Vardefs from cache...done
Clearing JS Language files from cache...done
Clearing language files from cache...done
Clearing Sugar Dashlet files from cache...done
Clearing Sugar Feed Cache...done
Clearing Smarty templates from cache...done
Clearing Theme Cache...done
Clearing XML files from cache...done
Clearing Unified Search Cache...done
Clearing External API Cache File...done
Rebuilding Extensions...
Rebuilding Include...
Rebuilding Language...en_us
Rebuilding ActionViewMap...
Rebuilding ActionFileMap...
Rebuilding ActionReMap...
Rebuilding Administration...
Rebuilding EntryPointRegistry...
Rebuilding Extensions...
Rebuilding FileAccessControlMap...
Rebuilding Layoutdefs...
Rebuilding GlobalLinks...
Rebuilding LogicHooks...
Rebuilding Menus...
Rebuilding Include...
Rebuilding ScheduledTasks...
Rebuilding UserPage...
Rebuilding Utils...
Rebuilding Vardefs...
Rebuilding JSGroupings...
Rebuilding DC Actions...
Rebuilding RelationshipsRebuilding TableDictionary...
Updating the admin warning message...
Rebuilding Audit Tables...
ACLAction not Audit Enabled...
ACLRole not Audit Enabled...
Relationship not Audit Enabled...
Audit table for Leads already exists. skipping...
Audit table for Cases already exists. skipping...
Audit table for Bugs already exists. skipping...
User not Audit Enabled...
CampaignLog not Audit Enabled...
Project not Audit Enabled...
Audit table for ProjectTasks already exists. skipping...
Audit table for Campaigns already exists. skipping...
ProspectList not Audit Enabled...
Prospect not Audit Enabled...
EmailMarketing not Audit Enabled...
CampaignTracker not Audit Enabled...
Release not Audit Enabled...
EmailMan not Audit Enabled...
Scheduler not Audit Enabled...
SchedulersJob not Audit Enabled...
Audit table for Contacts already exists. skipping...
Audit table for Accounts already exists. skipping...
Audit table for Opportunitys already exists. skipping...
EmailTemplate not Audit Enabled...
Note not Audit Enabled...
Call not Audit Enabled...
Email not Audit Enabled...
Meeting not Audit Enabled...
Task not Audit Enabled...
User not Audit Enabled...
Employee not Audit Enabled...
Currency not Audit Enabled...
Tracker not Audit Enabled...
ImportMap not Audit Enabled...
UsersLastImport not Audit Enabled...
Administration not Audit Enabled...
UpgradeHistory not Audit Enabled...
vCal not Audit Enabled...
Version not Audit Enabled...
Role not Audit Enabled...
Document not Audit Enabled...
DocumentRevision not Audit Enabled...
FieldsMetaData not Audit Enabled...
InboundEmail not Audit Enabled...
SavedSearch not Audit Enabled...
UserPreference not Audit Enabled...
MergeRecord not Audit Enabled...
EmailAddress not Audit Enabled...
EmailText not Audit Enabled...
SugarFeed not Audit Enabled...
EAPM not Audit Enabled...
OAuthKey not Audit Enabled...
OAuthToken not Audit Enabled...
Audit table for AOS_Contractss already exists. skipping...
Audit table for AOS_Invoicess already exists. skipping...
Audit table for AOS_PDF_Templatess already exists. skipping...
Audit table for AOS_Productss already exists. skipping...
Audit table for AOS_Products_Quotess already exists. skipping...
Audit table for AOS_Line_Item_Groupss already exists. skipping...
Audit table for AOS_Quotess already exists. skipping...
creating table aop_case_events_audit for AOP_Case_Events.
Database failure. Please refer to sugarcrm.log for details.
The administrator has disabled public write access.

Database failure. 5 years 10 months ago #4104

  • Will
  • Will's Avatar
  • Offline
  • Administrator
  • Posts: 953
  • Thank you received: 79
  • Karma: 0
Hi Bouwsma,

You received a database failure in your repair & rebuild. What does it state in your sugarcrm log?

Thanks,

Will.
Software Support Engineer
SalesAgility - SugarCRM Consultants and Developers
Last Edit: 5 years 10 months ago by Will.
The administrator has disabled public write access.

Database failure. 5 years 10 months ago #4105

  • Bouwsma
  • Bouwsma's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 8
  • Karma: 0
I see nothing in my current log for the aop_enents failure. Other related log items are freely flowing.
The administrator has disabled public write access.

Database failure. 5 years 10 months ago #4110

  • Will
  • Will's Avatar
  • Offline
  • Administrator
  • Posts: 953
  • Thank you received: 79
  • Karma: 0
Hi Bouwsma,

Which server are you running on, which version of sugar are you using and which version of AOP?

Thanks,

Will.
Software Support Engineer
SalesAgility - SugarCRM Consultants and Developers
The administrator has disabled public write access.

Database failure. 5 years 10 months ago #4111

  • Bouwsma
  • Bouwsma's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 8
  • Karma: 0
Ubuntu 12.0.4, SugarCRM Version 6.5.15 (Build 1083), Version 1.0 AOP
The administrator has disabled public write access.

Database failure. 5 years 10 months ago #4126

  • Will
  • Will's Avatar
  • Offline
  • Administrator
  • Posts: 953
  • Thank you received: 79
  • Karma: 0
Hi Bouwsma,

Have you tried installing AOP on a fresh version of SugarCRM? Can you do this and do you get the same issues? You mention you uninstalled it before and it hanged, and the uninstall may not have completed fully.

Thanks,

Will.
Software Support Engineer
SalesAgility - SugarCRM Consultants and Developers
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Time to create page: 0.106 seconds
Powered by Kunena Forum