[Android Auto General] paolocorpo:
Dear [MENTION=9536392]Jen94[/MENTION],

I am trying to add others 2 apps

MIRROR_plus

and

CARSTREAM

Below the two modified codes

Unfortunately I receive back (relating to insert flags step) an error message that says:

ERROR: 10 values for 8 columns

Are you able to understand why ?

Thanks

Paolo

2. Insert flags

Code:

INSERT OR REPLACE INTO Flags (packageName, version, flagType, partitionId, user, name, stringVal, committed) VALUES ("com.google.android.gms.car#car", 234, 0, 0, "",

"app_white_list", "com.github.slashmax.aamirror","com.github.slashmax.aamirror_plus","com.google.android.kk",1);
INSERT OR REPLACE INTO Flags (packageName, version, flagType, partitionId, user, name, stringVal, committed) VALUES ("com.google.android.gms.car#car", 230, 0, 0, "",

"app_white_list", "com.github.slashmax.aamirror","com.github.slashmax.aamirror_plus","com.google.android.kk",1);
INSERT OR REPLACE INTO Flags (packageName, version, flagType, partitionId, user, name, stringVal, committed) VALUES ("com.google.android.gms.car", 234, 0, 0, "",

"app_white_list", "com.github.slashmax.aamirror","com.github.slashmax.aamirror_plus","com.google.android.kk",1);
INSERT OR REPLACE INTO Flags (packageName, version, flagType, partitionId, user, name, stringVal, committed) VALUES ("com.google.android.gms.car", 230, 0, 0, "",

"app_white_list", "com.github.slashmax.aamirror","com.github.slashmax.aamirror_plus","com.google.android.kk",1);
INSERT OR REPLACE INTO Flags (packageName, version, flagType, partitionId, user, name, stringVal, committed) VALUES ("com.google.android.gms.car#car_setup", 234, 0, 0,

"", "app_white_list", "com.github.slashmax.aamirror","com.github.slashmax.aamirror_plus","com.google.android.kk",1);
INSERT OR REPLACE INTO Flags (packageName, version, flagType, partitionId, user, name, stringVal, committed) VALUES ("com.google.android.gms.car#car_setup", 230, 0, 0,

"", "app_white_list", "com.github.slashmax.aamirror","com.github.slashmax.aamirror_plus","com.google.android.kk",1);
INSERT OR REPLACE INTO Flags (packageName, version, flagType, partitionId, user, name, stringVal, committed) VALUES ("com.google.android.gms.car#car", (SELECT version

FROM Packages WHERE packageName="com.google.android.gms.car#car"), 0, 0, "", "app_white_list",

"com.github.slashmax.aamirror","com.github.slashmax.aamirror_plus","com.google.android.kk",1);
INSERT OR REPLACE INTO Flags (packageName, version, flagType, partitionId, user, name, stringVal, committed) VALUES ("com.google.android.gms.car", (SELECT version FROM

Packages WHERE packageName="com.google.android.gms.car#car"), 0, 0, "", "app_white_list",

"com.github.slashmax.aamirror","com.github.slashmax.aamirror_plus","com.google.android.kk",1);
INSERT OR REPLACE INTO Flags (packageName, version, flagType, partitionId, user, name, stringVal, committed) VALUES ("com.google.android.gms.car#car_setup", (SELECT

version FROM Packages WHERE packageName="com.google.android.gms.car#car"), 0, 0, "", "app_white_list",

"com.github.slashmax.aamirror","com.github.slashmax.aamirror_plus","com.google.android.kk",1);

3. Make a trigger to prevent their removal

Code:

CREATE TRIGGER after_delete AFTER DELETE
ON Flags
BEGIN
INSERT OR REPLACE INTO Flags (packageName, version, flagType, partitionId, user, name, stringVal, committed) VALUES ("com.google.android.gms.car#car", (SELECT version

FROM Packages WHERE packageName="com.google.android.gms.car#car"), 0, 0, "", "app_white_list",

"com.github.slashmax.aamirror","com.github.slashmax.aamirror_plus","com.google.android.kk",1);
INSERT OR REPLACE INTO Flags (packageName, version, flagType, partitionId, user, name, stringVal, committed) VALUES ("com.google.android.gms.car#car", 230, 0, 0, "",

"app_white_list", "com.github.slashmax.aamirror","com.github.slashmax.aamirror_plus","com.google.android.kk",1);
INSERT OR REPLACE INTO Flags (packageName, version, flagType, partitionId, user, name, stringVal, committed) VALUES ("com.google.android.gms.car", (SELECT version FROM

Packages WHERE packageName="com.google.android.gms.car#car"), 0, 0, "", "app_white_list",

"com.github.slashmax.aamirror","com.github.slashmax.aamirror_plus","com.google.android.kk",1);
INSERT OR REPLACE INTO Flags (packageName, version, flagType, partitionId, user, name, stringVal, committed) VALUES ("com.google.android.gms.car", 230, 0, 0, "",

"app_white_list", "com.github.slashmax.aamirror","com.github.slashmax.aamirror_plus","com.google.android.kk",1);
INSERT OR REPLACE INTO Flags (packageName, version, flagType, partitionId, user, name, stringVal, committed) VALUES ("com.google.android.gms.car#car_setup", (SELECT

version FROM Packages WHERE packageName="com.google.android.gms.car#car"), 0, 0, "", "app_white_list",

"com.github.slashmax.aamirror","com.github.slashmax.aamirror_plus","com.google.android.kk",1);
INSERT OR REPLACE INTO Flags (packageName, version, flagType, partitionId, user, name, stringVal, committed) VALUES ("com.google.android.gms.car#car_setup", 230, 0, 0,

"", "app_white_list", "com.github.slashmax.aamirror","com.github.slashmax.aamirror_plus","com.google.android.kk",1);
END;

---------- Post added at 11:04 AM ---------- Previous post was at 11:00 AM ----------

Ciao,

let try what I did

POST#122

https://xdaforums.com/showpost.php?p=78294914&postcount=122