PDA

View Full Version : Changing database field

jluerken
07-26-2005, 01:53 PM
Hi Author,

I tested to upgrade my forum from 3.0.7 to 3.5.

For sure I know that your hack currently does not support vb3.5 but here is one small hint.

Upgrading the board to 3.5 will not work with this hack installed cause 3.5 adds a new table field in the userban table called reason.

AWS is using this field also so when you have AWS installed you will get an error message during the upgrade process.

To be sure that users which have installed this hack run into problems I suggest to release version 3.4.16 which changes the fieldname from reason into aws_reason or something else.

Is this possible?
Marco van Herwaarden
07-26-2005, 09:21 PM
Sounds like a very good request to me.
Andreas
07-26-2005, 09:28 PM
Hmm, for compatibility reasons i'd keep the Fieldname - this way Ban Reasons would show up in vB 3.5.
Just point out that the User should rename the Field before upgrading to vB 3.5 and afterwards

UPDATE userban SET banreason=newfieldname
sv1cec
07-27-2005, 06:24 AM
Hi Author,

I tested to upgrade my forum from 3.0.7 to 3.5.

For sure I know that your hack currently does not support vb3.5 but here is one small hint.

Upgrading the board to 3.5 will not work with this hack installed cause 3.5 adds a new table field in the userban table called reason.

AWS is using this field also so when you have AWS installed you will get an error message during the upgrade process.

To be sure that users which have installed this hack run into problems I suggest to release version 3.4.16 which changes the fieldname from reason into aws_reason or something else.

Is this possible?

The way AWS installation script works, does not stop the installation process if a field exists. And I do not want to add another field for AWS reason, since this is the ban reason, the same ban reason used throughout vB. If someone is banned from AWS, the field is populated by AWS accordingly. If a user is banned from the normal vB process, the reason is there for the moderator to enter his comments. Why should it be renamed? AWS will use that field as it is.

Unless of course the field "reason" is used differently in vB 3.5. Haven't check that.