Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 05-03-2003, 04:09 AM
Crazy Pete Crazy Pete is offline
 
Join Date: Nov 2002
Posts: 155
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Switched hosts and now my forums are SCREWED!!

Ok I really need someone's help with this. I just moved my forums to a new host and restored the old database. Everything worked flawlessly on my old host, and all appeared well at first on this new one, but now when I try to view a thread, I get this horrendous error that I have NO idea how to fix!!

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT

thread.threadid,thread.lastposter,thread.title,thr ead.postusername,thread.replycount,thread.

lastpost,thread.postuserid,
thread.dateline,forum.title AS

ftitle,forum.forumid,forum.parentlist
FROM thread
LEFT JOIN forum ON (thread.forumid=forum.forumid)
WHERE thread.threadid<>949 AND thread.forumid IN( 5,3,4,6,7,14,8,12,13,15,11,10,18,21,9,19,16,17 )
AND MATCH(thread.title) AGAINST ('pittsburgh show cancelled')
AND thread.open<>10
AND thread.visible=1
ORDER BY dateline DESC
LIMIT 4
mysql error: Can't find FULLTEXT index matching the column list

mysql error number: 1191

Date: Saturday 03rd of May 2003 01:04:36 AM
Script: http://www.expectedmiracles.com/foru...p?threadid=949
Referer: http://www.expectedmiracles.com/foru....php?forumid=7
Repair Report: This type of error cannot be automatically repaired.


PLEASE!! Someone help! I have no idea what went wrong. Thaks for any advice!
Reply With Quote
  #2  
Old 05-03-2003, 03:32 PM
DarkDraco07's Avatar
DarkDraco07 DarkDraco07 is offline
 
Join Date: Apr 2002
Posts: 414
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

did you switch your domain over to your new host as well? some links on your forum might be trying to gain access to a page with the old domain.
Reply With Quote
  #3  
Old 05-03-2003, 04:17 PM
N!ck N!ck is offline
 
Join Date: Mar 2002
Location: Lake Havasu City, AZ
Posts: 886
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No, that's not the problem.

I suggest you contact your host and see what they have to say about it. Also, what is the MySQL version on the new server, and what was the version on the old server?
Reply With Quote
  #4  
Old 05-03-2003, 05:54 PM
Crazy Pete Crazy Pete is offline
 
Join Date: Nov 2002
Posts: 155
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well I fixed the problem. My old host was running MySQL 3.23, and now I'm running 4.012 on the new host. What fixed the problem was upgrading to vB 2.3.0. It kinda sucks because I have to rehack all my files again , but I figured I had intended on upgrading at some point, so now's a good a time as any I suppose.
Reply With Quote
  #5  
Old 05-03-2003, 05:58 PM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Upgrading to the latest version of vB never sucks, unless you enjoy being hacked.
Reply With Quote
  #6  
Old 05-03-2003, 11:32 PM
N!ck N!ck is offline
 
Join Date: Mar 2002
Location: Lake Havasu City, AZ
Posts: 886
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

2.3.0 was a security update?
Reply With Quote
  #7  
Old 05-03-2003, 11:38 PM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Most of the vB updates are. Also Jelsoft doesn't publicize every security hole fixed in an update.
Reply With Quote
  #8  
Old 05-04-2003, 05:40 AM
GaleForce GaleForce is offline
 
Join Date: Sep 2002
Location: New York
Posts: 201
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Yesterday at 07:58 PM filburt1 said this in Post #5
Upgrading to the latest version of vB never sucks, unless you enjoy being hacked.
Its too much of a hassle to upgrade a hacked board, even with that tutorial.
Reply With Quote
  #9  
Old 05-04-2003, 06:43 AM
Crazy Pete Crazy Pete is offline
 
Join Date: Nov 2002
Posts: 155
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well I finally did manage to update it all. Took me about 9 hours to readd all the things I had added before.

I also found out what the initial problem was, and it had to do with the vB3 Similar Threads hack that I installed. Apparently I had forgotten this step: ALTER TABLE `thread` ADD FULLTEXT(`title`);

I skipped it this time, thinking it was already there, and I had been checking threads out here and there to make sure things were good. Well, I got to this hack, made all the file changes, reloaded a thread and BAM! Got that same error. This time I went back to the beginning of it, ran that query and everything worked wonders.

So basically I could've saved myself 9 hours if I had done that originally, but hey...at least I'm updated now. Plus it happened while our DNS is still in the process of switching over so I guess it worked out.
Reply With Quote
  #10  
Old 05-04-2003, 01:58 PM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 02:40 AM GaleForce said this in Post #8
Its too much of a hassle to upgrade a hacked board, even with that tutorial.
Each to his own, but all I'm saying is that laziness may come back and bite you in the a** eventually.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:22 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05338 seconds
  • Memory Usage 2,248KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete