Author Topic: Database Error...  (Read 550 times)

0 Members and 0 Guests are viewing this topic.

Offline FlashlightForum

  • Full Member
  • ***
  • Posts: 120
  • Karma: 8
  • Gender: Female
  • I can help you set up your forum!
    • View Profile
Database Error...
« on: September 06, 2013, 03:21:54 pm »
Database Error
Unknown column 'b.catimage' in 'field list'
File: C:\inetpub\createaforum\Sources\Subs-BoardIndex.php
Line: 72


SELECT
c.id_cat, c.name AS cat_name,
b.id_board, b.name AS board_name, b.description, b.catimage,
CASE WHEN b.redirect != '' THEN 1 ELSE 0 END AS is_redirect,
b.num_posts, b.num_topics, b.unapproved_posts, b.unapproved_topics, b.id_parent,
IFNULL(m.poster_time, 0) AS poster_time, IFNULL(mem.member_name, m.poster_name) AS poster_name,
m.subject, m.id_topic, IFNULL(mem.real_name, m.poster_name) AS real_name,
1 AS is_read, 0 AS new_from,
IFNULL(mem.id_member, 0) AS id_member, m.id_msg,
IFNULL(mods_mem.id_member, 0) AS id_moderator, mods_mem.real_name AS mod_real_name
FROM advertise_boards AS b
LEFT JOIN advertise_categories AS c ON (c.id_cat = b.id_cat)
LEFT JOIN advertise_messages AS m ON (m.id_msg = b.id_last_msg)
LEFT JOIN advertise_members AS mem ON (mem.id_member = m.id_member)
LEFT JOIN advertise_moderators AS mods ON (mods.id_board = b.id_board)
LEFT JOIN advertise_members AS mods_mem ON (mods_mem.id_member = mods.id_member)
WHERE (FIND_IN_SET(-1, b.member_groups) != 0)


http://Http://Adyf.tk/index.php

Offline CreateAForum

  • Administrator
  • *****
  • Posts: 6256
  • Karma: 294
    • View Profile
Re: Database Error...
« Reply #1 on: September 06, 2013, 03:24:30 pm »
Looks ok that board looks old though 2010
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

Offline FlashlightForum

  • Full Member
  • ***
  • Posts: 120
  • Karma: 8
  • Gender: Female
  • I can help you set up your forum!
    • View Profile
Re: Database Error...
« Reply #2 on: September 06, 2013, 03:26:30 pm »
Looks ok that board looks old though 2010

Woah!
How is that possible?
Like a partial archive?

Offline CreateAForum

  • Administrator
  • *****
  • Posts: 6256
  • Karma: 294
    • View Profile
Re: Database Error...
« Reply #3 on: September 06, 2013, 03:38:25 pm »
Old deleted board didn't get deleted completely.
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/


Offline FlashlightForum

  • Full Member
  • ***
  • Posts: 120
  • Karma: 8
  • Gender: Female
  • I can help you set up your forum!
    • View Profile
Re: Database Error...
« Reply #5 on: September 06, 2013, 04:34:04 pm »
Well, got another error.
This time I can't view any topics...

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 advertise_attachments AS a
LEFT JOIN advertise_attachments AS thumb ON (thumb.id_attach = a.id_thumb)
WHERE a.id_msg IN (2)
AND a.attachment_type = 0

Offline CreateAForum

  • Administrator
  • *****
  • Posts: 6256
  • Karma: 294
    • View Profile
Re: Database Error...
« Reply #6 on: September 06, 2013, 06:08:32 pm »
Should be fixed
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

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

Started by lads Bugs

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