SMFHacks.com

It seems to be happening with any blocks, recent comments, latest pictures, all the blocks. So should I disable them all? Just wondering what the long term solution might be. Thanks

Error

SQL query:

ALTER TABLE smf_gallery_usersettings ADD INDEX ( PASSWORD )

MySQL said: 

#1170 - BLOB/TEXT column 'password' used in key specification without a key length



Hello sorry for the delay... this gallery is giving me fits... i got this result

EXPLAIN SELECT COUNT( * ) AS total
FROM (
smf_gallery_pic AS p, smf_gallery_comment AS com
)
LEFT JOIN smf_members AS m ON ( m.ID_MEMBER = p.ID_MEMBER )
LEFT JOIN smf_gallery_usersettings AS s ON ( s.ID_MEMBER = m.ID_MEMBER )
WHERE (
(
s.private =0 || s.private IS NULL
)
AND (
s.password = '' || s.password IS NULL
)
AND p.USER_ID_CAT !=0
AND p.approved =1
) || ( p.approved =1
AND p.USER_ID_CAT =0 )
AND com.ID_PICTURE = p.ID_PICTURE
GROUP BY p.ID_PICTURE

Your SQL query has been executed successfully (Query took 1.0697 sec) 

Thank you hacks it appears to have worked!

http://www.smfhacks.com/index.php/topic,3675.0.html

ok i found this thread.. first if I enable this feature is that all I do and it creates new folders for storage? Will this help with peformance issues?

If this is what I think can I then move some of my pictures to other folders or will this cause a problem with images already displayed in the gallery. Thanks

EDIT - Ok I see this function is already enabled in the gallery. So do create multiple folders because everything is going in the "gallery" folder.

I cannot do anything at the moment my site has crashed... it is not even up 

EXPLAIN SELECT COUNT( * ) AS total
FROM smf_gallery_pic AS p
LEFT JOIN smf_gallery_catperm AS c ON ( c.ID_GROUP
IN ( 31, 50, 30, 56, 11, 55, 54, 20 )
AND c.ID_CAT = p.ID_CAT )
LEFT JOIN smf_gallery_log_mark_view AS v ON ( p.ID_PICTURE = v.ID_PICTURE
AND v.ID_MEMBER =1
AND v.user_id_cat = p.USER_ID_CAT )
LEFT JOIN smf_members AS m ON (
p.ID_MEMBER = m.ID_MEMBER
)
LEFT JOIN smf_gallery_usersettings AS s ON ( s.ID_MEMBER = m.ID_MEMBER )
WHERE v.ID_PICTURE IS NULL
AND (
s.private =0 || s.private IS NULL
)
AND (
c.view IS NULL || c.view =1
)
AND p.approved =1

1 SIMPLE p ALL NULL NULL NULL NULL 5556 Using where
1 SIMPLE c ref ID_GROUP,ID_CAT ID_CAT 3 melin4_xxxx.p.ID_CAT 5 Using where
1 SIMPLE v ref id_member,user_id_cat,id_member_2,user_id_cat_2,id... user_id_cat 5 melin4_xxxx.p.USER_ID_CAT 806 Using where; Not exists
1 SIMPLE m eq_ref PRIMARY PRIMARY 3 melin4_XXXX.p.ID_MEMBER 1 Using index
1 SIMPLE s eq_ref PRIMARY PRIMARY 3 melin4_xxxxx.m.ID_MEMBER 1 Using where



Hey hacks sorry to bother you again but things are getting worse with the gallery... Besides the errors mentioned above I have this information... this seems to happen when people are trying to see most recent pics, recent commented, or trying to open any gallery

_____________________________________

Data Base and Running Processes

State        Time

Sending data 846s SELECT COUNT(*) as totalFROM smf_gallery_pic as p

SELECT    COUNT(*) as totalFROM smf_gallery_pic as pLEFT JOIN smf_gallery_catperm AS c ON (c.ID_GROUP IN (31,50,30,56,11,55,54,20) AND c.ID_CAT = p.ID_CAT)
LEFT JOIN smf_gallery_log_mark_view AS v ON (p.ID_PICTURE = v.ID_PICTURE AND v.ID_MEMBER = 1 AND v.user_id_cat = p.USER_ID_CAT)LEFT JOIN smf_members AS m ON
(p.ID_MEMBER = m.ID_MEMBER)LEFT JOIN smf_gallery_usersettings AS s ON (s.ID_MEMBER = m.ID_MEMBER)WHERE v.ID_PICTURE IS NULL AND (s.private =0 || s.private IS NULL )
AND  (c.view IS NULL || c.view =1) AND  p.approved = 1

______________________________________________

Unable to connect

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@melindaspenpals.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

--------------------------------------------------------------------------------

Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.melindaspenpals.com Port 80