<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent changes to bugs</title><link href="https://sourceforge.net/p/cosi-nms/bugs/" rel="alternate"/><link href="https://sourceforge.net/p/cosi-nms/bugs/feed.atom" rel="self"/><id>https://sourceforge.net/p/cosi-nms/bugs/</id><updated>2004-08-25T21:26:00Z</updated><subtitle>Recent changes to bugs</subtitle><entry><title>Error in mySQL_Commands.txt</title><link href="https://sourceforge.net/p/cosi-nms/bugs/1/" rel="alternate"/><published>2004-08-25T21:26:00Z</published><updated>2004-08-25T21:26:00Z</updated><author><name>Anonymous</name><uri>https://sourceforge.net/u/userid-None/</uri></author><id>https://sourceforge.net85ee8dc84ed961fd098f502dee7ce20456165d81</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;From reading the forums, this is a known problem.  It&lt;br /&gt;
still has not been changed in the distribution however.&lt;br /&gt;
Dist contains the file mySQL_commands.txt which&lt;br /&gt;
contains the following invalid SQL:&lt;/p&gt;
&lt;p&gt;DROP TABLE IF EXISTS device_types;&lt;br /&gt;
CREATE TABLE device_types (&lt;br /&gt;
int int(11) NOT NULL default '0',&lt;br /&gt;
name VARCHAR(255) NOT NULL default '',&lt;br /&gt;
PRIMARY KEY (int),&lt;br /&gt;
UNIQUE KEY name (name)&lt;br /&gt;
) TYPE=MyISAM;&lt;/p&gt;
&lt;p&gt;INSERT INTO device_types (int, name) VALUES (0, 'unknown');&lt;br /&gt;
INSERT INTO device_types (int, name) VALUES (1, 'router');&lt;br /&gt;
INSERT INTO device_types (int, name) VALUES (2, 'switch');&lt;br /&gt;
INSERT INTO device_types (int, name) VALUES (3, 'ATM&lt;br /&gt;
switch');&lt;/p&gt;
&lt;p&gt;MySQL apparently doesn't like a column named 'int' so&lt;br /&gt;
changing it to 'id' fixes the issue.  Install would be&lt;br /&gt;
alot smoother however if these lines were changed.&lt;/p&gt;
&lt;p&gt;Ben Hanson&lt;br /&gt;
benhanson@borough.kenai.ak.us&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>