MyBB Community Forums

http://forums.mybb-plugins.com/thread-5553.html

Diogo gave me shop 1.9 which is no different (still had same issues)

Hm, what query did you run to create the items table? The query I can see does specify that column.

CREATE TABLE `mybb_newpoints_shop_items` (
	  `iid` bigint(30) UNSIGNED NOT NULL auto_increment,
	  `name` varchar(100) NOT NULL default '',
	  `description` text NOT NULL,
	  `price` DECIMAL(16,2) NOT NULL default '0',
	  `icon` varchar(255) NOT NULL default '',
	  `visible` smallint(1) NOT NULL default '1',
	  `disporder` int(5) NOT NULL default '0',
	  `infinite` smallint(1) NOT NULL default '0',
	  `limit` smallint(1) NOT NULL default '0',
	  `stock` int(10) NOT NULL default '0',
	  `sendable` smallint(1) NOT NULL default '1',
	  `sellable` smallint(1) NOT NULL default '1',
	  `cid` int(10) NOT NULL default '0',
	  `pm` text NOT NULL,
	  PRIMARY KEY  (`iid`)
		) ENGINE=MyISAM

I get this issue now:

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'pmadmin' in 'field list'
Query:
INSERT INTO mybbe2_newpoints_shop_items (`name`,`description`,`icon`,`visible`,`disporder`,`price`,`infinite`,`stock`,`limit`,`sendable`,`sellable`,`cid`,`pm`,`pmadmin`) VALUES ('test','','',1,0,'2',1,0,0,1,1,1,'','')
Please contact the MyBB Group for technical support.

I replaced the categories phase with items in the first code you gave me.

---

EDIT: I fixed it by adding the "pmadmin" to the end from the php file.

CREATE TABLE `mybb_newpoints_shop_items` (
      `iid` bigint(30) UNSIGNED NOT NULL auto_increment,
      `name` varchar(100) NOT NULL default '',
      `description` text NOT NULL,
      `price` DECIMAL(16,2) NOT NULL default '0',
      `icon` varchar(255) NOT NULL default '',
      `visible` smallint(1) NOT NULL default '1',
      `disporder` int(5) NOT NULL default '0',
      `infinite` smallint(1) NOT NULL default '0',
      `limit` smallint(1) NOT NULL default '0',
      `stock` int(10) NOT NULL default '0',
      `sendable` smallint(1) NOT NULL default '1',
      `sellable` smallint(1) NOT NULL default '1',
      `cid` int(10) NOT NULL default '0',
      `pm` text NOT NULL,
      `pmadmin` text NOT NULL,
      PRIMARY KEY  (`iid`)
        ) ENGINE=MyISAM