Trying to install Zarath's Shop Mod 2.6.0...

[anwipr]

It seemed to work up until here, it brought me to this page, eek!


_________________________________


Step 2 of 3
Proposed Database Alterations
EasyMOD will now make changes to your database if you command it to. Any SQL with a check next to it will be performed by EM. If you are reinstalling a MOD, you probably do not want to run the SQL a second time, so be careful!

Official Warning: This is a DUMB process. Commands you check off will be executed but EM does NOT check to see if these changes will negatively impact your database. You are STRONGLY advised to backup your database before making any changes. Prior to executing, you are advised to examine each command thoroughly or ask for feedback from experienced MOD installers. Again, if you are reinstalling a MOD, multiple executions of the same SQL lines could adversely effect your database.

Proposed Database Alterations for your mysql Database Allow

SQL PROCESSING ERROR:
No SQL alterations will be performed. However, you may skip SQL processing, continue installing the MOD, and deal with the SQL manually

The following error occured:

Error:
A non-closed string constant has been found: ALTER TABLE phpbb_users ADD user_custitle TEXT";

SQL:


_________________________________

Sorry for not being able to decipher this... now what?

(again, thanks so much for helping)

[Nightrider]

Yep, that's a syntax error too. I'm not surprised there were problems. Since you are the guinea pig to work out these flaws, those that follow shouldn't have to deal with them...

Ok, do this:

OPEN
ShopMod_EM.txt

FIND

Code: Select all

ALTER TABLE phpbb_users ADD user_custitle TEXT";
ALTER TABLE phpbb_users ADD user_specmsg TEXT";
ALTER TABLE phpbb_users ADD user_items TEXT";
ALTER TABLE phpbb_users ADD user_trade TEXT";

REPLACE WITH

Code: Select all

ALTER TABLE phpbb_users ADD user_custitle TEXT;
ALTER TABLE phpbb_users ADD user_specmsg TEXT;
ALTER TABLE phpbb_users ADD user_items TEXT;
ALTER TABLE phpbb_users ADD user_trade TEXT;

Save, upload, and try again using EM...

[anwipr]

Step 2 of 3
Proposed Database Alterations
EasyMOD will now make changes to your database if you command it to. Any SQL with a check next to it will be performed by EM. If you are reinstalling a MOD, you probably do not want to run the SQL a second time, so be careful!

Official Warning: This is a DUMB process. Commands you check off will be executed but EM does NOT check to see if these changes will negatively impact your database. You are STRONGLY advised to backup your database before making any changes. Prior to executing, you are advised to examine each command thoroughly or ask for feedback from experienced MOD installers. Again, if you are reinstalling a MOD, multiple executions of the same SQL lines could adversely effect your database.

Proposed Database Alterations for your mysql Database Allow

SQL PROCESSING ERROR:
No SQL alterations will be performed. However, you may skip SQL processing, continue installing the MOD, and deal with the SQL manually

The following error occured:

Error:
Unknown column name "___5___" in primary key, statement: 1, table: "phpbb_shopitems"

SQL:
CREATE TABLE phpbb_shopitems(id INT UNSIGNED NOT NULL AUTO_INCREMENT,name varchar(32) NOT NULL,shop varchar(32) NOT NULL,sdesc varchar(80) NOT NULL,ldesc TEXT NOT NULL,cost int(20) UNSIGNED DEFAULT '100',stock TINYINT(3) UNSIGNED DEFAULT '10',maxstock TINYINT(3) UNSIGNED DEFAULT '100',sold int(5) UNSIGNED NOT NULL DEFAULT '0',accessforum int(4) DEFAULT '0',PRIMARY KEY('id'),INDEX('name'))


___________________________________

That occured in the same spot as the last error like that.

[Nightrider]

Ok, do this:

OPEN
ShopMod_EM.txt

FIND

Code: Select all

#
#-----[ SQL ]-------------------------------------------------
#
CREATE TABLE phpbb_shopitems (
	   id INT UNSIGNED NOT NULL AUTO_INCREMENT, 
	   name varchar(32) NOT NULL, 
	   shop varchar(32) NOT NULL, 
	   sdesc varchar(80) NOT NULL, 
	   ldesc TEXT NOT NULL, 
	   cost int(20) UNSIGNED DEFAULT '100', 
	   stock TINYINT(3) UNSIGNED DEFAULT '10', 
	   maxstock TINYINT (3) UNSIGNED DEFAULT '100', 
	   sold int(5) UNSIGNED NOT NULL DEFAULT '0', 
	   accessforum int(4) DEFAULT '0', 
	   PRIMARY KEY('id'), 
	   INDEX('name')
);

CREATE TABLE phpbb_shops (
	   id INT UNSIGNED NOT NULL AUTO_INCREMENT, 
	   shopname varchar(32) NOT NULL, 
	   shoptype varchar(32) NOT NULL, 
	   type varchar(32) NOT NULL, 
	   restocktime int(20) UNSIGNED DEFAULT '86400', 
	   restockedtime int(20) UNSIGNED DEFAULT '0', 
	   restockamount int(4) UNSIGNED DEFAULT '5', 
	   amountearnt int(20) UNSIGNED DEFAULT '0', 
	   PRIMARY KEY('id'), 
	   INDEX('shopname')
);

REPLACE WITH

Code: Select all

#
#-----[ SQL ]-------------------------------------------------
#
CREATE TABLE phpbb_shopitems (
	   id INT UNSIGNED NOT NULL AUTO_INCREMENT, 
	   name varchar(32) NOT NULL, 
	   shop varchar(32) NOT NULL, 
	   sdesc varchar(80) NOT NULL, 
	   ldesc TEXT NOT NULL, 
	   cost int(20) UNSIGNED DEFAULT '100', 
	   stock TINYINT(3) UNSIGNED DEFAULT '10', 
	   maxstock TINYINT (3) UNSIGNED DEFAULT '100', 
	   sold int(5) UNSIGNED NOT NULL DEFAULT '0', 
	   accessforum int(4) DEFAULT '0', 
	   PRIMARY KEY(id), 
	   INDEX(name)
);

CREATE TABLE phpbb_shops (
	   id INT UNSIGNED NOT NULL AUTO_INCREMENT, 
	   shopname varchar(32) NOT NULL, 
	   shoptype varchar(32) NOT NULL, 
	   type varchar(32) NOT NULL, 
	   restocktime int(20) UNSIGNED DEFAULT '86400', 
	   restockedtime int(20) UNSIGNED DEFAULT '0', 
	   restockamount int(4) UNSIGNED DEFAULT '5', 
	   amountearnt int(20) UNSIGNED DEFAULT '0', 
	   PRIMARY KEY(id), 
	   INDEX(shopname)
);

Save, upload, and try again using EM...

[anwipr]

did that, then this came up:

________________________________


7 Warning(s) reported by the SQL Parser
Identifier "name" is a reserved keyword (reference: MySQL), statement: 1, table: "phpbb_shopitems"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "cost", statement: 1, table: "phpbb_shopitems"
Identifier "name" is a reserved keyword (reference: MySQL), statement: 1, table: "phpbb_shopitems"
Identifier "type" is a reserved keyword (reference: MySQL), statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "restocktime", statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "restockedtime", statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "amountearnt", statement: 2, table: "phpbb_shops"

7 Warning(s) reported by the SQL Parser
Identifier "name" is a reserved keyword (reference: MySQL), statement: 1, table: "phpbb_shopitems"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "cost", statement: 1, table: "phpbb_shopitems"
Identifier "name" is a reserved keyword (reference: MySQL), statement: 1, table: "phpbb_shopitems"
Identifier "type" is a reserved keyword (reference: MySQL), statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "restocktime", statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "restockedtime", statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "amountearnt", statement: 2, table: "phpbb_shops"

7 Warning(s) reported by the SQL Parser
Identifier "name" is a reserved keyword (reference: MySQL), statement: 1, table: "phpbb_shopitems"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "cost", statement: 1, table: "phpbb_shopitems"
Identifier "name" is a reserved keyword (reference: MySQL), statement: 1, table: "phpbb_shopitems"
Identifier "type" is a reserved keyword (reference: MySQL), statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "restocktime", statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "restockedtime", statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "amountearnt", statement: 2, table: "phpbb_shops"

7 Warning(s) reported by the SQL Parser
Identifier "name" is a reserved keyword (reference: MySQL), statement: 1, table: "phpbb_shopitems"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "cost", statement: 1, table: "phpbb_shopitems"
Identifier "name" is a reserved keyword (reference: MySQL), statement: 1, table: "phpbb_shopitems"
Identifier "type" is a reserved keyword (reference: MySQL), statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "restocktime", statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "restockedtime", statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "amountearnt", statement: 2, table: "phpbb_shops"

7 Warning(s) reported by the SQL Parser
Identifier "name" is a reserved keyword (reference: MySQL), statement: 1, table: "phpbb_shopitems"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "cost", statement: 1, table: "phpbb_shopitems"
Identifier "name" is a reserved keyword (reference: MySQL), statement: 1, table: "phpbb_shopitems"
Identifier "type" is a reserved keyword (reference: MySQL), statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "restocktime", statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "restockedtime", statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "amountearnt", statement: 2, table: "phpbb_shops"

7 Warning(s) reported by the SQL Parser
Identifier "name" is a reserved keyword (reference: MySQL), statement: 1, table: "phpbb_shopitems"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "cost", statement: 1, table: "phpbb_shopitems"
Identifier "name" is a reserved keyword (reference: MySQL), statement: 1, table: "phpbb_shopitems"
Identifier "type" is a reserved keyword (reference: MySQL), statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "restocktime", statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "restockedtime", statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "amountearnt", statement: 2, table: "phpbb_shops"

7 Warning(s) reported by the SQL Parser
Identifier "name" is a reserved keyword (reference: MySQL), statement: 1, table: "phpbb_shopitems"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "cost", statement: 1, table: "phpbb_shopitems"
Identifier "name" is a reserved keyword (reference: MySQL), statement: 1, table: "phpbb_shopitems"
Identifier "type" is a reserved keyword (reference: MySQL), statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "restocktime", statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "restockedtime", statement: 2, table: "phpbb_shops"
Inconsistent display width specified "INTEGER(20) UNSIGNED" in column "amountearnt", statement: 2, table: "phpbb_shops"

Proposed Database Alterations for your mysql Database Allow
1 CREATE TABLE phpbb_shopitems (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(32) NOT NULL,
shop VARCHAR(32) NOT NULL,
sdesc VARCHAR(80) NOT NULL,
ldesc TEXT NOT NULL,
cost INTEGER(20) UNSIGNED DEFAULT 100,
stock TINYINT(3) UNSIGNED DEFAULT 10,
maxstock TINYINT(3) UNSIGNED DEFAULT 100,
sold INTEGER(5) UNSIGNED NOT NULL DEFAULT 0,
accessforum INTEGER(4) DEFAULT 0,
PRIMARY KEY (id),
INDEX name_x1 (name)
);

2 CREATE TABLE phpbb_shops (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
shopname VARCHAR(32) NOT NULL,
shoptype VARCHAR(32) NOT NULL,
type VARCHAR(32) NOT NULL,
restocktime INTEGER(20) UNSIGNED DEFAULT 86400,
restockedtime INTEGER(20) UNSIGNED DEFAULT 0,
restockamount INTEGER(4) UNSIGNED DEFAULT 5,
amountearnt INTEGER(20) UNSIGNED DEFAULT 0,
PRIMARY KEY (id),
INDEX shopname_x1 (shopname)
);

3 INSERT INTO phpbb_config(config_name,config_value) values('multibuys','on');

4 INSERT INTO phpbb_config(config_name,config_value) values('restocks','off');

5 INSERT INTO phpbb_config(config_name,config_value) values('sellrate','75');

6 INSERT INTO phpbb_config(config_name,config_value) values('viewtopic','images');

7 INSERT INTO phpbb_config(config_name,config_value) values('viewprofile','images');

8 INSERT INTO phpbb_config(config_name,config_value) values('viewinventory','grouped');

9 INSERT INTO phpbb_config(config_name,config_value) values('specialshop','ßstoreÞdisabledßnameÞEffects StoreßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1');

10 INSERT INTO phpbb_config(config_name,config_value) values('viewtopiclimit','5');

11 INSERT INTO phpbb_config(config_name,config_value) values('shop_orderby','name');

12 INSERT INTO phpbb_config(config_name,config_value) values('shop_give','on');

13 INSERT INTO phpbb_config(config_name,config_value) values('shop_trade','on');

14 INSERT INTO phpbb_config(config_name,config_value) values('shop_invlimit','0');

15 ALTER TABLE phpbb_users ADD user_effects VARCHAR(255);

16 ALTER TABLE phpbb_users ADD user_privs VARCHAR(255);

17 ALTER TABLE phpbb_users ADD user_custitle TEXT;

18 ALTER TABLE phpbb_users ADD user_specmsg TEXT;

19 ALTER TABLE phpbb_users ADD user_items TEXT;

20 ALTER TABLE phpbb_users ADD user_trade TEXT;

_______________________________________________

next the the numbered list, each item had a checked checkbox, i'm not sure if that is needed info or not...

[Nightrider]

Yes, I was expecting a lot of these warning errors since the MOD author used reserved words for field names in his/her SQL queries. You still should be able to continue though. I don't believe that any of these errors will prevent EM from applying the SQL code or keep the MOD from working. So go ahead and finish the install...

After you install this, make sure you test all of your board pages to make sure they are still working correctly. If this MOD causes problems, be prepared to go into EM History and Restore the Backups that EM creates for you. Make sure you record any new errors that arise due to installing this MOD and we can try to work them out in the code...

The alternative would be to change some of the field names created in the SQL code that are reserved words. Then we would need to find every instance of of these fields in all the included files and in the MOD script and modify them to match the new field names that we have chosen. It's up to you which option to use. Either option should be acceptable...

[anwipr]

aha, it looks like it worked! thanks for your prompt help!

I'll PM you if I find anything that goes wrong, once again, thanks! I sincerely appreciate it!

[Nightrider]

Ok, sounds good anwipr. I've got my fingers crossed that all is working perfectly...

[spitcity]

I did everything you guys explained and got up to the point where anwipr was getting the 7 sql errors, however it wouldnt install for me.

I am looking for a shop to use with cash mod that allows users to buy custom titles, glowing names, bold names etc. and was wondering are there any others out there except zaraths version 2.6

Thanks

[Nightrider]

Did you see an error message explaining why the MOD wouldn't install for you???

I can't help you with your second request. I don't have the Cash or Points MOD installed on my board...