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?

Keahlian: HTML, Javascript, MySQL, PHP, Perancangan Perangkat Lunak

Lihat lebih lanjut: 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

Tentang Pemberi kerja:
( 6 ulasan ) Wimborne, Australia

ID Proyek: #17916352

Diberikan kepada:


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 dalam 1 hari
(180 Ulasan)

7 freelancer menawar dengan rata-rata $42 untuk pekerjaan ini


Please reply soon thanks

$30 AUD dalam 1 hari
(224 Ulasan)

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

$25 AUD dalam 1 hari
(103 Ulasan)

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 Lebih banyak

$25 AUD dalam 1 hari
(92 Ulasan)
$45 AUD dalam 1 hari
(24 Ulasan)

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 Lebih banyak

$111 AUD dalam 2 hari
(20 Ulasan)

yes , i am >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Lebih banyak

$25 AUD dalam 1 hari
(0 Ulasan)