yast problem:SQL error or missing database

English Applications
1

Hello

An error occurs each time I try to start “Software Management”. It starts downloading package info from the repository and after some time leaves an error message saying “History - SQL logic error or
missing database”. I tried to delete the repositories so that I can reconfigure them. However, I can not delete Main update repository. Please suggest.

Thank you.

2

Hi
Try it from the CLI then (console/konsole);


sudo zypper ref
sudo zypper lu
sudo zypper up

The first command refreshes the repositories, the second lists any
updates, the third will apply the updates.

If that doesn’t work a read here;
Package
Manager Cleanup

Note the script has an error, the correct one is here;
SDB:Speed
up Package Manager Stack - openSUSE

–
Cheers Malcolm °¿° (Linux Counter #276890)
openSUSE 11.0 x86 Kernel 2.6.25.18-0.2-default
up 12:14, 2 users, load average: 0.11, 0.07, 0.11
GPU GeForce 6600 TE/6200 TE - Driver Version: 177.80

3

Malcolm wrote:
> Hi
> Try it from the CLI then (console/konsole);
>


> sudo zypper ref
> sudo zypper lu
> sudo zypper up
>

The first command refreshes the repositories, the second lists any
updates, the third will apply the updates.

If that doesn’t work a read here;
Package
Manager Cleanup

Note the script has an error, the correct one is here;
SDB:Speed
up Package Manager Stack - openSUSE

Thank you.

sqlite3 /var/cache/zypp/zypp.db vacuum

This line did it for me.