SMFShop > Coding

Help With Points For Boards

<< < (5/7) > >>

perplexed:
ok I added the comma

then ran the query in your post:


--- 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 ---

but in phpmyadmin I got an error saying I had duplicate column:


--- Quote ---Error

SQL query:

ALTER TABLE `smf_boards` 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_perpost'
--- End quote ---

but I looked at the boards and I only have one of each of these:

countMoney    shop_pertopic    shop_perpost    shop_bonuses

so I still can't read threads or get to boards in the admin panel

perplexed:
Would be it best to reload the sources files again and forget about this?  Do I need to change the database anywhere?

feeble:

--- Quote from: perplexed on April 05, 2007, 06:59:48 am ---but I looked at the boards and I only have one of each of these:

countMoney    shop_pertopic    shop_perpost    shop_bonuses

so I still can't read threads or get to boards in the admin panel


--- End quote ---

i dont understand. if you already have the columns, why are you trying to add them again?

perplexed:
I followed the instructions exactly in Daniels post and thats what it told me to do, but that was the error I got

Then you posted with the query in your post, so I made the comma change and run the query like you suggested.

I dont know what the query means, I'm just following the instructions (badly)

Now when I try to click on a thread I get this:

Unknown column 'b.Avtr_Use' in 'field list'

*clueless*

perplexed:
I gave up and restored my sources from backup as I couldnt access boards or posts.

If I need to make changes to the database can someone please tell me what to do.

Navigation

[0] Message Index

[#] Next page

[*] Previous page