News:

Create A Forum Installed

Author Topic: Database errors  (Read 2533 times)

0 Members and 1 Guest are viewing this topic.

Offline Clunt

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

Badges: (View All)
Combination Topic Starter First Post
Database errors
« on: October 08, 2013, 10:25:49 pm »
I have multiple problems. I created a new forum eternal.createaforum.com and when anyone tries register they get:

Unknown column 'skype' in 'field list'
File: C:\inetpub\createaforum\Sources\Subs-Members.php
Line 866

And then a page of code

When i try to read my post as a guest i get:

Unknown column 'mem.myspace' in 'field list'
File: C:\inetpub\createaforum\Sources\Load.php
Line: 1101

Followed by a whole page of stuff

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 errors
« Reply #1 on: October 08, 2013, 10:58:21 pm »
Try now
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

Offline Jadoinker

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

Badges: (View All)
Karma Good First Post Level 1
Re: Database errors
« Reply #2 on: October 09, 2013, 12:51:21 am »
I have the same problem, nothing seems to change it

Offline CreateAForum

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

Badges: (View All)
Avatar Linux User Tenth year Anniversary
Re: Database errors
« Reply #3 on: October 09, 2013, 12:54:02 am »
I have the same problem, nothing seems to change it
What is your forum url
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

Offline Jadoinker

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

Badges: (View All)
Karma Good First Post Level 1
Re: Database errors
« Reply #4 on: October 09, 2013, 01:07:42 am »

Offline Jadoinker

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

Badges: (View All)
Karma Good First Post Level 1
Re: Database errors
« Reply #5 on: October 09, 2013, 01:10:49 am »
Unknown column 'enclose' in 'field list'
File: C:\inetpub\createaforum\Sources\Profile.php
Line: 770


 SELECT
 col_name, field_name, field_desc, field_type, field_length, field_options,
 default_value, bbc, enclose, placement
 FROM creativewriters_custom_fields
 WHERE active = 1 AND show_reg != 0


one of the errors

Offline CreateAForum

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

Badges: (View All)
Avatar Linux User Tenth year Anniversary
Re: Database errors
« Reply #6 on: October 09, 2013, 01:12:56 am »
Unknown column 'enclose' in 'field list'
File: C:\inetpub\createaforum\Sources\Profile.php
Line: 770


 SELECT
 col_name, field_name, field_desc, field_type, field_length, field_options,
 default_value, bbc, enclose, placement
 FROM creativewriters_custom_fields
 WHERE active = 1 AND show_reg != 0


one of the errors
Fixed
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

Offline Jadoinker

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

Badges: (View All)
Karma Good First Post Level 1
Re: Database errors
« Reply #7 on: October 09, 2013, 01:14:28 am »
getting this one now when trying to register. Thanks for such a speedy reply


Unknown column 'placement' in 'field list'
File: C:\inetpub\createaforum\Sources\Profile.php
Line: 770


 SELECT
 col_name, field_name, field_desc, field_type, field_length, field_options,
 default_value, bbc, enclose, placement
 FROM creativewriters_custom_fields
 WHERE active = 1 AND show_reg != 0

Offline Jadoinker

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

Badges: (View All)
Karma Good First Post Level 1
Re: Database errors
« Reply #8 on: October 09, 2013, 01:16:09 am »
ill try on a different't computer

Offline CreateAForum

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

Badges: (View All)
Avatar Linux User Tenth year Anniversary
Re: Database errors
« Reply #9 on: October 09, 2013, 01:19:06 am »
Fixed that issue now.
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

Offline Jadoinker

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

Badges: (View All)
Karma Good First Post Level 1
Re: Database errors
« Reply #10 on: October 09, 2013, 01:23:12 am »
Thank you very much, i really appreciate it. Have a good one.


Sincerely,
               
                Nate


Offline Jadoinker

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

Badges: (View All)
Karma Good First Post Level 1
Re: Database errors
« Reply #11 on: October 09, 2013, 01:33:36 am »
now im getting

C:\inetpub\createaforum\Sources\Subs-Members.php



Unknown column 'skype' in 'field list'File: C:\inetpub\createaforum\Sources\Subs-Members.phpLine: 866INSERT INTO creativewriters_members(`member_name`, `email_address`, `passwd`, `password_salt`, `posts`, `date_registered`, `member_ip`, `member_ip2`, `validation_code`, `real_name`, `personal_text`, `pm_email_notify`, `id_theme`, `id_post_group`, `lngfile`, `buddy_list`, `pm_ignore_list`, `message_labels`, `website_title`, `website_url`, `location`, `icq`, `skype`, `facebook`, `myspace`, `twitter`, `googleplus`, `linkedin`, `youtube`, `deviantart`, `pinterest`, `aim`, `yim`, `msn`, `time_format`, `signature`, `avatar`, `usertitle`, `secret_question`, `secret_answer`, `additional_groups`, `ignore_boards`, `smiley_set`, `openid_uri`, `is_activated`, `id_group`)

Offline CreateAForum

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

Badges: (View All)
Avatar Linux User Tenth year Anniversary
Re: Database errors
« Reply #12 on: October 09, 2013, 01:34:59 am »
Fixed. Hopefully that should be it.
What happened looks like an old forum by the same used to exist which caused those errorrs.
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

Offline Jadoinker

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

Badges: (View All)
Karma Good First Post Level 1
Re: Database errors
« Reply #13 on: October 09, 2013, 01:37:10 am »
Works fine now, thanks a bunch

Offline Jadoinker

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

Badges: (View All)
Karma Good First Post Level 1
Re: Database errors
« Reply #14 on: October 09, 2013, 01:48:55 am »
Hopefully this is the last error. When i tried to post in the poetry section i got this error


Unknown column 'a.file_hash' in 'field list'File: C:\inetpub\createaforum\Sources\Display.phpLine: 1003SELECTa.id_attach, a.id_folder, a.id_msg, a.filename, a.file_hash, IFNULL(a.size, 0) AS filesize, a.downloads, a.approved,a.width, a.height,IFNULL(thumb.id_attach, 0) AS id_thumb, thumb.width AS thumb_width, thumb.height AS thumb_heightFROM creativewriters_attachments AS aLEFT JOIN creativewriters_attachments AS thumb ON (thumb.id_attach = a.id_thumb)WHERE a.id_msg IN (3)AND a.attachment_type = 0

 

Related Topics

  Subject / Started by Replies Last post
4 Replies
956 Views
Last post July 10, 2011, 01:34:32 am
by simply sibyl
2 Replies
612 Views
Last post February 02, 2013, 02:42:45 am
by Shocari
1 Replies
1035 Views
Last post November 27, 2013, 03:22:08 am
by CreateAForum
1 Replies
1067 Views
Last post March 30, 2014, 03:56:56 am
by CreateAForum
5 Replies
988 Views
Last post April 27, 2014, 11:49:27 pm
by CreateAForum