Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Error after updating a category description

Hi, i have a fresh install of vanilla and after editing a category description i got a bonk message.
Could anyone help me with this error?


Fatal Error in Gdn_Database.Query();
Incorrect integer value: '' for column 'Archived' at row 1
update GDN_Category Category set UrlCode = :UrlCode, Archived = :Archived, Name = :Name, Description = :Description, UpdateUserID = :UpdateUserID, DateUpdated = :DateUpdated, AllowDiscussions = :AllowDiscussions where CategoryID = :CategoryID
The error occurred on or near: C:\www\foro\library\database\class.database.php

276:
277: if (!is_object($PDOStatement)) {
278: trigger_error(ErrorMessage('PDO Statement failed to prepare', $this->ClassName, 'Query', $this->GetPDOErrorMessage($this->Connection()->errorInfo())), E_USER_ERROR);
279: } else if ($PDOStatement->execute($InputParameters) === FALSE) {
280: trigger_error(ErrorMessage($this->GetPDOErrorMessage($PDOStatement->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);
281: }
282: } else {
283: $PDOStatement = $this->Connection()->query($Sql);
284: }

Backtrace:

C:\www\foro\library\database\class.database.phpPHP::Gdn_ErrorHandler();
[C:\www\foro\library\database\class.database.php:280] PHP::trigger_error();
[C:\www\foro\library\database\class.sqldriver.php:1650] Gdn_Database->Query();
[C:\www\foro\library\database\class.sqldriver.php:1619] Gdn_SQLDriver->Query();
[C:\www\foro\library\core\class.model.php:276] Gdn_SQLDriver->Put();
[C:\www\foro\applications\vanilla\models\class.categorymodel.php:885] Gdn_Model->Update();
[C:\www\foro\library\core\class.form.php:1742] CategoryModel->Save();
[C:\www\foro\applications\vanilla\controllers\class.settingscontroller.php:401] Gdn_Form->Save();
[C:\www\foro\applications\vanilla\controllers\class.settingscontroller.php:401] SettingsController->EditCategory();
[C:\www\foro\library\core\class.dispatcher.php:322] PHP::call_user_func_array();
[C:\www\foro\index.php:53] Gdn_Dispatcher->Dispatch();

Variables in local scope:

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

[InputParameters] array (
':UrlCode' => 'general',
':Archived' => false,
':Name' => 'General',
':Description' => 'Discusiones generales, si no sabes donde poner el tema. ',
':UpdateUserID' => '1',
':DateUpdated' => '2013-02-01 11:07:24',
':AllowDiscussions' => '1',
':CategoryID' => '1',
)

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

[ReturnType] NULL

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


Additional information for support personnel:

Application: Vanilla
Application Version: 2.0.18.4
PHP Version: 5.4.11
Operating System: WINNT
Server Software: Apache/2.2.22 (Win32) PHP/5.4.11
Referer: http://saturno/foro/vanilla/settings/editcategory/1
User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:18.0) Gecko/20100101 Firefox/18.0
Request Uri: /foro/vanilla/settings/editcategory/1
Controller: Gdn_Database
Method: Query
Sign In or Register to comment.