Download: [HQ] Awards (Free)

Morozzz · April 9, 2012

Thank you very much.

Simon Culshaw · April 10, 2012

I have installed a fresh installation of your lastest version and it seems to be working nice. Although as soon as I add a reward to someone, I click on the awards tab on my forums and I get this error :

Fatal error: Call to a member function listings_row() on a non-object in /applications_addon/other/jawards/modules_public/awards/awards.php on line 221

Michael's post here should resolve this problem - http://community.invisionpower.com/topic/332003-download-inv-awards/page__st__380#entry2198299

AlexJ · April 14, 2012


Error: ALTER TABLE ipb_groups CHANGE g_can_give_awards g_jlogica_awards_can_give TINYINT(1) NOT NULL DEFAULT '0'

Unknown column 'g_can_give_awards' in 'ipb_groups'

Error: ALTER TABLE ipb_groups CHANGE g_can_remove_awards g_jlogica_awards_can_remove TINYINT(1) NOT NULL DEFAULT '0'

Unknown column 'g_can_remove_awards' in 'ipb_groups'

Error: ALTER TABLE ipb_groups CHANGE g_can_receive_awards g_jlogica_awards_can_receive TINYINT(1) NOT NULL DEFAULT '0'

Unknown column 'g_can_receive_awards' in 'ipb_groups'

How do I fixe above error?

Updating from 2.2.4 Inv to 3.0.6.

installer is stuck on your version 3.0.0

Viper V2 · April 14, 2012

did you run the installer.php file, if not you need to run it if your upgrading to the current version.

AlexJ · April 14, 2012

did you run the installer.php file, if not you need to run it if your upgrading to the current version.

Do you mean "awardsupgrade.php" because I can't find installer.php file.

Actually while trying to update from 3.0.0 to 3.0.6 from ACP I get above mentioned SQL error.

April 14, 2012

Do you mean "awardsupgrade.php" because I can't find installer.php file.

Actually while trying to update from 3.0.0 to 3.0.6 from ACP I get above mentioned SQL error.

If you are upgrading from v3.0.0 you need to run the awardsupgrade.php file before doing the standard upgrade as per the Installation.html instructions.

But from the error message it would seem that you have cooked the system somewhat.

AlexJ · April 14, 2012

Actually, I had 2.2.4 installed. Then i run awardsupgrade.php and uploaded u 3.0.6 version. I hit upgrade and it upgrade to 3.0.0 but after that it gived me that SQL error.

Can I run manual query to fix the DB issue? If yes can you please tell me the query?

April 14, 2012

If you tell it to just go on it should work, dunno why it is throwing that error if you followed the process.

AlexJ · April 14, 2012

I believe I am stuck on your version 301?



===================================================

Date: Sat, 14 Apr 2012 22:52:06 +0000

IP Address: xxxxxxxxxx

Application jawards

Version Folder: 301

Current Sub Step: sql

Current workact: 

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

SQL Error: ALTER TABLE ipb_groups CHANGE g_can_give_awards   g_jlogica_awards_can_give    TINYINT(1) NOT NULL DEFAULT '0'

Duplicate column name 'g_jlogica_awards_can_give'

===================================================

Date: Sat, 14 Apr 2012 22:52:06 +0000

IP Address: xxxxxxxxxx

Application jawards

Version Folder: 301

Current Sub Step: sql

Current workact: 

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

SQL Error: ALTER TABLE ipb_groups CHANGE g_can_remove_awards  g_jlogica_awards_can_remove  TINYINT(1) NOT NULL DEFAULT '0'

Duplicate column name 'g_jlogica_awards_can_remove'

===================================================

Date: Sat, 14 Apr 2012 22:52:07 +0000

IP Address: xxxxxxxxxx

Application jawards

Version Folder: 301

Current Sub Step: sql

Current workact: 

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

SQL Error: ALTER TABLE ipb_groups CHANGE g_can_receive_awards g_jlogica_awards_can_receive TINYINT(1) NOT NULL DEFAULT '0'

Duplicate column name 'g_jlogica_awards_can_receive'

===================================================

Date: Sat, 14 Apr 2012 22:52:07 +0000

IP Address: xxxxxxxxxx

Application jawards

Version Folder: 301

Current Sub Step: sql

Current workact: 

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

SQL Error: CREATE TABLE ipb_jlogica_awards  (

`id` int(255) NOT NULL auto_increment,

`name` varchar(255) NOT NULL,

`desc` text NOT NULL,

`icon` varchar(50) NOT NULL,

`placement` INT(2) NOT NULL,

`parent` INT(255) NOT NULL,

`visible` TINYINT(1) NOT NULL DEFAULT '1',

`public_perms` TEXT NOT NULL,

`location` INT( 8 ) NOT NULL DEFAULT '0',

PRIMARY KEY(id)

) ENGINE=MyISAM;

Table 'ipb_jlogica_awards' already exists

===================================================

Date: Sat, 14 Apr 2012 22:52:07 +0000

IP Address: xxxxxxxxxx

Application jawards

Version Folder: 301

Current Sub Step: sql

Current workact: 

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

SQL Error: CREATE TABLE ipb_jlogica_awards_awarded  (

  `row_id` int(255) NOT NULL auto_increment,

  `award_id` int(255) NOT NULL,

  `user_id` int(255) NOT NULL,

  `auto_award_id` mediumint(8) default NULL,

  `is_active` tinyint(1) NOT NULL default '1',

  `notes` text NOT NULL,

  `date` varchar(45) NOT NULL,

  `awarded_by` INT(255) NOT NULL,

  `approved` TINYINT(1) NOT NULL DEFAULT 1,

  PRIMARY KEY  (`row_id`)

)

Table 'ipb_jlogica_awards_awarded' already exists

===================================================

Date: Sat, 14 Apr 2012 22:52:07 +0000

IP Address: xxxxxxxxxx

Application jawards

Version Folder: 301

Current Sub Step: sql

Current workact: 

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

SQL Error: CREATE TABLE ipb_jlogica_awards_cats  (

  `cat_id` int(255) NOT NULL auto_increment,

  `title` varchar(25) NOT NULL,

  `placement` int(2) NOT NULL,

  `visible` tinyint(1) NOT NULL default '1',

  PRIMARY KEY  (`cat_id`)

)

Table 'ipb_jlogica_awards_cats' already exists

===================================================

Date: Sat, 14 Apr 2012 22:52:07 +0000

IP Address: xxxxxxxxxx

Application jawards

Version Folder: 301

Current Sub Step: sql

Current workact: 

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

SQL Error: CREATE TABLE ipb_jlogica_awards_auto_awards  (

  `inst_id` mediumint(8) NOT NULL auto_increment,

  `award_id` mediumint(8) NOT NULL,

  `title` varchar(35) NOT NULL,

  `type` varchar(25) NOT NULL,

  `data` text NOT NULL,

  `notes` varchar(150) NOT NULL,

  `enabled` tinyint(1) NOT NULL default '1',

  PRIMARY KEY  (`inst_id`)

) ENGINE=MyISAM;

Table 'ipb_jlogica_awards_auto_awards' already exists

April 14, 2012

Send me a pm with ftp/admin access and I will have a look.

(e) Eric · April 14, 2012

I've made the switch from (inv) to (JLogica) awards integration in ibEconomy, so if anyone wants to test it before release (hopefully tomorrow), PM me for a copy.

AlexJ · April 16, 2012

Send me a pm with ftp/admin access and I will have a look.

Send you PM with my FTP/ACP access. Thanks for helping me out!

DeRealDeano · April 16, 2012

I've made the switch from (inv) to (JLogica) awards integration in ibEconomy, so if anyone wants to test it before release (hopefully tomorrow), PM me for a copy.

Hi eric I never knew this was possible at all :), but please do tell what exactly will this in co-operation will do :), sounds really interesting.

April 16, 2012

Hi eric I never knew this was possible at all :smile:, but please do tell what exactly will this in co-operation will do :smile:, sounds really interesting.

You can add an award to the eco store that users can buy with their points.

April 16, 2012

Bit of an update on v3.0.7 and what's happening generally

I have been working on internationalisation, fixing the hooks/settings and cleaning code. It took me a week to fix one file into using language strings and the ACP skin system. I have just finished renaming the last of the setting string to my new system and I need to fix the code to reflect that, I am also no working on the autoaward by posts to make it compatible with my way of handling things hopefully I will have that done by the end of the week then I will start on the next bit of code.

You may ask why I am needing to do so much refactoring, well although the system worked the way it was the code was not very efficient. One big change is that the hooks that handle putting the awards into the topics now cache the user information so that it is not running the query/build process for each of the users posts that's what started me looking at all of the rest of the code.

v3.0.7 will also have a new feature the display can have awarded count displayed, look at the image shot in the download area for an idea.

Anyway back to work...

3DKiwi · April 17, 2012

Thanks. The award count will be really great as some of my members have won the same award multiple times.

3DKiwi

DeRealDeano · April 17, 2012

You can add an award to the eco store that users can buy with their points.

thanks buddy, never new this could be done.

quangtran · April 22, 2012

How can i rename the "Awards" tab in profile view? i want to change it to something else in my language! it's not in the language file, please help

April 22, 2012

umm that's a pretty standard thingy....

ACP > Manage Applications & Modules > JLogica Awards > Application Public Title

quangtran · April 23, 2012

umm that's a pretty standard thingy....

I already did that, and it works everywhere but not on the Tab in profile page. any idea somewhere else to edit?

April 23, 2012

I already did that, and it works everywhere but not on the Tab in profile page. any idea somewhere else to edit?

Sorry missed 'profile' language bits 'awards_profile_view_title' should be the one you want

Connor T · April 23, 2012

On both your site and my own, I receive this JS error when trying to click "View Awarded".


Uncaught ReferenceError: showAwarded is not defined

quangtran · April 23, 2012

Sorry missed 'profile' language bits 'awards_profile_view_title' should be the one you want

there is no key bit 'awards_profile_view_title' in profile language bits. and i tried to add an entry 'awards_profile_view_title' in there with my own value but it still not working at all.
I tried to search 'Awards' in all language and replace them with my own value but the one in profile still cannot be found.
Please help

April 23, 2012

there is no key bit 'awards_profile_view_title' in profile language bits. and i tried to add an entry 'awards_profile_view_title' in there with my own value but it still not working at all.

Then you can change it in the template bit, I am likely looking at it with the internationalisation done in 3.0.7.

On both your site and my own, I receive this JS error when trying to click "View Awarded".

On Razorback Railway it is OK. I am trying to get 3.0.7 done but every time I think I have finsihed I find something else .. hohum :tongue:

quangtran · April 24, 2012

Then you can change it in the template bit, I am likely looking at it with the internationalisation done in 3.0.7.

CAn you tell me what the tempalte bit called? and where it is! i tried to look for it all day long but can't find it :(

Invision Community 4: SEO, prepare for v5 and dormant account notifications

Invision Community 5: Beta testing and latest updates

Invision Community 4: A more professional report center

Invision Community 5: A video walkthrough creating a custom theme and homepage

Download: [HQ] Awards (Free)

Recommended Posts

Morozzz

Simon Culshaw

AlexJ

Viper V2

AlexJ

Guest

AlexJ

Guest

AlexJ

Guest

(e) Eric

AlexJ

DeRealDeano

Guest

Guest

3DKiwi

DeRealDeano

quangtran

Guest

quangtran

Guest

Connor T

quangtran

Guest

quangtran

Archived

Recently Browsing 0 members

More