Error in 1.1

   Community Suite
   SMF Gallery Pro
   SMF Store
   SMF Classifieds
   Newsletter Pro
   Downloads System Pro
   Ad Seller Pro
   Badge Awards
  
   Hacks and Mods
   Latest SMF Hacks
   TopTen Hacks
   Styles and Themes
   Add a Hack
   Manage Hacks
   Earn Money from Your Forum with these tips
   SMF Theme Generator
   SMF Package Parser
   Free SMF Hosting
   Buy Website Traffic
   Site Showcase
   Email Marketing Software

Advanced search

[rjmiz]

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ID_MEMBER = 48 LIMIT 1' at line 1
File: /home/content/r/j/m/rjmiz/html/smf/Sources/Gallery.php
Line: 3198

Message I get when I go to
File Space Manager>Recount Space Used

Hmmmm my problem? or is it yours?

[SMFHacks]

I have a hotfix for it.

Open Sources/Gallery.php
Around line 3196 in function RecountFileQuotaTotals
Find

Code:

mysql_free_result($dbresult2);
//Update the quota
db_query("UPDATE {$db_prefix}gallery_userquota SET totalfilesize = $total WHERE ID_MEMBER = " . $row['ID_MEMBER'] . " LIMIT 1", __FILE__, __LINE__);

Change to

Code:

if($total == '')
$total = 0;

mysql_free_result($dbresult2);
//Update the quota
db_query("UPDATE {$db_prefix}gallery_userquota SET totalfilesize = $total WHERE ID_MEMBER = " . $row['ID_MEMBER'] . " LIMIT 1", __FILE__, __LINE__);

Help Support the SMFHacks.com mod making.