How would i do this>?

[Liquid1ce]

ALTER TABLE " . TABLE_PREFIX . "user CHANGE autosubscribe autosubscribe SMALLINT NOT NULL DEFAULT -1

I need to change this by phpmyadmin or via the admincp
but not sure what do do as i have error=mysql error: Unknown column 'autosubscribe' in 'field list'


:ermm:

[Xenon]

make sure the Hack is written for the vb version you use.
if it's not, you may want to report that bug to the author :)

[Liquid1ce]

its not part of a hack its out of upgrade6.php
but it gave errors when trying to run so i finished the upgrade i just need to run this through phpmyadmin

[Scrub]

ALTER TABLE user ADD autosubscribe SMALLINT(6) DEFAULT -1 NOT NULL


You can try that, but I say let's wait to see if Xenon or someone with better query knowledge than me to reply. :o. Or if you want to try it out now, back up your database before doing so.

[Xenon]

Are you sure you did run the correct upgrade files?
always start with upgrade.php.

i did not get that error when doing my upgrades, so i assume it has to do with a hack of you.

you can try Scrubs code, that should prevent the error at least :)

[Liquid1ce]

that returns this error
ror desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-1 NOT NULL' at line 1

i got the error on the upgrade and changed upgrade6.php?etc1 to 2

[Liquid1ce]

bleh nm thnx for your help guys