SMF Gallery 3.6 (May 4) with SMF 2.0/SMF 1.1.x Support!

Customizing SMF > Modifications and Packages

<< < (626/659) > >>

vbgamer45:
Don't have any time at the moment to write code for specific requests.

Shambles:
How can I prevent the Google Crawlers causing this error?

It's only ever Google IP addresses that cause this, but it's several times a day :o

Platform Details:
SMF 2.0.2
Simple Portal 2.3.5
MySQL version: 5.0.95-community
eAccelerator: 0.9.6.1
PHP: 5.2.17

Modifications:

--- Code: ---1. Countdown BBCode 2.0.1
2. SimplePortal 2.3.5
3. Aeva ~ Auto-Embed Video & Audio 7.2
4. SMF Gallery Lite 3.1.1a
5. PageDropdown 1.4
6. Highslide 4 SMF 0.8.1
7. Contact Form 1.1
8. Separate the sticky topics 1.0.0
9. Google Analytics Code 1.4
10. Google Translate for SMF 2.0 1.1
11. Email Template Editor 1.0
12. Float BBCODE 1.0.2
13. Moderator and Administrator Comment Tags 1.8.1
14. Tapatalk SMF 2.0 RC4/RC5/Final Plugin 3.0.1
15. SMF 2.0.2 Update 1.0
16. Tidy Child Boards 1.4
17. Member Color Link 3.1
18. Auto Purge Old Topics 1.2
19. Default Avatar 2.2
20. Double Check your Email in Registration by SmfSimple.com 1.0
21. Hide Signatures from Guests 2.0
22. Display Signatures Only Once Per Page 1.0.3
23. Hide Avatars from Guests 2.0
24. Auto Lock Old Topics 1.3
25. Copy Topics 1.6
26. Thank-o-matic 3.0
27. SMF 2.0.1 Update 1.0
28. BCC Messages 1.2
29. Happy Birthday 0.3
30. PNG Message Icons 1.3.1
31. Enable or Disable "Â« Last Edit: by Â»" for Administrators 1.3a
32. james bond avatars 1.0
33. Dog Avatars 1.0
34. Cat Avatars 1.0
35. Country_Flagatars 1.1
36. Welcome Topic Mod 2.1
37. Removes the post rank if a custom title is set 1.1
38. Hide User Names from Guests 1.1
39. Bookmarks 2.3
40. MessagePreviewOnHover 1.8
41. SMF Arcade 2.5 RC1
42. httpBL 2.5.1
43. Stop Spammer 2.3.9
44. [BBCode] Blink 1.0
45. Country Flags 1.1.2
46. Spoiler Tag 0.7.2a
47. Add Join Date to Post 1.0
48. [BBCode] Dotted Underline 1.0

--- End code ---

Code reported in error message:
Sources/Gallery2.php around line 579

--- Code: --- $dbresult = $smcFunc['db_query']('', "
SELECT
c.id_picture, c.id_comment, c.date, c.comment, c.id_member, m.posts, m.member_name, m.real_name
FROM {db_prefix}gallery_comment as c
LEFT JOIN {db_prefix}members AS m ON (c.id_member = m.id_member)
579 WHERE c.id_picture = " . $context['gallery_pic']['id_picture'] . " ORDER BY c.id_comment DESC" );

$context['gallery_comment_count'] = $smcFunc['db_affected_rows']();
$context['gallery_comment_list'] = array();

--- End code ---

The error is not caused by anyone else viewing or updating our gallery (which is splendid I have to say :))

SMFHacks.com Team:

--- Quote from: Shambles on May 29, 2012, 02:51:24 PM ---How can I prevent the Google Crawlers causing this error?

It's only ever Google IP addresses that cause this, but it's several times a day :o

Platform Details:
SMF 2.0.2
Simple Portal 2.3.5
MySQL version: 5.0.95-community
eAccelerator: 0.9.6.1
PHP: 5.2.17

Modifications:

--- Code: ---1. Countdown BBCode 2.0.1
2. SimplePortal 2.3.5
3. Aeva ~ Auto-Embed Video & Audio 7.2
4. SMF Gallery Lite 3.1.1a
5. PageDropdown 1.4
6. Highslide 4 SMF 0.8.1
7. Contact Form 1.1
8. Separate the sticky topics 1.0.0
9. Google Analytics Code 1.4
10. Google Translate for SMF 2.0 1.1
11. Email Template Editor 1.0
12. Float BBCODE 1.0.2
13. Moderator and Administrator Comment Tags 1.8.1
14. Tapatalk SMF 2.0 RC4/RC5/Final Plugin 3.0.1
15. SMF 2.0.2 Update 1.0
16. Tidy Child Boards 1.4
17. Member Color Link 3.1
18. Auto Purge Old Topics 1.2
19. Default Avatar 2.2
20. Double Check your Email in Registration by SmfSimple.com 1.0
21. Hide Signatures from Guests 2.0
22. Display Signatures Only Once Per Page 1.0.3
23. Hide Avatars from Guests 2.0
24. Auto Lock Old Topics 1.3
25. Copy Topics 1.6
26. Thank-o-matic 3.0
27. SMF 2.0.1 Update 1.0
28. BCC Messages 1.2
29. Happy Birthday 0.3
30. PNG Message Icons 1.3.1
31. Enable or Disable "Â« Last Edit: by Â»" for Administrators 1.3a
32. james bond avatars 1.0
33. Dog Avatars 1.0
34. Cat Avatars 1.0
35. Country_Flagatars 1.1
36. Welcome Topic Mod 2.1
37. Removes the post rank if a custom title is set 1.1
38. Hide User Names from Guests 1.1
39. Bookmarks 2.3
40. MessagePreviewOnHover 1.8
41. SMF Arcade 2.5 RC1
42. httpBL 2.5.1
43. Stop Spammer 2.3.9
44. [BBCode] Blink 1.0
45. Country Flags 1.1.2
46. Spoiler Tag 0.7.2a
47. Add Join Date to Post 1.0
48. [BBCode] Dotted Underline 1.0

--- End code ---

Code reported in error message:
Sources/Gallery2.php around line 579

--- Code: --- $dbresult = $smcFunc['db_query']('', "
SELECT
c.id_picture, c.id_comment, c.date, c.comment, c.id_member, m.posts, m.member_name, m.real_name
FROM {db_prefix}gallery_comment as c
LEFT JOIN {db_prefix}members AS m ON (c.id_member = m.id_member)
579 WHERE c.id_picture = " . $context['gallery_pic']['id_picture'] . " ORDER BY c.id_comment DESC" );

$context['gallery_comment_count'] = $smcFunc['db_affected_rows']();
$context['gallery_comment_list'] = array();

--- End code ---

The error is not caused by anyone else viewing or updating our gallery (which is splendid I have to say :))

--- End quote ---
Fixed
Update posted
3.1.2
!Fixed database error if viewing a link of a delete picture. Normally occurred by search engines

Shambles:

--- Quote from: SMFHacks.com Team on May 29, 2012, 07:53:50 PM ---
--- Quote from: Shambles on May 29, 2012, 02:51:24 PM ---How can I prevent the Google Crawlers causing this error?

It's only ever Google IP addresses that cause this, but it's several times a day :o

--- End quote ---

Fixed
Update posted
3.1.2
!Fixed database error if viewing a link of a delete picture. Normally occurred by search engines

--- End quote ---
Thank you - I'll get this update put in right away 8)

Inti31:
thx - seems like the error messages are gone - btw: people which have 3.1.1a installed need just to change Gallery2.php...

good job!

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version