Administrative and Maintenance Tools - Global & Cross-Posted Stickies

This mod allows you to specify threads that are stickied across multiple forums, including universally and set a limit on how long this remains in effect.

[Nirjonadda]

Does not work on 4.1.10 ? Get database error on when clik Crosspost Sticky Thread

Database error in vBulletin 4.1.10:

Invalid SQL:

SELECT f.*, t.title
FROM vbthread_global_stickies AS f inner join vb thread AS t on t.threadid = f.threadid
ORDER BY read_order ASC;

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 'AS t on t.threadid = f.threadid
ORDER BY read_order ASC' at line 2
Error Number : 1064
Request Date : Tuesday, November 13th 2012 @ 01:10:36 AM
Error Date : Tuesday, November 13th 2012 @ 01:10:36 AM

MySQL Error : Table 'user_database.vbthread_global_stickies' doesn't exist
Error Number : 1146

[Eosian]

It works on 4.1.10.
There was an extra space in the query by the TABLE_PREFIX. It's been corrected in the zip or you can just manauly remove it from your version.

Line 119:

FROM " . TABLE_PREFIX . "thread_global_stickies AS f inner join " . TABLE_PREFIX . " thread AS t on t.threadid = f.threadid

Should be:

FROM " . TABLE_PREFIX . "thread_global_stickies AS f inner join " . TABLE_PREFIX . "thread AS t on t.threadid = f.threadid

[Nirjonadda]

Does not fixed ? get database error on new zip file.
MySQL Error : Table 'user_database.vbthread_global_stickies' doesn't exist
Error Number : 1146

[Eosian]

Similar issue with the install routine, it had a ` mark that conflicted with your prefix.

Should work if you reinstall now.

[osix]

will this be working on 4.2 pl2 -

[Eosian]

Originally Posted by osix

will this be working on 4.2 pl2 -

Are you somehow under the impression that it does not?

[Gemma]

Thanks, this could come in handy. I'll give this a try

[patrick91]

Thanx! Will try this soon. It's nice to see that there still being devs making addons for vb4

[Eosian]

Originally Posted by patrick91

It's nice to see that there still being devs making addons for vb4

More that I'm releasing things I've been sitting on forever. I have so much built into my installation that I take for granted that it's a pain to export addons that rely on things the rest of vBulletin doesn't have but always should've.