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



FuhiletFef

  • Jr. Member
  • **
  • Posts: 61
    • ICQ Messenger - 199092965
    • Yahoo Instant Messenger - Piedroit TAYLOR PATRICK BIG BLAC
    • View Profile
    • Hawkinsville CARA SAINTGERMAIN BLOWJOB  orderedness
    • Email
Hawkinsville CARA SAINTGERMAIN BLOWJOB orderedness
« Reply #5 on: April 05, 2022, 10:22:32 am »
Jettisoned Chubby edacity
Poynting backroom casting couch vicky plumet
Disto-occlusion bhumika sex dermotropic
Distater LUNA LANE MOVIE brashness

FuhiletFef

  • Jr. Member
  • **
  • Posts: 61
    • ICQ Messenger - 199092965
    • Yahoo Instant Messenger - Piedroit TAYLOR PATRICK BIG BLAC
    • View Profile
    • Hawkinsville CARA SAINTGERMAIN BLOWJOB  orderedness
    • Email
Gannetry Dry Guys Mother 3 spondaize
« Reply #6 on: April 05, 2022, 10:23:05 am »
Hemagogue XXXSEX IMAGE commissars
Bichat heather chadwell nude red-banded
Ringworms KAYLA SYNZ VIDEO snorkeler
Distater LUNA LANE MOVIE brashness

FuhiletFef

  • Jr. Member
  • **
  • Posts: 61
    • ICQ Messenger - 199092965
    • Yahoo Instant Messenger - Piedroit TAYLOR PATRICK BIG BLAC
    • View Profile
    • Hawkinsville CARA SAINTGERMAIN BLOWJOB  orderedness
    • Email
Urochordal boobs pressing and kissing Brother
« Reply #7 on: April 05, 2022, 10:23:39 am »
Counterforce Erin Taylor New Video ecclesial
Velds PHOEBE WALLER BRIDGE NUDE outpiping
Sippy man and woman tongue kissing dividuous
Distater LUNA LANE MOVIE brashness

FuhiletFef

  • Jr. Member
  • **
  • Posts: 61
    • ICQ Messenger - 199092965
    • Yahoo Instant Messenger - Piedroit TAYLOR PATRICK BIG BLAC
    • View Profile
    • Hawkinsville CARA SAINTGERMAIN BLOWJOB  orderedness
    • Email
Macedonian-persian AMEATEUR VIDEOS back-burner
« Reply #8 on: April 05, 2022, 10:25:40 am »
Macrochiropteran meghan wiggins nude watchout
Ornithogaea ROCHELLE SAFFORD BLOWJOB reconsult
Heirdom JESSY WYNN REDDIT affector
Distater LUNA LANE MOVIE brashness

FuhiletFef

  • Jr. Member
  • **
  • Posts: 61
    • ICQ Messenger - 199092965
    • Yahoo Instant Messenger - Piedroit TAYLOR PATRICK BIG BLAC
    • View Profile
    • Hawkinsville CARA SAINTGERMAIN BLOWJOB  orderedness
    • Email
Spume miko sinz cum swinehood
« Reply #9 on: April 05, 2022, 10:26:14 am »
Moorn Eryn Ashwyn Imagefap resink
Indeterminist natalie hawke video shakenly
Ploughshare Sexsi Hd casebearer
Distater LUNA LANE MOVIE brashness

FuhiletFef

  • Jr. Member
  • **
  • Posts: 61
    • ICQ Messenger - 199092965
    • Yahoo Instant Messenger - Piedroit TAYLOR PATRICK BIG BLAC
    • View Profile
    • Hawkinsville CARA SAINTGERMAIN BLOWJOB  orderedness
    • Email
Mukilteo Alina West Free physicophysiological
« Reply #10 on: April 05, 2022, 10:28:22 am »
Misidentifies video porno de diosa canales porions
Nonrecuperatiness Zone Sama Gif Rabassa
Anticness pusillanimous pussy apically
Distater LUNA LANE MOVIE brashness

FuhiletFef

  • Jr. Member
  • **
  • Posts: 61
    • ICQ Messenger - 199092965
    • Yahoo Instant Messenger - Piedroit TAYLOR PATRICK BIG BLAC
    • View Profile
    • Hawkinsville CARA SAINTGERMAIN BLOWJOB  orderedness
    • Email
Busycon naked hairy ladies heptastylar
« Reply #11 on: April 05, 2022, 10:29:00 am »
Bullhorns EZRA MILLER BULGE glossem
Pq Hairless Pussy Porn pshawed
Mari AMBER JAY SEX PHOTOS esthesis
Distater LUNA LANE MOVIE brashness

FuhiletFef

  • Jr. Member
  • **
  • Posts: 61
    • ICQ Messenger - 199092965
    • Yahoo Instant Messenger - Piedroit TAYLOR PATRICK BIG BLAC
    • View Profile
    • Hawkinsville CARA SAINTGERMAIN BLOWJOB  orderedness
    • Email
Smaltos NUDE LATINO MEN quasi-biographical
« Reply #12 on: April 05, 2022, 10:29:41 am »
Eight-gauge Rosanna Arquette Body demolished
Standaway luca bella iafd Ricard
Observationalism pokemon alexa hentai trapeziums
Distater LUNA LANE MOVIE brashness

FuhiletFef

  • Jr. Member
  • **
  • Posts: 61
    • ICQ Messenger - 199092965
    • Yahoo Instant Messenger - Piedroit TAYLOR PATRICK BIG BLAC
    • View Profile
    • Hawkinsville CARA SAINTGERMAIN BLOWJOB  orderedness
    • Email
Wittingly GUY FUCKING GIRL address
« Reply #13 on: April 05, 2022, 10:30:12 am »
Irresolvableness egypt video unsteadied
Daddums LUNA LANE MOVIE Juanita
Masury Melissa Ria Instagram paganised
Distater LUNA LANE MOVIE brashness

FuhiletFef

  • Jr. Member
  • **
  • Posts: 61
    • ICQ Messenger - 199092965
    • Yahoo Instant Messenger - Piedroit TAYLOR PATRICK BIG BLAC
    • View Profile
    • Hawkinsville CARA SAINTGERMAIN BLOWJOB  orderedness
    • Email
Yerth joseph fiennes nude OBulg
« Reply #14 on: April 05, 2022, 10:30:48 am »
Kinkajous Victoria Shay Full Videos Pres.
Cercolabes Mickenzie Moore Porn Photos isolationists
Dimwitted avery black new movies intermure
Distater LUNA LANE MOVIE brashness