How to install AUP rules?
By Derek Zhou on Tuesday, 30 September 2014
Posted in Installation Issues
Replies 4
Likes 0
Views 1.3K
Votes 0
I'm using the latest Komento and Easyblog 3.9.18613 and AlphaUserPoints 1.9.10. I've downloaded the rules' plugins. But failed to install it.

For Easyblog, I downloaded the plugin here:
http://stackideas.com/downloads/plugins
It says:
AlphaUserPoints rules files used in EasyBlog. Install the rules file (you do not need to extract the zip file) via AlphaUserPoints backend under plugin installer page.

If I do not extract the zip file, there's no way to install it. If I extract it and install (xml file), then it shows the error:

Column count doesn't match value count at row 1 SQL=INSERT INTO mq13i_alpha_userpoints_rules VALUES ('', 'Upload avatar', 'This rule add points if user upload avatar in EasyBlog', 'EasyBlog', 'plgaup_easyblog_upload_avatar', '1', 'EasyBlog', '', '', '0', '0', 0, '0000-00-00 00:00:00', '', '', '', '', '0', '0', '0', '0', '1', '1', '', '0', '', '0', '0', '', '', '0', '0', '0')

What's wrong?

Thanks!
Hello,

Hm, it looks like Alpha User Points has updated their database and this is probably causing this errors. We'll need to check on this and update the plugins soon.
Mark
·
Tuesday, 30 September 2014 23:23
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello zhous1998,

Sorry for late reply to this,
Can you try apply this temporary solution and see how it goes?
-> JoomlaFolder\administrator\components\com_alphauserpoints\models\plugins.php


//LINE 89

						$query = "INSERT INTO #__alpha_userpoints_rules VALUES ('', '".$nameRule."', '".$descriptionRule."', '".$componentRule."', '".$pluginRule."', '1', '".$componentRule."', '', '', '0', '0', 0, '0000-00-00 00:00:00', '', '', '', '', '0', '0', '0', '0', '1', '".$fixedpointsRule."', '".$categoryRule."', '".$displayMessage."', '', '0', '".$emailNotification."', '', '', '0', '0', '0')";



//Replace with

						$query = "INSERT INTO #__alpha_userpoints_rules VALUES ('', '".$nameRule."', '".$descriptionRule."', '".$componentRule."', '".$pluginRule."', '1', '".$componentRule."', '', '', '0', '0', 0, '0000-00-00 00:00:00', '', '', '', '', '0', '0', '0', '0', '1', '".$fixedpointsRule."', '".$categoryRule."', '".$displayMessage."', '', '0', '".$emailNotification."', '', '', '0', '0', '0', '0', '0')";

If work, is it possible consult with AUP developer regarding this and see is it have a better solution about this? Keep us updated then if you receive their respond.
Arlex Wong
·
Wednesday, 01 October 2014 18:45
·
0 Likes
·
0 Votes
·
0 Comments
·
Fortunately, AlphaUserPoints has updated and the bug is fixed.
But the rules package for EasyDiscuss is not published. We can only google the threats and get it. I mean we cannot find it around the "download" menu.
Thank you!
Derek Zhou
·
Monday, 03 November 2014 20:29
·
0 Likes
·
0 Votes
·
0 Comments
·
hello zhous1998,

Thanks for getting back to us, that was great, finally that bug is fixed.
You can download my attachment file here.
Arlex Wong
·
Monday, 03 November 2014 23:53
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post