Create A Forum - Support Forums

Support => General Support => Topic started by: Dr. Pa1N on June 06, 2012, 02:24:42 am

Title: Database error
Post by: Dr. Pa1N 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?
Title: Re: Database error
Post by: CreateAForum 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.
Title: Re: Database error
Post by: CreateAForum on June 06, 2012, 02:34:52 am
Should be better now let me know if anything else.
Title: Re: Database error
Post by: Dr. Pa1N 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!
Title: Re: Database error
Post by: CreateAForum on June 06, 2012, 02:39:21 am
Try now.
Title: Re: Database error
Post by: Dr. Pa1N on June 06, 2012, 02:41:58 am
Fixed, thankyou so much for your help.