search

ho-dev / HattrickOrganizer

Assistant for Hattrick online football manager
https://ho-dev.github.io/HattrickOrganizer/
GNU Lesser General Public License v3.0
195 stars 79 forks source link

[eBUG] DB: constraint violation: XTRADATA column: CURRENCYNAME #116

Closed akasolace closed 5 years ago

akasolace commented 5 years ago

HO still launch but the following is logged:

JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: NOT NULL check constraint; SYS_CT_10855 table: XTRADATA column: CURRENCYNAME Statement: INSERT INTO XTRADATA ( HRF_ID , CurrencyRate, HasPromoted , LogoURL , SeriesMatchDate ,TrainingDate, EconomyDate, LeagueLevelUnitID ) VALUES(95,10.0,0,'//res.hattrick.org/teamlogo/18/176/1755/1754082/1754082.png', '2019-05-04 21:00:00.0', '2019-05-03 05:15:00.0', '2019-05-04 02:30:00.0', 36840 ) java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: NOT NULL check constraint; SYS_CT_10855 table: XTRADATA column: CURRENCYNAME

brokenelevator commented 5 years ago

Do you have an updated database? In 'updateDBv23' CURRENCYNAME is dropped so this problem should not appear. You have it in your db?

akasolace commented 5 years ago

I had this message when running DEV version, I will double check

akasolace commented 5 years ago

closed by ef27789