Home > 绝口不提技术 > discuz diy 模块推荐主题过滤Bug

discuz diy 模块推荐主题过滤Bug

October 21st, 2014

不小心接了个论坛的活,采用discuz 来搭建,遇到个Bug

开启门户4合1模块后报错:
1054) Unknown column ‘tr.tid’ in ‘on clause’
SELECT a.*, t.tid, t.subject, t.authorid, t.author FROM forum_activity a INNER JOIN `forum_thread` t ON t.tid=a.tid AND t.isgroup=’0′ AND t.displayorder>=’0′ INNER JOIN `forum_forumrecommend` fc ON fc.tid=tr.tid ORDER BY t.dateline DESC LIMIT 0,5;
PHP Debug
第一次访问(或者删除缓存后)出现,之后会正常显示,但是模块“根据推荐主题过滤”选项不起作用。不知道discuz 是怎么处理在报错的情况下还能正常生成缓存的,很厉害。

模块有个推荐主题过滤选项,是否只显示推荐主题。

source/class/block/forum/block_activity.php
line:277
if($recommend) {
$sqlfrom .= ” $joinmethod JOIN `”.DB::table(‘forum_forumrecommend’).”` fc ON fc.tid=tr.tid”;
}
意思应该是活动表和推荐表关联,但是关联表tr 错误,参考
line:281
$query = DB::query(“SELECT a.*, t.tid, t.subject, t.authorid, t.author$sqlfield
FROM “.DB::table(‘forum_activity’).” a $sqlfrom $where
ORDER BY $orderby
LIMIT $startrow,$items;”
);
应该改为:
if($recommend) {
$sqlfrom .= ” $joinmethod JOIN `”.DB::table(‘forum_forumrecommend’).”` fc ON fc.tid=a.tid”;
}
群组活动也有同样的问题:
source/class/block/group/block_groupactivity.php
line:292
if($recommend) {
$sqlfrom .= ” $joinmethod JOIN `”.DB::table(‘forum_forumrecommend’).”` fc ON fc.tid=tr.tid”;
}
改为:
if($recommend) {
$sqlfrom .= ” $joinmethod JOIN `”.DB::table(‘forum_forumrecommend’).”` fc ON fc.tid=a.tid”;
}

绝口不提技术 , ,

  1. October 8th, 2015 at 02:50 | #1

    The ko samui villas offer various types of villas the larger people and teams.

  2. October 8th, 2015 at 02:51 | #2

    Koh Samui undisguising estate differs from say residential
    property ownership in Portugal or Spain.

  3. October 8th, 2015 at 03:25 | #3

    As well as good beaches, Samui is renowned for activity, leisure, good meals and
    expert & indulgent spas and health retreats.

  4. October 8th, 2015 at 03:35 | #4

    You can completely over indulge here, with a Thai cook readily available to whip up signature cocktails and Thai feasts complement a master.

  5. October 8th, 2015 at 03:37 | #5

    While investment options tend to be scarce in those areas of the entire world, Samui property
    is sappy in worth on a regular basis.

  6. October 8th, 2015 at 03:54 | #6

    Oh my goodness! Incredible article dude! Thank you, However I am experiencing
    troubles with your RSS. I don’t understand why I am unable to subscribe to it.
    Is there anybody else having similar RSS issues?
    Anybody who knows the solution can you kindly respond?
    Thanx!!

  7. October 8th, 2015 at 04:13 | #7

    Samui deluxe Villas are independently embosomed and ensure yourselves pleasure your
    increasing generation temperament never forget.

  8. October 8th, 2015 at 04:16 | #8

    Ive been on a number of antibiotics, and been informed I had
    PID, which the Dr said was from the Mirena.

  9. October 8th, 2015 at 04:26 | #9

    All of our villas is positioned at prime spots and enables you
    the chance to mix leisure and liveliness.

  10. October 8th, 2015 at 05:02 | #10

    This personal collection of just ten villas
    is included within a secure gated community with complete rental and property management solutions readily available.

  11. October 8th, 2015 at 05:14 | #11

    Thanks for finally writing about >观察 思考 记录 discuz diy 模块推荐主题过滤Bug <Liked it!

  12. October 8th, 2015 at 05:15 | #12

    All the Villas are remarkable in their design and appointments, for style in style and convenience.

  13. October 8th, 2015 at 05:21 | #13

    I’m amazed, I have to admit. Seldom do I come across a blog that’s equally educative and entertaining, and without a doubt, you’ve hit the nail on the head.

    The issue is something which not enough folks are speaking intelligently about.
    I’m very happy I stumbled across this in my hunt for something concerning this.

  14. October 8th, 2015 at 06:21 | #14

    Ergo, the need to get a land to stay is pure senior; that’s where a realtor comes foolproof so as to hire a home in Hyderabad.

  15. October 8th, 2015 at 06:31 | #15

    Each Samui villa in addition is sold with an experienced team of
    dedicated, expert in-villa staff to deal with friends’ per
    demand.

  16. October 8th, 2015 at 07:36 | #16

    You can easily make the smaller villas the intimate gateways as well as for romantic along with the medium size villa is most beneficial of family and friends travelling.

  17. October 8th, 2015 at 07:49 | #17

    I may think about some Bitcoin miners who had there life reworked by beginning early might need to buy the ring.

  18. October 8th, 2015 at 08:09 | #18

    Every destructive facet impact all you women have
    suffered with mirena in, I am now suffering with however the only
    distinction is its submit removing.

  19. October 8th, 2015 at 08:26 | #19

    The concern samui villa will have a slur down and a specific lake where you could chill smooth for
    windy time and benefit from the exsiccate.

  20. October 8th, 2015 at 08:28 | #20

    Outfitted with the amenities you can desire and featuring their own private pools, our villas would be the
    perfect getaway residence.

  21. October 8th, 2015 at 09:00 | #21

    Samui Luxury Villas are individually situated and guarantee you a trip that
    the family won’t forget.

  22. October 8th, 2015 at 09:07 | #22

    Red Ginger Chic Resort provides exceptional views of nearby Noppharat Thara nationwide Park, recognized for its wealthy bird-watching options.

  23. October 8th, 2015 at 09:43 | #23

    Pawanthorn Samui is a unique beachfront property comprising of three
    luxurious and completely unique villas.

  24. October 8th, 2015 at 09:57 | #24

    The Koh Samui seaview villas enjoy panoramic views towards the
    coast therefore the Gulf of Siam beyond.

  25. October 8th, 2015 at 15:41 | #25

    You can search the villas using a customized Google Map that shows the area of the many available villas.

  26. October 10th, 2015 at 17:01 | #26

    Hey, you used to write great, but the last several posts have been kinda boring¡K I miss your
    great writings. Past several posts are just a little bit
    out of track! Come on!

  27. October 12th, 2015 at 20:07 | #27

    There are two basic services offered by remote support:.

    Understanding your stimulus for being unorganized can be
    one of the most compelling things you can do for
    yourself. Cleaning and maintaining the house would not
    feel like such a monumental task.

  28. October 13th, 2015 at 00:46 | #28

    Hello, you used to write great, but the last several posts have been kinda boring…
    I miss your tremendous writings. Past several posts
    are just a bit out of track! Come on!

  29. October 14th, 2015 at 10:57 | #29

    The act will regulate digital television including, cable operator and multichannel video programming distributor’s which has raised the eyebrows of
    some advertisers. Funds were raised for this
    ambitious scheme and two British companies were each contracted
    to supply 1250 nautical miles of wire cable which took six months to manufacture.
    So now you will need to think about is where you should be trying to purchase
    this product from.

  30. October 14th, 2015 at 18:46 | #30

    I extremely doubt tampa dui there is an daunting job but, for lawyers are like that.
    Isn’t it nice and respectable family. Your research and interviews will help you
    recover the money that is a first time on appeal. Please visit us in our
    videos that may tampa dui negatively affect commerce.

    He has earned us a call for help with medical expenses.

  31. October 14th, 2015 at 21:40 | #31

    It is really a nice and helpful piece of info. I am satisfied that you shared this useful information with us.
    Please stay us up to date like this. Thank you for sharing.

  32. October 15th, 2015 at 08:36 | #32

    Always use the combination of two moves while doing erotic
    love making. So instead of writing about changing the
    black women, let’s just go with the flow and enjoy it for what it
    is. You can share a little information about yourself but talking about
    yourself the whole time is a big turn off.

  33. October 15th, 2015 at 12:09 | #33

    You can melt several calories every day whilst nonetheless consuming tsty foods and not becoming hungry.

  34. October 15th, 2015 at 17:45 | #34

    Communication is the most critical thing when you are.

    When you have this confident attitude, he will be attracted to
    you. Okay, so you deliberately took time off, getting a result you planned, which made you feel empowered again.

  35. October 16th, 2015 at 03:42 | #35

    Flip flops, ah it is summertime again and for those of us who
    live in the Western world, it is time for walking and enjoying the summer.

  36. October 16th, 2015 at 05:18 | #36

    The properties tend to be essentially positioned utilizing the most readily useful beaches in the area
    while the nightlife of Chaweng literally a few momemts away.

  37. October 16th, 2015 at 05:33 | #37

    While you’re at the workout center, look at
    a few of the weightlifting patterns which bodybuilders employ.
    Elevated insulin levels with an acceptable supply
    of amino acids can minimize the affects of muscle fiber breakdown during
    your workouts. Lean muscle mass: Lean muscle mass is the pure muscle mass
    without the fat.

  38. October 17th, 2015 at 03:30 | #38

    I used Star Wars, Star Trek , and Lord of the Rings all on Blu to put this to the test.
    Take the guesswork out of picture adjustments with this simple-to-use feature.
    I’ll just let her work off her excess energy alone, I mutter
    to myself.

  39. October 21st, 2015 at 05:48 | #39

    Hiya very nice site!! Guy .. Excellent .. Amazing .. I’ll bookmark your web site and
    take the feeds also? I am glad to find so many useful information right here within the post, we’d like
    develop extra strategies in this regard, thanks for sharing.
    . . . . .

  40. October 23rd, 2015 at 05:34 | #40

    The act will regulate digital television including, cable
    operator and multichannel video programming
    distributor’s which has raised the eyebrows of some advertisers.

    Laddertray is most widely used in the construction of commercial construction projects and light industrial applications.
    Reaction Injection Molding (RIM) was a new process still in use today that
    combines liquid reactive components under high pressure into
    a molded shape.

  41. October 24th, 2015 at 11:53 | #41

    I think the admin of this web site is in fact working hard in favor of his website, for the reason that here every stuff is quality based information.

  42. October 28th, 2015 at 15:55 | #42

    The Xtreme-CT produces images that show the architecture of the bone, not just the density.
    In order to combat the problems caused by testosterone becoming bound to SHBG an athlete must strive to keep
    his testosterone bioavailability high. Many of these developments and changes
    form a part of the secondary sex characteristics in males.

  43. October 30th, 2015 at 19:53 | #43

    Europe: Many European countries do not expect tips.
    Attempt to get an early morning flight if possible.
    Air traffic controllers keep the airways more safe.

  44. July 7th, 2016 at 17:10 | #44

    thats REALLY that price is for like a monthly but ya das fucked up

  45. September 29th, 2016 at 04:57 | #45

    Avere un attributo più extensa per essere in grado di soddisfare il
    tuo partner è stato un problema enorme per gli uomini nel corso degli anni, soprattutto perché (fino ad ora) non esisteva un modo sicuro
    per raggiungerlo senza compromettere la tua
    salute.

  46. October 18th, 2016 at 04:11 | #46

    Tommy Emmanuel’s career as a guitar player took him to the realm of stone where
    he won talent quests like a guitar player, played drums in the
    rock-band regarding his brother Phil on guitar and found themselves playing with the large names in Australian pop music.
    Then, when the presale starts, click within the
    presale password box and press Ctrl + V to paste it within the box.
    Search on the internet to acquire some guidelines about how precisely to buy a Paolo Soprani accordion.

  47. October 22nd, 2016 at 15:36 | #47

    Everything and something is just a subject below: delicate
    bans, sniping information, robot config spoofing methods and methods, advises, ban studies.

  48. October 29th, 2016 at 19:25 | #48

    Outstandin uest there. Whaat occurred after? Takke care!

  49. November 14th, 2016 at 00:15 | #49

    A jak już, tak jak ja wczoraj, podejmiemy wysiłek żeby się tam
    się dla Ciebie zarejestrować, nasze wpisy znikają.

  50. April 14th, 2017 at 01:27 | #50

    Bad human! Digging for comment karma, bad human! Don’t make me spritz you with the water bottle! Hehe

  1. No trackbacks yet.