database may require an upgrade?

[lather]

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

[shawnb61]

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.

[Sir Osis of Liver]

Which php version are you running?

[lather]

Should I run fix_packages in the packages folder?

PHP Version 5.6.31

[Sir Osis of Liver]

Should install in php 5.6.  You run fix_packages in forum root, same as repair_settings.

[lather]

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?

[Sir Osis of Liver]

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.

[lather]

fix_pacakges crashed the forum again

[Sir Osis of Liver]

Did you remove hooks again?

[lather]

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)

[Sir Osis of Liver]

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?

[lather]

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.