Query Error on blog_category Issue Tools
issueid=23112 Mon 3rd Sep '07 11:20pm
Senior Member
Query Error on blog_category

There is no field named postcount inside blog_category table. the following query inside ImpExDatabase_blog_001.php shall be fixed

Code:
$Db_object->query("
INSERT INTO {$tableprefix}blog_category
(
userid, title, description, childlist,
parentlist, parentid, displayorder, postcount,
importblogcategoryid
)
VALUES
(
'" . intval($this->get_value('mandatory', 'userid')) . /* Default : 0 Type : int(10) unsigned */ "',
'" . addslashes($this->get_value('mandatory', 'title')) . /* Default : Type : varchar(255) */ "',
'" . addslashes($this->get_value('nonmandatory', 'description')) . /* Default : Type : varchar(255) */ "',
'" . addslashes($this->get_value('nonmandatory', 'childlist')) . /* Default : Type : mediumtext */ "',
'" . addslashes($this->get_value('nonmandatory', 'parentlist')) . /* Default : Type : mediumtext */ "',
'" . intval($this->get_value('nonmandatory', 'parentid')) . /* Default : Type : int(10) unsigned */ "',
'" . intval($this->get_value('nonmandatory', 'displayorder')) . /* Default : Type : int(10) unsigned */ "',
'" . intval($this->get_value('nonmandatory', 'postcount')) . /* Default : Type : int(10) unsigned */ "',
'" . intval($this->get_value('mandatory', 'importblogcategoryid')) . /* Default : Type : int(10) unsigned */ "'
)
");
Issue Details
Project ImpEx
Category Unknown
Status Fixed (Closed)
Priority 1 - Highest
Affected Version 1.83
Fixed Version (none)
Users able to reproduce bug 0
Users unable to reproduce bug 0
Assigned Users (none)
Tags (none)

Wed 3rd Dec '08 9:32pm
Issue Changed by Jerry
  • Status changed from Unconfirmed to Fixed (Closed)
Reply