Advertisement:

Author Topic: trying to upgrade my test site to the neweat beta  (Read 3055 times)

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
trying to upgrade my test site to the neweat beta
« on: November 07, 2015, 06:02:50 PM »
all i get is this error

i have fully checked all permissions and theres nothing wrong with them

Updating Your SMF Install!
The MySQL user you have set in Settings.php does not have proper privileges.

Please ask your host to give this user the ALTER, CREATE, and DROP privileges.

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 50,968
Re: trying to upgrade my test site to the neweat beta
« Reply #1 on: November 07, 2015, 06:07:56 PM »
same reply you already got still applies.

  • It sounds like your database user doesn't have the right permissions. You should contact your hosting company for assistance.

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: trying to upgrade my test site to the neweat beta
« Reply #2 on: November 07, 2015, 06:09:39 PM »
same reply you already got still applies.

  • It sounds like your database user doesn't have the right permissions. You should contact your hosting company for assistance.

i have checked all permissions and the user has all the permissions to the database

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,317
  • Gender: Male
    • Kindred-999 on GitHub
Re: trying to upgrade my test site to the neweat beta
« Reply #3 on: November 07, 2015, 08:39:42 PM »
obviously, that is not actually the case -- otherwise you would not be seeing that error
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 SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: trying to upgrade my test site to the neweat beta
« Reply #4 on: November 08, 2015, 04:06:43 AM »
I can assure you that all the permissions are set

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,317
  • Gender: Male
    • Kindred-999 on GitHub
Re: trying to upgrade my test site to the neweat beta
« Reply #5 on: November 08, 2015, 08:12:52 AM »
then you had better check with your host -- since the error message clearly indicates that the database user you have told SMF to use does *NOT* have the access rights that it needs.
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 SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: trying to upgrade my test site to the neweat beta
« Reply #6 on: November 08, 2015, 09:27:04 AM »
i have already checked with my host, and the forum is functioning properly...

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: trying to upgrade my test site to the neweat beta
« Reply #7 on: November 08, 2015, 12:39:35 PM »
At this point there is no further point in debating whether or not the user has access or not. It seems clear it hasn't, although you are sure it has.
If you're comfortable with the idea, please PM me a login/password to your cPanel (or other control panel you might be using)

and the forum is functioning properly...
The upgrade is supposed to be ran on top of your "old" version, so you either have the "forum functioning properly" or the upgrade in place, until it's ran successfully and the "new" forum is functioning properly...
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: trying to upgrade my test site to the neweat beta
« Reply #8 on: November 08, 2015, 04:10:06 PM »
i have pm'd you the information.

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: trying to upgrade my test site to the neweat beta
« Reply #9 on: November 08, 2015, 04:10:39 PM »
i simply uploaded the large upgrade package as a zip and extracted it

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: trying to upgrade my test site to the neweat beta
« Reply #10 on: November 08, 2015, 05:36:28 PM »
OK so...

The user does have permissions to the database (so the message is wrong) but your files were a mess :P
You had mixed 2.0/2.1 files so I removed everything except Settings/Settings_bak.php and "attachments" and uploaded a new, clean upgrade package (which I built from GH so you have the last code available).

You should now be able to proceed with th upgrade ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair