Effects Shop is Disabled & No Items display in admin?

  -----  
Author Message

Gemini Stone
Member
Fri Mar 07, 2008 1:30 pm   Post subject: Effects Shop is Disabled & No Items display in admin?
Ok, bear with me, I'm fairly new to phpBB but loving it. I've used other's forums for years but I had no idea there were this many mods for it lol

I have Shop 3 (with Cash Mod, latest version) & I just installed Effects Shop using EZMod (sorry, didn't know any better - but do after reading through this forum lol)

The first problem I ran into was that EZMod generated a critical error due to special characters being in the install.txt that shouldn't be there. Looks like the effect you get if you upload a file in FTP Binary mode instead of ASCII.

I opened install.txt in winword, then saved as txt thus loosing the formatting, re-uploaded it to the server (FreeBSD) & iInstall went on as planned, no problems. Ran the sql install file, no errors.

Now when I go to my forums, I see the Effects Shop in the shop list, but when I click it it says it's disabled?

Also in the Shop Settings, when I go to edit the shop, it's there but there is no inventory.

If there's anything I'm going to need to change by hand plz dumb it down as much as possible - I'm a System Engineer & fairly decent Graphics Designer but coding & I just don't see eye to eye most of the time lol

Thanks!
 

Gemini Stone
Member
Mon Mar 17, 2008 3:56 am   Post subject:
*tap tap* is this thing on? lol

I manually removed the shops installed and then ran the install.php again. Not sure if I totally overlooked the errors before or if they're new, but here's install.php's output.

Code:


INSERT INTO phpbb_shop_addons (id, addon_name, addon_display, addon_description, addon_url, addon_version, addon_author) VALUES (1, 'effects', 'EFFECTS_NAV', '', 'effects_config.php', '2.0.0', 'Thoul')
Failed due to error: Table 'kenetic_rdl.phpbb_shop_addons' doesn't exist

# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, special_link, icon_location, item_template, effect_type, effect_field) VALUES ('Rank Color', 'Special Effects', 'Change the color of your rank title.', 'Changes the color of your rank title on the forum.', 150, 0, 255, 255, 0, 'shop_effects.php?m=equip', 'shop/images/pallete_color.gif', 'effects_color_details.tpl', 'color', 'rank')
Failed due to error: Unknown column 'cash_id' in 'field list'

# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, special_link, icon_location, item_template, effect_type, effect_field) VALUES ('Rank Glow', 'Special Effects', 'Add a glowing background color to your rank title.', 'Give your rank title a glowing background color on the forum.', 150, 0, 255, 255, 0, 'shop_effects.php?m=equip', 'shop/images/pallete_glow.gif', 'effects_color_details.tpl', 'glow', 'rank')
Failed due to error: Unknown column 'cash_id' in 'field list'

# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, special_link, icon_location, item_template, effect_type, effect_field) VALUES ('Rank Shadow', 'Special Effects', 'Add a shadowy background color to your rank title.', 'Give your rank title a shadowy background color on the forum.', 150, 0, 255, 255, 0, 'shop_effects.php?m=equip', 'shop/images/pallete_shadow.gif', 'effects_color_details.tpl', 'shadow', 'rank')
Failed due to error: Unknown column 'cash_id' in 'field list'

# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, special_link, icon_location, item_template, effect_type, effect_field) VALUES ('Username Color', 'Special Effects', 'Change the color of your username.', 'Changes the color of your username on the forum.', 150, 0, 255, 255, 0, 'shop_effects.php?m=equip', 'shop/images/pallete_color.gif', 'effects_color_details.tpl', 'color', 'name')
Failed due to error: Unknown column 'cash_id' in 'field list'

# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, special_link, icon_location, item_template, effect_type, effect_field) VALUES ('Username Glow', 'Special Effects', 'Add a glowing background color to your username.', 'Give your username a glowing background color on the forum.', 150, 0, 255, 255, 0, 'shop_effects.php?m=equip', 'shop/images/pallete_glow.gif', 'effects_color_details.tpl', 'glow', 'name')
Failed due to error: Unknown column 'cash_id' in 'field list'
# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, special_link, icon_location, item_template, effect_type, effect_field) VALUES ('Username Shadow', 'Special Effects', 'Add a shadowy background color to your username.', 'Give your username a shadowy background color on the forum.', 150, 0, 255, 255, 0, 'shop_effects.php?m=equip', 'shop/images/pallete_shadow.gif', 'effects_color_details.tpl', 'shadow', 'name')
Failed due to error: Unknown column 'cash_id' in 'field list'

# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, special_link, icon_location, item_template, effect_type, effect_field) VALUES ('Title Color', 'Special Effects', 'Change the color of your custom title.', 'Changes the color of your custom title on the forum.', 150, 0, 255, 255, 0, 'shop_effects.php?m=equip', 'shop/images/pallete_color.gif', 'effects_color_details.tpl', 'color', 'title')
Failed due to error: Unknown column 'cash_id' in 'field list'

# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, special_link, icon_location, item_template, effect_type, effect_field) VALUES ('Title Glow', 'Special Effects', 'Add a glowing background color to your custom title.', 'Give your custom title a glowing background color on the forum.', 150, 0, 255, 255, 0, 'shop_effects.php?m=equip', 'shop/images/pallete_glow.gif', 'effects_color_details.tpl', 'glow', 'title')
Failed due to error: Unknown column 'cash_id' in 'field list'

# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, special_link, icon_location, item_template, effect_type, effect_field) VALUES ('Title Shadow', 'Special Effects', 'Add a shadowy background color to your custom title.', 'Give your custom title a shadowy background color on the forum.', 150, 0, 255, 255, 0, 'shop_effects.php?m=equip', 'shop/images/pallete_shadow.gif', 'effects_color_details.tpl', 'shadow', 'title')
Failed due to error: Unknown column 'cash_id' in 'field list'

# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, special_link, icon_location, item_template, effect_type, effect_field) VALUES ('Message Color', 'Special Effects', 'Change the color of text in your posts.', 'Changes the default color of text in your posts.', 150, 0, 255, 255, 0, 'shop_effects.php?m=equip', 'shop/images/pallete_color.gif', 'effects_color_details.tpl', 'color', 'post')
Failed due to error: Unknown column 'cash_id' in 'field list'

# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, special_link, icon_location, item_template, effect_type, effect_field) VALUES ('Message Background', 'Special Effects', 'Change the background color of your posts.', 'Changes the default background color of your posts.', 150, 0, 255, 255, 0, 'shop_effects.php?m=equip', 'shop/images/pallete_bgcolor.gif', 'effects_color_details.tpl', 'bgcolor', 'post')
Failed due to error: Unknown column 'cash_id' in 'field list'

# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, special_link, effect_field) VALUES ('Name Tag', 'Special Effects', 'Use this tag to give yourself a new name.', 'Use this item from your inventory to change your username. This item is automatically discarded after use.', 150, 0, 250, 255, 0, 'shop_effects.php?m=namechange', 'namechange')
Failed due to error: Unknown column 'cash_id' in 'field list'
# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, special_link, item_template, effect_type, effect_field) VALUES ('Title Tag', 'Special Effects', 'Create your own title to display with your posts.', 'Use this item from your inventory to activate your own custom title. Custom titles will be displayed in your posts and profile. You can also buy Title effects to add color to your custom title.', 150, 0, 255, 255, 0, 'shop_effects.php?m=equip', 'effects_title', 'content', 'title')
Failed due to error: Unknown column 'cash_id' in 'field list'

# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, item_template, effect_type, effect_field) VALUES ('Title Stamp', 'Special Effects', 'Give other members a new title.', 'Purchase this item to assign a new custom title to another member. The custom title will be displayed in their posts and profile. This item is automatically given to the affected member as a Title Tag after purchase.', 150, 0, 252, 255, 0, 'effects_title', 'content', 'othertitle')
Failed due to error: Unknown column 'cash_id' in 'field list'

# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, effect_type, effect_field) VALUES ('Signature Ticket', 'Special Effects', 'Allows you to use signatures.', '"The holder of this ticket is entitled to use one signature," is written on the item.', 150, 0, 255, 255, 0, 'priv', 'sig')
Failed due to error: Unknown column 'cash_id' in 'field list'

# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, effect_type, effect_field) VALUES ('Title Badge', 'Special Effects', 'Replace your rank title with your custom title.', 'This special badge will display your custom title in the place of your rank title. You can make a custom title with a Title Tag.', 150, 0, 255, 255, 0, 'content', 'rank')
Failed due to error: Unknown column 'cash_id' in 'field list'

# INSERT INTO phpbb_shopitems (name, shop, sdesc, ldesc, cost, cash_id, stock, maxstock, sold, effect_type, effect_field) VALUES ('Avatar Ticket', 'Special Effects', 'Allows you to use avatars.', '"The holder of this ticket is entitled to use one avatar," is written on the item.', 150, 0, 255, 255, 0, 'priv', 'avatar')
Failed due to error: Unknown column 'cash_id' in 'field list'


If anyone could help I'd really appreciate it. At this point my users can't edit signatures, usernames, nada....so getting this fixed is kinda critical.

I can't just do a database restore b/c I've had new users sign up since then & I tried using install.php's "uninstall" but it just spit fatal errors at me as well.

HELP!!!
 

Page 1 of 1
Display posts from previous: