Problem modifying roles and categories :

Votirono · June 2016

Fatal Error in PHP.trigger_error();
The error occurred on or near: C:\wamp\www\web\thelastday\web\forum\library\database\class.database.php

418:                     $this->closeConnection();

419:                     continue;

420:                 }

421: 

422:                 trigger_error($message, E_USER_ERROR);

423:             }

424: 

425:         }

426: 

Backtrace:

C:\wamp\www\web\thelastday\web\forum\library\database\class.database.phpPHP::Gdn_ErrorHandler();

[C:\wamp\www\web\thelastday\web\forum\library\database\class.database.php:422] PHP::trigger_error();

[C:\wamp\www\web\thelastday\web\forum\library\database\class.sqldriver.php:1663] Gdn_Database->query();

[C:\wamp\www\web\thelastday\web\forum\library\database\class.sqldriver.php:1618] Gdn_SQLDriver->query();

[C:\wamp\www\web\thelastday\web\forum\library\core\class.model.php:313] Gdn_SQLDriver->put();

[C:\wamp\www\web\thelastday\web\forum\applications\vanilla\models\class.categorymodel.php:1706] Gdn_Model->update();

[C:\wamp\www\web\thelastday\web\forum\library\core\class.form.php:2224] CategoryModel->save();

[C:\wamp\www\web\thelastday\web\forum\applications\vanilla\controllers\class.settingscontroller.php:529] Gdn_Form->save();

[C:\wamp\www\web\thelastday\web\forum\applications\vanilla\controllers\class.settingscontroller.php:529] SettingsController->editCategory();

[C:\wamp\www\web\thelastday\web\forum\library\core\class.dispatcher.php:329] PHP::call_user_func_array();

[C:\wamp\www\web\thelastday\web\forum\index.php:44] Gdn_Dispatcher->dispatch();

Variables in local scope:

[Sql] 'update GDN_Category `Category`
set `UrlCode` = :UrlCode,
 `Archived` = :Archived,
 `Name` = :Name,
 `Description` = :Description,
 `CssClass` = :CssClass,
 `HideAllDiscussions` = :HideAllDiscussions,
 `DisplayAs` = :DisplayAs,
 `UpdateUserID` = :UpdateUserID,
 `DateUpdated` = :DateUpdated,
 `AllowDiscussions` = :AllowDiscussions,
 `PointsCategoryID` = :PointsCategoryID
where CategoryID = :CategoryID'

[InputParameters] array (
  ':UrlCode' => 'general',
  ':Archived' => false,
  ':Name' => 'General',
  ':Description' => 'General discussions',
  ':CssClass' => '',
  ':HideAllDiscussions' => false,
  ':DisplayAs' => 'Default',
  ':UpdateUserID' => '2',
  ':DateUpdated' => '2016-06-21 14:52:52',
  ':AllowDiscussions' => '1',
  ':PointsCategoryID' => 0,
  ':CategoryID' => '1',
)

[Options] array (
  'Type' => 'update',
  'Slave' => NULL,
  'ReturnType' => NULL,
)

[ReturnType] NULL

[tries] 2

[try] 0

[PDO] array (
)

[PDOStatement] array (
  'queryString' => 'update GDN_Category `Category`
set `UrlCode` = :UrlCode,
 `Archived` = :Archived,
 `Name` = :Name,
 `Description` = :Description,
 `CssClass` = :CssClass,
 `HideAllDiscussions` = :HideAllDiscussions,
 `DisplayAs` = :DisplayAs,
 `UpdateUserID` = :UpdateUserID,
 `DateUpdated` = :DateUpdated,
 `AllowDiscussions` = :AllowDiscussions,
 `PointsCategoryID` = :PointsCategoryID
where CategoryID = :CategoryID',
)

[ex] array (
  'xdebug_message' => '<tr><th align=\'left\' bgcolor=\'#f57900\' colspan="5"><span style=\'background-color: #cc0000; color: #fce94f; font-size: x-large;\'>( ! )</span> Gdn_ErrorException: Incorrect integer value: \'\' for column \'Archived\' at row 1|Gdn_Database|Query|update GDN_Category `Category`
set `UrlCode` = :UrlCode,
 `Archived` = :Archived,
 `Name` = :Name,
 `Description` = :Description,
 `CssClass` = :CssClass,
 `HideAllDiscussions` = :HideAllDiscussions,
 `DisplayAs` = :DisplayAs,
 `UpdateUserID` = :UpdateUserID,
 `DateUpdated` = :DateUpdated,
 `AllowDiscussions` = :AllowDiscussions,
 `PointsCategoryID` = :PointsCategoryID
where CategoryID = :CategoryID in C:\\wamp\\www\\web\\thelastday\\web\\forum\\library\\database\\class.database.php on line <i>390</i></th></tr>
<tr><th align=\'left\' bgcolor=\'#e9b96e\' colspan=\'5\'>Call Stack</th></tr>
<tr><th align=\'center\' bgcolor=\'#eeeeec\'>#</th><th align=\'left\' bgcolor=\'#eeeeec\'>Time</th><th align=\'left\' bgcolor=\'#eeeeec\'>Memory</th><th align=\'left\' bgcolor=\'#eeeeec\'>Function</th><th align=\'left\' bgcolor=\'#eeeeec\'>Location</th></tr>
<tr><td bgcolor=\'#eeeeec\' align=\'center\'>1</td><td bgcolor=\'#eeeeec\' align=\'center\'>0.0000</td><td bgcolor=\'#eeeeec\' align=\'right\'>279376</td><td bgcolor=\'#eeeeec\'>{main}(  )</td><td title=\'C:\\wamp\\www\\web\\thelastday\\web\\forum\\index.php\' bgcolor=\'#eeeeec\'>...\\index.php<b>:</b>0</td></tr>
<tr><td bgcolor=\'#eeeeec\' align=\'center\'>2</td><td bgcolor=\'#eeeeec\' align=\'center\'>0.2184</td><td bgcolor=\'#eeeeec\' align=\'right\'>8583544</td><td bgcolor=\'#eeeeec\'>Gdn_Dispatcher->dispatch(  )</td><td title=\'C:\\wamp\\www\\web\\thelastday\\web\\forum\\index.php\' bgcolor=\'#eeeeec\'>...\\index.php<b>:</b>44</td></tr>
<tr><td bgcolor=\'#eeeeec\' align=\'center\'>3</td><td bgcolor=\'#eeeeec\' align=\'center\'>0.2652</td><td bgcolor=\'#eeeeec\' align=\'right\'>10848008</td><td bgcolor=\'#eeeeec\'><a href=\'http://www.php.net/function.call-user-func-array:{C:\\wamp\\www\\web\\thelastday\\web\\forum\\library\\core\\class.dispatcher.php:329}\' target=\'_new\'>call_user_func_array:{C:\\wamp\\www\\web\\thelastday\\web\\forum\\library\\core\\class.dispatcher.php:329}</a>
(  )</td><td title=\'C:\\wamp\\www\\web\\thelastday\\web\\forum\\library\\core\\class.dispatcher.php\' bgcolor=\'#eeeeec\'>...\\class.dispatcher.php<b>:</b>329</td></tr>
<tr><td bgcolor=\'#eeeeec\' align=\'center\'>4</td><td bgcolor=\'#eeeeec\' align=\'center\'>0.2652</td><td bgcolor=\'#eeeeec\' align=\'right\'>10849488</td><td bgcolor=\'#eeeeec\'>SettingsController->editCategory(  )</td><td title=\'C:\\wamp\\www\\web\\thelastday\\web\\forum\\library\\core\\class.dispatcher.php\' bgcolor=\'#eeeeec\'>...\\class.dispatcher.php<b>:</b>329</td></tr>
<tr><td bgcolor=\'#eeeeec\' align=\'center\'>5</td><td bgcolor=\'#eeeeec\' align=\'center\'>0.3120</td><td bgcolor=\'#eeeeec\' align=\'right\'>12370440</td><td bgcolor=\'#eeeeec\'>Gdn_Form->save(  )</td><td title=\'C:\\wamp\\www\\web\\thelastday\\web\\forum\\applications\\vanilla\\controllers\\class.settingscontroller.php\' bgcolor=\'#eeeeec\'>...\\class.settingscontroller.php<b>:</b>529</td></tr>
<tr><td bgcolor=\'#eeeeec\' align=\'center\'>6</td><td bgcolor=\'#eeeeec\' align=\'center\'>0.3120</td><td bgcolor=\'#eeeeec\' align=\'right\'>12374816</td><td bgcolor=\'#eeeeec\'>CategoryModel->save(  )</td><td title=\'C:\\wamp\\www\\web\\thelastday\\web\\forum\\library\\core\\class.form.php\' bgcolor=\'#eeeeec\'>...\\class.form.php<b>:</b>2224</td></tr>
<tr><td bgcolor=\'#eeeeec\' align=\'center\'>7</td><td bgcolor=\'#eeeeec\' align=\'center\'>0.3432</td><td bgcolor=\'#eeeeec\' align=\'right\'>12520136</td><td bgcolor=\'#eeeeec\'>Gdn_Model->update(  )</td><td title=\'C:\\wamp\\www\\web\\thelastday\\web\\forum\\applications\\vanilla\\models\\class.categorymodel.php\' bgcolor=\'#eeeeec\'>...\\class.categorymodel.php<b>:</b>1706</td></tr>
<tr><td bgcolor=\'#eeeeec\' align=\'center\'>8</td><td bgcolor=\'#eeeeec\' align=\'center\'>0.3432</td><td bgcolor=\'#eeeeec\' align=\'right\'>12524872</td><td bgcolor=\'#eeeeec\'>Gdn_SQLDriver->put(  )</td><td title=\'C:\\wamp\\www\\web\\thelastday\\web\\forum\\library\\core\\class.model.php\' bgcolor=\'#eeeeec\'>...\\class.model.php<b>:</b>313</td></tr>
<tr><td bgcolor=\'#eeeeec\' align=\'center\'>9</td><td bgcolor=\'#eeeeec\' align=\'center\'>0.3432</td><td bgcolor=\'#eeeeec\' align=\'right\'>12529816</td><td bgcolor=\'#eeeeec\'>Gdn_SQLDriver->query(  )</td><td title=\'C:\\wamp\\www\\web\\thelastday\\web\\forum\\library\\database\\class.sqldriver.php\' bgcolor=\'#eeeeec\'>...\\class.sqldriver.php<b>:</b>1618</td></tr>
<tr><td bgcolor=\'#eeeeec\' align=\'center\'>10</td><td bgcolor=\'#eeeeec\' align=\'center\'>0.3432</td><td bgcolor=\'#eeeeec\' align=\'right\'>12530392</td><td bgcolor=\'#eeeeec\'>Gdn_Database->query(  )</td><td title=\'C:\\wamp\\www\\web\\thelastday\\web\\forum\\library\\database\\class.sqldriver.php\' bgcolor=\'#eeeeec\'>...\\class.sqldriver.php<b>:</b>1663</td></tr>
<tr><td bgcolor=\'#eeeeec\' align=\'center\'>11</td><td bgcolor=\'#eeeeec\' align=\'center\'>0.3432</td><td bgcolor=\'#eeeeec\' align=\'right\'>12543704</td><td bgcolor=\'#eeeeec\'><a href=\'http://www.php.net/function.trigger-error\' target=\'_new\'>trigger_error</a>
(  )</td><td title=\'C:\\wamp\\www\\web\\thelastday\\web\\forum\\library\\database\\class.database.php\' bgcolor=\'#eeeeec\'>...\\class.database.php<b>:</b>390</td></tr>
<tr><td bgcolor=\'#eeeeec\' align=\'center\'>12</td><td bgcolor=\'#eeeeec\' align=\'center\'>0.3432</td><td bgcolor=\'#eeeeec\' align=\'right\'>12546344</td><td bgcolor=\'#eeeeec\'>Gdn_ErrorHandler(  )</td><td title=\'C:\\wamp\\www\\web\\thelastday\\web\\forum\\library\\database\\class.database.php\' bgcolor=\'#eeeeec\'>...\\class.database.php<b>:</b>390</td></tr>
',
)

[message] NULL

[code] NULL

[state] '00000'

Need Help?

If you are a user of this website, you can report this message to a website administrator.

If you are an administrator of this website, you can get help at the Vanilla Community Forums.
Additional information for support personnel:

    Application: Vanilla
    Application Version: 2.2.1
    PHP Version: 5.6.16
    Operating System: WINNT
    Server Software: Apache/2.4.17 (Win64) PHP/5.6.16
    Referer: http://5.135.42.34/thelastday/web/forum/index.php?p=/vanilla/settings/editcategory/1
    User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:47.0) Gecko/20100101 Firefox/47.0
    Request Uri: /thelastday/web/forum/index.php?p=/vanilla/settings/editcategory/1&
    Controller: PHP
    Method: trigger_error

Votirono · June 2016

This problem occur on a fresh Vanilla Forum installation with only French language activated and a theme.

Votirono · June 2016

Problem solved in my.ini (configurations of mysql) found :
# Set the SQL mode to strict
#sql-mode=""
sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"

You should disable SQL strict mode :

# Set the SQL mode to strict
#sql-mode=""
sql-mode="ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"

Problem modifying roles and categories :

Comments