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
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- 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 not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 3908
- Created
- Wednesday 01 June, 2011 18:47:54 UTC
by tvader - LastModif
- Thursday 29 September, 2011 21:28:30 UTC