FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Search engine broken / Upgrade to 2.7.2 failed
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
icon8.gif  Search engine broken / Upgrade to 2.7.2 failed [message #27601] Wed, 14 September 2005 13:16 Go to next message
Stijn is currently offline  Stijn   Belgium
Messages: 11
Registered: September 2004
Location: Czech Republic
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hi all!

Bit unhappy tonight. Since a while our search engine is broken, but my lack of SQL-knowledge did even worsten the situation. Today I wanted to try to solve the problem with an upgrade to 2.7.2.. The upgrade failed and now I'm stuck.

This is the msg I get.. So, my question is, how can I fix my search engine as soon as possible in order that I can start the upgrade...

Checking if SQL permissions to perform the upgrade are avaliable
Disable the forum
Forum is now disabled
Beginning the file upgrade process
Begining to decompress the archive
Finished decompressing the archive
File Upgrade Complete
Any changed files were backed up to: "/home/httpd/vhosts/czechslovakforum.be/httpdocs/1/errors/.backup/"

Beginning SQL Upgrades
MySQL Error: #1016 (Can't open file: 'fud26_search_cache.MYD'. (errno: 144)): show fields from fud26_search_cache

Thanks to all!

(Sorry I'm a dummy-starter Sad )

[Updated on: Wed, 14 September 2005 13:17]

Report message to a moderator

Re: Search engine broken / Upgrade to 2.7.2 failed [message #27602 is a reply to message #27601] Wed, 14 September 2005 14:45 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
This is a mysql error, you can probably fix it by running:

REPAIR TABLE fud26_search_cache;


FUDforum Core Developer
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27604 is a reply to message #27601] Wed, 14 September 2005 15:04 Go to previous messageGo to next message
Stijn is currently offline  Stijn   Belgium
Messages: 11
Registered: September 2004
Location: Czech Republic
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Thanks. But how can I run this command?
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27608 is a reply to message #27604] Wed, 14 September 2005 18:05 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
This is a MySQL query you run via your Mysql interface tool.

FUDforum Core Developer
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27626 is a reply to message #27601] Sat, 17 September 2005 11:28 Go to previous messageGo to next message
Stijn is currently offline  Stijn   Czech Republic
Messages: 11
Registered: September 2004
Location: Czech Republic
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Thanks, repairing went okay, but now appears another problem:

Fatal error: Cannot redeclare fud_sql_error_handler() (previously declared in /home/httpd/vhosts/czechslovakforum.be/httpdocs/1/index.php:17) in /home/httpd/vhosts/czechslovakforum.be/httpdocs/1/include/core.inc on line 141

So, what now Smile Thanks for your support!

S.
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27662 is a reply to message #27626] Mon, 19 September 2005 11:05 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Can you access the admin control panel?

FUDforum Core Developer
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27702 is a reply to message #27601] Wed, 21 September 2005 10:15 Go to previous messageGo to next message
Stijn is currently offline  Stijn   Czech Republic
Messages: 11
Registered: September 2004
Location: Czech Republic
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
No, same error when I want to login to the adm. panel...

Fatal error: Cannot redeclare fud_sql_error_handler() (previously declared in /home/httpd/vhosts/czechslovakforum.be/httpdocs/1/include/core.inc:141) in /home/httpd/vhosts/czechslovakforum.be/httpdocs/1/include/theme/default/db. inc on line 14
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27703 is a reply to message #27702] Wed, 21 September 2005 10:31 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Can you re-run the upgrade script please?

FUDforum Core Developer
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27706 is a reply to message #27703] Thu, 22 September 2005 05:36 Go to previous messageGo to next message
Stijn is currently offline  Stijn   Czech Republic
Messages: 11
Registered: September 2004
Location: Czech Republic
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Can't... Because I had to change my pssword at my localhost, so the upgradescript blocks... And I can't change core.inc because it's in an APACHE directory...
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27708 is a reply to message #27706] Thu, 22 September 2005 09:38 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Make a tiny script that would chmod GLOBALS.php inside the include/ dir 666 so you can edit it.

FUDforum Core Developer
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27745 is a reply to message #27601] Fri, 23 September 2005 21:37 Go to previous messageGo to next message
Stijn is currently offline  Stijn   Czech Republic
Messages: 11
Registered: September 2004
Location: Czech Republic
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Okay, the forum is running now, but all the messages are gone, so what now...
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27748 is a reply to message #27745] Sat, 24 September 2005 12:10 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Run the consistency checker in the admin control panel.

FUDforum Core Developer
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27758 is a reply to message #27601] Sun, 25 September 2005 04:04 Go to previous messageGo to next message
Stijn is currently offline  Stijn   Belgium
Messages: 11
Registered: September 2004
Location: Czech Republic
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Done, but unfortunately no result:

This is the problem:

Warning: fopen(/home/httpd/vhosts/czechslovakforum.be/httpdocs/1/messages/msg_1): failed to open stream: Onbekend bestand of map in /home/httpd/vhosts/czechslovakforum.be/httpdocs/1/theme/default/msg.php on line 528

Warning: fseek(): supplied argument is not a valid stream resource in /home/httpd/vhosts/czechslovakforum.be/httpdocs/1/theme/default/msg.php on line 541

So Smile
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27760 is a reply to message #27758] Sun, 25 September 2005 09:33 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Does the msg_1 file exist, if so does the webserver have permission to open it?

FUDforum Core Developer
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27763 is a reply to message #27601] Sun, 25 September 2005 10:15 Go to previous messageGo to next message
Stijn is currently offline  Stijn   Belgium
Messages: 11
Registered: September 2004
Location: Czech Republic
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hmmm, indeed the old msg-files seemed to be deleted, although I didn't delete them... So, how can they be gone or are they moved?
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27764 is a reply to message #27763] Sun, 25 September 2005 10:24 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Did you run message compactor?

FUDforum Core Developer
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27766 is a reply to message #27601] Sun, 25 September 2005 11:11 Go to previous messageGo to next message
Stijn is currently offline  Stijn   Belgium
Messages: 11
Registered: September 2004
Location: Czech Republic
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Yes, but in the past this function seemed never to delete messagecontent... But as I saw in another topic, this messagedata will be probably lost? Sad

[Updated on: Sun, 25 September 2005 11:42]

Report message to a moderator

Re: Search engine broken / Upgrade to 2.7.2 failed [message #27777 is a reply to message #27766] Mon, 26 September 2005 09:40 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
That's why I asked if you've ran it... it could've been a possible explanation for the file being gone. No other part of the forum tries to remove that file, ever.

FUDforum Core Developer
Re: Search engine broken / Upgrade to 2.7.2 failed [message #27807 is a reply to message #27601] Tue, 27 September 2005 01:45 Go to previous message
Stijn is currently offline  Stijn   Belgium
Messages: 11
Registered: September 2004
Location: Czech Republic
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Okay, than I know enough Sad
Thanks for your patience and your help...
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Failure on new install V2.7.3RC1
Next Topic: Exporting User Data
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Oct 19 03:27:01 EDT 2017

Total time taken to generate the page: 0.00913 seconds