|
Forum > Support
Error in 1.1
(1/1)
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__);
--- End code --- 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__);
--- End code ---
Navigation
[0] Message Index |
No thumbnails on new uploads
by SMFHacks
March 27, 2024, 02:10:41 pm
|
Display the Contact Page for guests
by SMFHacks
March 27, 2024, 10:55:43 am
|
is it possible to add support for odysee.com
by fvlog19
March 21, 2024, 08:47:51 am
|
Request for admin notification
by davejo
March 10, 2024, 01:31:59 am
|
I need help with torrent upload
by Ineedsmfhelp
March 09, 2024, 10:01:13 pm
|
an idea for new mod (( content type with different display ))
by SMFHacks
February 27, 2024, 01:36:27 pm
|
[Mod] RSS Feed Poster
by SMFHacks
February 27, 2024, 11:57:18 am
|
find duplicate pictures
by fvlog19
February 14, 2024, 02:22:40 pm
|
Error uploading video.
by SMFHacks
February 08, 2024, 02:04:16 pm
|
Gallery icon as last added image
by fvlog19
February 01, 2024, 01:04:56 pm
|
|
|