Jump to content

Community

Spanner

(DB31) Reputation History

Recommended Posts

%7Boption%7D



File Name: (DB31) Reputation History

File Submitter: Spanner

File Submitted: 22 Oct 2010

File Category: User and Social Engagement

Supported Versions: IP.Board 3.1.x, IP.Board 3.2.x, IP.Board 3.3.x



Author: Spanner (IPSBeyond.pl)


Wersja: 1.1.0
Version: 1.1.0

Opis: Aplikacja pokazująca historię reputacji.

Description: Application showing history of reputations.

Demo: http://www.ipsbeyond.pl/reputationhistory/



here to download this file

Share this post


Link to post
Share on other sites

I get an SQL error when clicking the "reputation received" tab in profile view.

Also when clicking both tasb arfter the error nothing happens.

This error appears:

Error: 1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Share this post


Link to post
Share on other sites

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

 Date: Sat, 23 Oct 2010 10:41:44 +0000

 Error: 1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

 IP Address: 124.157.225.113 - /forum/index.php?app=members&section=load&module=ajax&member_id=3076&tab=reputationhistory:reputation_received&md5check=3cefb95905de8d3419a6da87a049e6be

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

 mySQL query error: SELECT COUNT(ri.id) as amount,p.pid FROM ibf_reputation_index ri,ibf_posts p WHERE p.author_id=3076 AND p.pid=ri.type_id

 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.

 | File                                                                       | Function                                                                      | Line No.          |

 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|

 | admin/applications/members/modules_public/ajax/load.php            | [profile_reputation_received].return_html_block                               | 110               |

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 | admin/sources/base/ipsController.php                               | [public_members_ajax_load].doExecute                                          | 417               |

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 | admin/sources/base/ipsController.php                               | [ipsAjaxCommand].execute                                                      | 101               |

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'



IS the full error...

Any hints on what my problem might be?

Share this post


Link to post
Share on other sites

Try open file /admin/applications_addon/other/reputationhistory/extensions/profileTabs/reputation_received.php

Find:

$countQuery = array(

                            'select'   => 'COUNT(ri.id) as amount',

                            'from'     => array( 'reputation_index' => 'ri' ),

                            'add_join' => array(

                                                    array(

                                                        'select' => 'p.pid',

                                                        'from'  => array( 'posts' => 'p' ),

                                                        'where' => 'p.pid=ri.type_id',

                                                        'type'   => 'inner'

                                                    ),

                                                ),

                            'where'    => 'p.author_id='.$member['member_id'],

                        );

Replace to:


$countQuery = array(

                            'select'   => 'COUNT(ri.id) as amount',

                            'from'     => array( 'reputation_index' => 'ri' ),

                            'add_join' => array(

                                                    array(

                                                        'select' => 'p.author_id',

                                                        'from'  => array( 'posts' => 'p' ),

                                                        'where' => 'p.pid=ri.type_id',

                                                        'type'   => 'inner'

                                                    ),

                                                ),

                            'where'    => 'p.author_id='.$member['member_id'],

                            'group'    => 'p.author_id',

                        );

Share this post


Link to post
Share on other sites

getting one erro


Fatal error: Call to a member function header() on a non-object in /home/*****/public_html/forums/admin/applications_addon/other/reputationhistory/modules_public/reputationhistory/reputationhistory.php on line 94

is this mod issue or ipb issue :huh:

Share this post


Link to post
Share on other sites

cant we use members table as most of the forums contains rep from old 2.3 versions and also there would be reps given as award and prizes
so those all will goes into a toss

Share this post


Link to post
Share on other sites

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...