Help! I don't know what to do..

[brandy1j]

SMF Version: SMF 1.0.7
I have been doing ok on my own so far but after I downloaded some mods and tried to go back to my home page it went haywire.

This is what it says when I try to read a post..

Can't find FULLTEXT index matching the column list
File: /home/secti4/public_html/forum2/Sources/Display.php
Line: 150

Note: It appears that your database may require an upgrade. Your forum files are currently at version SMF 1.0.7, whereas your database is at version SMF 1.0.2. It is recommended that you execute the latest version of upgrade.php.

This is what it says when someone else tries to read a topic..

Please try again. If you come back to this error screen, report the error to an administrator.

[brandy1j]

I just need to know how do I execute latest version of upgrade.php? Can anyone help? This is the forum.

[sawz]

I just need to know how do I execute latest version of upgrade.php? Can anyone help? This is the forum.

i think you just call it up in a browser.

[brandy1j]

How do I do That? 

[青山 素子]

First, make a database backup. You'll probably need phpMyAdmin to do this (your host should have it set up for you). If you already have working mods, or a custom theme, also backup the files themselves.

General rule: Make a db and file backup before any major change to your forum (including installation/removal of mods).

Now, get the 1.0.7 upgrade package. Upload it over the existing files there (this will remove all changes mods added to your forum on the files).

Then, call up your forum page, but instead of index.php, change it to upgrade.php. Now, just follow the instructions to hopefully resolve the issue.

If it does break, you did make that database backup, right?

[brandy1j]

Trying it Now... Thanks

[brandy1j]

Hey, I did the backup, upgrade.php and now its saying:

Can't find FULLTEXT index matching the column list
File: /home/secti4/public_html/forum2/Sources/Display.php
Line: 150

How do I find Line 150 and what is the Full Text they're talking about?
Thanks

[青山 素子]

My lines 150 - 157 (from 1.0.7):

Koodi [Valitse] Laajenna


// Find the earliest unread message in the topic. (the use of topics here is just for both tables.)
$request = db_query("
SELECT IFNULL(lt.logTime, IFNULL(lmr.logTime, 0)) AS logTime
FROM {$db_prefix}topics AS t
LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC = $topic AND lt.ID_MEMBER = $ID_MEMBER)
LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD = $board AND lmr.ID_MEMBER = $ID_MEMBER)
WHERE t.ID_TOPIC = $topic
LIMIT 1", __FILE__, __LINE__);


You can find line 150 by opening the Display.php file in an editor that gives you line numbering (I use ConTEXT).

I still think perhaps the file edited by the mod is still broken. Compare your lines with the ones above.

A fulltext index is a special database thing that speeds up searching for stuff in a database by keeping track of what is placed where. (Kinda like an index in a reference book).

[jerm]

All you actually have to do is upload upgrade.php file and run that.
However, this might be an issue with the mods you have installed at the moment.
Which ones do you have installed?