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. January 8th, 2015 at 15:59 | #1

    Yeah, that’s the titkce, sir or ma’am

  2. March 12th, 2015 at 02:35 | #2

    moi ça reste simple le matin :-lotion micelaire avène-eau à la rose sanoflore ou eau de beauté caudalie-pour le contours des yeux : idealist cooling eye illuminator d’estée lauder-pour le visage : hydramax + active chanelle soir :-lotion micelaire avène-eau à la rose sanoflore-pour les yeux : advanced night repair estée lauder-le visage :la crème 1er cru caudalie

  3. April 6th, 2015 at 04:13 | #3

    I literally searched for months for a clock radio with certain features. I wanted all of these features in one unit: digital radio tuner, large number display, option to dim and/or turn off display light, two alarms, a time projection, easy to program, a small footprint, AND all that at a reasonable price. This little radio has all of that and then some. I love the weight of it…sturdy. It has a contemporary look and feel to it. All in all I am very pleased with this purchase.

  4. September 15th, 2015 at 23:51 | #4

    I was searching for this. Actually rejuvenating information. Thank you.

  5. September 16th, 2015 at 11:38 | #5

    Hi there to every one, the contents existing at this website
    are truly amazing for people knowledge, well, keep up the
    nice work fellows.

  6. September 27th, 2015 at 06:34 | #6

    Cleaning Quotes
    1 Willoughby Avenue
    Howick
    Auckland 2014
    027 243 1862

  7. September 27th, 2015 at 19:21 | #7

    This is a fantastic blog, many thanks for sharing.

  8. September 27th, 2015 at 20:21 | #8

    I’m new to your blog. Stumbled upon it while exploring the web.
    Continue the good work. I am hoping you update it on a regular basis as I’ll be staying tuned for lots more.

  9. September 30th, 2015 at 02:00 | #9

    Good pߋst! Ԝе will be linking to this particularly
    great content on our website. Keep up the good writing.

  10. October 5th, 2015 at 23:04 | #10

    Thanks for sharing your thoughts about bug.
    Regards

  11. October 6th, 2015 at 12:05 | #11

    I do not even know the way I stopped up here, but I
    believed this post was good. I do not recognize who you’re but certainly you’re going to a famous blogger in case you are not
    already. Cheers!

  12. October 7th, 2015 at 08:48 | #12

    This is a good tip particularly to those fresh
    to the blogosphere. Short but very accurate info… Thanks for
    sharing this one. A must read post!

  13. October 7th, 2015 at 09:22 | #13

    the

  14. October 7th, 2015 at 09:37 | #14

    X2 Samui Seaside Resort is designed to blend using natural surroundings and peaceable uninterrupted views over the
    Gulf of Thailand.

  15. October 7th, 2015 at 10:02 | #15

    I do trust all of the concepts you’ve presented in your post.

    They’re truly convincing and can definitely
    work. Thank you for the post.

  16. October 7th, 2015 at 10:12 | #16

    Almost all samui property will accept a meet wrecked and a specific pond where you can poker face uninterrupted instead of few years and relish
    the sunshine.

  17. October 7th, 2015 at 10:33 | #17

    Wish to actually get business from it?

  18. October 7th, 2015 at 10:34 | #18

    Excellent post! Continue the good work.

  19. October 7th, 2015 at 10:48 | #19

    Absolute Sansabai Resort and Spa is the new resort in 2010
    that sits serene among the Bangla bustle.

  20. October 7th, 2015 at 10:50 | #20

    Most of the villas are built in Balinese design with a main house and an independent guesthouse(s) as
    well as least 3 bathrooms.

  21. October 7th, 2015 at 11:00 | #21

    So great to see remarkable articles on this blog. Appreciation for posting and also sharing them.

  22. October 7th, 2015 at 11:09 | #22

    The Chawang Beach, that is notorious for its unlimited assortment
    of nightlife attractions, is approximately 5 minutes away
    from the villas.

  23. October 7th, 2015 at 11:34 | #23

    Unless you remain in a competitive market I ‘d state
    you don’t have to put much – if any – effort into earning links.

  24. October 7th, 2015 at 11:44 | #24

    And of course Samui has enough spas and beauty remedies to assist you do
    just that.

  25. October 7th, 2015 at 11:44 | #25

    Truly instructional as well as superb structure of articles,
    now that’s great.

  26. October 7th, 2015 at 11:56 | #26

    I am typically to blogging and i actually like your content.

    The article has actually got my interest. I’m going to
    bookmark your site as well as retain checking for fresh information.

  27. October 7th, 2015 at 12:12 | #27

    I do not even know the way I ended up right here, however I believed this publish was great.
    I do not realize who you’re however definitely you’re going to a famous blogger when you are not already.
    Cheers!

  28. October 7th, 2015 at 12:16 | #28

    There’s also future rentals designed for these villas and you can stay for your full holidays.

  29. October 7th, 2015 at 12:47 | #29

    You will acquire weight and wont have the ability to lose it: I actually lost some weight coming off of hormonal birth control and onto the Mirena.

  30. October 7th, 2015 at 13:14 | #30

    This passion for information plays a part in the personal, tranquil atmosphere of Samui Garden Villa.

  31. October 7th, 2015 at 13:17 | #31

    They have been very lovely, and so they can contend with a number of
    the most readily useful trip houses in Asia.

  32. October 7th, 2015 at 13:49 | #32

    The resort staff had been marvellously friendly and helpful
    and nothing had been a lot of trouble.

  33. October 7th, 2015 at 13:58 | #33

    No doubt a welcomed boost for the business and I can not criticise the
    project from that perspective.

  34. October 7th, 2015 at 14:09 | #34

    You could undergo a list of property obtainable if you believe you would
    most certainly enjoy a stunning view everyday of your life.

  35. October 7th, 2015 at 14:20 | #35

    Your consumers are searching for your business RIGHT
    NOW. Let us assist you get discovered!

  36. October 7th, 2015 at 14:48 | #36

    Koh Samui real estate is rapidly becoming mixed of the finest possible investments for folks in the world.

  37. October 7th, 2015 at 14:52 | #37

    Transmontane Nature guide tray (OPP), is an independent agent, addressing
    most of the world aspects in accordance with the Koh
    Samui marketplace.

  38. October 7th, 2015 at 15:25 | #38

    Quality articles is the secret to be a focus for the users to go to see the web site, that’s what this website is providing.

  39. October 7th, 2015 at 15:36 | #39

    That’s discovery.

  40. October 7th, 2015 at 17:13 | #40

    Sure, naturally. I advise it. However for local SEO, it’s the local aspects that matter the majority of.

  41. October 7th, 2015 at 17:18 | #41

    I think the companies that are appearing on the map are business that have been around the longest.

  42. October 7th, 2015 at 18:12 | #42

    Kandana Villas are made with quality in your mind, guaranteeing your Samui villa will last the test
    of time.

  43. October 7th, 2015 at 19:31 | #43

    Search engines pick exactly what material they will and will not
    index as they go through the crawling process.

  44. October 7th, 2015 at 19:32 | #44

    Given that they are actual end users, you never ever have to worry about bots or receiving into trouble with Instagram.

  45. October 7th, 2015 at 22:31 | #45

    Drive around the community to see homes with available” signs of their yards.

  46. October 7th, 2015 at 22:38 | #46

    The villas are designed, specified and done
    towards the highest requirements with clean lines and timeless
    designs.

  47. October 7th, 2015 at 23:00 | #47

    The 4 kilometer beach strip of Maenam provides a
    charming and intimate background for a secret vacation at Fair home Villas & Spa.

  48. October 7th, 2015 at 23:35 | #48

    Your website is preferably situated in a lush coconut grove between the tourist hubs of Chaweng and
    Lamai and will be offering panoramic close ocean views.

  49. October 8th, 2015 at 00:15 | #49

    We now have two room villas for a small group and
    5 to 6 bedroom villas for medium-sized groups aswell.

  50. October 8th, 2015 at 01:08 | #50

    Top-notch freehold condominiums come in very short offer in Samui
    and early watching is strongly suggested.

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

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

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

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

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

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

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

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

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

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

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

    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!!

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

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

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

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

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

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

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

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

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

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

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

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

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

    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.

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

    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.

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

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

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

    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.

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

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

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

    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.

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

    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.

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

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

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

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

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

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

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

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

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

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

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

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

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

    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!

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

    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.

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

    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!

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

    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.

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

    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.

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

    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.

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

    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.

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

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

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

    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.

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

    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.

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

    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.

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

    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.

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

    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.

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

    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.
    . . . . .

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

    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.

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

    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.

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

    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.

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

    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.

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

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

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

    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.

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

    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.

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

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

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

    Outstandin uest there. Whaat occurred after? Takke care!

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

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

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

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

  1. No trackbacks yet.