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?
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
5.0 (180 reviews)
6.5
6.5
7 freelancers are bidding on average $42 AUD for this job
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 on projects with a team that cares about creating beautiful and easy to use interfaces.
It's important to me to build long-term relationships with clients, so I'm primarily looking for long term projects.
I'm flexible with my working hours and am happy to work with any existing freelancers you work with.
I look forward to hearing from you!
Thank you, Mostafa Kassem.
yes , i am >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>