vb.org Archive - Miscellaneous Hacks

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Miscellaneous Hacks - Featured Threads (https://vborg.vbsupport.ru/showthread.php?t=320387)

This mod has quickly become a staple of my board, thank you ^^

However, when trying to reorder the threads, I get a database error which suggests that the table "thread" doesn't exist.

Code:

Database error in vBulletin 4.2.2:



Invalid SQL:



                SELECT thread.*, featuredthreads.id

                FROM estate_thread

                INNER JOIN estate_featuredthreads

                ON thread.threadid = featuredthreads.threadid

                    ORDER BY featuredthreads.thread_order ASC, featuredthreads.id ASC;



MySQL Error   : Unknown table 'thread'

Error Number  : 1051

Can you provide the information about the steps you are taking to reorder the list and the exact error you get?

Quote:

Originally Posted by MarkFL (Post 2569204)

Can you provide the information about the steps you are taking to reorder the list and the exact error you get?

Thank you, and from the main page (forumhome) which is where I display the Featured Threads box, I either select all or select the Featured Threads I want to reorder and then alter the value in the display order box to be what I want it to (while editing the display order of any other threads which had that original value to the value of the threads being moved up or down). I then click re-order.

My exact error is this on the standard vBulletin Database Error page:

Page URL: https://www.alexandria-ns.com/featur...p?action=array

Code:

Database error in vBulletin 4.2.2:



Invalid SQL:



                SELECT thread.*, featuredthreads.id

                FROM estate_thread

                INNER JOIN estate_featuredthreads

                ON thread.threadid = featuredthreads.threadid

                    ORDER BY featuredthreads.thread_order ASC, featuredthreads.id ASC;



MySQL Error   : Unknown table 'thread'

Error Number  : 1051

Request Date  : Monday, April 18th 2016 @ 02:43:08 PM

Error Date    : Monday, April 18th 2016 @ 02:43:08 PM

Script        : http://www.alexandria-ns.com/featuredthread.php?action=array

Referrer      : https://www.alexandria-ns.com/forum.php

IP Address    : xx.xx.xx.xx

Username      : Joshua Ravenclaw

Classname     : vB_Database_MySQLi

MySQL Version : 5.5.47-0ubuntu0.14.04.1

Okay, try replacing the file "featuredthread.php" (in your forum's root folder) with the attached file...let me know if that works. :)

Quote:

Originally Posted by MarkFL (Post 2569216)

Okay, try replacing the file "featuredthread.php" (in your forum's root folder) with the attached file...let me know if that works. :)

It now works perfectly, thank you so much! :D

Quote:

Originally Posted by ProfC (Post 2569218)

It now works perfectly, thank you so much! :D

Thanks for calling this to my attention and for now letting me know it works. :) I neglected to give some tables an alias in a few of the queries which resulted in an error for sites with a table prefix.

I am planning an upgrade for this product soon to fix a lot of minor details, as I have learned a great deal since I wrote the code for this product.

I'd like to give this a try.. :)

Any idea when upgrade will be forthcoming so I can test the most current version?

Thanks for your efforts ...

Regards,
Doug

Quote:

Originally Posted by BadgerDog (Post 2569670)

I'd like to give this a try.. :)

Any idea when upgrade will be forthcoming so I can test the most current version?

Thanks for your efforts ...

Regards,
Doug

Sorry, I can't be more specific than "soon." The main changes I have in mind are to use phrases and to revise the thread links. :)

Quote:

Originally Posted by MarkFL (Post 2569710)

Sorry, I can't be more specific than "soon." The main changes I have in mind are to use phrases and to revise the thread links. :)

Thanks Mark .. :)

I'll keep checking back... :up:

Regards,
Doug

Quote:

Originally Posted by MarkFL (Post 2569219)

Have you gotten around to this yet? I don't see a post from you saying you have.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01204 seconds Memory Usage 1,745KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: