adiciona isso no seu mysql ve si resolve
CREATE TABLE IF NOT EXISTS `z_shop_offer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`points` int(11) NOT NULL DEFAULT '0',
`itemid1` int(11) NOT NULL DEFAULT '0',
`count1` int(11) NOT NULL DEFAULT '0',
`itemid2` int(11) NOT NULL DEFAULT '0',
`count2` int(11) NOT NULL DEFAULT '0',
`offer_type` varchar(255) DEFAULT NULL,
`offer_description` text NOT NULL,
`offer_name` varchar(255) NOT NULL,
`pid` int(11) NOT NULL DEFAULT '0',
`category` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;