Lampada iPortal 1.0.1 (CE) Not Working

[T3Kaos]

I have installed Lampada iPortal 1.0.1 (LampadaPortal_CE_1.0) and successfully activated it on SugarCE-6.3.1 however despite editing the iportal_config.php and adding a default user I am still receiving the following error;

The default portal user is not set, wrong with no access to any module, please edit the iportal_config.php

Also when I visit http://crm.z01.co.uk/iportal.php I get nothing but a blank page. Anyone know whats going on?

[Chris_C]

Could you try the new release - 2.0 - downloadable from Sugarforge ?

Post back with your results !

[T3Kaos]

Version 2.0 wouldn't install at all. It doesn't appear to be compatible with CE. Any reasons why?

[T3Kaos]

When I try to install v2.0 I get the following error;

Query Failed: ALTER TABLE lg_portaluser modify column name varchar(30) NULL , ADD INDEX idx_lg_portaluser_tmst_id (team_set_id): Database failure. Please refer to sugarcrm.log for details.

Tue Feb 7 00:07:17 2012 [32653][1][FATAL] Query Failed: ALTER TABLE lg_portaluser modify column name varchar(30) NULL , ADD INDEX idx_lg_portaluser_tmst_id (team_set_id): MySQL error 1072: Key column 'team_set_id' doesn't exist in table

This woud indicate that v2.0 isn't compatible with v2.0 due to CE lacking team_set_id as a table cat.

Any suggestions.

[andopes]

Version 2.0 wouldn't install at all. It doesn't appear to be compatible with CE. Any reasons why?

It was due an agreement with SugarCRM itself.

Lampada Portal only works on commercial editions.

Cheers

[Chris_C]

It was due an agreement with SugarCRM itself.

Lampada Portal only works on commercial editions.

Cheers

André - It's unfortunate you had to disable the SugarCRM CE compatibility for Lampada Portal !

You should update the Lampada Portal listing on Sugarforge:

Lampada Portal for SugarCRM simplifies the deployment of a portal for your customers, partners and other contacts. The Portal is compatible with SugarCRM CE, Professional and Enterprise.

[Chris_C]

When I try to install v2.0 I get the following error;

Query Failed: ALTER TABLE lg_portaluser modify column name varchar(30) NULL , ADD INDEX idx_lg_portaluser_tmst_id (team_set_id): Database failure. Please refer to sugarcrm.log for details.

Tue Feb 7 00:07:17 2012 [32653][1][FATAL] Query Failed: ALTER TABLE lg_portaluser modify column name varchar(30) NULL , ADD INDEX idx_lg_portaluser_tmst_id (team_set_id): MySQL error 1072: Key column 'team_set_id' doesn't exist in table

This woud indicate that v2.0 isn't compatible with v2.0 due to CE lacking team_set_id as a table cat.

Any suggestions.

1) Try the SalesAgility SugarCRM Joomla Case Portal. It says it works with SugarCRM CE.

SugarCRM Portal
Demo video: http://sugarcrmdemo.co.uk/sugarcrm%20portal%20demo.ogv

2) Try the Sales Agility Advanced Portal - says it works with CE - but it's not showing in the download list:
SugarForge: Developer Profile

Create and update cases, documents, get quotes, request services, track email dialogs, manage invoices, manage and request due diligence documents in authenticated Portal. Community Edition - requires OpenSales modules.

Might want to contact Sales Agility and see if they still can provide the Advanced Portal for SugarCE:
SugarCRM Manchester & Scotland

[Chris_C]

You should also check this thread - David O'Keefe, the developer of the Lampada Portal, talks about how to adapt the Lampada Portal 2.0 code to run properly on Sugar CE 6 - by removing references to the Sugar Pro-only "Teams" feature:

http://www.sugarcrm.com/forums/f6/la...e-6-1-a-67161/

[scottamericall]

It was due an agreement with SugarCRM itself.

Lampada Portal only works on commercial editions.

Cheers

I'm on CE 6.24 and attempted to load Lampada Portal version 2.0 (it was listed as ccompatible with CE), now my system reports a database failure. When I run the repair utility in admin it says there are differences between database and vardefs. When I execute the process as recommended it does not succeed.


/* Table : cases */
/*COLUMNS*/
/*MISSING IN DATABASE - - ROW*/
/* INDEXES */
ALTER TABLE cases add column f f DEFAULT 'f' NULL auto_increment,add column NULL ,add column NULL ;
/* Table : bugs */
/*COLUMNS*/
/*MISSING IN DATABASE - - ROW*/
/* INDEXES */
ALTER TABLE bugs add column f f DEFAULT 'f' NULL auto_increment,add column NULL ,add column NULL ;
/* Table : notes */
/*COLUMNS*/
/*MISSING IN DATABASE - - ROW*/
/* INDEXES */
ALTER TABLE notes add column f f DEFAULT 'f' NULL auto_increment,add column NULL ,add column NULL ;
/* 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;


The message I get is " Database failure. Please refer to sugarcrm.log for details". The log has repeating entries:


[16652][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone America/Los_Angeles. Please set date.timezone="America/Los_Angeles" in php.ini!
03/21/12 16:54:03 [16652][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone America/Los_Angeles. Please set date.timezone="America/Los_Angeles" in php.ini!
03/21/12 16:54:05 [16652][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone America/Los_Angeles. Please set date.timezone="America/Los_Angeles" in php.ini!


My php.ini looks like this:



;;;;;;;;;;;;;;;;;;;
; Module Settings ;
;;;;;;;;;;;;;;;;;;;

[Date]
; Defines the default timezone used by the date functions
;date.timezone = "America/Los_Angeles"

;date.default_latitude = 31.7667
;date.default_longitude = 35.2333

;date.sunrise_zenith = 90.583333
;date.sunset_zenith = 90.583333


So, I think it is properly set. Also, now I can see a list of cases but when I try to open one the page is completely blank? I could really use some help with this. Thanks!


.