i have to upgrade forum i just want to when i m 1.1.6 mod installing is upgrading but he is asking to convert ur database 1.1.5 to 1.1.6 and i dont know how to convert my data base 1.1.5 to 1.1.6 plz help me out.
can you post the correct message which it asks you to do ?
There are no database changes between smf 1.1.5 and smf 1.1.6
what abt 1.14 to 1.1.6 we just had a crash because the data base wasn't updated
What version of SMF are you currently using now? If it's already on 1.1.6, just update the smfVersion value in your database so the mods will detect it properly:
Go into phpMyAdmin (http://www.simplemachines.org/community/index.php?topic=21919.0) and click on your database. Then click on the SQL tab and copy paste the following code and run it:
UPDATE `smf_settings` SET `value`='1.1.6' WHERE `variable`='smfVersion' LIMIT 1;
Change smf_ prefix if you don't use the same one.
Kevin I am just trying to help with this as the site has been down all day. I have never gotten into the data base but here are the details the server is godaddy the was updated to 1.1.6 either last night or this am around 8:30 am the site went down and the error message is
QuoteTable 'ms' is marked as crashed and last (automatic?) repair failed
File: /home/dairygoa/public_html/Sources/Display.php
Line: 160
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.6, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.
have to say that the person who built the data base is a teenager and has been working on this now since abt 5pm and it is now 9:28pm so don't think she knows what to do either. I am a mod on the forum
Thanks for any help.
Do you have a backup of the database already?
Have you tried repairing all the tables in the database to see if it helps? Go into phpMyAdmin (http://www.simplemachines.org/community/index.php?topic=21919.0) and click on your database. Then scroll down and click on the select all button to select all the checkboxes. Under the drop down menu, choose Repair tables.
In the meantime, you can also run the SQL statement I provided earlier to update the version value in the database.
Thanks will give it a try
Quote from: greyknight17 on October 18, 2008, 10:11:54 PM
What version of SMF are you currently using now? If it's already on 1.1.6, just update the smfVersion value in your database so the mods will detect it properly:
Go into phpMyAdmin (http://www.simplemachines.org/community/index.php?topic=21919.0) and click on your database. Then click on the SQL tab and copy paste the following code and run it:
UPDATE `smf_settings` SET `value`='1.1.6' WHERE `variable`='smfVersion' LIMIT 1;
Change smf_ prefix if you don't use the same one.
Just for future reference, that setting has nothing to do with mods. That just indicates the version of SMF when your database was last updated.
OK
Greynight and Oldiesmann well she did all that the site came up for a min then she was doing something else to the data base I guess and it crashed again with the following error this was at 10:30 pm or so last night and still is the same today. Anything else I can tell her to do?
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.
I have a back up gz file on my computer will that help with anything I took it off our website last month.
dairygoa_smf1-data_2008-08-14.sql
and if so can you give me simple for dummies how to ? :-[
I don't know that the other gal has a backup.
Thanks guys we got it fixed!!! :)