Incorrect file format 'smf_sessions'

reddriver · May 06, 2018, 02:28:10 PM

done but the same , anyway when check administrator center and check update I got this
This package is already installed, and no upgrade was found!

You should uninstall the old version first to avoid problems, or ask the author to create an upgrade from your old version.

Please remember to always make regular backups of your sources and database before installing mods, especially beta versions.

Error in Package Installation

Aleksi "Lex" Kilpinen · May 06, 2018, 02:32:35 PM

In PhpMyadmin - Select all the tables in the database, and run "Check table". Please post back the results.

reddriver · May 06, 2018, 02:38:51 PM

Quote from: Aleksi "Lex" Kilpinen on May 06, 2018, 02:32:35 PM
In PhpMyadmin - Select all the tables in the database, and run "Check table". Please post back the results.

after I did all query, I did check like you asked and give all OK except http://prntscr.com/jehuxo

Aleksi "Lex" Kilpinen · May 06, 2018, 02:43:24 PM

Ok, select only the table smf_log_topics and try running repair table on it once more, and let us know the result.

reddriver · May 06, 2018, 02:52:43 PM

Quote from: Aleksi "Lex" Kilpinen on May 06, 2018, 02:43:24 PM
Ok, select only the table smf_log_topics and try running repair table on it once more, and let us know the result.

when try select it I get this error http://prntscr.com/jei0bi
btw I should run this query:
SELECT * FROM `smf_log_topics` WHERE 1
repair table;

Aleksi "Lex" Kilpinen · May 06, 2018, 02:56:06 PM

Contact your host, ask them to look in to that error. That is probably not something you will be able to fix yourself.

reddriver · May 06, 2018, 02:59:40 PM

Quote from: Aleksi "Lex" Kilpinen on May 06, 2018, 02:56:06 PM
Contact your host, ask them to look in to that error. That is probably not something you will be able to fix yourself.

ok and what about db error upgrade ?

Aleksi "Lex" Kilpinen · May 06, 2018, 03:00:46 PM

Quote from: reddriver on May 06, 2018, 02:59:40 PM
Quote from: Aleksi "Lex" Kilpinen on May 06, 2018, 02:56:06 PM
Contact your host, ask them to look in to that error. That is probably not something you will be able to fix yourself.
ok and what about db error upgrade ?

You can simply ignore the database version error.

reddriver · May 06, 2018, 03:07:55 PM

ok thanks for the help guys

I sent ticket to host , wait a replay
will be back with them answer

Shambles · May 06, 2018, 04:53:08 PM

I'll never understand why forum owners/controllers don't take regular DB backups

It's so important to not leave it upto their host.

vbgamer45 · May 06, 2018, 05:03:35 PM

Yeah. I might make a mod to auto do it...

Illori · May 06, 2018, 07:23:41 PM

do keep in mind that the backup in SMF is not reliable and has created partial backup's without any notice to the person running the backup.

Aleksi "Lex" Kilpinen · May 07, 2018, 12:30:57 AM

I have a the option on my server to get automated backups of everything - files, settings and databases - I have it running every couple of days, and try to remember to download the latest backups offsite at least weekly. It's pretty handy, as it offers everything in one package that can be extracted with 7zip to a be a mirror of the server folder structure. Many hosts offer something similar these days, for free even - so might be something to consider in the future.

reddriver · May 07, 2018, 01:58:33 AM

they fixed that table , now I can view boards but I can't see any threads or posts .
forum keep show that there are threads and posts but when open any board I can't see nothing

http://prntscr.com/jenrfw

http://prntscr.com/jenrs3

Aleksi "Lex" Kilpinen · May 07, 2018, 02:24:20 AM

If all the tables are now OK according to MySQL, then it is more than likely that you are facing a scenario where your only options are to revert to a backup or start fresh. But first, you may want to go through all the tables one at a time once more, run a check on them, and see if they actually hold data or not. Specifically smf_messages should have all the posts of your forum in it. If everything seems ok on that side, backup everything, and run all the routine maintanence options in SMF admin panel. That might help, or make things worse, hence the backup.

reddriver · May 07, 2018, 03:04:17 AM

Quote from: Aleksi "Lex" Kilpinen on May 07, 2018, 02:24:20 AM
If all the tables are now OK according to MySQL, then it is more than likely that you are facing a scenario where your only options are to revert to a backup or start fresh. But first, you may want to go through all the tables one at a time once more, run a check on them, and see if they actually hold data or not. Specifically smf_messages should have all the posts of your forum in it. If everything seems ok on that side, backup everything, and run all the routine maintanence options in SMF admin panel. That might help, or make things worse, hence the backup.

how I can check one by one tables ?
I selected all tables and run check and gave me all OK

Aleksi "Lex" Kilpinen · May 07, 2018, 03:14:21 AM

Well, that works too - but then check if you see the posts inside smf_messages. Or is the table really empty, so no posts to show.

reddriver · May 07, 2018, 03:17:51 AM

when I check it I see only this http://prntscr.com/jeohtq
only 2 posts which I made after forum go online
what's means this ?

Aleksi "Lex" Kilpinen · May 07, 2018, 04:27:56 AM

That would be a strong indication that you cannot recover from this without reverting to a backup.

reddriver · May 07, 2018, 12:29:00 PM

Quote from: Aleksi "Lex" Kilpinen on May 07, 2018, 04:27:56 AM
That would be a strong indication that you cannot recover from this without reverting to a backup.

I dont have one , I have very old one
maybe I fixed wrong the table.
possible there is no way to fix it manually , or check where is wrong in it an replace it from old db ?

News:

Incorrect file format 'smf_sessions'