Author Topic: Updated Template list  (Read 4195 times)

Techstyle

  • Addicted
  • *
  • Posts: 674
    • View Profile
    • Techstyle UK Ltd.
Updated Template list
« on: May 09, 2013, 08:31:45 pm »
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

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 3675
  • Wastes Life On LinuxMCE Since 2007
    • View Profile
    • My Home
Re: Updated Template list
« Reply #1 on: May 10, 2013, 03:32:35 pm »
You did sqlCVS update all repos, didn't you

Techstyle

  • Addicted
  • *
  • Posts: 674
    • View Profile
    • Techstyle UK Ltd.
Re: Updated Template list
« Reply #2 on: May 10, 2013, 04:05:42 pm »
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

  • Guru
  • ****
  • Posts: 230
    • View Profile
    • Sean Walker
Re: Updated Template list
« Reply #3 on: May 11, 2013, 12:20:27 am »
Works for me!  ;D

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

  • LinuxMCE God
  • ****
  • Posts: 5549
  • DOES work for LinuxMCE.
    • View Profile
Re: Updated Template list
« Reply #4 on: May 12, 2013, 12:19:21 am »
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

  • Addicted
  • *
  • Posts: 674
    • View Profile
    • Techstyle UK Ltd.
Re: Updated Template list
« Reply #5 on: May 12, 2013, 01:14:12 am »
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