Mysql Error On Ipb Forum

[fjbfour]

I am not a mySQL guru, I am hoping someone here can resolve this for me or at least tell me where to turn next. I submitted a ticket to TCH support and it got kicked up to level 2 before they gave up and suggested I seek help elsewhere.

 

When a user of my IPB forum attempts to report a post to the moderator, they get the error copied in below. This occurs after they have completed the report form and attempt to submit it. The problem has been replicated in three different browsers (IE, FF, Moz), and on multiple OS's.

 

mySQL query error: SELECT m.name, m.email, mod.member_id FROM ibf_moderators mod, ibf_members m WHERE mod.forum_id='2' and mod.member_id=m.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, ibf_members m WHERE mod.forum_id='2' and mod.member_id=m.id' at line 1

mySQL error code: 1064

Date: Sunday 04th of February 2007 04:24:34 PM

 

Any help or suggestions appreciated!

[nortk]

A google search and a look at the reserved words in MySQL suggest that the error means you are using a reserved keyword in your query. Sure enough, "mod" is reserved. Try using a different name and see what happens.

 

I found the following suggestion on some other website:

 

 

Go to sources/functions and find the one occurance of mod (where it isnt attached to anything) i.e. this line: mod ON (mod.member_id=m.id OR mod.group_id=m.mgroup

 

and change it to `mod` (note its ` and not ').

 

i.e.

 

`mod` ON (mod.member_id=m.id OR mod.group_id=m.mgroup

Edited February 4, 2007 by nortk

[fjbfour]

You lost me at "Go to sources/functions".

 

After that I get the general drift, it seems reminiscent of repairing flaky complicated formulas in Microsoft Excel.

 

I can probably bungle my way around and change out the line when I find it, but using the tools in cPanel to manage mySQL (something I have only done twice before and with great fear) does not lend itself to my understanding what you intend for me to do when you say "Go to sources/functions".

 

I apologize in advance for being so inexperienced at this. Thanks again.

[nortk]

I have to admit that I'm not an IPB person, and my post was only based on doing a little research and posting the results. Perhaps a member who uses IPB could point you to the right file. The issue seems to be that one of the files in your IPB installation has the word mod in a query when it should appear instead as `mod`. I don't believe the issue is with the MySQL database configuration.

 

If you want to do something within CPanel, I believe it would be to use the file manager to find the file in your IPB installation that is causing the problems (perhaps a file named functions, in a folder named sources?). Once you find that file, you can edit it within CPanel's file manager...look for the word mod all by itself, and change it to `mod`

 

That's about the limit to my insight. Good luck with this.

[TCH-Thomas]

I would check if anyone else have this problem at IPB´s official forum.

[fjbfour]

OK, after getting the runaround I have a few observations.

 

(1) It is not helpful for TCH support to send us mere customers off to IPB official forum at http://forums.invisionpower.com because it is not a support forum.

 

I found a handful of topics asking for support and a few halfhearted attempts to give it, but the rules clearly state that it is not a support resource. To get support you must use a different forum at http://www.ipsbeyond.com/forums/ or log in and submit a ticket at https://www.invisionpower.com/customer/. Both of these require a user account which you don't have unless you are a direct Invision customer. Using their products through an account here at TCH does not constitute making you a customer, so you are locked out. I attempted to post my problem at http://forums.invisionpower.com anyway and got slightly tongue-lashed for it.

 

(2) Despite my tongue-lashing, the guy who shut me off at http://forums.invisionpower.com did suggest I visit http://forums.invisionize.com, which is not directly run by Invision. It was VERY helpful, and I would suggest that TCH keep this resource handy for anyone with future IPB problems of any type.

 

(3) The problem was actually more complicated than the solution that nortk ran across. In the end I needed to modify four files (none of which ended up being sources/functions.php lol). Still I award him a medal for actually attempting to help me. Thank you!! I now feel like an all-powerful code god, as I have made changes and the problems have been vanquished.

 

In closing, should anyone else have this problem and run into this thread through a search, the specific fix can be found here:

http://forums.invisionize.com/index.php?showtopic=73882

 

Cheers.

Edited February 6, 2007 by fjbfour

[TCH-Thomas]

Hello,

 

First of all, I am sorry that you did not find the answer in the IPB forum I asked you to check out.

 

Second, the reason I asked you to check out that forum is because:

 

1) The TCH forum is a member to member forum not an official support forum for every script there is. If any user have the answer to your question, the user will respond.

 

2) Whenever there is a problem with a script it most logical to go to the author of the script if there are any questions, in this case, Invisionpower. This does not mean that no one here might not know the answer to a specific question, but what I mean is that the author of a script knows better than anyone.

 

3) No one in this forum can be held responsible for what happens outside the forum, in this case, you were sent to a another place. If the IPB forum forwards you to another forum it is their decision, not ours.

 

4) As for the suggestion given by another member, it was clearly stated in the post that the member is not using IPB and therefor might not be able to have the solution.

[TCH-Dick]

I am sorry you had such trouble finding assistance but that is going to be the norm if you continue to use IPB 1.2, which is over 2 years old. We NO longer provide this software as is not very secure nor supported by the author. Had you been able to access their official support forums or help desk you would not have received much assistance. I'm sure you are aware they moved to a paid license system and understandably they no longer support the free versions. I recommend you migrate to something like SMF or purchase a license for the current version of IPB.

[nortk]

It's the nature of trying to do anything on a web page that goes beyond static html: The more powerful your site gets by installing third-party scripts, the more prone to problems it will be, and the harder you will have to work on your own putting out your own fires. These forums are a great starting point, but they have their limits as to what they can fix.

 

Several months ago, I had some problems with my WordPress site. In that situation, the problem actually turned out to be on the TCH end of things. They promptly (very promptly) helped me move things around. But when the problem is with something that is not under TCH's control (your IPB doesn't work, your computer is slow, your soup is too salty, etc.), you can ask for advice here but there are no guarantees that anyone will have the solution you seek. Try googling your problems in a case like that.

 

I am glad you found a solution. In the meantime, you might seriously consider updating to the latest version of IPB (by paying), or select a forum such as SMF using the Fantastico installation in your CPanel.