Is is compatible with latest version 4.1.12 ?
Could you update it for that ?

Regards,,

See the posts above yours by me on the page for how to fix this, starting with post 1069.

Hello everyone, I wanted to ask you if you think you could make a retroactive award. For example, if I create a award of the 100th post inserted at the time of creation but there are already users with 100 posts, you can automatically assign the award ?
I try but there isn't nothing to do...the award not display

No, the awards are not retroactive, you'll need to do a manual insert query on the database to achieve what you're after. I posted a sample query either in this thread or the one for the vb3.8 version of this mod that you could use.

Hi,

Eveything set up except automatic awards. How are these set up with the software - eg what goes in the bottom for for example 1000 posts:

Automation Task Name -
Award ID to Automate -

Thanks

bump

So no answer for me?

When will a version for 4.1.12 be available?

Hallo,
I tried to install Award System and received the following error:

https://vborg.vbsupport.ru/external/2012/05/40.png

My vbulletin version is 4.1.12.

What should I do?

I got the EXACT same database error when I tried to install it. I also am running 4.1.12.

I think its an issue with the install script. Do both of your forums have a table prefix?

I downloaded the "YaAS-4.0.2-PL1" zip file, did what the instructions told me, and it seemed to upload fine. It added the "Awards" tab to my forum. HOWEVER, when I click the "Awards" tab, it takes me to a page with no content. It says:

404 Error File Not Found
The page you are looking for might have been removed,
had its name changed, or is temporarily unavailable.

Can you please assist?? This is very confusing.

It sounds like you didn't upload the files to the correct location, or there was an error with the installation.

How do I upload? I see there are three files. Two folders and one Word doc.

I just uploaded the one folder.

You need to upload the contents of the upload folder to your forum's root folder (i.e. the same location where the index.php for the forum is lcoated).

I did that for the one folder. Do I need to do it for the other one also?

so will this be fixed for 4.1.12. just wondering cause i had it for 4.1.5 or .6 and it was great could we get this fixed for it please!

Still working here on 4.1.12?

when will it be released for 4.1.12

It works on 4.1.12 - check it out on my site

Do I need to upload both of the folders?

I uninstalled the plug-in, and tried to reinstall and got this....

MySQL Error : Duplicate column name 'award_allowrecommend'

How to fix please?

There is an error in my upload. I tried uploading both folders via ftp.

As soon as I tried uploading the "product-yet_another_award_system" from the "YaAS-4.0.2-PL1" folder, it gave me a database error.

In my AdminCP, Plugin Manager, Edit Product screen, these are what appear under the "Install Code":

Version 1.0.0:

$db->reporterror = 0;
// NEW INSTALL CODE
if ($installed_version == null) {

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "award_user ADD award_cgroup VARCHAR( 15 )");
echo "<font size=\"1\">Alter table - award_user - criteria group</font><br />";

}



Version 1.0.2:
// CREATE AWARD AUTOMATION TABLE
$db->reporterror = 0;

$db->query_write("CREATE TABLE " . TABLE_PREFIX . "award_automation (
award_automation_id int(10) unsigned NOT NULL auto_increment,
auto_active int(1) NOT NULL,
auto_name varchar(32) NOT NULL,
auto_issuereason varchar(255) NOT NULL,
auto_type varchar(32) NOT NULL,
auto_criteria int(10) NOT NULL,
auto_awardid int(10) NOT NULL,
PRIMARY KEY (award_automation_id)
)
");
echo "<font size=\"1\">Added Table - Award Automation</font><br />";

No just the contents of the upload folder, if you uploaded the contents correctly and installed the xml correctly it should work.

What version did you uninstall? If you started with a 4.0.2PL1 version, the only error you should get when uninstalling and reinstalling is related to some missing uninstall code for the award_requests table.

That being said, if you run the following sql commands from admincp it should remove any leftover stuff.


show tables
drop table *award*


The first command will list all your tables, then you'll need to use the second command as many times as needed, by replacing the *award* with the name of an award table that was left around by mistake.

What is the database error you are getting?

Alter table - award
Alter table - usergroup

Tables Altered Successfully

Alter table - 2.1.3
Alter table - 2.1.4





Database error



The Social Hulk Espa?ol database has encountered a problem.




--------------------------------------------------------------------------------




Please try the following: •Load the page again by clicking the Refresh button in your web browser.
•Open the www.socialhulk.com home page, then try to open another page.
•Click the Back button to try another link.



The www.socialhulk.com forum technical staff have been notified of the error, though you may contact them if the problem persists.




We apologise for any inconvenience.

Database error in vBulletin 4.1.11:

Invalid SQL:
ALTER TABLE award ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_pointvalue TINYINT( 3 ) DEFAULT 0 NOT NULL;

MySQL Error : Duplicate column name 'award_allowrecommend'
Error Number : 1060
Request Date : Tuesday, May 22nd 2012 @ 04:58:59 PM
Error Date : Tuesday, May 22nd 2012 @ 04:58:59 PM
Script : http://www.socialhulk.com/spanish/ad...=productimport
Referrer : http://www.socialhulk.com/spanish/ad...?do=productadd
IP Address : (hidden because confidential?)
Username : El Luchador Rubio
Classname : vB_Database
MySQL Version : 5.1.63-community-log

Does this make any sense?

Ok, the SQL command worked and it installed, but now it brings me back to the awards main page getting this message.

Fatal error: Cannot redeclare construct_depth_mark() in /public_html/forums/includes/adminfunctions.php on line 1915

keep getting this message when i try to upload the xml product

Database error in vBulletin 4.1.12:

Invalid SQL:
ALTER TABLE vbaward ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_pointvalue TINYINT( 3 ) DEFAULT 0 NOT NULL;

MySQL Error : Duplicate column name 'award_allowrecommend'
Error Number : 1060
Request Date : Wednesday, May 23rd 2012 @ 06:25:31 PM
Error Date : Wednesday, May 23rd 2012 @ 06:25:32 PM
Script : http://fataltalentgaminglive.com/adm...=productimport
Referrer : http://fataltalentgaminglive.com/adm...?do=productadd
IP Address : 75.137.26.203
Username : Admin
Classname : vB_Database
MySQL Version : 5.1.63-community-log

What exactly were you doing that caused this error to occur? The only reference I can find to this function within the awards files is in a location that does not make use of the file includes/adminfunctions.php.

Are you upgrading or re-installing the plugin? If re-installing then follow my instructions on the last page about deleting tables that weren't properly uninstalled. If upgrading what version are you upgrading from?

Didn't do anything I wasn't supposed to. It was the error I had before when I upgraded my vB to 4.1.11. It just started giving me that error after the upgrade completed. Since then, I uninstalled it, dropped the tables, and re-installed and I still get the error.

What other plugins are you running? I'm on a clean vb4.1.12PL1 and don't get that message, nor did I get it when the forum was on 4.1.10.

As I said the only place in the awards code that creates its own construct_depth_mark function is in the awards.php file, which does not require adminfunctions.php nor does in require a file which requires adminfunctions.php.

I was specifically asking what actions you'd taken (e.g. trying to view/change the awards settings) that causes that error.

Mine is the same (please see my last post). Can you please assist?

Did you read my response to FTG LIQUID CL?

yes i will work on it

its the first time i have installed this product,i have tried to re install the xml file but keep getting that message

Follow my instructions on the previous page how to delete the previous install correctly. First uninstall the plugin if it shows up in the plugin list, then you'll need to drop the three tables (if all of them were created) before trying to re-install.