I am not able to save the data in the sheetnode spreadsheet when I am logged on with a non admin account.

Comments

infojunkie’s picture

Make sure the non-admin user belongs to a group for whom the sheetnode permissions "create sheetnode" and "edit own sheetnode" are set. Does that apply to your case?

nehagupt’s picture

By group, do you mean role? The role does have "create sheetnode" and "edit own sheetnode" perms and still does not save.

infojunkie’s picture

Does that happen on all your machines or just the one that failed for #534534: Sheetnode Spreadsheet not showing up ?

LightTraveller’s picture

Component: Code » Core

I wish this thread had continued. I am able to create a sheetnode and save it. But I'm having a problem saving it again after any editing. Perms are set, but the problem persists even logged in as admin. I Edit the node, make a change, and Save the node. It's not saving changes and it's throwing a query error:

user warning: Duplicate entry '9' for key 1 query: INSERT INTO sheetnode (nid, vid, value) VALUES (9, 9, 's:814:\"socialcalc:version:1.0\r\nMIME-Version: 1.0\r\nContent-Type: multipart/mixed; boundary=SocialCalcSpreadsheetControlSave\r\n--SocialCalcSpreadsheetControlSave\r\nContent-type: text/plain; charset=UTF-8\r\n\r\n# SocialCalc Spreadsheet Control Save\r\nversion:1.0\r\npart:sheet\r\npart:edit\r\npart:audit\r\n--SocialCalcSpreadsheetControlSave\r\nContent-type: text/plain; charset=UTF-8\r\n\r\nversion:1.5\r\ncell:A1:t:test\r\ncell:B1:t:data\r\ncell:C1:t:here\r\ncell:A2:t:more\r\ncell:B2:t:data\r\ncell:C2:t:here\r\nsheet:c:3:r:2\r\n--SocialCalcSpreadsheetControlSave\r\nContent-type: text/plain; charset=UTF-8\r\n\r\nversion:1.0\r\nrowpane:0:1:36\r\ncolpane:0:1:12\r\necell:D2\r\nsort::-1:up::::\r\n--SocialCalcSpreadsheetControlSave\r\nContent-type: text/plain; charset=UTF-8\r\n\r\nset A2 text t more\r\nset B2 text t data\r\nset C2 text t here\r\n--SocialCalcSpreadsheetControlSave--\r\n\";') in /home/ericschm/public_html/sandbox2/sites/all/modules/sheetnode/sheetnode.module on line 364.

Does that give you any ideas of what is wrong or what I should check?

Thanks in advance!

-Eric

LightTraveller’s picture

Forgive me, I see this is answered in http://drupal.org/node/638468

Thanks!!!

-Eric

infojunkie’s picture

Status: Active » Closed (fixed)

Closed unless OP still encounters the problem.