–– 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. 6 years 2 weeks ago #3643

  • rawfish66
  • rawfish66's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
Help :?)

:silly: Installation error:

nstalling Language Packs
Rebuilding Language...en_us
Installing layoutdefs extension
Installing vardefs extension
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...
Installing Images
Installing Relationships
Rebuilding Vardefs...
Rebuilding Layoutdefs...
Installing Bean : AOP_Case_Events
Table already exists : aop_case_events
Installing Bean : AOP_Case_Updates
Table already exists : aop_case_updates
Including: cache/upgrades/temp/FABA.tmp/scripts/post_install.php
Database failure. Please refer to sugarcrm.log for details.
The administrator has disabled public write access.

Database failure. 6 years 2 weeks ago #3645

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

Could you please post the details on the error in your sugarcrm.log file.
Software Support Engineer
SalesAgility - SugarCRM Consultants and Developers
The administrator has disabled public write access.

Database failure. 6 years 2 weeks ago #3652

  • rawfish66
  • rawfish66's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
I got working, now well sort of, I can create a "new case" in Joomola and it shows up in Sugar but the status does not, it stays blank."No data available in table".


I have created several with the result being the same no status in Joomola but the case shows up in Sugar. Can you point me in the direction of my error?
The administrator has disabled public write access.

Database failure. 6 years 2 weeks ago #3653

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

Please send a screenshot of the issue and attach it here, or post the sugarcrm.log file from your previous post if you are still getting errors.

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

Database failure. 6 years 2 weeks ago #3656

  • rawfish66
  • rawfish66's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
Here is the screenshot of the missing info in Joomola
Attachments:
The administrator has disabled public write access.

Database failure. 6 years 2 weeks ago #3657

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

You need to go into your contacts and create a portal user.

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

Database failure. 6 years 2 weeks ago #3658

  • rawfish66
  • rawfish66's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
Hi there,

I have done that as per the instruction but this problem is present. ANy other thoughts?
The administrator has disabled public write access.

Database failure. 6 years 2 weeks ago #3660

  • Will
  • Will's Avatar
  • Offline
  • Administrator
  • Posts: 953
  • Thank you received: 79
  • Karma: 0
Did you log into Joomla as that portal user and create a case? If not, please do so and post back on any progress.

Thanks.
Software Support Engineer
SalesAgility - SugarCRM Consultants and Developers
The administrator has disabled public write access.
The following user(s) said Thank You: rawfish66

Database failure. 6 years 2 weeks ago #3667

  • rawfish66
  • rawfish66's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
Hi I don't seem to have a "create portal user" tab any more. I created a fresh install of Sugar and reloaded the module and now there is no "create portal user" tab. I Have included some screen shots. please help :S

Cheers, Roy
Attachments:
The administrator has disabled public write access.

Database failure. 6 years 2 weeks ago #3670

  • rawfish66
  • rawfish66's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
Hi there,

Any thoughts on this?
Last Edit: 6 years 2 weeks ago by rawfish66.
The administrator has disabled public write access.

Database failure. 6 years 2 weeks ago #3671

  • rawfish66
  • rawfish66's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
please see my comments I don't seem to have a "create portal user" tab any more."
The administrator has disabled public write access.

Database failure. 6 years 2 weeks ago #3672

  • rawfish66
  • rawfish66's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
Hello as you can see in the attachment I missing the
duplicate>Delete>Find Duplicates> Manage Subscriptions> CREATE PORTAL >

How do I get the create portal to show up so I can finish configuring this baby?
Attachments:
Last Edit: 6 years 1 week ago by rawfish66.
The administrator has disabled public write access.

Database failure. 6 years 1 week ago #3674

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

To create a portal user, please follow the full user guide for AOP. You can access the user guide by clicking on the following link: Advanced OpenPortal (AOP) V1.0 User Guide. Please follow all steps and post back on progress.

Thanks.
Software Support Engineer
SalesAgility - SugarCRM Consultants and Developers
The administrator has disabled public write access.
The following user(s) said Thank You: rawfish66

Database failure. 6 years 1 week ago #3685

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

Did you find a solution to the portal issue you had?

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

Database failure. 5 years 11 months ago #3959

  • dpw
  • dpw's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
I am having a similar issue installing AOP on Sugar CE 6.5.15. Below is the output of the module installer, and below that is the sugarcrm.log entries.

[Module Install Output]

Installing Language Packs
Rebuilding Language...en_us
Installing layoutdefs extension
Installing vardefs extension
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...
Installing Images
Installing Relationships
Rebuilding Vardefs...
Rebuilding Layoutdefs...
Installing Bean : AOP_Case_Events
Table already exists : aop_case_events
Installing Bean : AOP_Case_Updates
Table already exists : aop_case_updates
Including: cache/upgrades/temp/aRjUEr/scripts/post_install.php
Database failure. Please refer to sugarcrm.log for details.

[sugarcrm.log]

Sat Oct 12 15:16:58 2013 [13196][1][FATAL] Error creating table: lg_portaluser: Query Failed: /* Table : lg_portaluser */
/* MISSING TABLE: lg_portaluser */
CREATE TABLE lg_portaluser (id char(36) NOT NULL ,name varchar(30) 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 ,password varchar(255) NULL ,status varchar(100) DEFAULT 'active' NULL ,role varchar(100) NULL , PRIMARY KEY (id), KEY idx_lg_portaluser_tmst_id (team_set_id)) CHARACTER SET utf8 COLLATE utf8_general_ci
: MySQL error 1072: Key column 'team_set_id' doesn't exist in table
Sat Oct 12 15:54:05 2013 [27929][1][FATAL] Failed to load original or custom subpanel data for aop_case_events in modules/AOP_Case_Events/metadata/subpanels/default.php
Sat Oct 12 15:54:05 2013 [27929][1][FATAL] Failed to load original or custom subpanel data for aop_case_updates in modules/AOP_Case_Updates/metadata/subpanels/default.php
Sat Oct 12 15:54:05 2013 [27929][1][FATAL] Failed to load original or custom subpanel data for aop_case_events in modules/AOP_Case_Events/metadata/subpanels/default.php
Sat Oct 12 15:54:05 2013 [27929][1][FATAL] Failed to load original or custom subpanel data for aop_case_updates in modules/AOP_Case_Updates/metadata/subpanels/default.php
Sat Oct 12 15:54:05 2013 [27929][1][FATAL] Failed to load original or custom subpanel data for aop_case_updates in modules/AOP_Case_Updates/metadata/subpanels/default.php
Sat Oct 12 15:54:11 2013 [27929][1][FATAL] Error creating table: lg_portaluser: Query Failed: /* Table : lg_portaluser */
/* MISSING TABLE: lg_portaluser */
CREATE TABLE lg_portaluser (id char(36) NOT NULL ,name varchar(30) 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 ,password varchar(255) NULL ,status varchar(100) DEFAULT 'active' NULL ,role varchar(100) NULL , PRIMARY KEY (id), KEY idx_lg_portaluser_tmst_id (team_set_id)) CHARACTER SET utf8 COLLATE utf8_general_ci
: MySQL error 1072: Key column 'team_set_id' doesn't exist in table
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Time to create page: 0.134 seconds
Powered by Kunena Forum