Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: lather on October 09, 2017, 09:32:37 AM

Title: database may require an upgrade?
Post by: lather on October 09, 2017, 09:32:37 AM
I followed the instructions at http://wiki.simplemachines.org/smf/How_to_upload_a_fresh_set_of_files including
"Extract the archive to the forum's directory, making sure that you delete upgrade.php"

This got my forum back up but without any mods. Now when trying to re-install the Downlods System mod I get this error message:

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'TYPE=MyISAM' at line 25
File: /home/ridemsta1/public_html/mstaforums/Packages/temp/downloadsinstall2.php Line: 56

Note: It appears that your database may require an upgrade. Your forum's files are currently at
version SMF 2.0.14, while your database is at version 2.0.7. The above error might possibly go away
if you execute the latest version of upgrade.php."

I am hesitant to run upgrade.php since "upload fresh files" instructions say to delete it. The downlods mods was working on the old forum and the database on the current one is a recent backup from a few days ago.

Any ideas? Thanks
Title: Re: database may require an upgrade?
Post by: shawnb61 on October 09, 2017, 10:23:45 AM
You can safely ignore that "you may require an upgrade" message.    Don't know why it says that when it encounters issues, but it is a little overeager to throw that out there.

First thing I'd try is running the fix_packages.php utility, then try installing the mods again.
Title: Re: database may require an upgrade?
Post by: Sir Osis of Liver on October 09, 2017, 01:05:06 PM
Which php version are you running?
Title: Re: database may require an upgrade?
Post by: lather on October 09, 2017, 01:16:55 PM
Should I run fix_packages in the packages folder?

PHP Version 5.6.31
Title: Re: database may require an upgrade?
Post by: Sir Osis of Liver on October 09, 2017, 01:22:37 PM
Should install in php 5.6.  You run fix_packages in forum root, same as repair_settings.
Title: Re: database may require an upgrade?
Post by: lather on October 09, 2017, 01:26:55 PM
Quote from: Sir Osis of Liver on October 09, 2017, 01:22:37 PM
Should install in php 5.6.  You run fix_packages in forum root, same as repair_settings.

5.6 is an older version? How do I install it?
Title: Re: database may require an upgrade?
Post by: Sir Osis of Liver on October 09, 2017, 01:30:05 PM
Sorry, I meant the mod should install without error in php 5.6.x.  Some of the mods will have problems in php 7.0/7.1.  Don't believe fix_packages will correct your problem, but give it a try.  If it's no go, try posting in the mod topic.
Title: Re: database may require an upgrade?
Post by: lather on October 09, 2017, 01:32:19 PM
fix_pacakges crashed the forum again :-\
Title: Re: database may require an upgrade?
Post by: Sir Osis of Liver on October 09, 2017, 01:35:25 PM
Did you remove hooks again?
Title: Re: database may require an upgrade?
Post by: lather on October 09, 2017, 01:45:37 PM
Quote from: Sir Osis of Liver on October 09, 2017, 01:35:25 PM
Did you remove hooks again?
Yes, I thought I was removing hooks left over from uninstalled mods.  I uploaded fresh files again. Now I am having problems fith attachment and packages directory or files not being writable.

Now when I try to install a mod I get

You cannot download or install new packages because the Packages directory or one of the files in it are not writable!

Also a user tried to upload an avatar and he got a message that the attachment folder is not writable

In the permissions section of package manager it says the packages folder IS Writable  (chmod: 0755)
Title: Re: database may require an upgrade?
Post by: Sir Osis of Liver on October 09, 2017, 10:26:18 PM
Everything I can see as guest is working normally on your forum.  Did you have this problem first time you uploaded clean files?  Can you disable mod_security in cpanel, or ask GoDaddy support to do it?
Title: Re: database may require an upgrade?
Post by: lather on October 10, 2017, 10:55:19 AM
Thanks for looking. Everything seems to be working now. The problem begain the first time I uploaded clean files and begain re-installing mods. The first two I tried installed with no problem. When I tried to install the downloads system mod I got the error. Last night I did get on cPanel and played with permissions, setting everything to 755 although most were already 755.

At any rate this morning I am able to install mods without a problem.

Thanks again.