Attempting to create a tikisheet results in DB error
- Status
- Closed
- Subject
- Attempting to create a tikisheet results in DB error
- Version
- 7.x
- Category
- Error
- Feature
- Spreadsheet
- Submitted by
- tvader
- Volunteered to solve
- Philippe Cloutier
- Lastmod by
- tvader
- Rating
- Description
Trying to create a spreadsheet results in DB error.
Incorrect integer value: '' for column 'parentSheetId' at row 1
La requête était :
INSERT INTO `tiki_sheets` ( `title`, `description`, `author`, `parentSheetId` ) VALUES( ?, ?, ?, ? )Valeurs :
Probo
adminLa requête construite était probablement :
INSERT INTO `tiki_sheets` ( `title`, `description`, `author`, `parentSheetId` ) VALUES( 'Probo', , 'admin', )Stacktrace :
- C:\inetpub\wwwroot\tiki\7.2\tiki-sheets.php : 0 -> {main}(array ( ))
- C:\inetpub\wwwroot\tiki\7.2\tiki-sheets.php : 98 -> replace_sheet(array ( ))
- C:\inetpub\wwwroot\tiki\7.2\lib\sheet\grid.php : 2358 -> query(array ( ))
- C:\inetpub\wwwroot\tiki\7.2\lib\core\TikiDb\Bridge.php : 29 -> query(array ( ))
- C:\inetpub\wwwroot\tiki\7.2\lib\core\TikiDb\Pdo.php : 120 -> handleQueryError(array ( ))
- C:\inetpub\wwwroot\tiki\7.2\lib\core\TikiDb.php : 150 -> handle(array ( ))
- Solution
Chealer: I reproduced this on Tiki 7.2 on Windows. This is probably specific to MySQL running in strict mode.
I could not reproduce the issue on trunk (future Tiki 8), so I assume this was fixed.
Thanks for reporting and please reopen if you experience this in Tiki 8 or later.- Importance
- 6
- Priority
- 30
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is currently unavailableUnable to connect to show.tikiwiki.org. Please let us know of the problem so that we can do something about it. Thanks.
- Ticket ID
- 3908
- Created
- Wednesday 01 June, 2011 18:47:54 UTC
by tvader - LastModif
- Thursday 29 September, 2011 21:28:30 UTC