Fix hostbill / mysql / website issue


I have migrated my hostibill application from one server to another and it does not work. Getting the following:

Uh oh! Something went wrong ...

Exception: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'logout' at row 1 IN /home/mrmail/public_html/portal/hbf/components/authorization/[login to view URL](84), stack trace:

#0 /home/mrmail/public_html/portal/hbf/components/authorization/[login to view URL](84): PDO->exec()

#1 /home/mrmail/public_html/portal/hbf/components/authorization/[login to view URL](72): AdminAuthorization->autologout()

#2 /home/mrmail/public_html/portal/hbf/core/[login to view URL](400): AdminAuthorization->__construct()

#3 /home/mrmail/public_html/portal/hbf/core/[login to view URL](239): HBLoader::_load()

#4 /home/mrmail/public_html/portal/hbf/core/types/[login to view URL](49): HBLoader::LoadComponent()

#5 /home/mrmail/public_html/portal/hbf/core/[login to view URL](126): Admin_FrontController->dispatch()

#6 /home/mrmail/public_html/portal/hbf/core/[login to view URL](109): FrontController->handleRequest()

#7 /home/mrmail/public_html/portal/admin/[login to view URL](15): FrontController::init()

#8 {main}

Uh oh! Something went wrong ...

PHP [Error]: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'id' at row 1' in /home/mrmail/public_html/portal/hbf/components/hbdebug/[login to view URL]

Stack trace:

#0 /home/mrmail/public_html/portal/hbf/components/hbdebug/[login to view URL](31): PDOStatement->execute()

#1 /home/mrmail/public_html/portal/hbf/core/[login to view URL](85): HBErrorLog->createEntry()

#2 [internal function]: HBException::php_exception_handler(Object(PDOException))

#3 {main}

thrown IN hbf/components/hbdebug/[login to view URL](31)

the problem might be in php / mysql configuration on the server or in the code

Probably someone know how he/she is doing can fix this easily.

The server is running ubuntu 18.04 / webmin / virtualmin

Do you have enough skills to tackle this?

Umiejętności: HTML, JavaScript, MySQL, PHP, Architektura oprogramowania

Zobacz więcej: fix broken links website, php mysql website scratch, create free mysql website, fix broken mysql database, php mysql website creator, free php mysql website test, fix submit button website, wallpaper mysql website script, mysql website seo, php mysql website creation job hourly rates, fix client side printing issue sql 2005, fix corrupted mysql database, fix cross browser compatibility issue, image upload mysql website, fix hacked joomla website, fix flash xml website issue, fix website issue

O pracodawcy:
( 6 ocen ) Wimborne, Australia

Numer ID Projektu: #17916352

Przyznany użytkownikowi:


hi, I am linux sys admin with wide experience in hosting field and I can help you with this task! I am ready to do server check for proper setup, p.s. access to old server still available just in case ?

$30 AUD w 1 dzień
(180 ocen)

7 freelancerów złożyło ofertę na kwotę $42 do tego projektu


Please reply soon thanks

$30 AUD w ciągu 1 dnia
(224 Oceny)

hello I can help you contact me and lets talk about this problem .

$25 AUD w ciągu 1 dnia
(103 Oceny)

I'm a developer with extensive experience in building high quality sites and apps. I have an experience in (PHP/Ionic framework/ReactJS/React Native/NativeScript/Javascript/UI design/native IOS). I like working o Więcej

$25 AUD w ciągu 1 dnia
(92 Oceny)
$45 AUD w ciągu 1 dnia
(24 Oceny)

Im SOFTWARE ENGINEER and having a SOFTWARE HOUSE We have skills in ur demanded languages, We did a lot of work in those languages,i saw ur project [login to view URL] can fulfill ur requirements our rates are less. i Więcej

$111 AUD w ciągu 2 dni
(20 Oceny)

yes , i am >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Więcej

$25 AUD w ciągu 1 dnia
(0 Oceny)