Peter66007 Posted October 10, 2005 Share Posted October 10, 2005 Hello, I`ve a version of IPB(1.3.1) The Dutch version of www.invisionpower.nl But i cant ask them on support because i am suspended on their forum. So.. When i click on: The Moderating Team then do i get a SQL error:mySQL query error: SELECT m2.id, m2.name, m2.email, m2.hide_email, m2.location, m2.aim_name, m2.icq_number, f.id as forum_id, f.read_perms, f.name as forum_name, c.state FROM ibf_moderators mod LEFT JOIN ibf_forums f ON(f.id=mod.forum_id) LEFT JOIN ibf_categories c ON(c.id=f.category AND c.state != 0) LEFT JOIN ibf_members m2 ON (mod.member_id=m2.id) 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 ibf_forums f ON(f.id=mod.forum_id) ' at line 3 mySQL error code: Date: Monday 10th of October 2005 03:22:55 PM Some people say it will do because i have a to low MySQL Version. The MySQL version of my server is: STATS Server: Apache 1.3.33 DirectAdmin 1.25.0 Exim 4.50 [b]MySQL 4.1.11 [/b] Named 9.2.4 If that its not the problem? Can anyone say what else the problem is? Link to comment Share on other sites More sharing options...
Xenboy Posted October 10, 2005 Share Posted October 10, 2005 The 1.x builds of IPB are no longer supported here. If you want support, buy a license for 2.x and convert your board to that. Link to comment Share on other sites More sharing options...
Marcello Posted October 10, 2005 Share Posted October 10, 2005 The 1.x builds of IPB are no longer supported here. If you want support, buy a license for 2.x and convert your board to that. Wrong, they are still supported. Link to comment Share on other sites More sharing options...
Peter66007 Posted October 10, 2005 Share Posted October 10, 2005 If they is supported can anyone explain to fix my problem? Link to comment Share on other sites More sharing options...
Why Two Kay Posted October 11, 2005 Share Posted October 11, 2005 Seems like a database error, I suggest submitting a support ticket, IPS should be able to fix this. Link to comment Share on other sites More sharing options...
jethro Posted October 11, 2005 Share Posted October 11, 2005 Is indeed a database error and have the exact same thing at an old site which l had forgotten about, oops!!! This will need to be fixed via myphpadmin or your host may be able to do it for you. Please note this ain't an Invision issue at all. Link to comment Share on other sites More sharing options...
Peter66007 Posted October 11, 2005 Share Posted October 11, 2005 But can anyone tell me HOW i fix it? Link to comment Share on other sites More sharing options...
Marcello Posted October 11, 2005 Share Posted October 11, 2005 Can you access the ACP? Try repairing the tables. Also, please note that you are using IPB for many years now and that you only registered to get help. People usually aren't that fond of "leechers => people who only take, but don't give anything back". So you might change the tone in your replies, please. Link to comment Share on other sites More sharing options...
eyedam Posted October 16, 2005 Share Posted October 16, 2005 FROM ibf_moderators modmod is a reserved word for MySQL 4.1, so you need to quote it to get this statement to work. I suppose, previous MySQL versions were not so strict regarding this, so it could have worked without quotes, but now it causes an error. So, open forums/sources/misc/stats.php, find string FROM ibf_moderators mod and replace it with FROM ibf_moderators `mod` (in two places). eyedam Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.