grid33
12-05-2010, 10:20
Witam może ktoś z user-ów miał taki problem albo wie jak go rozwiązać . Poniżej zamieszczam błąd jaki dostaje od bazy podczas modyfikacji skryptu joomgallery $this->catrows = $database->loadObjectList();
a błąd :
No valid database connection Something is wrong in your syntax obok
'8' w linii 17 SQL=SELECT *, a.owner AS owner,
ROUND(imgvotesum/imgvotes, 2) AS rating FROM jos_joomgallery AS a LEFT
JOIN jos_joomgallery_catg AS c ON c.cid=a.catid WHERE a.published =
'1' AND a.catid = '1' AND a.approved = '1' AND c.access <= '0' ORDER
BY a.ordering ASC, a.imgdate DESC, a.imgtitle DESC LIMIT ,8
i stoję już 3ci dzień ...
to miejsce :
$database->setQuery(" SELECT
*,
a.owner AS owner,
ROUND(imgvotesum/imgvotes, 2) AS rating
FROM
#__joomgallery AS a
LEFT JOIN
#__joomgallery_catg AS c ON c.cid=a.catid
WHERE
a.published = '1'
AND a.catid = '$this->catid'
AND a.approved = '1'
AND c.access <= '".$user->get('aid')."'
ORDER BY
".$this->orderclause." ".$moreorderclause."
LIMIT
".$this->catstart.",".$config->jg_perpage);
$this->catrows = $database->loadObjectlist();
$this->catrowcounter = 0;
HELP>>>
a błąd :
No valid database connection Something is wrong in your syntax obok
'8' w linii 17 SQL=SELECT *, a.owner AS owner,
ROUND(imgvotesum/imgvotes, 2) AS rating FROM jos_joomgallery AS a LEFT
JOIN jos_joomgallery_catg AS c ON c.cid=a.catid WHERE a.published =
'1' AND a.catid = '1' AND a.approved = '1' AND c.access <= '0' ORDER
BY a.ordering ASC, a.imgdate DESC, a.imgtitle DESC LIMIT ,8
i stoję już 3ci dzień ...
to miejsce :
$database->setQuery(" SELECT
*,
a.owner AS owner,
ROUND(imgvotesum/imgvotes, 2) AS rating
FROM
#__joomgallery AS a
LEFT JOIN
#__joomgallery_catg AS c ON c.cid=a.catid
WHERE
a.published = '1'
AND a.catid = '$this->catid'
AND a.approved = '1'
AND c.access <= '".$user->get('aid')."'
ORDER BY
".$this->orderclause." ".$moreorderclause."
LIMIT
".$this->catstart.",".$config->jg_perpage);
$this->catrows = $database->loadObjectlist();
$this->catrowcounter = 0;
HELP>>>