Member Awards (2.0 Compatible!)

[Kindred]

enCyde, you would have to list the ACTUAL error, not just "an error in subs.php"

Mechanical Karasu, look at the manual install instructions and run the database portion

[enCyde]

Kindred, this is what I get after I upload the modified Subs.php to my web server.


Parse error: syntax error, unexpected ',' in /home/w139901/public_html/forum/Sources/Subs.php  on line 3177 

[Kindred]

enCyde, what that means is that you did not perform one of the edits correctly. Look at the 10 lines before and 5 lines after that line count for a bad edit.

[enCyde]

oh I'm not good at that.. would you like to take a look? I can attach it...


I would be very happy..

[droganto]

Ok guys i try to give it another chance to the mod since is been updated and Im still receiving the Test Error in the Subs.php file. Last time I ignored the error it mess up my website. I know one of the guys was willing to help, but I didnt have time to reply on time. The mod since very good for what we are planning to do on our site. But so far every Mod I installed on my site has no error. This one those and when this one edited the sub.php then the other aplications I try to install after that were  erroring in the same file.

If anyone want to help I will appreciate it.

P.S. Im not a guru in editing the codes, and normally I dont like to manually change stuff, cause then it wont make it compatible with other mods or is difficult to uninstall. So it will be great that is just get fix so I can install it without any error  Thanks in advance for any help.

[Kindred]

chances are that another mod has alreayd made changes to the spot that this mod is trying to change as well.... THAT is the normal reason for the error and there is really no way to work around it except to install manually, or uninstall the other mods and install this one first.
More specifically... there is nothing in this mod to "fix" since the error is due to previous changes on your side, which are not knowable to the (or any other) mod author when he makes his install file.,

[droganto]

OK Kind, then what you pro, need in order for me to have it fix and dont crash the site.

I dont know which of the mods are stopping this one from working, but as long it work I dont mind doing it. What information you guru people need from me 

[JBlaze]

Attach your Subs.php file here and I'll take a look.

[droganto]

Attach your Subs.php file here and I'll take a look.

[enCyde]

Attach your Subs.php file here and I'll take a look.

[KensonPlays]

FINALLY!!!! DOWNLOADING!!!!

[Babalui]

Unknown column 'aw.award_name' in 'field list'
File: /home2/roryjs5/hsnaruto/Sources/Load.php
Line: 954

My SMF version is 1.1.11. (...)

Mechanical Karasu, look at the manual install instructions and run the database portion

I have the same problem on 1.1.11. When I go to Manual Install Instructions for SMF and choose a version to parse, I constantly get following message for any smf 1.1.x:

An Error Has Occurred!
Sorry, but this modification does not appear to be compatible with the selected version.

http://custom.simplemachines.org/mods/index.php?action=parse

How can I manually update my DB with award filed?

Thanks in advance!

EDIT:
AAAAA WAIT!
OK, I've decided to give it one more try before hitting the sack, so I've read install.php and compared with my DB in phpmyadmin and there were some minor differences. So, I've manually deleted (dropped) all tables with "award" in their name, and then I've tried to install this mod in regular manner and now it seems to be working OK!

[Babalui]

If I may ask for few things, either to add features or to explain me how to implement in SMF 1.1.11...
(sorry if it is already ask and answered)

1. Awards menu - on a menu button bar, next to Forum, Search, Help, Admin. One can click on it and see all awards.
2. To assign an award, instead of going to Admin > Awards, to use above Awards page
3. Under avatar in post, I have text only "Awards", and I would like to have a small pic there.

Thanks

[droganto]

OK I tried to install it again and see if after the installation I can just edit the subs.php file. Which I did, but still was getting this error

Unknown column 'aw.award_name' in 'field list'
File: /home/xecoflc/public_html/forum/Sources/Load.php
Line: 1098

Every time I click on any link about Forums, or whos online, etc. Glad that when I uninstall it, everything works again

[Babalui]

@ droganto - thats the same problem I had. Check part "EDIT: AAAAA WAIT!" in my post, two prior to yours.

[droganto]

@ droganto - thats the same problem I had. Check part "EDIT: AAAAA WAIT!" in my post, two prior to yours.

Thank you Babalui, but I dont know what to edit or where. I opened the install.php and opened the phpadmin but idk what Im  looking. I dose a lot of awards_columns and awards_members_colums inside the install.php but Im not sure what IM doing. If you can help that will be great. Thanks in advance. btw Im using R2 C3, so idk if is the same process you did.

[Babalui]

Yeah, but no
I mean, I've spotted those columns in install.php, but I did nothing with it - as I did not know how to. Instead, I've opened up pahpmyadmin to directly examine my SMF DB. There, I saw three "award" tables, but their filed names did not fully match names in install.php. I've come to conclusion that they were leftovers from previous award mods, as I experimented with many.
I guess that install.php from this mod was not able to "adjust" tables - they had the same names as used by other award mod or previous version of this one? Dunno for sure.
So, in phpmyadmin, I've deleted those three tables. You can do that when you click DB name (yourweb_forumsmf on attached pic), and then click X mark in row of that table (terminology is "drop table").
After I have deleted (dropped) all three tables, I went back to smf forum admin page > packages and run the regular install, and then it was OK.

Pic below shows what a table look like at this moment, that is correctly. It differed slightly before.
As for phpmyadmin usage, it is simple, but how to access it depends on your hosting provider....

[Kindred]

yes... if you had previously installed another awards mod, the left-over tables will cause this one to fail because the database portion can not create new tables with the correct columns. (That has been noted several times in this thread)

[droganto]

Bubalui I do appreciate the answer and the time you took to make the picture and everything. Maybe since I upgraded from 1.1.11 I have some awards table. So I will check that now in my DB. Yes I do use CPanel so is the same process that you explained.

Kindred, Im new into this editing databases and php files. Im the type of user that need things stupid proof, Just install and forget about it. Sorry it was mentioned befored in the thread and I didnt take the time to read the 91 pages of post. To get an answer that someone like Bubalui did it in few post.

[droganto]

Bubalui.

OFFICIALLY THANK YOU

I did find the 3 awards databases and delete them. Then installed the Mod again and links are working. Thanks a lot for your help. Now I just need to find a webiste where I can download badges and awards so I dont have to make them  all