SQL Error I Suppose

[ℓєσ gнσѕт]

SQL ERROR [ mysqli ]

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 '' at line 3 [1064]

SQL

SELECT group_reputation_power FROM phpbb_groups WHERE group_id =

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_reputation.php
LINE: 61
CALL: dbal_mysqli->sql_query()

FILE: memberlist.php
LINE: 1502
CALL: get_rep_power()

Gotta love these MODs eh? So, as its been pointed out to me, I think theres an error on line 3 of something...heres the issue though. It says to read the manual. I host with Blue Host, am I to ask them for the manual?

For the record, I also got weird errors the entire time I went to install this copy of phpBB3.0.4 which made me mad. They just floated on the top of the page, but I was able to install fine.

Im starting to think I should have just installed 3.0.3 and updated

 

[spyka]

The manual is that of MySQL on http://www.mysql.com

The error is because the SQL statement is trying to select data where the group_id value is a certain value but that value doesn't exist.

What mod is it?

 

[ℓєσ gнσѕт]

Its the User Reputation Points 0.2.0a. Ive been looking through its topic on phpBB.com

http://www.phpbb.com/community/viewtopi ... 0&t=780735

But I just cant seem to get anywhere yet. Maybe its farther beack in the topic...

The funny part is, ive installed this MOD before, on the same host without any issues at all. The MOD hasnt had an update either, I used the exact same one, I never deleted it off my computer -😉-

 

[Murder he Wrote]

I believe the MOD has compatibility issues with phpBB 3.0.4, we're still running 3.0.3 here which is why things are still working.

I believe Forum Advertiser have temporarily removed the rep mod for the same reason...the SQL error. You're not alone, you'd be best off removing the MOD (not the database parts) for now and when it works with 3.0.4 make the file edits again ~smile~

 

[Jasonp]

Yeah that way once the mod has been re released you wont lose any stats 🙂

Good luck

 

[ℓєσ gнσѕт]

Ah, that makes sense guys. The good news is that im not installing this on a live forum, so I can just leave it the way it is. I only see the error on the member list page (that I know of...) so its not really a big issue. I hope the MOD author kicks it into high gear with this one though...

 

[Subz]

Thats a shame, i am glad I saw this topic -D-

 

[ℓєσ gнσѕт]

I just checked the topic again, still no updates from the author

So if this guy leaves it go, what happens to the MOD? Will it die out, or can someone else try to make the updates it needs...?

 

[Subz]

This mod is ment to be getting integrated in the next big release of phpBB3 but for now i am not sure, i am going to downgrade to 3.0.3

 

[ℓєσ gнσѕт]

This mod is ment to be getting integrated in the next big release of phpBB3 but for now i am not sure, i am going to downgrade to 3.0.3

Is it now? I hadnt heard that yet...hopefully theyll add in lots of MODs, im willing to wait if they decide to. Ill probably just install a copy of phpBB 3.0.3 fresh rather than try to downgrade and what not. Easier on my end, since nothing is live or anything.

 

[Callum93]

I believe the MOD has compatibility issues with phpBB 3.0.4, we're still running 3.0.3 here which is why things are still working.

I believe Forum Advertiser have temporarily removed the rep mod for the same reason...the SQL error. You're not alone, you'd be best off removing the MOD (not the database parts) for now and when it works with 3.0.4 make the file edits again ~smile~

Also the attribute MOD doesn't work on phpBB 3.0.4.

 

[ℓєσ gнσѕт]

Also the attribute MOD doesn't work on phpBB 3.0.4.

Isnt that wonderful...im really starting to like the sounds of that "hook system" lol. Seems alot easier if you ask me...im looking forward to see it, because if I dont, I might have to get a job and get IPB -lol-

 

[CyberFreak]

I believe the MOD has compatibility issues with phpBB 3.0.4, we're still running 3.0.3 here which is why things are still working.

I believe Forum Advertiser have temporarily removed the rep mod for the same reason...the SQL error. You're not alone, you'd be best off removing the MOD (not the database parts) for now and when it works with 3.0.4 make the file edits again ~smile~

Also the attribute MOD doesn't work on phpBB 3.0.4.

That isn't true...

I have updated this forum to phpBB 3.0.4 and it works fine here -🙂-