vb.org Archive - How would i do this>?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - How would i do this>? (https://vborg.vbsupport.ru/showthread.php?t=64147)

Liquid1ce

04-20-2004 04:50 PM

How would i do this>?

Code:

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

04-20-2004 09:36 PM

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

04-21-2004 04:15 AM

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

04-21-2004 06:50 AM

PHP Code:


		
			
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

04-21-2004 09:04 AM

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

04-21-2004 11:09 AM

that returns this error

Code:

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

04-21-2004 11:13 AM

bleh nm thnx for your help guys

All times are GMT. The time now is 08:23 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01259 seconds Memory Usage 1,724KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: