Jump to content
X2Community Forums

CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DOUBLE value


Recommended Posts

Hi,

 

Ive just upgraded from version 7.1 to 8.0. The upgrade appear to work as i could see the new format. When i went to log in later in the day i now get this error.

 

Here's a quick list of what will be included in the report:

Error Code: 500
Error Message: CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DOUBLE value: ''
Stack Trace: [click to toggle display]

CDbException in /var/www/html/x2crm/framework/db/CDbCommand.php(358)
#0 /var/www/html/x2crm/protected/components/behaviors/CommonSiteControllerBehavior.php(144): CDbCommand->execute()
#1 /var/www/html/x2crm/framework/base/CComponent.php(261): CommonSiteControllerBehavior->login(Object(LoginForm))
#2 /var/www/html/x2crm/protected/controllers/SiteController.php(1656): CComponent->__call('login', Array)
#3 /var/www/html/x2crm/framework/web/actions/CInlineAction.php(49): SiteController->actionLogin()
#4 /var/www/html/x2crm/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#5 /var/www/html/x2crm/framework/web/filters/CFilterChain.php(134): CController->runAction(Object(CInlineAction))
#6 /var/www/html/x2crm/framework/web/filters/CFilter.php(40): CFilterChain->run()
#7 /var/www/html/x2crm/framework/web/CController.php(1148): CFilter->filter(Object(CFilterChain))
#8 /var/www/html/x2crm/framework/web/filters/CInlineFilter.php(58): CController->filterAccessControl(Object(CFilterChain))
#9 /var/www/html/x2crm/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
#10 /var/www/html/x2crm/protected/controllers/x2base.php(586): CFilterChain->run()
#11 /var/www/html/x2crm/framework/web/filters/CInlineFilter.php(58): x2base->filterSetPortlets(Object(CFilterChain))
#12 /var/www/html/x2crm/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
#13 /var/www/html/x2crm/protected/controllers/x2base.php(586): CFilterChain->run()
#14 /var/www/html/x2crm/framework/web/filters/CInlineFilter.php(58): x2base->filterSetPortlets(Object(CFilterChain))
#15 /var/www/html/x2crm/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
#16 /var/www/html/x2crm/framework/web/filters/CFilter.php(40): CFilterChain->run()
#17 /var/www/html/x2crm/framework/web/filters/CFilterChain.php(131): CFilter->filter(Object(CFilterChain))
#18 /var/www/html/x2crm/framework/web/filters/CFilter.php(40): CFilterChain->run()
#19 /var/www/html/x2crm/framework/web/filters/CFilterChain.php(131): CFilter->filter(Object(CFilterChain))
#20 /var/www/html/x2crm/framework/web/CController.php(291): CFilterChain->run()
#21 /var/www/html/x2crm/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#22 /var/www/html/x2crm/framework/web/CWebApplication.php(282): CController->run('login')
#23 /var/www/html/x2crm/protected/components/X2WebApplication.php(65): CWebApplication->runController('site/login')
#24 /var/www/html/x2crm/framework/base/CApplication.php(185): X2WebApplication->processRequest()
#25 /var/www/html/x2crm/index.php(67): CApplication->run()
#26 {main}

X2Engine Version: 8.0
PHP Version: 7.1.33-41+ubuntu20.04.1+deb.sury.org+1

Does anyone know what has created this issue? Any help greatly appreciated.

Link to post
Share on other sites

Hello, can you confirm that line 144 in protected/components/behaviors/CommonSiteControllerBehavior.php is

Yii::app()->db->createCommand( 'UPDATE x2_sessions SET status=status-1,lastUpdated=:time WHERE user=:name AND CAST(IP AS CHAR)=:ip AND status BETWEEN -2 AND 0') ->bindValues( array(':time' => time(), ':name' => $effectiveUsername, ':ip' => $ip)) ->execute();

Also what is the user name of your user?

 

-Jack

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...