On 8/6/07, Denis Arifin <[EMAIL PROTECTED]> wrote: > > guys... > > ada yang pernah coba upload database mambo ke dalam ftp lom? soalnya > saya error pada waktu upload database yaitu di mos_components.. > > tolong solusinya ya.. > > thx > > FYI : > berikut adalah errornya.. > > CREATE TABLE mos_components( > id int( 11 ) NOT NULL AUTO_INCREMENT , > name varchar( 50 ) NOT NULL default '', > link varchar( 255 ) NOT NULL default '', > menuid int( 11 ) unsigned NOT NULL default '0', > parent int( 11 ) unsigned NOT NULL default '0', > admin_menu_link varchar( 255 ) NOT NULL default '', > admin_menu_alt varchar( 255 ) NOT NULL default '', > OPTION varchar( 50 ) NOT NULL default '', > ordering int( 11 ) NOT NULL default '0', > admin_menu_img varchar( 255 ) NOT NULL default '', > iscore tinyint( 4 ) NOT NULL default '0', > params text NOT NULL , > PRIMARY KEY ( id ) > ) TYPE = MYISAM > > *MySQL said: *Documentation > <http://dev.mysql.com/doc/mysql/en/error-messages-server.html> > > | #1064 - 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 'option varchar(50) NOT NULL default '', > ordering int(11) NOT NULL default '0'' at line 9 | >
wah kata OPTION adalah 'kata terlarang' untuk di jadikan nama field...sebab sudah dipakai untuk sistem si MySQL coba ganti nama fieldnya jadi: opsi varchar(50) NOT NULL default -- visit: www.darinol.net Windows 2003 Server for Newbie Exchange Server 2003 for Newbie McAfee ePO for Newbie Kaspersky Corporate Suite for Newbie Symantec Backup Exec (was Veritas) for Newbie -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## ## Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
