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:

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...')


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

alexaalto
 
CMSDeveloper replied on at Permalink Reply
CMSDeveloper
Hello,

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
alexaalto replied on at Permalink Reply
alexaalto
Excellent!

I just upgraded the client site (after making backups of course) and it works again.

Thank you very much!
Cheers,

Alex
CMSDeveloper replied on at Permalink Best Answer Reply
CMSDeveloper
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