Gunnar94 Posted August 17, 2011 Author Posted August 17, 2011 Is this a fresh install or an upgrade, if you are installing try below: Try running this query in your ACP.CREATE TABLE inv_awards_awarded ( `row_id` int(255) NOT NULL auto_increment, `award_id` int(255) NOT NULL, `user_id` int(255) NOT 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`) )Be sure to include your database table prefix. IF UPGRADING: Please tell me the error you are getting.
PersonalMode Posted August 18, 2011 Posted August 18, 2011 Hi topthrillkid, I update 2.2.0 to 2.2.2, and I have this error during the upgrade : Error: ALTER TABLE ibf_`groups` ADD `g_can_receive_awards` TINYINT(1) NOT NULL DEFAULT '1' You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`groups` ADD `g_can_receive_awards` TINYINT(1) NOT NULL DEFAULT '1'' at line 1 Error: ALTER TABLE ibf_`inv_awards` ADD `public_perms` TEXT NOT NULL You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`inv_awards` ADD `public_perms` TEXT NOT NULL' at line 1 Error: ALTER TABLE ibf_`inv_awards_awarded` ADD `awarded_by` INT( 255 ) NOT NULL AFTER `user_id` You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`inv_awards_awarded` ADD `awarded_by` INT( 255 ) NOT NULL AFTER `user_id`' at line 1 Error: ALTER TABLE ibf_`inv_awards_awarded` ADD `approved` TINYINT(1) NOT NULL DEFAULT 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`inv_awards_awarded` ADD `approved` TINYINT(1) NOT NULL DEFAULT 1' at line 1
Azoun Posted August 22, 2011 Posted August 22, 2011 Any idea when the issue with friendly url's will be solved?
Viper V2 Posted August 23, 2011 Posted August 23, 2011 I got the awards app nicely. my only question is how do I get it from showing the resized awards in the topic profile view? The do not show option in the ACP is not working for me. thanks
Andrej Posted August 24, 2011 Posted August 24, 2011 This has probably been asked but is it planned to have auto awards? Things like were it automatically gives awards to x post count / join date / etc.
Sinistra Sensei Posted August 25, 2011 Posted August 25, 2011 Broken images in admin CP? How do I fix this and also Renaming the main category or the option to delete?
Heosforo Posted August 26, 2011 Posted August 26, 2011 Reading so many member errors I thought it would be difficult, but it works perfect thanks a lot. Any chance to hide the tab menu?
Gunnar94 Posted August 30, 2011 Author Posted August 30, 2011 This has probably been asked but is it planned to have auto awards? Things like were it automatically gives awards to x post count / join date / etc. Yes, just trying to figure out the best way to make that all happen for now. Broken images in admin CP? How do I fix this and also Renaming the main category or the option to delete? Install the latest version.
Viper V2 Posted August 31, 2011 Posted August 31, 2011 I have noticed that if you have a deleted member in your thread then it throws the User's Awards off for everyone within that thread or page in the topic views for the awards.
Gunnar94 Posted August 31, 2011 Author Posted August 31, 2011 What do you mean by it throws them off, what exactly happens?
PersonalMode Posted August 31, 2011 Posted August 31, 2011 Hi topthrillkid, I update 2.2.0 to 2.2.2, and I have this error during the upgrade : Error: ALTER TABLE ibf_`groups` ADD `g_can_receive_awards` TINYINT(1) NOT NULL DEFAULT '1' You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`groups` ADD `g_can_receive_awards` TINYINT(1) NOT NULL DEFAULT '1'' at line 1 Error: ALTER TABLE ibf_`inv_awards` ADD `public_perms` TEXT NOT NULL You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`inv_awards` ADD `public_perms` TEXT NOT NULL' at line 1 Error: ALTER TABLE ibf_`inv_awards_awarded` ADD `awarded_by` INT( 255 ) NOT NULL AFTER `user_id` You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`inv_awards_awarded` ADD `awarded_by` INT( 255 ) NOT NULL AFTER `user_id`' at line 1 Error: ALTER TABLE ibf_`inv_awards_awarded` ADD `approved` TINYINT(1) NOT NULL DEFAULT 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`inv_awards_awarded` ADD `approved` TINYINT(1) NOT NULL DEFAULT 1' at line 1 Can you help me ??
Viper V2 Posted August 31, 2011 Posted August 31, 2011 What do you mean by it throws them off, what exactly happens? For example in a thread that has a deleted member within it, the deleted member will show it has User's Award in it's topic profile and then go below that deleted member and there is a member who's awards are not right in the topic view until it just stops having the user awards in the topic view towards the bottom of the page.
Viper V2 Posted August 31, 2011 Posted August 31, 2011 I downloaded the most recent upgrade or Beta and I beleive there are 2 settings in the system setting part that appear to be the same thing: Listings Page Settings Enable Awards System YesNo Enable/Disable all public areas for this awards applications. (Listings page and profile tab) Revert Edit Delete Listings Page Settings Enable Awards System YesNo Enable/Disable all public areas for this awards applications. (Listings page and profile tab)
Gunnar94 Posted September 1, 2011 Author Posted September 1, 2011 Can you help me ?? Upgrade to version 2.2.3 BETA 1, skip 2.2.2 For example in a thread that has a deleted member within it, the deleted member will show it has User's Award in it's topic profile and then go below that deleted member and there is a member who's awards are not right in the topic view until it just stops having the user awards in the topic view towards the bottom of the page. If you could give me a screenshot or link, I think I understand, but just want to be sure. I downloaded the most recent upgrade or Beta and I beleive there are 2 settings in the system setting part that appear to be the same thing: Listings Page Settings Enable Awards System YesNo Enable/Disable all public areas for this awards applications. (Listings page and profile tab) Revert Edit Delete Listings Page Settings Enable Awards System YesNo Enable/Disable all public areas for this awards applications. (Listings page and profile tab) Not sure, why it's doing that, I had the same result. You can just delete one.
Viper V2 Posted September 2, 2011 Posted September 2, 2011 Upgrade to version 2.2.3 BETA 1, skip 2.2.2 If you could give me a screenshot or link, I think I understand, but just want to be sure. Not sure, why it's doing that, I had the same result. You can just delete one. Just for instance in a thread that has a post from a deleted member it will then mess up the chain on user awards in the topic view for the members who have posted below that deleted member.
whoisdo Posted September 2, 2011 Posted September 2, 2011 Are you still planning on having a gamerscore/points value added to this?
Azoun Posted September 2, 2011 Posted September 2, 2011 Any idea when the issue with friendly url's will be solved? Any idea?
Viper V2 Posted September 2, 2011 Posted September 2, 2011 Here is a screen shot showing how a deleted member shows the user awards in the topic view. It should not show any for a deleted member.
Gunnar94 Posted September 2, 2011 Author Posted September 2, 2011 Any idea? It is already, in version 2.2.3 BETA 1. Here is a screen shot showing how a deleted member shows the user awards in the topic view. It should not show any for a deleted member. Ok, thank you, I will look into it.
groverr Posted September 4, 2011 Posted September 4, 2011 and showed how to do this in your signature
Viper V2 Posted September 5, 2011 Posted September 5, 2011 you got an eta of when the fix for the deleting members and messed up awards in the profile will be? thanks
Gunnar94 Posted September 5, 2011 Author Posted September 5, 2011 Not yet, sorry. I have been without power for a few days now, a big storm rolled through. I will hopefully be able to make an estimate on Wednesday as we still do not have power, I am working off of a generator.
Viper V2 Posted September 10, 2011 Posted September 10, 2011 Hello, not to bug you, but any fix yet on the deleted member topic view bug?
Gunnar94 Posted September 11, 2011 Author Posted September 11, 2011 (inv) Awards 2.2.3 BETA 2 uploaded to the IPS Marketplace and at Invision Envy. Fix for deleted members in topic is included, BV Gaming! ;)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.