03-26-2008, 06:13 PM
Pages: 1 2
03-26-2008, 06:22 PM
You do great work Zinga, thank you.
Registering is easy, so I'm no longer a guest.
Registering is easy, so I'm no longer a guest.
(03-26-2008 06:13 PM)Guest Wrote: [ -> ]Does this have the option to use on only a couple sub-forums?
03-27-2008, 10:17 AM
(03-26-2008 06:13 PM)Guest Wrote: [ -> ]Does this have the option to use on only a couple sub-forums?Nope, but I guess it's not too tricky to do.
I'll look at it when I get home.
(03-26-2008 06:22 PM)Firefox Wins Wrote: [ -> ]You do great work Zinga, thank you.Thanks
Registering is easy, so I'm no longer a guest.
03-27-2008, 04:24 PM
This way it would be really fun for some sub-forums, and without global use.
04-04-2008, 04:50 AM
Lmao, I remember the trouble you had trying to figure out what the person at MyBB support was asking you to do. xD I see you figured it out. Nice job.
06-24-2008, 08:37 AM
have this and the random thread and now i get these errors
when clicking on the index
MySQL error: 1054
Unknown column 't.lastpostbump' in 'order clause'
Query: SELECT t.*, (t.totalratings/t.numratings) AS averagerating, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='19' AND (t.visible='1' OR t.visible='0') ORDER BY t.sticky DESC, t.lastpostbump DESC LIMIT 0, 20
and when trying to post this
MySQL error: 1054
Unknown column 'lastpostbump' in 'field list'
Query: UPDATE mybb_threads SET lastpostbump='1214259142' WHERE tid=37
do i need to create a table ? and if so how and what kind ? thanks
also when i try to switch of the bump thread plug in get a similar error
when clicking on the index
MySQL error: 1054
Unknown column 't.lastpostbump' in 'order clause'
Query: SELECT t.*, (t.totalratings/t.numratings) AS averagerating, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='19' AND (t.visible='1' OR t.visible='0') ORDER BY t.sticky DESC, t.lastpostbump DESC LIMIT 0, 20
and when trying to post this
MySQL error: 1054
Unknown column 'lastpostbump' in 'field list'
Query: UPDATE mybb_threads SET lastpostbump='1214259142' WHERE tid=37
do i need to create a table ? and if so how and what kind ? thanks
also when i try to switch of the bump thread plug in get a similar error
06-24-2008, 12:50 PM
^ I'm actually not sure how you managed to do that, since the plugin creates the field when activated, and drops it when deactivated.
The only possible causes I can think of:
1) somehow you messed up the plugins cache
2) you restored a DB backup before the plugin was activated, or, more likely, switched the threads table with an older one
I suggest just adding the "lastpostbump" field via phpMyAdmin (type etc doesn't matter; if you don't know how, ask your host), which will allow you to deactivate the plugin. After that, reactivate the plugin.
The only possible causes I can think of:
1) somehow you messed up the plugins cache
2) you restored a DB backup before the plugin was activated, or, more likely, switched the threads table with an older one
I suggest just adding the "lastpostbump" field via phpMyAdmin (type etc doesn't matter; if you don't know how, ask your host), which will allow you to deactivate the plugin. After that, reactivate the plugin.
06-25-2008, 07:29 AM
Thanks Zing will look in to it
Pages: 1 2