On 26/06/13 03:52 AM, Alexander Pyhalov wrote:
> On 06/26/2013 07:34, Gary Dale wrote:
>> INSERT INTO RestoreObject
>> (ObjectName,PluginName,RestoreObject,ObjectLength,ObjectFullLength,ObjectIndex,ObjectType,ObjectCompression,FileIndex,JobId)
>>
>> VALUES
>> ('job_metadata.xml','job','PABCAEEAQwBLAFUAUABfAEMATwBNAFAATwBOAEUATgBUAFMAIAB4AG0AbABuAHMAPQAiAHgALQBzAGMAaABlAG0AYQA6ACMAVgBzAHMAQwBvAG0AcABvAG4AZQBuAHQATQBlAHQAYQBkAGEAdABhACIAIAB2AGUAcgBzAGkAbwBuAD0AIgAxAC4AMgAiACAAYgBvAG8AdABhAGIAbABlAFMAeQBzAHQAZQBtAFMAdABhAHQAZQBCAGEAYwBrAHUAcAA9ACIAeQBlAHMAIgAgAHMAZQBsAGUAYwB0AEMAbwBtAHAAbwBuAGUAbgB0AHMAPQAiAHkAZQBzACIAIABiAGEAYwBrAHUAcABUAHkAcABlAD0AIgBpAG4AYwByAGUAbQBlAG4AdABhAGwAIgAgAHAAYQByAHQAaQBhAGwARgBpAGwAZQBTAHUAcABwAG8AcgB0AD0AIgBuAG8AIgAgAHMAbgBhAHAAcwBoAG8AdABTAGUAdABJAGQAPQAiADEAZQA4ADEAMQBiADEANwAtAGYANgBkADEALQA0ADYAMAA5AC0AYQA0AGYAYQAtAGQANwA3ADMANwBhADcANAAyAGUAYwA5ACIALwA+AAAA',462,462,1372216087,25,0,3250,1492)
>
> It is not a client issue. Upgrade DB script at least on Debian is
> incorrect: it creates table
> RestoreObject (
> RestoreObjectId INTEGER,
> ObjectName TEXT DEFAULT '',
> RestoreObject TEXT DEFAULT '',
> PluginName TEXT DEFAULT '',
> ObjectLength INTEGER DEFAULT 0,
> ObjectFullLength INTEGER DEFAULT 0,
> ObjectIndex INTEGER DEFAULT 0,
> ObjectType INTEGER DEFAULT 0,
> FileIndex INTEGER UNSIGNED DEFAULT 0,
> !!!!!! ObejctCompression INTEGER DEFAULT 0,
> JobId INTEGER UNSIGNED REFERENCES Job NOT NULL,
> PRIMARY KEY(RestoreObjectId)
> );
>
> Look at it: "ObejctCompression", not "ObjectCompression"!
>
Thanks Alexander. Since sqlite3 doesn't allow me to rename or drop
columns, I just added one with the correct name and the backup is
working again!
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
