For over a year now, i haven't been able to log into SMD's site.
I can browse it fine, but as soon as i log on, i get this-
mySQL query error: SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title as member_title, m.warn_level, m.warn_lastwarn, m.members_display_name, m.members_seo_name, m.member_banned, m.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,m.garage_vehicles,pp.*,w.wl_id,pc.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache,cca.*,ccb.cache_content as cache_content_sig, ccb.cache_updated as cache_updated_sig FROM ( SELECT pid, post_date FROM ibf_posts WHERE topic_id=191915 AND queued=0 ORDER BY pid asc LIMIT 40,20 ) z LEFT JOIN ibf_posts p ON ( p.pid=z.pid )
LEFT JOIN ibf_members m ON ( m.member_id=p.author_id )
LEFT JOIN ibf_profile_portal pp ON ( m.member_id=pp.pp_member_id )
LEFT JOIN ibf_members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid )
LEFT JOIN ibf_pfields_content pc ON ( pc.member_id=p.author_id )
LEFT JOIN ibf_reputation_index rep_index ON ( rep_index.app='forums' AND
rep_index.type='pid' AND
rep_index.type_id=p.pid AND
rep_index.member_id=13137 )
LEFT JOIN ibf_reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid )
LEFT JOIN ibf_content_cache_posts cca ON ( cca.cache_content_id=p.pid )
LEFT JOIN ibf_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) ORDER BY z.pid asc
This is not a problem with the IPS Community Suite but rather with your SQL server. Please contact your host and copy the message shown above
In this time span, i have went through 2 phones and have tried on 6 different computers.
I have talked to some members about this to try and figure it out.. While still haven't, we have agreed that the website is coded very poorly which may never be fixed.
I rarely go on there because.. well.. what's the point but the main thing is it has me confused as to why only my account causes an SQL error.
I can browse it fine, but as soon as i log on, i get this-
mySQL query error: SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title as member_title, m.warn_level, m.warn_lastwarn, m.members_display_name, m.members_seo_name, m.member_banned, m.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,m.garage_vehicles,pp.*,w.wl_id,pc.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache,cca.*,ccb.cache_content as cache_content_sig, ccb.cache_updated as cache_updated_sig FROM ( SELECT pid, post_date FROM ibf_posts WHERE topic_id=191915 AND queued=0 ORDER BY pid asc LIMIT 40,20 ) z LEFT JOIN ibf_posts p ON ( p.pid=z.pid )
LEFT JOIN ibf_members m ON ( m.member_id=p.author_id )
LEFT JOIN ibf_profile_portal pp ON ( m.member_id=pp.pp_member_id )
LEFT JOIN ibf_members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid )
LEFT JOIN ibf_pfields_content pc ON ( pc.member_id=p.author_id )
LEFT JOIN ibf_reputation_index rep_index ON ( rep_index.app='forums' AND
rep_index.type='pid' AND
rep_index.type_id=p.pid AND
rep_index.member_id=13137 )
LEFT JOIN ibf_reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid )
LEFT JOIN ibf_content_cache_posts cca ON ( cca.cache_content_id=p.pid )
LEFT JOIN ibf_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) ORDER BY z.pid asc
This is not a problem with the IPS Community Suite but rather with your SQL server. Please contact your host and copy the message shown above
In this time span, i have went through 2 phones and have tried on 6 different computers.
I have talked to some members about this to try and figure it out.. While still haven't, we have agreed that the website is coded very poorly which may never be fixed.
I rarely go on there because.. well.. what's the point but the main thing is it has me confused as to why only my account causes an SQL error.
