4 replies to this topic

[fiked]

We are having troubles upgrading our points mod, when we post we get a querie:

mySQL query error: UPDATE ibf_members SET posts=posts+1, points=points+1, last_post=1151995318 WHERE id=1

SQL error: Unknown column 'points' in 'field list'
SQL error code:
Date: Tuesday 04th of July 2006 01:41:58 AM


What is the problem and how can i fix?


My msn: Michael@shoutgfx.com

There is a 10$ reward to who fix's the problem that leads to the mod working on my site again.

[Mr. Matt]

well the line SQL error: Unknown column 'points' in 'field list' is telling you it can't find the collumn in the table ibf_members. Either the column is in another table, or the mod forgot to add that column or you didn't read it correctly.

Either add the new column yourself or show us the mod so we can take a look at it. And I would suggest showing us.

Matt

[Matthew.]

Just a small addon to that, What deadly says is correct, the last time i did this mod (a long while ago ) i believe the sql they provided to modify the user table was incorrect and i had to modify it.

However there are a few points mods so that could be completly irrelevant.

[Mr. Matt]

yea I have taken a look at it, and I think its just the new column needed, but I didn't fiddle with it just in case I did somthing wrong, told him to contact the mod makers.

If this has been around for a while you would have thought someone could have fixed it by now...

[Matthew.]

Just create a tinyint column called points. Nothing technical, and you couldnt screw it up