search

daris / fluxbb-quick-mod-tools

Allows moderators quickly moderate topics (edit/delete/close/stick etc).
http://fluxbb.org/resources/mods/quick-mod-tools/
0 stars 0 forks source link

Can't delete or stick topics #4

Open Cryborg opened 12 years ago

Cryborg commented 12 years ago

Hi !

I am experiencing a problem with my 1.4.7 fluxBB and 1.0.4.1 Quick Mod Tools : I can modify and open/close a topic, but deleting or sticking it don't work.

I have no error message in Firebug. The "unstick" action GET is triggered, and in the parameters, everything seems ok : the action, the fid and the tid.

Can you help me ?

Thank you for this mod BTW !

PS : I am on FF7, W7

daris commented 12 years ago

What is your dabatase type?

Cryborg commented 12 years ago

It is MySQL. I just noticed that in fact, the other two functions don't work as I thought they were.... After a few debugging, I noticed that the SQL requests are sent, there is no error, but the data is not updated :s

daris commented 12 years ago

Does it work when you add $db->end_transaction(); before $db->close(); to the include/quick_mod_tools/moderate.php

It was common issue on my mods but it shouldn't affect mysql.

there is no error, but the data is not updated :s

It's something strange :)

Cryborg commented 12 years ago

Yes it works !!! And I'm positive, I am on MySQL in case you ask :)

Thank you very much, I wouldn't have found without you :)

daris commented 12 years ago

It's more strange because end_transaction for mysql does nothing :) 

function end_transaction()
{
    return;
}

Are you sure you're using MySQL? :)

Cryborg commented 12 years ago

Oh yes, I am sure : MySQL 5.0.51. I thought this was some kind of rollback, because when I triggered a SELECT just after the UPDATE, the field was changed. But looking into the DB, this was not the case.

Indeed, that's strange that an empty function makes it work... but it does, I assure you :)