middlebury / coursecatalog

This Course-Catalog is a project to develop a web front-end for searching and browsing course information stored in Banner.
https://github.com/middlebury/coursecatalog/wiki
GNU General Public License v3.0
9 stars 2 forks source link

Data-truncation on sync in SSBXLST_XLST_GROUP #32

Closed adamfranco closed 3 years ago

adamfranco commented 3 years ago

The following errors occurred during database synchronization:

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'SSBXLST_XLST_GROUP' at row 1

#0 /var/www/coursecatalog/application/library/CatalogSync/Database/Statement/Insert/Pdo.php(55): PDOStatement->execute()
#1 /var/www/coursecatalog/application/library/CatalogSync/Syncer/Abstract.php(581): CatalogSync_Database_Statement_Insert_Pdo->insertAll(Object(CatalogSync_Database_Statement_Select_PdoMysql))
#2 /var/www/coursecatalog/application/library/CatalogSync/Director.php(52): CatalogSync_Syncer_Abstract->copy()
#3 /var/www/coursecatalog/bin/update-from-banner.php(30): CatalogSync_Director->sync()
#4 {main}

Most likely the Banner database has had a column width expanded over the years and we need to expand the SSBXLST_XLST_GROUP table in our database to match.