 The Moderating Team, Error |
|
|
|
|
  |
 Dec 19 2005, 04:12 PM
Post
#1
|
|
|
Nenad Bozidarevic  Group: [MODERATOR] Posts: 1,049 Joined: 7-November 05 From: Belgrade, Serbia Member No.: 9,500 myCENTs:9.92  |
The forum I administrate work just fine, but there is just one problem. The board version is 1.3, and the error occurs when I click the moderating team link. Here's what I get:
QUOTE There appears to be an error with the *********** database. You can try to refresh the page by clicking here, if this does not fix the error, you can contact the board administrator by clicking here And then it says: QUOTE mySQL query error: SELECT m.id, m.name, m.email, m.hide_email, m.location, m.aim_name, m.icq_number, f.id as forum_id, f.read_perms, f.name as forum_name, c.state FROM astahost_moderators mod LEFT JOIN astahost_forums f ON(f.id=mod.forum_id) LEFT JOIN astahost_categories c ON(c.id=f.category AND c.state != 0) LEFT JOIN astahost_members m ON ((mod.is_group=1 and mod.group_id=m.mgroup)) mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mod LEFT JOIN astahost_forums f ON(f.id=mod.forum_id) ' at line 3 mySQL error code: Date: Monday 19th of December 2005 11:04:15 AM I have heard many advice waht to do, but nothing worked. Can you guys help? |
 |
 
|
|
Dec 19 2005, 06:45 PM
Post
#2
|
|
|
SM- the Man -The Myth - The Legend Himself  Group: Members Posts: 457 Joined: 4-September 05 From: Drinking da rootbeers Member No.: 8,313 myCENTs:72.48 |
what mods have you installed? lets tart with that, but from the looks of it you must have not editing the file correctly when you install the member group color mod.
|
|
|
|
|
Dec 19 2005, 07:50 PM
Post
#3
|
|
|
Nenad Bozidarevic Group: [MODERATOR] Posts: 1,049 Joined: 7-November 05 From: Belgrade, Serbia Member No.: 9,500 myCENTs:9.92 |
I have installed a Spoiler Tag mod, but this hasn't been working from the beginning. Besides that mod, I haven't installed anything else. I have messed with the file that contains this code, but only to try some advice I was given. Unfortunatelly, it didn't work, and it still isn't. I have been told that there is an error in the code itself, but none of the suggestions helped.
|
|
|
|
|
Dec 26 2005, 04:25 PM
Post
#4
|
|
|
Member [ Level 1 ] Group: Members Posts: 33 Joined: 25-December 05 From: Bucharest Member No.: 10,286 |
you should try going on www.invisionboard.com forum and ask there for help because they should know it better !
|
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 5th December 2008 - 12:57 AM |