vb.org Archive - not working: ALTER TABLE x ADD x IF NOT EXISTS

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

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

- - not working: ALTER TABLE x ADD x IF NOT EXISTS (https://vborg.vbsupport.ru/showthread.php?t=156800)

foxfirediego

09-01-2007 03:57 PM

not working: ALTER TABLE x ADD x IF NOT EXISTS

i'm trying to use a "IF NOT EXISTS" with a install code but i couldn't
could someone correct this for me?
thx

$db->query_write("ALTER TABLE accounts ADD group_id IF NOT EXISTS INT(11) NOT NULL COMMENT 'accounts group' AFTER password");

the error

Code:

Database error in vBulletin 3.6.8:



Invalid SQL:

ALTER TABLE accounts ADD group_id IF NOT EXISTS INT(11) NOT NULL COMMENT 'accounts group' AFTER password;



MySQL Error  : 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 'IF NOT EXISTS INT(11) NOT NULL COMMENT 'accounts group' AFTER password' at line 1

Error Number : 1064

Dismounted

09-02-2007 06:26 AM

You can't directly use the IF NOT EXISTS method on column additions.

Adrian Schneider

09-02-2007 07:05 AM

Use the db alter class, disable database errors before doing the query, or do another query to see if the column exists.

foxfirediego

09-02-2007 04:07 PM

thanks Dismounted and SirAdrian i'll give a try!

All times are GMT. The time now is 09:23 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01382 seconds Memory Usage 1,708KB 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 (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)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: