vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - Yet Another Awards System (https://vborg.vbsupport.ru/showthread.php?t=232684)

tomrep 05-19-2012 11:11 PM

when will it be released for 4.1.12

marccap 05-20-2012 12:48 AM

It works on 4.1.12 - check it out on my site

Dave234 05-21-2012 12:35 PM

Do I need to upload both of the folders?

BWG22 05-22-2012 04:39 AM

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

MySQL Error : Duplicate column name 'award_allowrecommend'

How to fix please?

Dave234 05-22-2012 03:06 PM

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 05-22-2012 07:15 PM

Quote:

Originally Posted by Dave234 (Post 2331245)
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.

Quote:

Originally Posted by BWG22 (Post 2331473)
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 05-22-2012 07:15 PM

Quote:

Originally Posted by Dave234 (Post 2331580)
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 05-22-2012 09:59 PM

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 05-22-2012 10:00 PM

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 05-23-2012 10:56 AM

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
  • Page Generation 0.05670 seconds
  • Memory Usage 1,747KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete