Author Topic: [3.4.0.7] fresh install cannot create workspace  (Read 1967 times)

Lupu

  • Newbie
  • *
  • Posts: 6
    • View Profile
[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)



Lupu

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: [3.4.0.7] fresh install cannot create workspace
« Reply #1 on: January 06, 2016, 07:26:49 AM »
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?

« Last Edit: January 06, 2016, 08:44:42 AM by Lupu »

FuturepIlot

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: [3.4.0.7] fresh install cannot create workspace
« Reply #2 on: February 08, 2016, 01:04:18 AM »
I'm having the same problem with a fresh install on Debian 8. Can you tell me how you modified the table? I'm not the best with MySQL.

dbastreghi

  • Newbie
  • *
  • Posts: 1
    • View Profile
    • Email
Re: [3.4.0.7] fresh install cannot create workspace
« Reply #3 on: May 31, 2017, 01:15:30 PM »
I'm facing the same problem. Lupo, please, could you give me more information?

Thanks!
-----

I found a solution. Use phpmyadmin to execute the SQL bellow (as root):

set global innodb_large_prefix=on;
set global innodb_file_format=barracuda;
set global innodb_file_per_table=true;
set global sql_mode=NO_ENGINE_SUBSTITUTION;
set global sql_mode=NO_ZERO_IN_DATE;
set global sql_mode=ERROR_FOR_DIVISION_BY_ZERO;
set global sql_mode=NO_AUTO_CREATE_USER;

Thanks (http://forum.fengoffice.com/index.php?topic=20915.0)
« Last Edit: May 31, 2017, 01:34:48 PM by dbastreghi »

 

anything