Advertisement:

Author Topic: How to upgrade database?  (Read 615 times)

Offline engrz

  • Full Member
  • ***
  • Posts: 575
  • Gender: Male
  • Engineering and IT Discussion Forum
    • www.facebook.com/engrzpakistan on Facebook
    • @engrz on Twitter
    • Engineering Forum
How to upgrade database?
« 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.


Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,300
Re: How to upgrade database?
« Reply #1 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.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,502
  • Gender: Male
    • Kindred-999 on GitHub
Re: How to upgrade database?
« Reply #2 on: October 09, 2019, 10:14:06 PM »
looks like the pm attachments mod was either partially installed or partially uninstalled
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline engrz

  • Full Member
  • ***
  • Posts: 575
  • Gender: Male
  • Engineering and IT Discussion Forum
    • www.facebook.com/engrzpakistan on Facebook
    • @engrz on Twitter
    • Engineering Forum
Re: How to upgrade database?
« Reply #3 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.


Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,300
Re: How to upgrade database?
« Reply #4 on: October 09, 2019, 10:44:36 PM »
Did package manager display any errors when you reinstalled?

Offline engrz

  • Full Member
  • ***
  • Posts: 575
  • Gender: Male
  • Engineering and IT Discussion Forum
    • www.facebook.com/engrzpakistan on Facebook
    • @engrz on Twitter
    • Engineering Forum
Re: How to upgrade database?
« Reply #5 on: October 10, 2019, 03:19:36 AM »
Did package manager display any errors when you reinstalled?


no any error, just installed fine.


Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,502
  • Gender: Male
    • Kindred-999 on GitHub
Re: How to upgrade database?
« Reply #6 on: October 10, 2019, 03:20:20 AM »
Well, since it's missing the table,  it clearly didn't.   
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,283
Re: How to upgrade database?
« Reply #7 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.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,300
Re: How to upgrade database?
« Reply #8 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?

Offline engrz

  • Full Member
  • ***
  • Posts: 575
  • Gender: Male
  • Engineering and IT Discussion Forum
    • www.facebook.com/engrzpakistan on Facebook
    • @engrz on Twitter
    • Engineering Forum
Re: How to upgrade database?
« Reply #9 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?


Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,300
Re: How to upgrade database?
« Reply #10 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.

Offline engrz

  • Full Member
  • ***
  • Posts: 575
  • Gender: Male
  • Engineering and IT Discussion Forum
    • www.facebook.com/engrzpakistan on Facebook
    • @engrz on Twitter
    • Engineering Forum
Re: How to upgrade database?
« Reply #11 on: October 12, 2019, 02:16:46 AM »
Mod Support is not answering


Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,502
  • Gender: Male
    • Kindred-999 on GitHub
Re: How to upgrade database?
« Reply #12 on: October 12, 2019, 05:42:44 AM »
Then uninstall the mod
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,300
Re: How to upgrade database?
« Reply #13 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.

Offline engrz

  • Full Member
  • ***
  • Posts: 575
  • Gender: Male
  • Engineering and IT Discussion Forum
    • www.facebook.com/engrzpakistan on Facebook
    • @engrz on Twitter
    • Engineering Forum
Re: How to upgrade database?
« Reply #14 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.


Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,300
Re: How to upgrade database?
« Reply #15 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.