Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: engrz on October 09, 2019, 09:46:40 PM

Title: How to upgrade database?
Post by: engrz on October 09, 2019, 09:46:40 PM
hello

im getting this error when installing any mod


Quote
Table 'engrz_xxx.org_pm_attachments' doesn't exist
File: /home/engrz/public_html/engrz.org/Sources/Subs-MediaAttachments.php
Line: 131

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.15, while your database is at version 2.0.10. The above error might possibly go away if you execute the latest version of upgrade.php.
Title: Re: How to upgrade database?
Post by: Sir Osis of Liver on October 09, 2019, 10:10:24 PM
There were no database changes from 2.0.10 -> 2.0.15, you can ignore that message.  The error is coming from a mod.  _pm_attachments is not a core table, Subs-MediaAttachments.php is not a core file.
Title: Re: How to upgrade database?
Post by: Kindred on October 09, 2019, 10:14:06 PM
looks like the pm attachments mod was either partially installed or partially uninstalled
Title: Re: How to upgrade database?
Post by: engrz on October 09, 2019, 10:36:15 PM
looks like the pm attachments mod was either partially installed or partially uninstalled

Thank you for the quick response.

first of all i fully uninstalled it few days ago but today installed again so i got this message.
Title: Re: How to upgrade database?
Post by: Sir Osis of Liver on October 09, 2019, 10:44:36 PM
Did package manager display any errors when you reinstalled?
Title: Re: How to upgrade database?
Post by: engrz on October 10, 2019, 03:19:36 AM
Did package manager display any errors when you reinstalled?


no any error, just installed fine.
Title: Re: How to upgrade database?
Post by: Kindred on October 10, 2019, 03:20:20 AM
Well, since it's missing the table,  it clearly didn't.   
Title: Re: How to upgrade database?
Post by: Illori on October 10, 2019, 05:14:50 AM
since this has to do with a mod, you should post in the mods support topic for further support.
Title: Re: How to upgrade database?
Post by: Sir Osis of Liver on October 10, 2019, 05:34:48 PM
Well, since it's missing the table,  it clearly didn't.   

^ The installer creates the table.  Have you checked your database to see if the table exists?
Title: Re: How to upgrade database?
Post by: engrz on October 10, 2019, 10:34:06 PM
Well, since it's missing the table,  it clearly didn't.   

^ The installer creates the table.  Have you checked your database to see if the table exists?

can you please guide me how to create table for this problem?
Title: Re: How to upgrade database?
Post by: Sir Osis of Liver on October 11, 2019, 01:02:56 AM
If the table doesn't exist, the mod installation failed.  Creating the table manually will probably not fix it.  You should ask for assistance in the mod support topic.
Title: Re: How to upgrade database?
Post by: engrz on October 12, 2019, 02:16:46 AM
Mod Support is not answering
Title: Re: How to upgrade database?
Post by: Kindred on October 12, 2019, 05:42:44 AM
Then uninstall the mod
Title: Re: How to upgrade database?
Post by: Sir Osis of Liver on October 12, 2019, 11:27:24 PM
If you got a bad install, you may get a bad uninstall.  If it was the last mod installed, you can restore the package backup in /Packages/backups/, else you'll have to clean it up manually.
Title: Re: How to upgrade database?
Post by: engrz on October 13, 2019, 01:23:31 AM
Then uninstall the mod

uninstall the mod is not resolving the attachment issue. after uninstallation i get "HTTP ERROR 500" during attachment. increased php parameters like attachment file size, execution time and all which may cause it.


Quote
If you got a bad install, you may get a bad uninstall.  If it was the last mod installed,

It was successful in both the cases (Installation and Uninstallation). but after a successful install i got that message to upgrade your database.
Title: Re: How to upgrade database?
Post by: Sir Osis of Liver on October 13, 2019, 05:05:33 PM
Package manager will uninstall some mods without error, but there will still be remnant code in some files.  You have to go through all files touched by the mod and clean up the code manually.
Title: Re: How to upgrade database?
Post by: engrz on October 24, 2019, 10:33:29 AM
Package manager will uninstall some mods without error, but there will still be remnant code in some files.  You have to go through all files touched by the mod and clean up the code manually.

I have tried to manually uninstall and cleared all but still on same problem.
Title: Re: How to upgrade database?
Post by: Kindred on October 24, 2019, 10:36:36 AM
in that case, you have no successfully removed the mod code changes.

Your best option may be a clean set of files, and then reinstall the mods that you need.