Hello There, Guest! › Register

MySubscriptions 2.2 released.
Looking for a custom plugin for your site? Ask here for a quote.

Shop problem
#1

Version of N.P: 1.1

Installing the shop:
Code:
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1074 - Column length too big for column 'icon' (max = 255); use BLOB or TEXT instead
Query:
CREATE TABLE `mybb_newpoints_shop_categories` ( `cid` bigint(30) UNSIGNED NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `description` TEXT NOT NULL default '', `visible` smallint(1) NOT NULL default '1', `icon` varchar(300) NOT NULL default '', `usergroups` varchar(100) NOT NULL default '', `disporder` int(5) NOT NULL default '0', `items` int(10) NOT NULL default '0', `expanded` smallint(1) NOT NULL default '1', PRIMARY KEY (`cid`) ) TYPE=MyISAM

The plugin results active refreshing the page.


When i click the shop tab (in the forum and even in the admin cp):
Code:
SQL Error:
1146 - Table 'my_habboceanforum.mybb_newpoints_shop_categories' doesn't exist
Query:
SELECT * FROM mybb_newpoints_shop_categories ORDER BY disporder ASC


How can I fix this?

Thanks in advance,

Trinit
Btw if u need the link of the board, just tell me
#2

Read the first page of the release thread Smile
Edit:
and change varchar(300) to varchar(255) in the code Smile
To download our paid plugins and receive support you must be a paid subscriber. Click here for more information.
#3

in the code of the shop plugin?
Anyway I read the first page... so? What exactly do I have 2 read?
#4

Yes in the code of the shop plugin.
You have to read the first page to do a few edits to fix a few errors.
1.1 will fix those errors and the rest of the bugs
To download our paid plugins and receive support you must be a paid subscriber. Click here for more information.
#5

But i can wait even the release of Shop 1.2 right?
#6

Changed the varchar in mybb_newpoints_shop_categories but it doesn't work! Maybe i have to change the varchar of the other table ?
#7

What's the error now?
To download our paid plugins and receive support you must be a paid subscriber. Click here for more information.
#8

fixed changing the other varchar




Users browsing this thread: 1 Guest(s)