- edited description
SQL Error on creating first album
Issue #41
resolved
Hi,
I try to create a new album (the first one) in the storage folder under Filelist like in step 5 of your Users Manual When I try to save it I get the following error.
*2: SQL error: 'Incorrect integer value: '' for column 'parentalbum' at row 1' (sys_file_collection:NEW5909e790edf2b885401318) *
Did I miss some important configuration step?
Comments (9)
-
reporter
-
repo owner
What version of TYPO3 are you using?
-
reporter
I have tried it on v 7.6.18 as well as on 8.7.1.
My LAMP Server runs Ubutunt 16.04 with Apache 2.4.18, PHP 7.0.14 and MySQL 5.7.18
-
For me the same, I get the same error. Fresh Typo3: 8.7.2 fs_media_gallery: 1.4.5 (composer install) The error also occurs when there are albums.
For me this fixed my problem, I edited the file fs_media_gallery/Configuration/TCA/Overrides/sys_file_collection.php:
# This patch file was generated by NetBeans IDE # It uses platform neutral UTF-8 encoding and \n newlines. --- a/<html>sys_file_collection.php (<b>14.03.2017 21:21:09</b>)</html> +++ b/<html><b>Current File</b></html> @@ -10,6 +10,7 @@ 'size' => 12, 'max' => 20, 'eval' => 'datetime', + 'default' => 0, ] ], 'sorting' => [ @@ -61,7 +62,8 @@ 'size' => 10, 'autoSizeMax' => 20, 'minitems' => 0, - 'maxitems' => 1 + 'maxitems' => 1, + 'default' => 0, ] ], 'main_asset' => [ -
repo owner
Hi Oliver,
tnx for digging into this. could you create a PR for this?
Frans
-
Hi Frans,
yes I can Do, but how can I do this? I have SourceTree, do I need write access to this repo?
-
repo owner
Fork this repo Commit it to your fork Create a pull request
-
repo owner
- changed status to resolved
[BUGFIX] Ads default values to fields in sys_file_collection Fixes:
#41→ <<cset 8c275c806750>>
-
repo owner
Merged in oliver_hamburg/fs_media_gallery (pull request #19)
[BUGFIX] Ads default values to fields in sys_file_collection Fixes:
#41→ <<cset 41126ce27f98>>
- Log in to comment
