![]() |
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 />"; |
Quote:
Quote:
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. |
Quote:
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?
|
All times are GMT. The time now is 05:12 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|