DIR Return Create A Forum - Home
       ---------------------------------------------------------
       Create A Forum - Support Forums
  HTML https://support.createaforum.com
       ---------------------------------------------------------
       *****************************************************
   DIR Return to: Create A Forum Discussion
       *****************************************************
       #Post#: 9770--------------------------------------------------
       Got a small problem 
   DIR By: Samuel Ashen
       Date: May 9, 2013, 12:15 pm
       ---------------------------------------------------------
       Got a small problem, I started a forum and all the structure
       working nicely for now, but after I post, then i try to read the
       post give me an error.
       example:
  HTML http://andromeda.createaforum.com/command-structure/test/
       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 andromeda_members AS mem
       LEFT JOIN _global_log_online  AS lo ON (lo.id_member =
       mem.id_member AND lo.subdomain = 'andromeda')
       LEFT JOIN andromeda_attachments AS a ON (a.id_member =
       mem.id_member)
       LEFT JOIN andromeda_membergroups AS pg ON (pg.id_group =
       mem.id_post_group)
       LEFT JOIN andromeda_membergroups AS mg ON (mg.id_group =
       mem.id_group)
       WHERE mem.id_member = 2
       #Post#: 9772--------------------------------------------------
       Re: Got a small problem 
   DIR By: CreateAForum
       Date: May 9, 2013, 1:21 pm
       ---------------------------------------------------------
       Fixed should be good now.
       #Post#: 9781--------------------------------------------------
       Re: Got a small problem 
   DIR By: Samuel Ashen
       Date: May 10, 2013, 6:09 am
       ---------------------------------------------------------
       Works perfectly thanks allot.
       #Post#: 9794--------------------------------------------------
       Re: Got a small problem 
   DIR By: CreateAForum
       Date: May 10, 2013, 9:13 pm
       ---------------------------------------------------------
       Glad to help.
       *****************************************************
       Page 1 of 1