Hi Bob, I think the problem is the sw_last_bootup_time definition. I don;t think you can specify a display length for DATETIME data types.
Pete Haworth On Mar 11, 2011, at 9:33 PM, Bob Sneidar wrote: > Hi all. I am having a problem with this sql and I do not know why. I am using > mySQL. The error I am generating is: > > 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 > '(30), > `sw_service_pack_major_version` integer(3), > `sw_service_pack_minor_versi' at line 1 > > I cannot see what is wrong. I deleted every column beyond where the error > says I am having a problem and it works! Is there a hard limit to how big a > query can be? If not, then is there a limit to how big an ON-REV query can > be?? > > As a side note, I take the SQL to create a table from sqLite, massage it to > work in mySQL then execute it. Not sure if that gives you a vector on the > issue but the more information the better I always say. > > Bob > > > > CREATE TABLE `slylabs_Helpdesk`.`sw_devices` ( > `uniqueid` mediumint(3) unsigned zerofill NOT NULL auto_increment, > `deleted` boolean DEFAULT FALSE, > `updated` boolean DEFAULT FALSE, > `sw_id` INTEGER NOT NULL, > `sw_name` varchar(50) NOT NULL, > `sw_type` varchar(50), > `sw_description` varchar(80), > `sw_server_name` varchar(50), > `sw_domain` varchar(50), > `sw_uuid` varchar(50), > `sw_manufacturer` varchar(50), > `sw_model` varchar(50), > `sw_os_serial_number` varchar(70), > `sw_windows_product_id` varchar(50), > `sw_serial_number` varchar(75), > `sw_ip_address` varchar(15), > `sw_mac_address` varchar(50), > `sw_operating_system` varchar(64), > `sw_version` varchar(50), > `sw_windows_user` varchar(50), > `sw_primary_owner_name` varchar(50), > `sw_memory` integer, > `sw_management_oid` varchar(75), > `sw_up_time` varchar(50), > `sw_last_boot_up_time` datetime(30), > `sw_service_pack_major_version` integer(3), > `sw_service_pack_minor_version` integer(3), > `sw_number_of_licensed_users` integer(3), > `sw_number_of_processors` integer(3), > `sw_processor_type` varchar(50), > `sw_created_on` datetime, > `sw_updated_on` datetime, > `sw_kernel` varchar(255), > `sw_page_count` integer, > `sw_install_date` datetime, > `sw_device_type` varchar(255), > `sw_current_user` varchar(255), > `sw_bios_version` varchar(255), > `sw_location` varchar(255), > `sw_online_at` datetime, > `sw_offline_at` datetime, > `sw_asset_tag` varchar(255), > `sw_manually_added` boolean DEFAULT FALSE, > `sw_bios_date` date, > `sw_c_purchase_price` float, > `sw_c_purchase_date` date, > `sw_b_name` varchar(50), > `sw_b_location` varchar(255), > `sw_b_device_type` varchar(255), > `sw_b_asset_tag` varchar(255), > `sw_b_manufacturer` varchar(50), > `sw_b_model` varchar(50), > `sw_b_primary_owner_name` varchar(50), > `sw_b_serial_number` varchar(75), > `sw_warning_alert_count` integer DEFAULT 0, > `sw_error_alert_count` integer DEFAULT 0, > `sw_open_ticket_count` integer DEFAULT 0, > `sw_auto_tag` varchar(255), > `sw_dn` varchar(255), > `sw_c_passwd_update` varchar(255) DEFAULT `Yes`, > `sw_c_dept_device` varchar(255) DEFAULT `Not Assigned`, > `sw_user_tag` varchar(255), > `sw_exclude_tag` varchar(255), > `sw_last_scan_time` datetime, > `sw_site_name` varchar(255), > `sw_spice_version` integer, > `notes` blob NOT NULL, > `signature` char(2) NOT NULL, > PRIMARY KEY (`uniqueid`) > ) > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode