8
« on: April 02, 2013, 10:54:20 am »
Hello Sanhero
Show unread posts since last visit.
Show new replies to your posts.
Ad Free Credits: 0 Order more Credits
April 02, 2013, 05:43:27 am
News:
Create A Forum Installed
Home
Help
Search
Admin
Moderate
Profile
My Messages
Members
Logout
Legends of legends » General Category » General Discussion » Member Application/LOL Clan
Database Error
Unknown column 'mem.myspace' in 'field list'
File: C:\Inetpub\createaforum\Sources\Load.php
Line: 1075
SELECT
IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
mem.signature, mem.personal_text, mem.location, mem.gender, mem.avatar, mem.id_member, mem.member_name,
mem.real_name, mem.email_address, mem.hide_email, mem.date_registered, mem.website_title, mem.website_url,
mem.birthdate, mem.member_ip, mem.member_ip2, mem.icq, mem.aim, mem.yim, mem.msn, mem.posts, mem.last_login,
mem.myspace AS myspace, mem.facebook, mem.twitter, mem.youtube, mem.deviantart, mem.googleplus, mem.linkedin, mem.pinterest, mem.skype,
mem.karma_good, mem.id_post_group, mem.karma_bad, mem.lngfile, mem.id_group, mem.time_offset, mem.show_online,
mem.buddy_list, mg.online_color AS member_group_color, IFNULL(mg.group_name, '') AS member_group,
pg.online_color AS post_group_color, IFNULL(pg.group_name, '') AS post_group, mem.is_activated, mem.warning,
CASE WHEN mem.id_group = 0 OR mg.stars = '' THEN pg.stars ELSE mg.stars END AS stars,
mem.usertitle
FROM lolclan_members AS mem
LEFT JOIN _global_log_online AS lo ON (lo.id_member = mem.id_member AND lo.subdomain = 'lolclan')
LEFT JOIN lolclan_attachments AS a ON (a.id_member = mem.id_member)
LEFT JOIN lolclan_membergroups AS pg ON (pg.id_group = mem.id_post_group)
LEFT JOIN lolclan_membergroups AS mg ON (mg.id_group = mem.id_group)
WHERE mem.id_member = 2
Back