Author Topic: Got a small problem  (Read 605 times)

0 Members and 0 Guests are viewing this topic.

Offline Samuel Ashen

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
    • View Profile
Got a small problem
« on: May 09, 2013, 05:15:49 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:  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

Share on Facebook Share on Twitter


Offline CreateAForum

  • Administrator
  • *****
  • Posts: 6145
  • Karma: 288
    • View Profile
Re: Got a small problem
« Reply #1 on: May 09, 2013, 06:21:03 pm »
Fixed should be good now.
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

Offline Samuel Ashen

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
    • View Profile
Re: Got a small problem
« Reply #2 on: May 10, 2013, 11:09:04 am »
Works perfectly thanks allot.

Offline CreateAForum

  • Administrator
  • *****
  • Posts: 6145
  • Karma: 288
    • View Profile
Re: Got a small problem
« Reply #3 on: May 11, 2013, 02:13:02 am »
Glad to help.
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
2 Replies
272 Views
Last post March 20, 2012, 03:53:02 pm
by member
2 Replies
162 Views
Last post August 11, 2012, 06:59:15 am
by Featherstar
5 Replies
409 Views
Last post August 25, 2012, 06:26:03 pm
by CreateAForum
5 Replies
283 Views
Last post September 04, 2012, 09:15:15 am
by forum
0 Replies
354 Views
Last post September 29, 2013, 01:33:36 pm
by davbell25413