Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Aiheen aloitti: engrz - lokakuu 09, 2019, 09:46:40 IP

Otsikko: How to upgrade database?
Kirjoitti: engrz - lokakuu 09, 2019, 09:46:40 IP
hello

im getting this error when installing any mod


LainaaTable '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.
Otsikko: Re: How to upgrade database?
Kirjoitti: Sir Osis of Liver - lokakuu 09, 2019, 10:10:24 IP
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.
Otsikko: Re: How to upgrade database?
Kirjoitti: Kindred - lokakuu 09, 2019, 10:14:06 IP
looks like the pm attachments mod was either partially installed or partially uninstalled
Otsikko: Re: How to upgrade database?
Kirjoitti: engrz - lokakuu 09, 2019, 10:36:15 IP
Lainaus käyttäjältä: Kindred - lokakuu 09, 2019, 10:14:06 IP
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.
Otsikko: Re: How to upgrade database?
Kirjoitti: Sir Osis of Liver - lokakuu 09, 2019, 10:44:36 IP
Did package manager display any errors when you reinstalled?
Otsikko: Re: How to upgrade database?
Kirjoitti: engrz - lokakuu 10, 2019, 03:19:36 AP
Lainaus käyttäjältä: Sir Osis of Liver - lokakuu 09, 2019, 10:44:36 IP
Did package manager display any errors when you reinstalled?


no any error, just installed fine.
Otsikko: Re: How to upgrade database?
Kirjoitti: Kindred - lokakuu 10, 2019, 03:20:20 AP
Well, since it's missing the table,  it clearly didn't.   
Otsikko: Re: How to upgrade database?
Kirjoitti: Illori - lokakuu 10, 2019, 05:14:50 AP
since this has to do with a mod, you should post in the mods support topic for further support.
Otsikko: Re: How to upgrade database?
Kirjoitti: Sir Osis of Liver - lokakuu 10, 2019, 05:34:48 IP
Lainaus käyttäjältä: Kindred - lokakuu 10, 2019, 03:20:20 AP
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?
Otsikko: Re: How to upgrade database?
Kirjoitti: engrz - lokakuu 10, 2019, 10:34:06 IP
Lainaus käyttäjältä: Sir Osis of Liver - lokakuu 10, 2019, 05:34:48 IP
Lainaus käyttäjältä: Kindred - lokakuu 10, 2019, 03:20:20 AP
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?
Otsikko: Re: How to upgrade database?
Kirjoitti: Sir Osis of Liver - lokakuu 11, 2019, 01:02:56 AP
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.
Otsikko: Re: How to upgrade database?
Kirjoitti: engrz - lokakuu 12, 2019, 02:16:46 AP
Mod Support is not answering
Otsikko: Re: How to upgrade database?
Kirjoitti: Kindred - lokakuu 12, 2019, 05:42:44 AP
Then uninstall the mod
Otsikko: Re: How to upgrade database?
Kirjoitti: Sir Osis of Liver - lokakuu 12, 2019, 11:27:24 IP
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.
Otsikko: Re: How to upgrade database?
Kirjoitti: engrz - lokakuu 13, 2019, 01:23:31 AP
Lainaus käyttäjältä: Kindred - lokakuu 12, 2019, 05:42:44 AP
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.


LainaaIf 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.
Otsikko: Re: How to upgrade database?
Kirjoitti: Sir Osis of Liver - lokakuu 13, 2019, 05:05:33 IP
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.
Otsikko: Re: How to upgrade database?
Kirjoitti: engrz - lokakuu 24, 2019, 10:33:29 AP
Lainaus käyttäjältä: Sir Osis of Liver - lokakuu 13, 2019, 05:05:33 IP
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.
Otsikko: Re: How to upgrade database?
Kirjoitti: Kindred - lokakuu 24, 2019, 10:36:36 AP
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.