Erro No Site Shop

[lordxd16 1]

alguem saber aruma esse erro

pqr favo se alguem saber mim ajuda ae

se ajuda dou rep+++

 

 

 

 

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'itemid1' in 'field list'' in C:\xampp\htdocs\shopadmin.php:124 Stack trace: #0 C:\xampp\htdocs\shopadmin.php(124): PDO->query('SELECT id, poin...') #1 C:\xampp\htdocs\index.php(225): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\shopadmin.php on line 124

shop erro.bmp

[smithaux 0]

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 ;

Editado Dezembro 11, 2011 por smithaux