DIR Return Create A Forum - Home
       ---------------------------------------------------------
       Create A Forum - Support Forums
  HTML https://support.createaforum.com
       ---------------------------------------------------------
       *****************************************************
   DIR Return to: Bugs
       *****************************************************
       #Post#: 10756--------------------------------------------------
       Profile
       By: DeckCheck Date: July 21, 2013, 2:39 pm
       ---------------------------------------------------------
       When I try to view my profile this happens:
       [font=arial]atabase Error
       Unknown column 'mem.myspace' in 'field list'
       File: C:\inetpub\createaforum\Sources\Load.php
       Line: 1097
       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.openid_uri, mem.birthdate, mem.icq, mem.aim, mem.yim,
       mem.msn, mem.posts, mem.last_login, mem.karma_good,
       mem.myspace AS myspace, mem.facebook, mem.twitter, mem.youtube,
       mem.deviantart, mem.googleplus, mem.linkedin, mem.pinterest,
       mem.skype,
       mem.karma_bad, mem.member_ip, mem.member_ip2, mem.lngfile,
       mem.id_group, mem.id_theme, mem.buddy_list,
       mem.pm_ignore_list, mem.pm_email_notify, mem.pm_receive_from,
       mem.time_offset, mem.usertitle,
       mem.time_format, mem.secret_question, mem.is_activated,
       mem.additional_groups, mem.smiley_set, mem.show_online,
       mem.total_time_logged_in, mem.id_post_group,
       mem.notify_announcements, mem.notify_regularity,
       mem.notify_send_body,
       mem.notify_types, lo.url, 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.ignore_boards, mem.warning,
       CASE WHEN mem.id_group = 0 OR mg.stars = '' THEN pg.stars ELSE
       mg.stars END AS stars, mem.password_salt, mem.pm_prefs
       FROM teamaqua_members AS mem
       LEFT JOIN _global_log_online AS lo ON (lo.id_member =
       mem.id_member AND lo.subdomain = 'teamaqua')
       LEFT JOIN teamaqua_attachments AS a ON (a.id_member =
       mem.id_member)
       LEFT JOIN teamaqua_membergroups AS pg ON (pg.id_group =
       mem.id_post_group)
       LEFT JOIN teamaqua_membergroups AS mg ON (mg.id_group =
       mem.id_group)
       WHERE mem.id_member = 1[/font]
       #Post#: 10757--------------------------------------------------
       Re: Profile
       By: CreateAForum Date: July 21, 2013, 2:41 pm
       ---------------------------------------------------------
       Should be fixed now
       #Post#: 10759--------------------------------------------------
       Re: Profile
       By: DeckCheck Date: July 21, 2013, 2:52 pm
       ---------------------------------------------------------
       Thanks, it works now.
       *****************************************************