Updated Template list

[Techstyle]

I am trying to find a template that Whateverfits has submitted and cannot find it.  The template uses manufacturer: Radio Thermostats and the description is: 3M50

I do not have the manufacturer in the manufacturer list. Possy confirmed that the Manufacturer exists in his list

I made sure my core was upto date - apt-get Update and Upgrade then

I did a sqlCVS Diff, reverted everything and did and "sqlCVS Update".

My understanding is that the templates should be upto date - am I doing something wrong?

[Marie.O]

You did sqlCVS update all repos, didn't you

[Techstyle]

yes.

I mentioned this to TSCHAK last night and he said it might have something to do with some database changes that have been made recently

[WhateverFits]

Works for me! 

I do recall there being an error on submission due to my failure to update my instance before checking in and it caused a conflict. In case that helps.

[tschak909]

try doing an sqlCVS update via the command line:

Code: [Select]

/usr/pluto/bin/sqlCVS -H schema.linuxmce.org -R 3999 -U anonymous~anonymous -r dce update

-Thom

[Techstyle]

that threw an error:

Code: [Select]

Updating (update) row id 2382 last sync: 2381
01 05/11/13 18:09:38.622 Query failed (Duplicate entry '2231' for key 'PRIMARY'): UPDATE `DeviceTemplate` SET `CommandLine`=NULL, `Comments`=NULL, `ConfigureScript`=NULL, `Define`='', `Description`='Tuner - OTARadio', `DestinationDir`=NULL, `FK_CommMethod`=NULL, `FK_DeviceCategory`='103', `FK_Distro`=NULL, `FK_InfraredGroup`=NULL, `FK_Licensing`=NULL, `FK_Manufacturer`='185', `FK_OperatingSystem`=NULL, `FK_Package`=NULL, `FK_PnpLevel`=NULL, `FK_StabilityStatus`=NULL, `FK_Users_Maintainer`='1', `HelpURL`=NULL, `IRFrequency`=NULL, `ImplementsDCE`='0', `InheritsMacFromPC`='0', `InternalURLSuffix`=NULL, `IsEmbedded`='0', `IsIPBased`='0', `IsPlugAndPlay`='0', `IsPlugIn`='0', `ManufacturerURL`=NULL, `PK_DeviceTemplate`='2231', `WizardURL`=NULL, `psc_frozen`=NULL, `psc_restrict`=NULL, psc_batch=3855, psc_user=39176 WHERE psc_id=2382 (1) <0xb774f6d0>
05 05/11/13 18:09:38.622 Resetting mysql connection <0xb774f6d0>
01 05/11/13 18:09:38.627 Query failed (Duplicate entry '2231' for key 'PRIMARY'): UPDATE `DeviceTemplate` SET `CommandLine`=NULL, `Comments`=NULL, `ConfigureScript`=NULL, `Define`='', `Description`='Tuner - OTARadio', `DestinationDir`=NULL, `FK_CommMethod`=NULL, `FK_DeviceCategory`='103', `FK_Distro`=NULL, `FK_InfraredGroup`=NULL, `FK_Licensing`=NULL, `FK_Manufacturer`='185', `FK_OperatingSystem`=NULL, `FK_Package`=NULL, `FK_PnpLevel`=NULL, `FK_StabilityStatus`=NULL, `FK_Users_Maintainer`='1', `HelpURL`=NULL, `IRFrequency`=NULL, `ImplementsDCE`='0', `InheritsMacFromPC`='0', `InternalURLSuffix`=NULL, `IsEmbedded`='0', `IsIPBased`='0', `IsPlugAndPlay`='0', `IsPlugIn`='0', `ManufacturerURL`=NULL, `PK_DeviceTemplate`='2231', `WizardURL`=NULL, `psc_frozen`=NULL, `psc_restrict`=NULL, psc_batch=3855, psc_user=39176 WHERE psc_id=2382 (1) <0xb774f6d0>
05 05/11/13 18:09:38.627 Resetting mysql connection <0xb774f6d0>
01 05/11/13 18:09:38.628 Query failed (): UPDATE `DeviceTemplate` SET `CommandLine`=NULL, `Comments`=NULL, `ConfigureScript`=NULL, `Define`='', `Description`='Tuner - OTARadio', `DestinationDir`=NULL, `FK_CommMethod`=NULL, `FK_DeviceCategory`='103', `FK_Distro`=NULL, `FK_InfraredGroup`=NULL, `FK_Licensing`=NULL, `FK_Manufacturer`='185', `FK_OperatingSystem`=NULL, `FK_Package`=NULL, `FK_PnpLevel`=NULL, `FK_StabilityStatus`=NULL, `FK_Users_Maintainer`='1', `HelpURL`=NULL, `IRFrequency`=NULL, `ImplementsDCE`='0', `InheritsMacFromPC`='0', `InternalURLSuffix`=NULL, `IsEmbedded`='0', `IsIPBased`='0', `IsPlugAndPlay`='0', `IsPlugIn`='0', `ManufacturerURL`=NULL, `PK_DeviceTemplate`='2231', `WizardURL`=NULL, `psc_frozen`=NULL, `psc_restrict`=NULL, psc_batch=3855, psc_user=39176 WHERE psc_id=2382 retry: -1 <0xb774f6d0>
Failed to update row: UPDATE `DeviceTemplate` SET `CommandLine`=NULL, `Comments`=NULL, `ConfigureScript`=NULL, `Define`='', `Description`='Tuner - OTARadio', `DestinationDir`=NULL, `FK_CommMethod`=NULL, `FK_DeviceCategory`='103', `FK_Distro`=NULL, `FK_InfraredGroup`=NULL, `FK_Licensing`=NULL, `FK_Manufacturer`='185', `FK_OperatingSystem`=NULL, `FK_Package`=NULL, `FK_PnpLevel`=NULL, `FK_StabilityStatus`=NULL, `FK_Users_Maintainer`='1', `HelpURL`=NULL, `IRFrequency`=NULL, `ImplementsDCE`='0', `InheritsMacFromPC`='0', `InternalURLSuffix`=NULL, `IsEmbedded`='0', `IsIPBased`='0', `IsPlugAndPlay`='0', `IsPlugIn`='0', `ManufacturerURL`=NULL, `PK_DeviceTemplate`='2231', `WizardURL`=NULL, `psc_frozen`=NULL, `psc_restrict`=NULL, psc_batch=3855, psc_user=39176 WHERE psc_id=2382
Transaction 0xbfa75ebc is open.  Rolling back
System error: Rolling back an incomplete transaction
Doing a rollback
Update threw exception: Failed to insert row