5.6.3.1 Problem Assigning File to Fileset
Permalink
Hello good people!
I am hoping someone could point me in the right direction. A client with an older install of 5.6.3.1 has suddenly started having a problem with assigning files to a fileset. The underlying problem is a database error:
I found this post which claims there is a fix:
https://www.concrete5.org/developers/bugs/5-6-3-1/mysql-5.6-error-wh...
...but can not find the pull request. I also found this post with no resolution:
https://www.concrete5.org/community/forums/chat/adding-files-to-file...
If anyone can point me in the right direction, it would be greatly appreciated.
Thanks in advance!
Alex
PS - The environment is like so:
I am hoping someone could point me in the right direction. A client with an older install of 5.6.3.1 has suddenly started having a problem with assigning files to a fileset. The underlying problem is a database error:
Exception Occurred: /home/website/new.mywebsite.com/updates/concrete5.6.3.1_updater/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 mysqlt error: [1048: Column 'timestamp' cannot be null] in EXECUTE("INSERT INTO FileSetFiles(fsfID,fID,fsID,timestamp,fsDisplayOrder) VALUES (NULL,'326','22',NULL,'0')") (1048) #0 /home/website/new.mywebsite.com/updates/concrete5.6.3.1_updater/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw('mysqlt', 'EXECUTE', 1048, 'Column 'timesta...', 'INSERT INTO Fil...', false, Object(ADODB_mysqlt)) #1 /home/website/new.mywebsite.com/updates/concrete5.6.3.1_updater/concrete/libraries/3rdparty/adodb/adodb.inc.php(1030): ADOConnection->_Execute('INSERT INTO Fil...') #2 /home/website/new.mywebsite.com/updates/concrete5.6.3.1_updater/concrete/libraries/3rdparty/adodb/adodb-active-record.inc.php(775): ADOConnection->Execute('INSERT INTO Fil...', Array) #3 /home/website/new.mywebsite.com/updates/concrete5.6.3.1_updater/concrete/libraries/3rdparty/adodb/adodb-active-record.inc.php(739): ADODB_Active_Record->Insert() #4 /home/website/new.mywebsite.com/updates/concrete5.6.3.1_updater/concrete/core/models/file_set.php(380): ADODB_Active_Record->Save() #5 /home/website/new.mywebsite.com/updates/concrete5.6.3.1_updater/concrete/core/models/file_set.php(210): Concrete5_Model_FileSetFile::createAndGetFile('326', '22') #6 /home/website/new.mywebsite.com/updates/concrete5.6.3.1_updater/concrete/elements/files/add_to_sets.php(113): Concrete5_Model_FileSet->addFileToSet(Object(File)) #7 /home/website/new.mywebsite.com/updates/concrete5.6.3.1_updater/concrete/core/libraries/loader.php(92): include('/home/website/n...') #8 /home/website/new.mywebsite.com/updates/concrete5.6.3.1_updater/concrete/tools/files/add_to.php(10): Concrete5_Library_Loader::element('files/add_to_se...') #9 /home/website/new.mywebsite.com/updates/concrete5.6.3.1_updater/concrete/startup/tools.php(29): include('/home/website/n...') #10 /home/website/new.mywebsite.com/updates/concrete5.6.3.1_updater/concrete/dispatcher.php(146): require('/home/website/n...') #11 /home/website/new.mywebsite.com/concrete/startup/updated_core_check.php(6): require('/home/website/n...') #12 /home/website/new.mywebsite.com/concrete/dispatcher.php(14): require('/home/website/n...')
Viewing 15 lines of 17 lines. View entire code block.
I found this post which claims there is a fix:
https://www.concrete5.org/developers/bugs/5-6-3-1/mysql-5.6-error-wh...
...but can not find the pull request. I also found this post with no resolution:
https://www.concrete5.org/community/forums/chat/adding-files-to-file...
If anyone can point me in the right direction, it would be greatly appreciated.
Thanks in advance!
Alex
PS - The environment is like so:
# concrete5 Version 5.6.3.1 # concrete5 Packages Designer Content (1.0.0), Sortable Fancybox Gallery (1.13), tcSlider (2.2.9). # concrete5 Overrides blocks/main_navigation, blocks/news_summary, blocks/page_title, blocks/product_row, blocks/rss, blocks/slider, blocks/sub_navigation, blocks/tc_slider, libraries/3rdparty # concrete5 Cache Settings Block Cache - On Overrides Cache - Off Full Page Caching - On - If blocks on the particular page allow it. Full Page Cache Lifetime - Every minutes. # Server Software Apache # Server API cgi-fcgi
Viewing 15 lines of 42 lines. View entire code block.
Excellent!
I just upgraded the client site (after making backups of course) and it works again.
Thank you very much!
Cheers,
Alex
I just upgraded the client site (after making backups of course) and it works again.
Thank you very much!
Cheers,
Alex
Hello, alexaalto
Just to let you and all other concrete5 v5.6.x.x users now, there is a update for v5.6.3.4
Concrete5 v5.6.3.5 is also a security update (XSS)!
5.6.3.5 Release Notes:
https://documentation.concrete5.org/developers/background/version-hi...
(Released on June 9, 2017.)
v5.6.3.5 direct download link:
https://www.concrete5.org/download_file/-/view/96083...
Kind Regards,
Peter
Just to let you and all other concrete5 v5.6.x.x users now, there is a update for v5.6.3.4
Concrete5 v5.6.3.5 is also a security update (XSS)!
5.6.3.5 Release Notes:
https://documentation.concrete5.org/developers/background/version-hi...
(Released on June 9, 2017.)
v5.6.3.5 direct download link:
https://www.concrete5.org/download_file/-/view/96083...
Kind Regards,
Peter
5.6.3.1 has a old ADOdb version!
Just update to 5.6.3.4:
https://www.concrete5.org/download_file/-/view/82244...
Kind Regards,
Peter