Completed

Fix hostbill / mysql / website issue

Hi,

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?

Skills: HTML, Javascript, MySQL, PHP, Software Architecture

See more: 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

About the Employer:
( 6 reviews ) Wimborne, Australia

Project ID: #17916352

Awarded to:

stels88

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 in 1 day
(180 Reviews)
6.5

7 freelancers are bidding on average $42 for this job

microwebtechs

Please reply soon thanks

$30 AUD in 1 day
(224 Reviews)
6.5
mohamedgb00714

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

$25 AUD in 1 day
(103 Reviews)
6.0
PhpWebD

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 More

$25 AUD in 1 day
(92 Reviews)
5.8
$45 AUD in 1 day
(24 Reviews)
4.9
webzonenetwork80

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 More

$111 AUD in 2 days
(20 Reviews)
4.2
dodawahba

yes , i am >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> More

$25 AUD in 1 day
(0 Reviews)
0.0