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)

Kirkus 06-02-2012 08:43 PM

Is anyone running this on vBulletin 4.2?

I've been using YAAS for years and am looking at an upgrade from vB 3.8.7 --> 4.2. But I have to be able to keep all the awards that have been given out over the years or my members will mutiny. ;)

Crotan 06-02-2012 09:01 PM

Quote:

Originally Posted by Kirkus (Post 2335933)
Is anyone running this on vBulletin 4.2?

I've been using YAAS for years and am looking at an upgrade from vB 3.8.7 --> 4.2. But I have to be able to keep all the awards that have been given out over the years or my members will mutiny. ;)

There's a few bugs here and there for this mod, and it hasn't been touched by the original author in ages. Beyond the the existing bugs, you shouldn't have any issues. I'd wait to hear from someone using this with 4.2

Though you may be better off going over to https://vborg.vbsupport.ru/showthrea...ighlight=ranks

Thunderbird8 06-04-2012 05:42 AM

Going to the vB4 version from the vB3 one won't harm existing awards. The only issue that I can see on 4.2 is that the Awards tab disappears from the navbar, but with the Navigation Manager, it is easy enough to re-add it.

DiageoLiam 06-04-2012 01:23 PM

Also receiving SQL error upon installing. Any fixes found yet?

CubicWebs 06-08-2012 01:05 PM

PHP Code:

Importing ProductPlease Wait...

[:]
Warningmysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award' doesn't exist in [path]/includes/class_core.php on line 1391

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table '
habbfeve_sarah.award_cat' doesn't exist in [path]/includes/class_core.php on line 1391
Adding Awards Tables


Warning
mysqli_query() [function.mysqli-query]: (42000/1064): You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10 in [path]/includes/class_core.php on line 1391
Added Table 
award

Warning
mysqli_query() [function.mysqli-query]: (42000/1064): You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 8 in [path]/includes/class_core.php on line 1391
Added Table 
award_user

Warning
mysqli_query() [function.mysqli-query]: (42000/1064): You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9 in [path]/includes/class_core.php on line 1391
Added Table 
award_cat

Warning
mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award_cat' doesn't exist in [path]/includes/class_core.php on line 1391
Inserted Default Catergory to table - award_cat

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table '
habbfeve_sarah.award' doesn't exist in [path]/includes/class_core.php on line 1391

Warning
mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award' doesn't exist in [path]/includes/class_core.php on line 1391

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table '
habbfeve_sarah.award' doesn't exist in [path]/includes/class_core.php on line 1391
Inserted 
Default Awards to table award

Warning
mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award' doesn't exist in [path]/includes/class_core.php on line 1391
Alter table - award

Warning: mysqli_query() [function.mysqli-query]: (42S21/1060): Duplicate column name '
awardpermissions' in [path]/includes/class_core.php on line 1391
Alter table - usergroup

Tables Altered Successfully


Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table '
habbfeve_sarah.award_user' doesn't exist in [path]/includes/class_core.php on line 1391
Alter table 
2.1.3

Warning
mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award' doesn't exist in [path]/includes/class_core.php on line 1391

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table '
habbfeve_sarah.award_user' doesn't exist in [path]/includes/class_core.php on line 1391
Alter table 
2.1.4

Warning
mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award' doesn't exist in [path]/includes/class_core.php on line 1391
    Database error
The HabbFever database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the habbfeverforum.net home page, then try to open another page.
Click the Back button to try another link.
The habbfeverforum.net 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.2.0:


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   : Table '
habbfeve_sarah.award' doesn't exist
Error Number  
1146
Request Date  
FridayJune 8th 2012 08:01:10 AM
Error Date    
FridayJune 8th 2012 08:01:10 AM
Script        
http://habbfeverforum.net/admincp/plugin.php?do=productimport
Referrer      http://habbfeverforum.net/admincp/plugin.php?do=productadd
IP Address    : **********
Username      : ***
Classname     vB_Database_MySQLi
MySQL Version 
5.5.23-55 


zapiy 06-08-2012 05:09 PM

Is there a Vbadvanced block available for this?

Hamish Gill 06-09-2012 11:32 AM

Ive just tried to install on vb4.2 the import screen just goes blank
tried just dropping it into the right folder on the ftp and nothing ... any thoughts?

Hamish Gill 06-09-2012 11:35 AM

scuse my stupidity ... uploaded then tried importing from server and got a db error
any thoughts?

Code:

Database error in vBulletin 4.2.0:

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

MySQL Error  : Table 'realphot_forum.vb_award' doesn't exist
Error Number  : 1146


CubicWebs 06-09-2012 03:07 PM

Quote:

Originally Posted by Hamish Gill (Post 2338068)
scuse my stupidity ... uploaded then tried importing from server and got a db error
any thoughts?

Code:

Database error in vBulletin 4.2.0:

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

MySQL Error  : Table 'realphot_forum.vb_award' doesn't exist
Error Number  : 1146


You've got a smaller one than me lol, erm I don't think this coder is active anymore :(

Hamish Gill 06-09-2012 05:37 PM

... shame ... yes, just read back a few pages :(
ah well ... ill try something else


All times are GMT. The time now is 07:43 PM.

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.02276 seconds
  • Memory Usage 1,786KB
  • 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
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (2)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