Getting an error in the main store page

[shuban]

This error:

2: mysql_fetch_assoc(): 81 is not a valid MySQL result resource
File: ...l/Themes/default/Store.template.php
Line: 281

Corresponds to:

Code: [Select]

while($row = mysql_fetch_assoc($dbresult))
{

if ($row['view'] == '0')

[SMFHacks]

Did you make any changes to that file? Or have you done something new recently?
That would be part of this query

Code: [Select]

SELECT
c.ID_CAT, c.title, c.roworder, c.description, c.imagefilename, c.imageurl, p.view
FROM {$db_prefix}store_cat as c
LEFT JOIN {$db_prefix}store_catperm AS p ON (p.ID_GROUP = $groupid AND c.ID_CAT = p.ID_CAT)
WHERE c.ID_PARENT = 0 ORDER BY roworder ASC


[shuban]

Right, I accidentally moved things around, apologies.

[SMFHacks]

Glad you have it figured out.