[Dave234]

I just uploaded the one folder.

[squidsk]

Originally Posted by Dave234

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

Originally Posted by Dave234

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

[Dave234]

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

[SN1PERCITY]

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!

[Crotan]

Originally Posted by SN1PERCITY

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?

[tomrep]

when will it be released for 4.1.12

[marccap]

It works on 4.1.12 - check it out on my site

[Dave234]

Do I need to upload both of the folders?

[BWG22]

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

MySQL Error : Duplicate column name 'award_allowrecommend'

How to fix please?

[Dave234]

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 />";

[squidsk]

Originally Posted by Dave234

Do I need to upload both of the folders?

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

Originally Posted by BWG22

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

MySQL Error : Duplicate column name 'award_allowrecommend'

How to fix please?

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.

[squidsk]

Originally Posted by Dave234

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 />";

What is the database error you are getting?

[Dave234]

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.

[Dave234]

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

[Dave234]

Does this make any sense?