1.1.2 Update

[James]

John has just put the finishing touches to the final relase version of the 1.1.2 upgrade and full version scripts, that are now available to download in the member area. For those forum-masters who have already attempted the beta upgrade with limited success, please upload the latest upgrade pack from the member area and follow the instuctions. If you continue to have problems with your forums, please post a message in the installation forum.

We hope you enjoy all the new features of version 1.1.2 :)

All the best,

James

[Brian]

Still have problem running upgrade.php

-Brian

[Freddie Bingham]

Well I just tried the latest 1.1.2 upgrade. I got further this time but I got more errors.

.
.
.
Updating welcometext

Updating yahoo

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

-
Then I was emailed this:
Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE forum ADD INDEX idxhome(active,displayorder,categoryid)
mysql error: Access denied for user: 'hedge@europa.your-site.com' to database 'hedge'

Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE user ADD INDEX idxhome(usergroupid,username)
mysql error: Access denied for user: 'hedge@europa.your-site.com' to database 'hedge'

Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE thread ADD INDEX idxme(forumid,lastpost,visible)
mysql error: Access denied for user: 'hedge@europa.your-site.com' to database 'hedge'

Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE thread ADD INDEX idxforumdisplay(lastpost,forumid,visible)
mysql error: Access denied for user: 'hedge@europa.your-site.com' to database 'hedge'

Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE forumpermission ADD INDEX idxhome(usergroupid,canadminedit,forumid)
mysql error: Access denied for user: 'hedge@europa.your-site.com' to database 'hedge'

Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE announcement
CHANGE startdate startdate INT UNSIGNED NOT NULL,
CHANGE enddate enddate INT UNSIGNED NOT NULL
mysql error: Access denied for user: 'hedge@europa.your-site.com' to database 'hedge'

Are these things I don't have access to do or is there something else actually wrong? I put my 1.1.1 files back and it seems to be working but I am going to corrupt something?

[Freddie Bingham]

I assume I don't have "ALTER" privelages according to the upgrade instructions. Why the hell would they not give me access to modify my own tables. Have I screwed anything up by trying to run the upgrade script while not having the appropiate permissions to do what is needed?

[werehere]

I assume I don't have "ALTER" privelages according to the upgrade instructions. Why the hell would they not give me access to modify my own tables.

Many virtual hosting accounts do not, unless you are on a dedicated server that has the MySQL installed on it, then almost certainly you should have permission.

[Freddie Bingham]

Yes there is a server dedicated just for MySQL. I have sent in my request so lets see what the response is. If NO then I change hosts.

[werehere]

Yes I agree that it would be in order to change hosts :)

[Freddie Bingham]

They (your-site.com) have been nothing but helpful and quick with all my requests so I am hoping they will be likewise with my Alter permission. Perhaps they just over-looked settng the bit. Any reason why they would not typically allow me to Alter my own database. I can add tables but I can't change a table? Makes no sense to me.

[Edited by rangersfan on 06-01-2000 at 10:13 PM]

[werehere]

I know they do that on shared MySQL servers on *some* accounts, but typically if you can create the databases and tables, then you should be able to alter them. Yeah it makes no sense.