2 MySQL Errors
I can't figure out why I get an error message relating to fiels borderstates and bordernotes when I try to create a new table. One is VARCHAR, the other TEXT, and both are NULL, like almost every field on the table. Can someone tell me what I'm doing wrong? Thanks. SQL-query: CREATE TABLE `geog` ( `NID` INT( 3 ) NOT NULL AUTO_INCREMENT , `IDArea` CHAR( 3 ) NOT NULL , `Name` VARCHAR( 50 ) NOT NULL , `coordNS` VARCHAR( 7 ) DEFAULT NULL , `coordNS2` VARCHAR( 3 ) DEFAULT NULL , `coordEW` VARCHAR( 8 ) DEFAULT NULL , `coordEW2` VARCHAR( 3 ) DEFAULT NULL , `coordnotes` TEXT DEFAULT NULL , `location` VARCHAR( 255 ) DEFAULT NULL , `mapref` VARCHAR( 33 ) DEFAULT NULL , `areak` DECIMAL( 9, 2 ) DEFAULT NULL , `arealandk` DECIMAL( 9, 2 ) DEFAULT NULL , `areawaterk` DECIMAL( 9, 2 ) DEFAULT NULL , `areanotes` VARCHAR( 255 ) DEFAULT NULL , `aracomp` VARCHAR( 100 ) DEFAULT NULL , `borderk` INT( 6, 1 ) DEFAULT NULL , `borderstates` VARCHAR( 255 ) DEFAULT NULL , `bordernotes` TEXT DEFAULT NULL , `coastk` DECIMAL( 6.1 ) DEFAULT NULL , `coastnotes` TEXT DEFAULT NULL , `martersea` INT( 3 ) DEFAULT NULL , `marconzone` INT( 2 ) DEFAULT NULL , `marconshelf` VARCHAR( 255 ) DEFAULT NULL , `marexecon` INT( 3 ) DEFAULT NULL , `marexfish` INT( 3 ) DEFAULT NULL , `marnotes` VARCHAR( 255 ) DEFAULT NULL , `climate` VARCHAR( 255 ) DEFAULT NULL , `elevhighpt` VARCHAR( 255 ) DEFAULT NULL , `elevhighm` INT( 4 ) DEFAULT NULL , `elevlowpt` VARCHAR( 255 ) DEFAULT NULL , `elevlowm` INT( 4 ) DEFAULT NULL , `elevnotes` VARCHAR( 255 ) DEFAULT NULL , `terrain` TEXT DEFAULT NULL , `natres` TEXT DEFAULT NULL , `nathaz` TEXT DEFAULT NULL , `envagree` TEXT DEFAULT NULL , `envagree2` VARCHAR( 255 ) DEFAULT NULL , `envissues` TEXT DEFAULT NULL , `landuse` INT( 2, 2 ) DEFAULT NULL , `landusecrops` INT( 2, 2 ) DEFAULT NULL , `landuseother` INT( 2, 2 ) DEFAULT NULL , `landusenotes` VARCHAR( 100 ) DEFAULT NULL , `irrigate` INT( 6, 2 ) DEFAULT NULL , `irrigatenotes` VARCHAR( 255 ) DEFAULT NULL , `geognotes` TEXT DEFAULT NULL , PRIMARY KEY ( `NID` ) , INDEX ( `IDArea` ) ) MySQL said: Documentation #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 '1) DEFAULT NULL, `borderstates` VARCHAR(255) DEFAULT NULL, `bordernotes` TEXT DE' at line 1 __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 2 MySQL Errors
On Fri, Mar 25, 2005 at 07:27:47PM -0800, David Blomstrom wrote: I can't figure out why I get an error message relating to fiels borderstates and bordernotes when I try to create a new table. One is VARCHAR, the other TEXT, and both are NULL, like almost every field on the table. Can someone tell me what I'm doing wrong? Thanks. [snip] `borderk` INT( 6, 1 ) DEFAULT NULL , This is your problem. INT does not take two parameters. [ snip ] MySQL said: Documentation #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 '1) DEFAULT NULL, `borderstates` VARCHAR(255) DEFAULT NULL, `bordernotes` TEXT DE' at line 1 That's why the error message says near 1) Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: re[2]: MySQL Errors -
Richard, Tuesday, July 23, 2002, 3:56:36 PM, you wrote: RM What instances can cause a Table to crash? RM Is this caused by a bug in itself, a power failure, or something else? It may be a bug in MySQL, hardware errors, abnormal shutdown, running myisamchk, when mysqld is running ... Some of possible causes are described in the manual: http://www.mysql.com/doc/C/r/Crashing.html http://www.mysql.com/doc/C/o/Corrupted_MyISAM_tables.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re[2]: MySQL Errors -
What instances can cause a Table to crash? Is this caused by a bug in itself, a power failure, or something else? Richard William_dw, Tuesday, July 23, 2002, 10:34:16 AM, you wrote: WS I'm hoping someone can give me a pointer as to what's going wrong that's WS crashing our MySQL server, I've included a snippet of the log (for the last WS time it restarted and then the errors after that). WS I've been trying to read through the 'Debugging MySQL server' section, but WS there doesn't seem to be much to go on from the log, and the 'if you don't WS see anything something went terribly wrong' message with nothing but an WS 'aborting backtrace' message after it kinda has me worried over here. WS Any suggestions, pointers, or anything else would be really appreciated as WS my hair is turning gray by the second :). WS Thanks in advance, WS William. WS mysqld got signal 11; WS The manual section 'Debugging a MySQL server' tells you how to use a WS stack trace and/or the core file to produce a readable backtrace that may WS help in finding out why mysqld died WS Attemping backtrace. You can use the following information to find out WS where mysqld died. If you see no messages after this, something went WS terribly wrong WS Bogus stack limit or frame pointer, aborting backtrace WS Number of processes running now: 0 WS 020722 08:55:42 mysqld restarted WS /usr/sbin/mysqld: ready for connections WS 020722 8:55:45 read_key: Got error 127 when reading table WS './wahse/keywords' $ perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed Your table is crashed. You should repair it using myisamchk: http://www.mysql.com/doc/m/y/myisamchk_repair_options.html http://www.mysql.com/doc/R/e/Repair.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php