I have a node type with sheetnode and custom permissions for it, like this:

+--------------------------------------------+------------+------------+-------+
|                                            | anonymous  | authorized | admin |
+--------------------------------------------+------------+------------+-------+
| Create own value for field Spreadsheet     |            |            |   x   |
| Edit own value for field Spreadsheet       |            |            |   x   |
| Edit anyone's value for field Spreadsheet  |            |            |   x   |
| View own value for field Spreadsheet       |            |            |   x   |
| View anyone's value for field Spreadsheet  |            |            |   x   |
+--------------------------------------------+------------+------------+-------+

Authorized should be able to create this node type, but shouldn't see the spreadsheet.

Admin should be able to create this node type with spreadsheet, or edit node created by authorized user and see the spreadsheet.

However, authorized user sees the node type creation form and when he presses "Save" it doesn't save.
Admin can do anything and everything works for him.

In log I find following:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'field_rt_spreadsheet_name' cannot be null: INSERT INTO {field_data_field_rt_spreadsheet} (entity_type, entity_id, revision_id, bundle, delta, language, field_rt_spreadsheet_value, field_rt_spreadsheet_name) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7); Array
(
    [:db_insert_placeholder_0] => node
    [:db_insert_placeholder_1] => 8755
    [:db_insert_placeholder_2] => 17025
    [:db_insert_placeholder_3] => radiographic_testing
    [:db_insert_placeholder_4] => 0
    [:db_insert_placeholder_5] => und
    [:db_insert_placeholder_6] => socialcalc:version:1.0
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary=SocialCalcSpreadsheetControlSave
--SocialCalcSpreadsheetControlSave
Content-type: text/plain; charset=UTF-8

# SocialCalc Spreadsheet Control Save
version:1.0
part:sheet
part:edit
part:audit
--SocialCalcSpreadsheetControlSave
Content-type: text/plain; charset=UTF-8

version:1.5
cell:A1:t:Welder's stamp:f:1
cell:B1:t:Welded joint:f:1
cell:C1:t:Film marking:f:1
cell:D1:t:Thick�ness (mm):f:1
cell:E1:t:Subfocus distance (mm):f:1
cell:F1:t:Voltage (kV):f:1
cell:G1:t:Current (mA):f:1
cell:H1:t:Image quality:f:1
cell:I1:t:Exposu�re time (sec):f:1
cell:J1:t:Optical density:f:1
cell:K1:t:Defects:f:1
cell:L1:t:Accep�ted:f:1
cell:M1:t:Not accepted:f:1
sheet:c:13:r:1
font:1:normal bold * *
--SocialCalcSpreadsheetControlSave
Content-type: text/plain; charset=UTF-8

version:1.0
rowpane:0:1:36
colpane:0:1:16
ecell:J16
sort::1:up::::
--SocialCalcSpreadsheetControlSave
Content-type: text/plain; charset=UTF-8

insertcol I2
deletecol I2
insertcol J2
set J1 text t Optical density
--SocialCalcSpreadsheetControlSave--

    [:db_insert_placeholder_7] => 
)
 in function field_sql_storage_field_storage_write() (line 451 in file /var/www/html/modules/field/modules/field_sql_storage/field_sql_storage.module).

On some random occasions this doesn't happen and authorized user can add the node type.

Drupal 7.25, 2014-01-02
PHPExcel 1.7.7, 2012-05-19
Sheetnode 7.x-1.0-beta6
Socialcalc 2012-03-25 (according to README.txt)
TCPDF 6.0.053

Comments

willhallonline’s picture

Status: Active » Closed (cannot reproduce)

Can't reproduce and very old.