News:

Create A Forum Installed

Author Topic: Database error  (Read 530 times)

0 Members and 1 Guest are viewing this topic.

Offline Dr. Pa1N

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

Badges: (View All)
Topic Starter First Post Level 1
Database error
« on: June 06, 2012, 02:24:42 am »
Hello, I am the admin of a RuneBase.createaforum.com and when I try to go to nearly any link, it has some kind of database error, it's different every time, when I go to edit my profile, there is an error, when I go to a topic I wrote, there is an error, idk what to do, can anyone help me?

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: June 06, 2012, 02:26:12 am »
Yeah looks like you made a very old board but let me see if I can fix.
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

Offline CreateAForum

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

Badges: (View All)
Avatar Linux User Tenth year Anniversary
Re: Database error
« Reply #2 on: June 06, 2012, 02:34:52 am »
Should be better now let me know if anything else.
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

Offline Dr. Pa1N

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

Badges: (View All)
Topic Starter First Post Level 1
Re: Database error
« Reply #3 on: June 06, 2012, 02:38:40 am »
Unknown column 'a.file_hash' in 'field list'
File: C:\Inetpub\createaforum\Sources\Display.php
Line: 1000


            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 runebase_attachments AS a
               LEFT JOIN runebase_attachments AS thumb ON (thumb.id_attach = a.id_thumb)
            WHERE a.id_msg IN (4)
               AND a.attachment_type = 0
 
You only fixed the forum profile thingy! there is still an error when I try going to any topic when I am logged into admin, it works when I am a guest though!

Offline CreateAForum

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

Badges: (View All)
Avatar Linux User Tenth year Anniversary
Re: Database error
« Reply #4 on: June 06, 2012, 02:39:21 am »
Try now.
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

Offline Dr. Pa1N

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

Badges: (View All)
Topic Starter First Post Level 1
Re: Database error
« Reply #5 on: June 06, 2012, 02:41:58 am »
Fixed, thankyou so much for your help.

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
605 Views
Last post September 16, 2010, 11:21:21 pm
by CreateAForum
3 Replies
603 Views
Last post May 20, 2012, 04:01:32 pm
by aIURbliS
3 Replies
360 Views
Last post February 01, 2013, 07:07:10 pm
by Willing to Help
6 Replies
672 Views
Last post September 06, 2013, 06:08:32 pm
by CreateAForum
database error

Started by lads Bugs

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