News:

Create A Forum Installed

Author Topic: Database errors  (Read 989 times)

0 Members and 1 Guest are viewing this topic.

Offline KrazyRedhead

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

Badges: (View All)
Topic Starter First Post Level 1
Database errors
« on: April 27, 2014, 04:56:33 pm »
Hello, I just started a forum and I can't view any topics including my own or access profiles. I get a database error each time. As the admin, do I need to enable/disable something to get my forum working? My admin panel is a tad confusing, so I may have missed something I was supposed to do. Thank you.

Share on Facebook Share on Twitter


Offline KrazyRedhead

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

Badges: (View All)
Topic Starter First Post Level 1
Re: Database errors
« Reply #1 on: April 27, 2014, 05:05:50 pm »
Example when I click on a topic:

Unknown column 'a.file_hash' in 'field list'
File: C:\inetpub\createaforum\Sources\Display.php
Line: 1003


 SELECT
 a.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_height
 FROM epicness_attachments AS a
 LEFT JOIN epicness_attachments AS thumb ON (thumb.id_attach = a.id_thumb)
 WHERE a.id_msg IN (3)
 AND a.attachment_type = 0

Offline CreateAForum

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

Badges: (View All)
Avatar Linux User Tenth year Anniversary
Re: Database errors
« Reply #2 on: April 27, 2014, 05:13:58 pm »
I would choose a new forum url. So recreate with a new url.
The old one was probably an old forum that was deleted so the new one made those not work.
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

Offline KrazyRedhead

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

Badges: (View All)
Topic Starter First Post Level 1
Re: Database errors
« Reply #3 on: April 27, 2014, 05:18:59 pm »
If I wasn't able to use it, why would the website allow me to create it? Also, will I have to use a new email as well since I have this forum under this email? Definitely not happy with my experience so far =( I hate being  pain, but I'm moving from a different forum that's been having horrible server issues over the last year. I've lost all of my data in a server crash, and now I can get this new one to work. It's been a frustrating day.
« Last Edit: April 27, 2014, 05:29:01 pm by KrazyRedhead »

Offline Gojoe

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

Badges: (View All)
Karma Good 10 Posts Level 2
Re: Database errors
« Reply #4 on: April 27, 2014, 05:38:03 pm »
I would choose a new forum url. So recreate with a new url.
The old one was probably an old forum that was deleted so the new one made those not work.
Sorr for bothering but could you answer my question? Name is "My Own Images". Thanks

Offline CreateAForum

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

Badges: (View All)
Avatar Linux User Tenth year Anniversary
Re: Database errors
« Reply #5 on: April 27, 2014, 11:49:27 pm »
If I wasn't able to use it, why would the website allow me to create it? Also, will I have to use a new email as well since I have this forum under this email? Definitely not happy with my experience so far =( I hate being  pain, but I'm moving from a different forum that's been having horrible server issues over the last year. I've lost all of my data in a server crash, and now I can get this new one to work. It's been a frustrating day.
Was an error long ago. Where we used to delete old forums but we no longer do so. Due to this issue.
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

 

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
Database errors

Started by Clunt « 1 2 » Bugs

17 Replies
2533 Views
Last post October 09, 2013, 03:55:20 am
by Clunt
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