Accombo Catergories only allows 10 records

hkclubbing · 13.07.2004, 14:02

Accombo Catergories only allows 10 records

When I add records is accombo it only shows the first 10 records and page 2 is blank, anyone got any ideas about this?

How do I fix this so all are shown?

javinasty · 15.07.2004, 14:54

oh!; i´ve got the shame problem.

how to find the solution??

divamissx · 28.07.2004, 02:58

I have a client with the same problem. Is this being investigated?

divamissx · 29.07.2004, 19:21

I'm guessing it's somewhere in this code but I'm not a php developer so I'm not touching it.

helper.accombo.php:

//************************************************** *****
// Get the total number of records ( Used for pagnation )
//************************************************** *****
$database->setQuery( "SELECT count(*) FROM #__accombo AS a".(count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : "") );
$total = $database->loadResult();

//************************************************** *****
// Add Join To Where Clause
//************************************************** *****
$where[] = "a.catid=cc.id";
$where[] = "a.contactid=client.id";

//************************************************** *****
// Create query
//************************************************** *****
$query = ( "SELECT a.*, cc.title AS category_title, client.name as contact_name"
. "\nFROM #__accombo AS a, #__categories AS cc, #__accombo_client as client"
. (count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : "")
. "\nORDER BY a.id DESC"
. "\nLIMIT $limitstart,$limit"
);

//************************************************** *****
// Set The Query
//************************************************** *****
$database->setQuery( $query );

//************************************************** *****
// Run and load the object list
//************************************************** *****
$rows = $database->loadObjectList();

//************************************************** *****
// Check for errors
//************************************************** *****
if ($database->getErrorNum()) {
return $database->getErrorMsg();
}

//************************************************** *****
// Include the page navigation and set pagnation
//************************************************** *****
include_once("includes/pageNavigation.php");
$pageNav = new mosPageNav( $total, $limitstart, $limit );

//************************************************** *****
// Store the setting in an array
//************************************************** *****
$settings["rows"] = $rows;
$settings["pageNav"] = $pageNav;

//************************************************** *****
// Return with no errors
//************************************************** *****
return NULL;

}

Metaphorically · 30.07.2004, 15:46

I'm not familiar with the code in question, but I'd look at this line

Code:

. "\nLIMIT $limitstart,$limit"

$limitstart is probably 0 and $limit is probably 10.
If somebody does want to hack at this to fix their own, you can find info on how LIMIT works in a SELECT in the docs at MySQL.com.

HTH

danialt · 30.07.2004, 16:02

just an idea;

normally components read $limit from a mosGetParam value

mosGetParam($_REQUEST,"limit",10); and 10 is the default value if no limit is defined in the post or get data transfers.

divamissx · 03.08.2004, 02:25

Is this still not resolved?? Does anyone have a fix?

divamissx · 12.08.2004, 04:20

I guess no one has more than 10 items per category. I can't get any more responses on this topic from here or mamboserver forums. My client is really needing this so I guess I have to hack the damn thing.

ehk · 02.10.2004, 02:15

Hi,

There is a small bug in the view.category.frontend.accombo.html.php file. The problem seems to be
$ag_perpage = 20; (near line 31)
This can be easily solved by setting the variable to $ag_perpage = 10;

Have fun, hope this helps

/components/com_accombo/view.category.frontend.accombo.html.php
---snip---

28 //************************************************** **************
29 // Count the number of published records in this category
30 //************************************************** **************
31 if ( !isset($ag_perpage) ) $ag_perpage = 10;

---snip---