»

[girlgerms]

One of my client's sites is running Invision Board 1.3 and in the last week some mySQL errors have been thrown up, seemingly out of the blue.

I'm not sure if it's something they've done (and haven't admitted) or if it's due to any server upgrades/changes.

It seems to be specific to the moderator group code, but I have no idea where to begin trying to fix this. (I have googled as much as I could but I'm still feeling lost!)

Here is one of the pages that displays the error:

http://www.zcarclubq.org.au/index.php

Any help would be appreciated!

Thanks!!

[deastwood]

No errors showing now! But just incase.

have you asked them if they have applied any modifications or anything?

have they edited any code?

If they have one option is to try and login to the control panel or the forum if you can and run the database maintenance scripts which clean and fix them.

Let me know if you have any other problems as there are other ways to try and fix it but without the exact errors im useless!

[David]

Tell your client that they need to upgrade that script IMMEDIATELY. They are running 1.2.2 and are HIGHLY AT RISK with such an outdated script. They need to take care of that right now.

Also, I have a Z car. 1974 260Z

[deastwood]

the problem is to upgrade they need to pay, as it now costs for invision board.

[girlgerms]

Thanks for all your suggestions! Interesting that the error wasn't showing for you! I just tried the site in IE and that page was actually ok, however in Firefox it shows up the errors. In IE though, the errors definitely come up once logged in to the site.

This is the error code that shows:

mySQL query error: SELECT mod.mid as is_mod, m.id, m.name, m.mgroup, m.password, m.email, m.allow_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track,
m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post,
m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, g.*
FROM ibf_members m
LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
LEFT JOIN ibf_moderators mod ON (mod.member_id=m.id OR mod.group_id=m.mgroup )
WHERE m.id='1'

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 ON (mod.member_id=m.id OR mod.group_id=m.mgroup )
WHERE m.' at line 6
mySQL error code: 1064
Date: Monday 05th of June 2006 07:08:49 AM

[David]

Originally Posted by deastwood

the problem is to upgrade they need to pay, as it now costs for invision board.

I know, I use invision board, but the fact that they are using something that far out of date is a serious risk. That script should be disabled from use on the server. They need to either upgrade it or change it to something else like SMF if they need simillar features, today. Plus the fact that that version is so old that the version of MySQL and PHP that are on the server didn't exist at the time probably have something to do with the error that is showing up.

[Skipdawg]

Originally Posted by deastwood

the problem is to upgrade they need to pay, as it now costs for invision board.

Yes, but either way they could end up having to pay one way or the other.

[deastwood]

one thing you could try is i no that 1.3 was released just before they made it cost and that was pretty secure and quite uptodate,

i understand what you are saying but there are many sites like invisionfree that all run on 1.3 without any problems so this is more likely todo with what the admin has done to the site than the script itself. Thats why i suggested a mysql clean up.

[David]

Originally Posted by deastwood

one thing you could try is i no that 1.3 was released just before they made it cost and that was pretty secure and quite uptodate,

i understand what you are saying but there are many sites like invisionfree that all run on 1.3 without any problems so this is more likely todo with what the admin has done to the site than the script itself. Thats why i suggested a mysql clean up.

1.3 has vulnerabilities as well. It's not a good idea to keep using an outdated script simply because you don't want to pay to upgrade it. If they don't want to pay for the new version, they need to switch software.

And Invisionfree isn't just invisionboard. I'm sure it's a hacked version of it to run the way it does. You also don't know which version of Mysql and php are running there. This needs to be updated to the latest or removed rather than patched up slightly. I mean come on, the one they are using is 3 years old and 1.3 hasn't been updated since 2.0 came out.