Lizard King
Mon 3rd Sep '07, 11:18pm
In blog_user table there is no field as posts and uncatposts .
The query needs to be fixed
$Db_object->query("
INSERT INTO {$tableprefix}blog_user
(
bloguserid, importbloguserid, title, description, options,
viewoption, comments, lastblog, lastblogid,
lastblogtitle, lastcomment, lastcommenter, lastblogtextid,
posts, allowsmilie, subscribeown, subscribeothers,
moderation, deleted, draft, options_everyone,
options_buddy, options_ignore, ratingnum, ratingtotal,
rating, pending, uncatposts
)
VALUES
(
'" . intval($this->get_value('mandatory', 'bloguserid')) . /* Default : 0 Type : int(10) unsigned */ "',
'" . intval($this->get_value('mandatory', 'importbloguserid')) . "',
'" . addslashes($this->get_value('nonmandatory', 'title')) . /* Default : Type : varchar(255) */ "',
'" . addslashes($this->get_value('nonmandatory', 'description')) . /* Default : Type : mediumtext */ "',
'" . intval($this->get_value('nonmandatory', 'options')) . /* Default : 0 Type : int(10) unsigned */ "',
'" . $this->enum_check($this->get_value('mandatory', 'viewoption'), array('all','only','except'), 'all') . /* Default : all Type : enum('all','only','except') */ "',
'" . intval($this->get_value('nonmandatory', 'comments')) . /* Default : 0 Type : int(10) unsigned */ "',
'" . intval($this->get_value('nonmandatory', 'lastblog')) . /* Default : 0 Type : int(10) unsigned */ "',
'" . intval($this->get_value('nonmandatory', 'lastblogid')) . /* Default : 0 Type : int(10) unsigned */ "',
'" . addslashes($this->get_value('nonmandatory', 'lastblogtitle')) . /* Default : Type : varchar(255) */ "',
'" . intval($this->get_value('nonmandatory', 'lastcomment')) . /* Default : 0 Type : int(10) unsigned */ "',
'" . addslashes($this->get_value('nonmandatory', 'lastcommenter')) . /* Default : Type : varchar(100) */ "',
'" . intval($this->get_value('nonmandatory', 'lastblogtextid')) . /* Default : 0 Type : int(10) unsigned */ "',
'" . intval($this->get_value('nonmandatory', 'posts')) . /* Default : 0 Type : int(10) unsigned */ "',
'" . intval($this->get_value('nonmandatory', 'allowsmilie')) . /* Default : Type : smallint(5) unsigned */ "',
'" . $this->enum_check($this->get_value('mandatory', 'subscribeown'), array('none','usercp','email'), 'none') . /* Default : none Type : enum('none','usercp','email') */ "',
'" . $this->enum_check($this->get_value('mandatory', 'subscribeothers'), array('none','usercp','email'), 'none') . /* Default : none Type : enum('none','usercp','email') */ "',
'" . intval($this->get_value('nonmandatory', 'moderation')) . /* Default : Type : int(10) unsigned */ "',
'" . intval($this->get_value('nonmandatory', 'deleted')) . /* Default : Type : int(10) unsigned */ "',
'" . intval($this->get_value('nonmandatory', 'draft')) . /* Default : Type : int(10) unsigned */ "',
'" . intval($this->get_value('nonmandatory', 'options_everyone')) . /* Default : Type : int(10) unsigned */ "',
'" . intval($this->get_value('nonmandatory', 'options_buddy')) . /* Default : Type : int(10) unsigned */ "',
'" . intval($this->get_value('nonmandatory', 'options_ignore')) . /* Default : Type : int(10) unsigned */ "',
'" . intval($this->get_value('nonmandatory', 'ratingnum')) . /* Default : Type : int(10) unsigned */ "',
'" . intval($this->get_value('nonmandatory', 'ratingtotal')) . /* Default : Type : int(10) unsigned */ "',
'" . floatval($this->get_value('nonmandatory', 'rating')) . /* Default : Type : float unsigned */ "',
'" . intval($this->get_value('nonmandatory', 'pending')) . /* Default : 0 Type : int(10) unsigned */ "',
'" . intval($this->get_value('nonmandatory', 'uncatposts')) . /* Default : 0 Type : int(10) unsigned */ "'
)
");