Shop system error

[Skychi]

when I try to access my shop I get this error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'argania.z_shop_offer' doesn't exist' in D:\xampp\htdocs\shopsystem.php:55 Stack trace: #0 D:\xampp\htdocs\shopsystem.php(55): PDO->query('SELECT * FROM `...') #1 D:\xampp\htdocs\shopsystem.php(99): getOfferArray() #2 D:\xampp\htdocs\index.php(184): include('D:\xampp\htdocs...') #3 {main} thrown in D:\xampp\htdocs\shopsystem.php on line 55


I think that the shop system isn't in my SQL database for some odd reason. If so, can someone guide me through the process of installing that script?

 

[Valania]

when I try to access my shop I get this error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'argania.z_shop_offer' doesn't exist' in D:\xampp\htdocs\shopsystem.php:55 Stack trace: #0 D:\xampp\htdocs\shopsystem.php(55): PDO->query('SELECT * FROM `...') #1 D:\xampp\htdocs\shopsystem.php(99): getOfferArray() #2 D:\xampp\htdocs\index.php(184): include('D:\xampp\htdocs...') #3 {main} thrown in D:\xampp\htdocs\shopsystem.php on line 55


I think that the shop system isn't in my SQL database for some odd reason. If so, can someone guide me through the process of installing that script?

Try

CREATE TABLE `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,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

[Skychi]

Could you break that down for me? I'm new to all of this SQL stuff. having enough trouble figuring out how to use some of these programs.

 

[Valania]

Could you break that down for me? I'm new to all of this SQL stuff. having enough trouble figuring out how to use some of these programs.

Just go to your databse and press the button sql afterwards paste all inside and press go.

 

[Skychi]

Thanks for your help, it's working now!

 

[Skychi]

Yet another error...

This time it's the Shop History...

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'argania.z_shop_history_item' doesn't exist' in D:\xampp\htdocs\shopsystem.php:353 Stack trace: #0 D:\xampp\htdocs\shopsystem.php(353): PDO->query('SELECT * FROM `...') #1 D:\xampp\htdocs\index.php(184): include('D:\xampp\htdocs...') #2 {main} thrown in D:\xampp\htdocs\shopsystem.php on line 353

I bet I need another SQL script. sorry for making you work so hard ='(

 

[Suxex]

CREATE TABLE `z_shop_history_item` (
`id` int(11) NOT NULL auto_increment,
`to_name` varchar(255) NOT NULL default '0',
`to_account` int(11) NOT NULL default '0',
`from_nick` varchar(255) NOT NULL,
`from_account` int(11) NOT NULL default '0',
`price` int(11) NOT NULL default '0',
`offer_id` int(11) NOT NULL default '0',
`trans_state` varchar(255) NOT NULL,
`trans_start` int(11) NOT NULL default '0',
`trans_real` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

[Valania]

Thanks for your help, it's working now!

How about rep++ me?-.-

 

[Skychi]

ok, now for the pacc...


Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'argania.z_shop_history_pacc' doesn't exist' in D:\xampp\htdocs\shopsystem.php:374 Stack trace: #0 D:\xampp\htdocs\shopsystem.php(374): PDO->query('SELECT * FROM `...') #1 D:\xampp\htdocs\index.php(184): include('D:\xampp\htdocs...') #2 {main} thrown in D:\xampp\htdocs\shopsystem.php on line 374

this is starting to get old... Just being honest -_-;

 

[Valania]

ok, now for the pacc...


Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'argania.z_shop_history_pacc' doesn't exist' in D:\xampp\htdocs\shopsystem.php:374 Stack trace: #0 D:\xampp\htdocs\shopsystem.php(374): PDO->query('SELECT * FROM `...') #1 D:\xampp\htdocs\index.php(184): include('D:\xampp\htdocs...') #2 {main} thrown in D:\xampp\htdocs\shopsystem.php on line 374

this is starting to get old... Just being honest -_-;

Use this one:

	CREATE TABLE `z_shop_history_pacc` (
 					      `id` int(11) NOT NULL auto_increment,
 					      `to_name` varchar(255) NOT NULL default '0',
 					      `to_account` int(11) NOT NULL default '0',
 					      `from_nick` varchar(255) NOT NULL,
 					      `from_account` int(11) NOT NULL default '0',
 					      `price` int(11) NOT NULL default '0',
 					      `pacc_days` int(11) NOT NULL default '0',
 					      `trans_state` varchar(255) NOT NULL,
 					      `trans_start` int(11) NOT NULL default '0',
 					      `trans_real` int(11) NOT NULL default '0',
 					      PRIMARY KEY  (`id`)
 					    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;");

Rep me++

 

[Skychi]

Thanks for the help, the webpages are displaying properly now. I gave you rep++ so don't worry.