Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Lupu

Pages: [1]
1
Installation problems / Re: Upgrade path to latest version?
« on: January 15, 2016, 01:35:32 AM »
Unfortunately I don't think you will have any luck upgrading FengOffice, the last 3 releases I
have tested are broken (3.4.0.7, 3.4, 3.3.0.4).
- Installer broken  and various bugs post-install.

Upgrades/migrations are more complex then fresh installs and I would not recommend a upgrade in this state.

But if you have some programming/sysadmin skills you could clone your installation and try some upgrade scenarios in a separate test VirtualMachine.


2
Installation problems / [3.4.0.7] Installer can't import sql data
« on: January 06, 2016, 01:39:41 PM »
I had to alter the sql schema in order to complete the install process (workspace and core plugin failed to import data)

Code: [Select]
- table: members
`description` TEXT,      ( -> removed NOT NULL )

- table: widgets
`path` varchar(512),     ( -> removed NOT NULL )
`default_options` text,  ( -> removed NOT NULL )


Later Edit:

Steps to reproduce:
Code: [Select]
# Ubuntu 14.04
apt update
apt upgrade
reboot
apt install apache2 php5 php5-gd php5-mysql php5-curl php5-xmlrpc
wget "http://downloads.sourceforge.net/project/opengoo/fengoffice/fengoffice_3.4.0.7/fengoffice_3.4.0.7.zip?r=&ts=1452165748&use_mirror=vorboss" -O fengoffice_3.4.0.7.zip
unzip fengoffice_3.4.0.7.zip -d /var/www/html/
chown www-data:www-data -R /var/www/html/fengoffice

// create mysql database feng collate utf8_general_ci on different server

Step 4 fails with 2 errors:
- Error while loading inital data for plugin 'core_dimensions'.Field 'description' doesn't have a default value
- Error while loading inital data for plugin 'workspaces'.Field 'path' doesn't have a default value

3
This is how the call trace looks like:

Code: [Select]
#0  DBQueryError->__construct(INSERT INTO fo_sharing_table (group_id,object_id) VALUES   ('','36') ON DUPLICATE KEY UPDATE fo_sharing_table.group_id=fo_sharing_table.group_id;, 1366, Incorrect integer value: '' for column 'group_id' at row 1) called at [/var/www/htdocs/environment/library/database/adapters/AbstractDBAdapter.class.php:395]
#1  AbstractDBAdapter->prepareAndExecute(INSERT INTO fo_sharing_table (group_id,object_id) VALUES   ('','36') ON DUPLICATE KEY UPDATE fo_sharing_table.group_id=fo_sharing_table.group_id;, ) called at [/var/www/htdocs/environment/library/database/adapters/AbstractDBAdapter.class.php:278]
#2  AbstractDBAdapter->execute(INSERT INTO fo_sharing_table (group_id,object_id) VALUES   ('','36') ON DUPLICATE KEY UPDATE fo_sharing_table.group_id=fo_sharing_table.group_id;, ) called at [/var/www/htdocs/environment/library/database/DB.class.php:145]
#3  DB::execute(INSERT INTO fo_sharing_table (group_id,object_id) VALUES   ('','36') ON DUPLICATE KEY UPDATE fo_sharing_table.group_id=fo_sharing_table.group_id;) called at [/var/www/htdocs/application/functions.php:1287]
#4  massiveInsert(fo_sharing_table, Array ([0] => group_id,[1] => object_id), Array ([0] => Array ([0] => ,[1] => 36)), 100,  ON DUPLICATE KEY UPDATE fo_sharing_table.group_id=fo_sharing_table.group_id;) called at [/var/www/htdocs/application/models/sharing_table/SharingTables.class.php:25]
#5  SharingTables->populateGroups(Array ([0] => ), 36) called at [/var/www/htdocs/application/models/ContentDataObjects.class.php:1306]
#6  ContentDataObjects::addObjToSharingTable(36, 1, 0) called at [/var/www/htdocs/application/models/ContentDataObject.class.php:1373]
#7  ContentDataObject->addToSharingTable() called at [/var/www/htdocs/application/models/DimensionObject.class.php:44]
#8  DimensionObject->addToSharingTable() called at [/var/www/htdocs/application/controllers/MemberController.class.php:935]
#9  MemberController->saveMember(Array ([dimension_id] => 2,[name] => ffff,[object_type_id] => 1,[parent_member_id] => 0,[color] => 0,[description] => ), Member Object ([] => ,[] => Array (),[] => ,[] => 1,[] => ,[] => ,[] => 1,[] => Array ([dimension_id] => 2,[name] => ffff,[object_type_id] => 1,[parent_member_id] => 0,[color] => 0,[description] => ,[depth] => 1,[object_id] => 36,[id] => 31),[] => Array ([0] => dimension_id,[1] => name,[2] => object_type_id,[3] => parent_member_id,[4] => color,[5] => description,[6] => depth,[7] => object_id,[8] => id),[] => Array ([id] => ),[] => Members Object ([] => members,[] => Array (),[] => Member,[] => 1),[] => Array ([0] => id,[1] => created_on,[2] => created_by_id,[3] => updated_on,[4] => updated_by_id),[] => ,[] => ,[] => )) called at [/var/www/htdocs/application/controllers/MemberController.class.php:478]
#10 MemberController->add() called at [/var/www/htdocs/environment/classes/controller/Controller.class.php:76]
#11 Controller->execute(add) called at [/var/www/htdocs/environment/classes/controller/PageController.class.php:62]
#12 PageController->execute(add) called at [/var/www/htdocs/environment/classes/Env.class.php:129]
#13 Env::executeAction(member, add) called at [/var/www/htdocs/init.php:177]
#14 require(/var/www/htdocs/init.php) called at [/var/www/htdocs/index.php:7]
#15 require(/var/www/htdocs/index.php) called at [/var/www/htdocs/public/index.php:9]


Later edit:

I found that `fo_contact_member_permissions` was missing 'workspace' type_id permission and now i can add new workspaces. (hint from ContentDataObjects.class.php:1291)

So there is certainly something wrong happening during the install process.
What do you guys think?


4
Installation problems / [3.4.0.7] fresh install cannot create workspace
« on: January 06, 2016, 07:06:44 AM »
Hello
After installing the latest version of FO I get the following error when adding new workspace:
Code: [Select]
Query failed with message 'Incorrect integer value: '' for column 'group_id' at row 1'
The mysql query is the following:
Code: [Select]
INSERT INTO fo_sharing_table (group_id,object_id) VALUES ('','30') ON DUPLICATE KEY UPDATE fo_sharing_table.group_id=fo_sharing_table.group_id;
Has anybody seen this before? or i am doing something wrong?
- ubuntu 14.04
- nginx version: nginx/1.4.6
- php5-fpm (php ver: 5.5.9)



5
Announcements / Re: OpenGoo 1.2 beta
« on: January 22, 2009, 05:40:33 PM »
thx, it works

6
Announcements / Re: OpenGoo 1.2 beta
« on: January 22, 2009, 04:55:19 PM »
How can I enable the spreadsheet editor?

Pages: [1]
anything