Bug #55380
SQL Error when choosing flexform file
| Status: | Closed | Start date: | 2014-01-28 | |
|---|---|---|---|---|
| Priority: | Won't have this time | Due date: | ||
| Assigned To: | - | % Done: | 0% |
|
| Category: | General Bugs | Spent time: | - | |
| Target version: | - | |||
| TYPO3 Version: | 6.2 | Patch is reviewed: | No | |
| PHP Version: | 5.4 | Reporter: | ||
| Has patch: | No |
Description
I've created a XML file (utf8, LF) and stored it within my fileadmin. Then I've chosen this file as flexform configuration file for one of my CE backend layouts. As soon as I hit the save button I'm getting the following error message:
exec_INSERTquery
caller: TYPO3\CMS\Core\Database\DatabaseConnection::exec_INSERTquery
ERROR: Column 'ref_table' cannot be null
lastBuiltQuery: INSERT INTO sys_refindex (tablename,recuid,field,flexpointer,softref_key,softref_id,sorting,deleted,ref_table,ref_uid,ref_string,hash) VALUES ('tx_gridelements_backend_layout','2','pi_flexform_ds_file','','','','0','0',NULL,NULL,'','9ff45e33a244b2c715eb11aaa97d527a')
debug_backtrace: TYPO3\CMS\Backend\Controller\EditDocumentController->processData#48 // TYPO3\CMS\Core\DataHandling\DataHandler->process_datamap#497 // TYPO3\CMS\Core\DataHandling\DataHandler->updateDB#1222 // TYPO3\CMS\Core\DataHandling\DataHandler->updateRefIndex#5808 // TYPO3\CMS\Core\Database\ReferenceIndex->updateRefIndexTable#5965 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_INSERTquery#120 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#206
I don't know if this problem is related to TYPO3 6.2beta4 or gridelements. What do you think?
Related issues
History
#1 Updated by Bernhard Kraft over 1 year ago
I experience the same problem when creating an image element from within EXT:news
#2 Updated by Gerrit Code Review over 1 year ago
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/27310
#3 Updated by Bernhard Kraft over 1 year ago
Could you try if the supplied patch also fixes the problem when a flexform is used?
#4 Updated by Gerrit Code Review over 1 year ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/27310
#5 Updated by Bjoern Jacob over 1 year ago
Thanks Bernhard. The patch works for me. I was able to store the file. Well done :) Yesterday, I've checked out the current master and applied the patch against it.
#6 Updated by Jo Hasenau over 1 year ago
- Category set to General Bugs
- Status changed from New to Closed
- Priority changed from Should have to Won't have this time
- PHP Version set to 5.4
Core problem, wont be fixed within GE
#7 Updated by Gerrit Code Review over 1 year ago
Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/27310
#8 Updated by Bjoern Jacob over 1 year ago
So what do I have to do to get this into the core? I can't move the ticket to the core. Or should I create a new one within the core project?
#9 Updated by Jo Hasenau over 1 year ago
As you can see, the patch is already made for Packages/TYPO3.CMS, so you just have to wait until the issues is fixed.
But of course you can test and review the patch to speed up that process. :-)
#10 Updated by Gerrit Code Review over 1 year ago
Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/27310
#11 Updated by Marc Bastian Heinrichs over 1 year ago
Fix will be handled with issue #56353 now. Please follow over there.