I have a record or 2 in the database that will not allow me to update or install due to a
Since this appears to be a conventional style database would the following work as a fix as opposed to doing a complete install from scratch of the whole system. I know next to nothing about sqlite3.
Delete the offending record in the database.
MySQL will delete a record with this
I believe that the database is /var/db/local.sqlite
I am able add/update/delete other ports/packages without any problems using
If one would know the table name and the key and format for the record would it be possible to delete the bad entry and do an install of the port/package? I have not found where anybody has attempted this. I have tried to find out what the database looks like from a copy, but the commands I try using are incorrect. A little or more learning curve for my fried brain trying to add
Code:
database disk image is malformed
Delete the offending record in the database.
MySQL will delete a record with this
DELETE FROM table_name [WHERE Clause]
. The where would be the table and specific record by key and value. Sqlite has a similar command.
Code:
DELETE
FROM
table
WHERE search_condition
ORDER BY criteria
LIMIT row_count OFFSET offset;
I believe that the database is /var/db/local.sqlite
I am able add/update/delete other ports/packages without any problems using
pkg install/delete [I]name[/I]
or portmaster [I]name[/I]
If one would know the table name and the key and format for the record would it be possible to delete the bad entry and do an install of the port/package? I have not found where anybody has attempted this. I have tried to find out what the database looks like from a copy, but the commands I try using are incorrect. A little or more learning curve for my fried brain trying to add
kde
after a version update.