vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Show Thread Enhancements - Thread Description (https://vborg.vbsupport.ru/showthread.php?t=131239)

KURTZ 12-14-2006 03:18 PM

thx TrucLinh!

already INSTALLED on 3.6.4 and works like a charm :D

TrucLinh 12-15-2006 01:06 AM

Quote:

Originally Posted by Neutral Singh (Post 1138470)
Is it possible to do search in thread description? Thanks for this.

Quote:

Originally Posted by KURTZ (Post 1138510)
thx TrucLinh!

already INSTALLED on 3.6.4 and works like a charm :D

You are welcome.

farooqaaa 12-19-2006 03:16 PM

Thanks alot. This is nice!

transitbus 12-19-2006 03:26 PM

A couple of suggestions:
  1. Don't rar the file please, leave it as zip
  2. There is no need to upload the XML product file via ftp. You can use the product upload via the admin CP
  3. The description on the main thread here is far too confusing, it has too much information that is hard to follow. Can you simplify the process and give upgrade instructions?

Thanks and aside from these little things this is an excellent mod.

transitbus 12-19-2006 03:40 PM

Edit... NM simply had to remove the program and reinstall it and the error went away.

transitbus 12-19-2006 11:08 PM

when installed your mod interferes with unread posts. When uninstalled it break the undread post function by deleting a required table field. This is a dangerous bug and I hope you fix it because now I am having to go and manually fix my forum to fix your bug


Quote:

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT searchid FROM search AS search WHERE userid = 1 AND searchhash = 'b2ba47094c3fh227e95e9820abe34e7a' AND orderedids = '491' AND announceids = '' AND completed = 1;

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Tuesday, December 19th 2006 @ 05:07:48 PM
Script : http://www.shebaliscronies.com/search.php?do=getnew
Referrer : http://www.shebaliscronies.com/
IP Address : xxx.xxx.xxx.xxx
Username : xxx
Classname : vb_database

transitbus 12-19-2006 11:34 PM

Edit:

looks like your mod removes a required field:

http://www.vbulletin.com/forum/bugs3...iew&bugid=1218

Quote:

If you have done a new install and are getting errors while searching, this column is missing. Please run the following query to add it:

Code:
ALTER TABLE `search` ADD `completed` SMALLINT UNSIGNED NOT NULL DEFAULT '1';
I think if you alter your xml file to not include:

Quote:

$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "search` ADD `completed` tinyint(1) default NULL");
and:

Quote:

$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "search` DROP `completed`");
This might work because completed has to have a default of not null to work and you are altering it to change to null as the default. You also can not remove this field

Paul M 12-20-2006 04:36 AM

The uninstall code of this mod is removing a default vbulletin field from the search table - this should be fixed asap and people informed to upgrade (and not to uninstall this product until they have). You should also remove the code in the install section that adds this field - the field should already be present in a 3.6.4 installation.

Edit: This has now been fixed by the author.

Terminatoronly 12-20-2006 07:09 AM

thanks alot working fine for me :D

Cybershaolin 12-20-2006 08:13 PM

There is also another bug for 3.6.4. When you want to edit a message by using the Edit (modifiy) button and if you decide to go in advance mode, you will get a DB error such as:

Quote:

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE thread SET description = '' WHERE threadid = '24';

MySQL Error : The table 'vb_364.thread' doesn't exist
Error Number : 1146
Date : Wednesday, December 20th 2006 @ 04:54:03 PM
Script : http://myforum.com/forum/editpost.p...pdatepost&p=87
Referrer : http://myforum.com/forum/editpost.p...post&postid=87
Username : Netsurfer
Classname : vb_database


All times are GMT. The time now is 09:15 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02600 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
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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