CMS MADE SIMPLE FORGE

Banners Module

 

[#10555] Error: Database Error!

avatar
Created By: Jack Skiba (nidus)
Date Submitted: Thu Jun 18 10:02:03 -0400 2015

Assigned To: Robert Campbell (calguy1000)
Version: 2.7.1
CMSMS Version: 1.12
Severity: Minor
Resolution: Fixed
State: Open
Summary:
Error: Database Error!
Detailed Description:
action.defualt.php
$category_id = cge_utils::get_param($params,'category');

doesn't return the id but the name of the category

in result the action.link.php
// get the details about this banner
$query = "SELECT * FROM ".cms_db_prefix()."module_banners WHERE category_id = ?
AND banner_id = ?";
$dbresult = $db->Execute( $query, array( $params['category_id'],
$params['banner_id'] ) );
if( !$dbresult ) {
$this->_DisplayErrorPage ($id, $params, $returnid, $this->Lang
('error_dberror'));
    return;
}
$banner = $dbresult->FetchRow();
if( !$banner ) {
$this->_DisplayErrorPage ($id, $params, $returnid, $this->Lang
('error_dberror'));
    return;
}
return error


History

Comments
avatar
Date: 2015-06-18 10:06
Posted By: Robert Campbell (calguy1000)

Fixed the help 
      
avatar
Date: 2015-06-18 10:32
Posted By: Jack Skiba (nidus)

Not sure I understand.
the help file says:
(optional) category="" - In the default action, this parameter is used to
specify the name of the category from which a single banner will be displayed.

do we need now to use id when specifying category parameter?
      
Updates

Updated: 2015-06-18 10:06
resolution_id: => 7
severity_id: 1 => 3