News:

Create A Forum Installed

Author Topic: Database Error  (Read 360 times)

0 Members and 1 Guest are viewing this topic.

Offline Willing to Help

  • Newbie
  • *
  • Posts: 9
  • Karma: 0
    • View Profile

Badges: (View All)
Combination Topic Starter Level 2
Database Error
« on: February 01, 2013, 01:00:31 pm »
Just made a forum yesterday and am having "Database Error" trouble upon going to some parts of the forum, such as my Inbox. I can send messages but I can't read them. Any ideas. Profiles, Memberlists and Message center errors and Not being able to post are the problems that I am having, I don't know if there are any others yet.


THIS IS THE ERROR.
nknown column 'mem.myspace' in 'field list'
File: C:\Inetpub\createaforum\Sources\Load.php
Line: 1073


 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 computerhelp_members AS mem
 LEFT JOIN _global_log_online  AS lo ON (lo.id_member = mem.id_member AND lo.subdomain = 'computerhelp')
 LEFT JOIN computerhelp_attachments AS a ON (a.id_member = mem.id_member)
 LEFT JOIN computerhelp_membergroups AS pg ON (pg.id_group = mem.id_post_group)
 LEFT JOIN computerhelp_membergroups AS mg ON (mg.id_group = mem.id_group)
 WHERE mem.id_member = 0
« Last Edit: February 01, 2013, 01:59:46 pm by helpme123 »

Share on Facebook Share on Twitter


Offline CreateAForum

  • Administrator
  • *****
  • Posts: 7186
  • Karma: 327
    • View Profile

Badges: (View All)
Avatar Linux User Tenth year Anniversary
Re: Database Error
« Reply #1 on: February 01, 2013, 03:06:59 pm »
Deleted it remake it again.
Issue occurred since that name was used in the past and had some odd data still tied to it.
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

Offline Willing to Help

  • Newbie
  • *
  • Posts: 9
  • Karma: 0
    • View Profile

Badges: (View All)
Combination Topic Starter Level 2
Re: Database Error
« Reply #2 on: February 01, 2013, 06:59:32 pm »
Is it safe to use that name again or should I try a different one?

Offline Willing to Help

  • Newbie
  • *
  • Posts: 9
  • Karma: 0
    • View Profile

Badges: (View All)
Combination Topic Starter Level 2
Re: Database Error
« Reply #3 on: February 01, 2013, 07:07:10 pm »
I'll just play it safe and make a slightly different name. Thank you for your support. 

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
605 Views
Last post September 16, 2010, 11:21:21 pm
by CreateAForum
2 Replies
691 Views
Last post October 09, 2011, 04:29:41 pm
by Justincase
3 Replies
603 Views
Last post May 20, 2012, 04:01:32 pm
by aIURbliS
5 Replies
529 Views
Last post June 06, 2012, 02:41:58 am
by Dr. Pa1N
database error

Started by lads Bugs

1 Replies
697 Views
Last post August 09, 2014, 01:56:06 pm
by CreateAForum