Author Topic: [3.4.0.7] fresh install cannot create workspace  (Read 1741 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.