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
- Demonstrate Bug
-
This bug has been demonstrated on show2.tikiwiki.org
Please demonstrate your bug on show2.tikiwiki.org
Version: Create show2.tikiwiki.org instanceAbout show2.tikiwiki.org
To help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tikiwiki.org instance. To start, simply select a version and click on "Create show2.tikiwiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tikiwiki.org.
- Ticket ID
- 3908
- Created
- Wednesday 01 June, 2011 18:47:54 GMT-0000
- LastModif
- Thursday 29 September, 2011 21:28:30 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- Better Editor or at least better FADE function.
- Forum post preview deletes post content
- Update Tracker Field Types Page
- Extended support for additional user input controls like checkboxes and dropdowns (single/multi selections)
- Fivealive-lite theme options: wrong bg color of top menu bar on dev.tiki.org
;){kind=link}
;){kind=link}