Re: [Bacula-users] backup of Windows 7 machine failing

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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users