vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   =V.2= vB3 Similar Threads (https://vborg.vbsupport.ru/showthread.php?t=46860)

Velocd 12-21-2002 03:54 PM

Alright, the .zip has been updated with version 2.1.

Updated:
+ Added permission check, with thanks going to Teck for supplying the code. ;)
+ Enhanced "last poster" information, requested by Boofo
+ Updated screenshot

To upgrade from V2:

Just update the template1.txt and the codechunk.txt over the previous code.

Velocd 12-21-2002 03:59 PM

Quote:

Originally posted by xware
phpmyadmin said:
The used table type doesn't support FULLTEXT indexes
Why?

What version of MySQL & vBulletin are you running?

TECK 12-21-2002 04:01 PM

[high]* TECK clicked Install :p :D
[/high]
Btw, the perms will add 2 queries, for a total of 3. But is better then editing every time the showthread.php, once you change the perm settings.

xware 12-21-2002 04:12 PM

Quote:

Originally posted by Velocd


What version of MySQL & vBulletin are you running?

PHP v4.2.2
mysql v3.23.54

Velocd 12-21-2002 04:33 PM

What about your vBulletin version? This hack has been tested on 2.2.6 and 2.2.9, thus suggesting it should work for 2.2.7 and 2.2.8 as well. If there are issues with older versions, I'll need to modify the vB database info of this hack.

TECK 12-21-2002 04:40 PM

Quote:

Originally posted by xware

PHP v4.2.2
mysql v3.23.54

Make a file with the content:
Code:

<?php
error_reporting( E_ALL & ~E_NOTICE );
include_once( './global.php' );

cpheader( '<title>Run Query</title>' );

$runquery = "ALTER TABLE thread ADD FULLTEXT( title )";
$DB_site->reporterror = 1;
$DB_site->query( $runquery );

print_r( 'Query successful:<br>' );
print_r( '<font face="Courier New"> ' . $runquery . '</font><br><br>' );
print_r( 'Do not forget to delete this file.' );

cpfooter();
?>

Save it as [high]doquery.php[/high] and upload it onto your /admin folder.
Once uploaded, load it through your browser and let me know if you get any errors. If you do, post them here...

TECK 12-21-2002 04:42 PM

Velocd, is working on 2.2.8 for sure. :)

xware 12-21-2002 04:42 PM

Quote:

Originally posted by Velocd
What about your vBulletin version? This hack has been tested on 2.2.6 and 2.2.9, thus suggesting it should work for 2.2.7 and 2.2.8 as well. If there are issues with older versions, I'll need to modify the vB database info of this hack.
my vb is 2.2.9 and phpmyadmin is 2.2.5

TECK 12-21-2002 04:43 PM

Forget about phpmyadmin, do what I asked you... please.

xware 12-21-2002 04:48 PM

Quote:

Originally posted by TECK

Make a file with the content:
Code:

<?php
error_reporting( E_ALL & ~E_NOTICE );
include_once( './global.php' );

cpheader( '<title>Run Query</title>' );

$runquery = "ALTER TABLE thread ADD FULLTEXT( title )";
$DB_site->reporterror = 1;
$DB_site->query( $runquery );

print_r( 'Query successful:<br>' );
print_r( '<font face="Courier New"> ' . $runquery . '</font><br><br>' );
print_r( 'Do not forget to delete this file.' );

cpfooter();
?>

Save it as [high]doquery.php[/high] and upload it onto your /admin folder.
Once uploaded, load it through your browser and let me know if you get any errors. If you do, post them here...


The used table type doesn't support FULLTEXT indexes
Same error...
Maybe I must check my thread table.


All times are GMT. The time now is 02:23 AM.

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.01202 seconds
  • Memory Usage 1,740KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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