Help With Points For Boards

[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: [Select]

.shop_perpost, b.shop_bonuses b.permission_mode, c.ID_Cill let you spot it

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'

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: [Select]

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


[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: [Select]

.shop_perpost, b.shop_bonuses, b.permission_mode, c.ID_Cyour 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

[perplexed]

ok I added the comma

then ran the query in your post:

Code: [Select]

ALTER TABLE `smf_boards` ADD `shop_perpost` DECIMAL( 9, 2 ) UNSIGNED NOT NULL ,
ADD `shop_bonuses` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1'
but in phpmyadmin I got an error saying I had duplicate column:

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'

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]

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

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.

[feeble]

ok sorry i couldnt help you out better

But its probably best to actually try and understand what you were altering, and what the code you were copying and pasting means.

should make it easier next time you attempt to do this.

[perplexed]

ok sorry i couldnt help you out better

But its probably best to actually try and understand what you were altering, and what the code you were copying and pasting means.

should make it easier next time you attempt to do this.

no worries feeble but I dont have time to take a course in php unfortunately.  I guess I understand what was going to change which was why I attempted it but what all the code means, that could take some time lol

I have restored my forum from back up and now its back to 1.1.1 and nothing will work *sigh*

At least its a testforum

[Daniel15]

Yeah, sorry, this is still in beta so may not work perfectly .
About the database columns, the error meant that you had already added them. If they've already been added, you don't need to add them again - Just skip the queries.

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

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

This error is not related to SMFShop.

[perplexed]

yeah I thought it was something like that but I was following the instructions so I dont know how they could have already been added since I didnt add them until I run the query right?

anyway, no matter, I am reinstalling my testforum and al the mods again lol 

Frustratingly some of the mods are getting that 'modification parse error' this time around when they didnt previously.  There seems to be a lot of that going around on the smf forum.

[Jen]

This worked perfectly with my shop 3.0. However, I did get the comma error. Weird because I highlighted the code and it seemed to drop that comma.

For other users, be sure you check that comma before asking...that's what my problem was.



Thanks for the hard work with all these goodies.