1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 Field 'last_note_viewed' doesn't have a default value

Discussion in 'Troubleshooting and Problems' started by BoomBoomUlli, Jul 26, 2014.

  1. BoomBoomUlli

    BoomBoomUlli Active Member

    Hi,
    I have follow Problem :
    When i want make a New Admin i become this error :
    Code:
    #0 C:\Inetpub\vhosts\roughnecks-germany.de\httpdocs\library\Zend\Db\Statement.php(317): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 C:\Inetpub\vhosts\roughnecks-germany.de\httpdocs\library\Zend\Db\Adapter\Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 C:\Inetpub\vhosts\roughnecks-germany.de\httpdocs\library\Zend\Db\Adapter\Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 C:\Inetpub\vhosts\roughnecks-germany.de\httpdocs\library\XenForo\DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('xf_admin', Array)
    #4 C:\Inetpub\vhosts\roughnecks-germany.de\httpdocs\library\XenForo\DataWriter.php(1613): XenForo_DataWriter->_insert()
    #5 C:\Inetpub\vhosts\roughnecks-germany.de\httpdocs\library\XenForo\DataWriter.php(1405): XenForo_DataWriter->_save()
    #6 C:\Inetpub\vhosts\roughnecks-germany.de\httpdocs\library\XenForo\ControllerAdmin\Admin.php(133): XenForo_DataWriter->save()
    #7 C:\Inetpub\vhosts\roughnecks-germany.de\httpdocs\library\XenForo\FrontController.php(347): XenForo_ControllerAdmin_Admin->actionSave()
    #8 C:\Inetpub\vhosts\roughnecks-germany.de\httpdocs\library\XenForo\FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 C:\Inetpub\vhosts\roughnecks-germany.de\httpdocs\admin.php(13): XenForo_FrontController->run()
    #10 {main}
    All Add-ons are Deaktivatet .
    Please help me ,
    Sry. for my Bad english.
     
  2. Liam W

    Liam W Well-Known Member

    Whoops, I'll fix that now...

    (I could've sworn I set a default value).

    Instant fix:
    Code:
    ALTER TABLE xf_admin MODIFY last_note_viewed INT NOT NULL DEFAULT '0';
     
    BoomBoomUlli likes this.
  3. BoomBoomUlli

    BoomBoomUlli Active Member

    ?
    Please explain that to me
     
  4. BoomBoomUlli

    BoomBoomUlli Active Member

    I found it , nice Big Thanks !!!!
     

Share This Page