Same error with different table name.
Output of dm.log:
Wed, 27 Mar 2013 23:02:11 GMT ~ info ~ Logfile created
~ (0.000000) SET sql_auto_is_null = 0
~ (0.000000) SET SESSION sql_mode =
'ANSI,NO_BACKSLASH_ESCAPES,NO_DIR_IN_CREATE,NO_ENGINE_SUBSTITUTION,NO_UNSIGNED_SUBTRACTION,TRADITIONAL'
~ (0.000000) SHOW TABLES LIKE 'Inv1'
~ (0.000000) SET sql_auto_is_null = 0
~ (0.000000) SET SESSION sql_mode =
'ANSI,NO_BACKSLASH_ESCAPES,NO_DIR_IN_CREATE,NO_ENGINE_SUBSTITUTION,NO_UNSIGNED_SUBTRACTION,TRADITIONAL'
~ (0.000000) SHOW VARIABLES LIKE 'character_set_connection'
~ (0.000000) SHOW VARIABLES LIKE 'collation_connection'
~ (0.000000) CREATE TABLE `Inv1` (`id` INT(10) UNSIGNED NOT NULL
AUTO_INCREMENT, `ComputerName` TEXT, `UserName` TEXT, `FQUserName` TEXT,
`Domain` TEXT, `Site` TEXT, `KioskVersion` TEXT, `KioskLastUpdated` TEXT,
`LastCheckedInForCommands` TEXT, `LastBootTime` TEXT, `LastUpdated` TEXT,
`Manufacturer` TEXT, `ProductName` TEXT, `BiosVendor` TEXT, `BiosVersion`
TEXT, `BiosReleaseDate` TEXT, `ChassisType` TEXT, `SerialNumber` TEXT,
`OperatingSystemInstallDate` TEXT, `OperatingSystem` TEXT,
`OperatingSystemBuild` TEXT, `OperatingSystemExtra` TEXT, `OSArchitecture`
TEXT, `VideoCard` TEXT, `Monitor` TEXT, `TotalDiskSpace` FLOAT,
`FreeDiskSpace` FLOAT, `FileSystem` TEXT, `CPUQuantity` INTEGER,
`CPUVirtualQuantity` INTEGER, `CPU` TEXT, `CPUSpeed` TEXT, `CPUMaxSpeed`
TEXT, `CPUArchitecture` TEXT, `Memory` FLOAT, `MemoryFree` FLOAT,
`IPAddress` TEXT, `SubnetMask` TEXT, `NetworkConnType` TEXT,
`DefaultIPGateway` TEXT, `MACAddress` TEXT, `SSID` TEXT, `DHCPServer` TEXT,
`DNSServer` TEXT, `WINSServer` TEXT, `RebootPending` TEXT,
`InternetExplorerVersion` TEXT, `TrendServer` TEXT, `TrendProgramVersion`
TEXT, `TrendBuildNumber` TEXT, `TrendPatternDate` TEXT,
`TrendPatternVersion` TEXT, `JavaVersions` TEXT, `JavaAutoUpdateEnabled`
TEXT, `site_id` TEXT, PRIMARY KEY(`id`)) ENGINE = InnoDB CHARACTER SET utf8
COLLATE utf8_general_ci
~ Table 'inv1' already exists (code: 1050, sql state: 42S01, query: CREATE
TABLE `Inv1` (`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `ComputerName`
TEXT, `UserName` TEXT, `FQUserName` TEXT, `Domain` TEXT, `Site` TEXT,
`KioskVersion` TEXT, `KioskLastUpdated` TEXT, `LastCheckedInForCommands`
TEXT, `LastBootTime` TEXT, `LastUpdated` TEXT, `Manufacturer` TEXT,
`ProductName` TEXT, `BiosVendor` TEXT, `BiosVersion` TEXT,
`BiosReleaseDate` TEXT, `ChassisType` TEXT, `SerialNumber` TEXT,
`OperatingSystemInstallDate` TEXT, `OperatingSystem` TEXT,
`OperatingSystemBuild` TEXT, `OperatingSystemExtra` TEXT, `OSArchitecture`
TEXT, `VideoCard` TEXT, `Monitor` TEXT, `TotalDiskSpace` FLOAT,
`FreeDiskSpace` FLOAT, `FileSystem` TEXT, `CPUQuantity` INTEGER,
`CPUVirtualQuantity` INTEGER, `CPU` TEXT, `CPUSpeed` TEXT, `CPUMaxSpeed`
TEXT, `CPUArchitecture` TEXT, `Memory` FLOAT, `MemoryFree` FLOAT,
`IPAddress` TEXT, `SubnetMask` TEXT, `NetworkConnType` TEXT,
`DefaultIPGateway` TEXT, `MACAddress` TEXT, `SSID` TEXT, `DHCPServer` TEXT,
`DNSServer` TEXT, `WINSServer` TEXT, `RebootPending` TEXT,
`InternetExplorerVersion` TEXT, `TrendServer` TEXT, `TrendProgramVersion`
TEXT, `TrendBuildNumber` TEXT, `TrendPatternDate` TEXT,
`TrendPatternVersion` TEXT, `JavaVersions` TEXT, `JavaAutoUpdateEnabled`
TEXT, `site_id` TEXT, PRIMARY KEY(`id`)) ENGINE = InnoDB CHARACTER SET utf8
COLLATE utf8_general_ci, uri:
mysql:root@localhostitinv?username=root&adapter=mysql&host=localhost&database=itinv&password=TEST)
The table does exist after the first time the app is ran:
mysql> show tables like 'Inv1';
+------------------------+
| Tables_in_itinv (Inv1) |
+------------------------+
| inv1 |
+------------------------+
1 row in set (0.00 sec)
On Tuesday, March 26, 2013 8:34:57 PM UTC-7, kristian wrote:
>
> frst turn on the logger then you see what SQL is going to DB
>
> DataMapper::Logger.new($stdout, :debug)
>
> does the same error pop up with a different storage name ?
>
--
You received this message because you are subscribed to the Google Groups
"DataMapper" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/datamapper?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
