SMFShop > Coding

Help With Points For Boards

<< < (4/7) > >>

perplexed:
any help with this please Daniel?  I can't access/view boards or posts on the testforum.

Should I just restore the sources back up and start over?  I don't know how to change any of the database stuff though if that is necessary

feeble:
your issue is here

--- Code: ---.shop_perpost, b.shop_bonuses b.permission_mode, c.ID_C
--- End code ---
ill let you spot it


--- Quote ---Error

SQL query:
ALTER TABLE `smf_boards` ADD `shop_pertopic` DECIMAL( 9, 2 ) UNSIGNED NOT NULL ,
ADD `shop_perpost` DECIMAL( 9, 2 ) UNSIGNED NOT NULL ,
ADD `shop_bonuses` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1'

MySQL said: Documentation
#1060 - Duplicate column name 'shop_pertopic'
--- End quote ---
means shop_pertopic already exists, column titles must be unique in each table, so it cant add it again.

so just check the table in your phpmyadmin for the column names if you know how to read the query, either drop them or alter the table query.

more then likely it should be setup correctly in your table, again check this my phpmyadmin

or
just change the query to

--- Code: ---ALTER TABLE `smf_boards` ADD `shop_perpost` DECIMAL( 9, 2 ) UNSIGNED NOT NULL ,
ADD `shop_bonuses` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1'

--- End code ---

perplexed:
lol thanks for letting me spot it but since I dont know what any of it means...

Can you tell me what I need to change?

And I dont know how to read the query *novice* so I guess option two?

feeble:

--- Code: ---.shop_perpost, b.shop_bonuses, b.permission_mode, c.ID_C
--- End code ---
your missing  a comma between .shop_bonuses and b.permission_mode

perplexed:
thanks feeble, I'm a dummy.

I'll go try and see if it works now

Navigation

[0] Message Index

[#] Next page

[*] Previous page