Show Multiple Badges (AKA Stars)

[mark7144]

This mod works fine for me in 1.1 final.

[Krysia]

I'm also all for a 1.1 version!

[mark7144]

I'm also all for a 1.1 version!

It is already fully compatible, it does not need to be re-released!

[Gobo]

yup works for me on 1.1 without errors
thanks

[Krysia]

I'm also all for a 1.1 version!

It is already fully compatible, it does not need to be re-released!

Well, when I tried installling it via the package manager, I got the following:
1.     Execute Modification     ./Sources/Load.php     Test failed
2.    Execute Modification    ./Sources/ManageMembers.php    Test failed
3.    Execute Modification    ./Themes/default/ManageMembers.template.php    Test failed

So, if it works with 1.1, I'll try installing it by hand.

[mark7144]

I'm also all for a 1.1 version!

It is already fully compatible, it does not need to be re-released!

Well, when I tried installling it via the package manager, I got the following:
1.     Execute Modification     ./Sources/Load.php     Test failed
2.    Execute Modification    ./Sources/ManageMembers.php    Test failed
3.    Execute Modification    ./Themes/default/ManageMembers.template.php    Test failed

So, if it works with 1.1, I'll try installing it by hand.

You are trying to install 1.0 of this mod right? Should install fine.

[Krysia]

I'm also all for a 1.1 version!

It is already fully compatible, it does not need to be re-released!

Well, when I tried installling it via the package manager, I got the following:
1.     Execute Modification     ./Sources/Load.php     Test failed
2.    Execute Modification    ./Sources/ManageMembers.php    Test failed
3.    Execute Modification    ./Themes/default/ManageMembers.template.php    Test failed

So, if it works with 1.1, I'll try installing it by hand.

You are trying to install 1.0 of this mod right? Should install fine.

Yeah.
And I installed by hand, but now get this:
Database Error
Unknown column 'showAddBadge' in 'field list'
File: /var/www/html/xx/myurl.com/SMF/Sources/ManageMembergroups.php
Line: 501

When I look at that line in the file, it says:

Code Select Expand

LIMIT 1", __FILE__, __LINE__);




The lines before start as follows:

Code Select Expand

496 // Fetch the current group information.
497  $request = db_query("
498 SELECT groupName, minPosts, onlineColor, maxMessages, stars, showAddBadge
499     FROM {$db_prefix}membergroups
        500     WHERE ID_GROUP = " . (int) $_REQUEST['group'] . "
        501     LIMIT 1", __FILE__, __LINE__);


[Krysia]

Also, I was wondering if the add_settings.php and remove_settings.php files need to be in the main SMF directory or not.

Thank you!

ETA: I uploaded them, because when I opened them, they mentioned something about being in that directory, but made no difference to the error mentioned above.

[mark7144]

The sql code seems fine and regarding the settings.php files, they don't seem to be in my SMF directory either.

[Valodim]

...you didn't apply the sql changes, hence the membergroups table is missing the showAddBadge column.

[Krysia]

...you didn't apply the sql changes, hence the membergroups table is missing the showAddBadge column.

How do I do that?

[Valodim]

just execute this query on your database (replacing {$db_prefix} with your prefix, of course)

Code Select Expand


ALTER TABLE {$db_prefix}membergroups
ADD showAddBadge TINYINT(4) UNSIGNED DEFAULT 0


[Krysia]

just execute this query on your database (replacing {$db_prefix} with your prefix, of course)

Code Select Expand


ALTER TABLE {$db_prefix}membergroups
ADD showAddBadge TINYINT(4) UNSIGNED DEFAULT 0


But how?

[Valodim]

open phpmyadmin, open query window (the little icon labelled "sql" in the upper left corner), copy&paste and click go.

[Krysia]

open phpmyadmin, open query window (the little icon labelled "sql" in the upper left corner), copy&paste and click go.

I got this:
Error

SQL query:

ALTER TABLE {$db_kwjtlff1}membergroups ADD showAddBadge TINYINT( 4 ) UNSIGNED DEFAULT 0

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{$db_kwjtlff1}membergroups
ADD showAddBadge TINYINT(4) UNSIGNED

Really weird for me, because I've never run into this type of problem before.

And when I'd tried to install it via the package manager:
Installing this package will perform the following actions:
   Type    Action    Description
1.    Execute Modification    ./Sources/ModSettings.php    Test successful
2.    Execute Modification    ./Sources/Load.php    Test failed
3.    Execute Modification    ./Sources/MessageIndex.php    Test successful
4.    Execute Modification    ./Sources/BoardIndex.php    Test successful
5.    Execute Modification    ./Sources/Calendar.php    Test failed
6.    Execute Modification    ./Sources/Display.php    Test failed
7.    Execute Modification    ./Sources/Recent.php    Test failed
8.    Execute Modification    ./Sources/PersonalMessage.php    Test failed
9.    Execute Modification    ./Sources/Stats.php    Test successful
10.    Execute Modification    ./Sources/Subs.php    Test successful
11.    Execute Modification    ./Themes/default/Calendar.template.php    Test successful
12.    Execute Modification    ./Themes/default/BoardIndex.template.php    Test successful
13.    Execute Modification    ./Themes/default/languages/Modifications.english.php    Test successful

So I did it by hand. Usually, when I've done it by hand, I've never had to go into the PHPAdmin thing. Thus, my new confusion.

[Valodim]

that's because this mod does changes to the database structure, which most other mods don't.

you have to replace the whole string "{$db_prefix}" with the prefix. as in, kwjtlff1_membergroups.

[Krysia]

Okay, I'm starting to feel like a moron here, because I'm getting the same error.

Would it be possible for you to type exactly what I'd need to copy/paste into the PHPAdmin query thing? I know you did above, but when you say "replace the whole string "{$db_prefix}", you might as well be saying: AWoiudgnfsdo sodgi738 slkdngso kj 2908yvs.?dso.

I now know how my mom feels when she asks me computer questions; this is way out of my scope of practice!
LOL!

[Valodim]

umm... you have to replace the {$db_prefix} part in the query with whatever prefix your database uses. nothing technical there, just remove that part (as in, highlight and hit backspace) and copy&paste or enter your database prefix. default is smf_ , you can find that setting in the server setting tab in your admin panel...

[Krysia]

But do I keep the "$db" part or delete it? Because I've tried it both ways and got the same error.

Do I type {$db_kwjtlff1} or {$db_kwjtlff1_membergroups} or {kwjtlff1_membergroups} or..?

Edit: Okay, I've tried several variations on the same theme, and still the same error. Is there another way to work around this?

[Valodim]

yeah, read this sentence two to three more times.

you have to replace the whole string "{$db_prefix}" with the prefix. as in, kwjtlff1_membergroups.

I said the whole string, meaning everything enclosed by the quotation marks, including the curly brackets. I even told you what it should look like: kwjtlff1_membergroups