B?ad z sms shopem

[Kokos113]

Elo ;d


Mam Taki problem pozniewaz gdy Loguje sie na moim otsie na stronce na Admina, i jak chcem dodac Iteems do sms shopa to wyskakuje mi taki B?ad:

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



Prosze o Pomoc

 

[Doman08]

Odp: B?ad z sms shopem

Mo?e nie masz w bazie danych czego? takiego? Wrzu? to do zak?adki sql w phpmyadminie i sprawd?

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 ;