Installing qgis in ubuntu 18.04 error with sqlite tables, can no longer use apt











up vote
0
down vote

favorite












I'm getting the following error:



$ sudo apt-get install grass grass-dev qgis python-qgis qgis-plugin-grass
Reading package lists... Done
Building dependency tree
Reading state information... Done
grass-dev is already the newest version (7.4.0-1).
python-qgis is already the newest version (1:3.4.2+28bionic).
The following additional packages will be installed:
qgis-providers
Suggested packages:
gpsbabel
The following NEW packages will be installed:
grass qgis qgis-plugin-grass qgis-providers
0 upgraded, 4 newly installed, 0 to remove and 2 not upgraded.
Need to get 0 B/12.7 MB of archives.
After this operation, 22.8 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Selecting previously unselected package qgis-providers.
(Reading database ... 398057 files and directories currently installed.)
Preparing to unpack .../qgis-providers_1%3a3.4.2+28bionic_amd64.deb ...
Unpacking qgis-providers (1:3.4.2+28bionic) ...
Selecting previously unselected package qgis.
Preparing to unpack .../qgis_1%3a3.4.2+28bionic_amd64.deb ...
Unpacking qgis (1:3.4.2+28bionic) ...
Selecting previously unselected package qgis-plugin-grass.
Preparing to unpack .../qgis-plugin-grass_1%3a3.4.2+28bionic_amd64.deb ...
Unpacking qgis-plugin-grass (1:3.4.2+28bionic) ...
Selecting previously unselected package grass.
Preparing to unpack .../archives/grass_7.4.0-1_all.deb ...
Unpacking grass (7.4.0-1) ...
Setting up grass (7.4.0-1) ...
Setting up qgis-providers (1:3.4.2+28bionic) ...
/usr/lib/qgis/crssync: symbol lookup error: /usr/lib/libgdal.so.20: undefined symbol: sqlite3_column_table_name
dpkg: error processing package qgis-providers (--configure):
installed qgis-providers package post-installation script subprocess returned error exit status 127
dpkg: dependency problems prevent configuration of qgis:
qgis depends on qgis-providers (= 1:3.4.2+28bionic); however:
Package qgis-providers is not configured yet.

dpkg: error processing package qgis (--configure):
dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
Processing triggers for mime-support (3.60ubuntu1) ...
Processing triggers for desktop-file-utils (0.23-1ubuntu3.18.04.2) ...
dpkg: dependency problems prevent configuration of qgis-plugin-grass:
qgis-plugin-grass depends on qgis (= 1:3.4.2+28bionic); however:
Package qgis is not configured yet.

dpkg: error processing package qgis-plugin-grass (--configure):
dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
Processing triggers for man-db (2.8.3-2ubuntu0.1) ...
Processing triggers for shared-mime-info (1.9-2) ...
Processing triggers for gnome-menus (3.13.3-11ubuntu1.1) ...
Processing triggers for hicolor-icon-theme (0.17-2) ...
Errors were encountered while processing:
qgis-providers
qgis
qgis-plugin-grass
E: Sub-process /usr/bin/dpkg returned an error code (1)


Why is it failing on something to do with sqlite tables?



I followed this:
Dependency issues when trying to install qgis python-qgis qgis-plugin-grass



And trying to install:



sudo apt install libmysqlclient-dev 


Produces the same error about qgis for some reason.



This seems to have permanently messed up my system. Anything I try to install produces this error.



Edit for debug



$ dpkg -S /usr/lib/libgdal.so.20
libgdal20: /usr/lib/libgdal.so.20









share|improve this question
























  • Please add output of dpkg -S /usr/lib/libgdal.so.20 and ldd /usr/lib/libgdal.so.20 to the question. Also note that your install command end with success on clean Ubuntu 18.04.1 LTS VM without PPAs. It opens qgis and reports that it has 2.18 version. Do you have any PPAs added to the system?
    – N0rbert
    Nov 29 at 18:37










  • Thanks, @N0rbert. ldd seems to have a lot of output but ldd /usr/lib/libgdal.so.20 grep | gdal returns nothing
    – Mittenchops
    Nov 29 at 19:20










  • Please share full output of ldd /usr/lib/libgdal.so.20 and apt-cache policy libgdal20.
    – N0rbert
    Nov 29 at 19:22

















up vote
0
down vote

favorite












I'm getting the following error:



$ sudo apt-get install grass grass-dev qgis python-qgis qgis-plugin-grass
Reading package lists... Done
Building dependency tree
Reading state information... Done
grass-dev is already the newest version (7.4.0-1).
python-qgis is already the newest version (1:3.4.2+28bionic).
The following additional packages will be installed:
qgis-providers
Suggested packages:
gpsbabel
The following NEW packages will be installed:
grass qgis qgis-plugin-grass qgis-providers
0 upgraded, 4 newly installed, 0 to remove and 2 not upgraded.
Need to get 0 B/12.7 MB of archives.
After this operation, 22.8 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Selecting previously unselected package qgis-providers.
(Reading database ... 398057 files and directories currently installed.)
Preparing to unpack .../qgis-providers_1%3a3.4.2+28bionic_amd64.deb ...
Unpacking qgis-providers (1:3.4.2+28bionic) ...
Selecting previously unselected package qgis.
Preparing to unpack .../qgis_1%3a3.4.2+28bionic_amd64.deb ...
Unpacking qgis (1:3.4.2+28bionic) ...
Selecting previously unselected package qgis-plugin-grass.
Preparing to unpack .../qgis-plugin-grass_1%3a3.4.2+28bionic_amd64.deb ...
Unpacking qgis-plugin-grass (1:3.4.2+28bionic) ...
Selecting previously unselected package grass.
Preparing to unpack .../archives/grass_7.4.0-1_all.deb ...
Unpacking grass (7.4.0-1) ...
Setting up grass (7.4.0-1) ...
Setting up qgis-providers (1:3.4.2+28bionic) ...
/usr/lib/qgis/crssync: symbol lookup error: /usr/lib/libgdal.so.20: undefined symbol: sqlite3_column_table_name
dpkg: error processing package qgis-providers (--configure):
installed qgis-providers package post-installation script subprocess returned error exit status 127
dpkg: dependency problems prevent configuration of qgis:
qgis depends on qgis-providers (= 1:3.4.2+28bionic); however:
Package qgis-providers is not configured yet.

dpkg: error processing package qgis (--configure):
dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
Processing triggers for mime-support (3.60ubuntu1) ...
Processing triggers for desktop-file-utils (0.23-1ubuntu3.18.04.2) ...
dpkg: dependency problems prevent configuration of qgis-plugin-grass:
qgis-plugin-grass depends on qgis (= 1:3.4.2+28bionic); however:
Package qgis is not configured yet.

dpkg: error processing package qgis-plugin-grass (--configure):
dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
Processing triggers for man-db (2.8.3-2ubuntu0.1) ...
Processing triggers for shared-mime-info (1.9-2) ...
Processing triggers for gnome-menus (3.13.3-11ubuntu1.1) ...
Processing triggers for hicolor-icon-theme (0.17-2) ...
Errors were encountered while processing:
qgis-providers
qgis
qgis-plugin-grass
E: Sub-process /usr/bin/dpkg returned an error code (1)


Why is it failing on something to do with sqlite tables?



I followed this:
Dependency issues when trying to install qgis python-qgis qgis-plugin-grass



And trying to install:



sudo apt install libmysqlclient-dev 


Produces the same error about qgis for some reason.



This seems to have permanently messed up my system. Anything I try to install produces this error.



Edit for debug



$ dpkg -S /usr/lib/libgdal.so.20
libgdal20: /usr/lib/libgdal.so.20









share|improve this question
























  • Please add output of dpkg -S /usr/lib/libgdal.so.20 and ldd /usr/lib/libgdal.so.20 to the question. Also note that your install command end with success on clean Ubuntu 18.04.1 LTS VM without PPAs. It opens qgis and reports that it has 2.18 version. Do you have any PPAs added to the system?
    – N0rbert
    Nov 29 at 18:37










  • Thanks, @N0rbert. ldd seems to have a lot of output but ldd /usr/lib/libgdal.so.20 grep | gdal returns nothing
    – Mittenchops
    Nov 29 at 19:20










  • Please share full output of ldd /usr/lib/libgdal.so.20 and apt-cache policy libgdal20.
    – N0rbert
    Nov 29 at 19:22















up vote
0
down vote

favorite









up vote
0
down vote

favorite











I'm getting the following error:



$ sudo apt-get install grass grass-dev qgis python-qgis qgis-plugin-grass
Reading package lists... Done
Building dependency tree
Reading state information... Done
grass-dev is already the newest version (7.4.0-1).
python-qgis is already the newest version (1:3.4.2+28bionic).
The following additional packages will be installed:
qgis-providers
Suggested packages:
gpsbabel
The following NEW packages will be installed:
grass qgis qgis-plugin-grass qgis-providers
0 upgraded, 4 newly installed, 0 to remove and 2 not upgraded.
Need to get 0 B/12.7 MB of archives.
After this operation, 22.8 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Selecting previously unselected package qgis-providers.
(Reading database ... 398057 files and directories currently installed.)
Preparing to unpack .../qgis-providers_1%3a3.4.2+28bionic_amd64.deb ...
Unpacking qgis-providers (1:3.4.2+28bionic) ...
Selecting previously unselected package qgis.
Preparing to unpack .../qgis_1%3a3.4.2+28bionic_amd64.deb ...
Unpacking qgis (1:3.4.2+28bionic) ...
Selecting previously unselected package qgis-plugin-grass.
Preparing to unpack .../qgis-plugin-grass_1%3a3.4.2+28bionic_amd64.deb ...
Unpacking qgis-plugin-grass (1:3.4.2+28bionic) ...
Selecting previously unselected package grass.
Preparing to unpack .../archives/grass_7.4.0-1_all.deb ...
Unpacking grass (7.4.0-1) ...
Setting up grass (7.4.0-1) ...
Setting up qgis-providers (1:3.4.2+28bionic) ...
/usr/lib/qgis/crssync: symbol lookup error: /usr/lib/libgdal.so.20: undefined symbol: sqlite3_column_table_name
dpkg: error processing package qgis-providers (--configure):
installed qgis-providers package post-installation script subprocess returned error exit status 127
dpkg: dependency problems prevent configuration of qgis:
qgis depends on qgis-providers (= 1:3.4.2+28bionic); however:
Package qgis-providers is not configured yet.

dpkg: error processing package qgis (--configure):
dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
Processing triggers for mime-support (3.60ubuntu1) ...
Processing triggers for desktop-file-utils (0.23-1ubuntu3.18.04.2) ...
dpkg: dependency problems prevent configuration of qgis-plugin-grass:
qgis-plugin-grass depends on qgis (= 1:3.4.2+28bionic); however:
Package qgis is not configured yet.

dpkg: error processing package qgis-plugin-grass (--configure):
dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
Processing triggers for man-db (2.8.3-2ubuntu0.1) ...
Processing triggers for shared-mime-info (1.9-2) ...
Processing triggers for gnome-menus (3.13.3-11ubuntu1.1) ...
Processing triggers for hicolor-icon-theme (0.17-2) ...
Errors were encountered while processing:
qgis-providers
qgis
qgis-plugin-grass
E: Sub-process /usr/bin/dpkg returned an error code (1)


Why is it failing on something to do with sqlite tables?



I followed this:
Dependency issues when trying to install qgis python-qgis qgis-plugin-grass



And trying to install:



sudo apt install libmysqlclient-dev 


Produces the same error about qgis for some reason.



This seems to have permanently messed up my system. Anything I try to install produces this error.



Edit for debug



$ dpkg -S /usr/lib/libgdal.so.20
libgdal20: /usr/lib/libgdal.so.20









share|improve this question















I'm getting the following error:



$ sudo apt-get install grass grass-dev qgis python-qgis qgis-plugin-grass
Reading package lists... Done
Building dependency tree
Reading state information... Done
grass-dev is already the newest version (7.4.0-1).
python-qgis is already the newest version (1:3.4.2+28bionic).
The following additional packages will be installed:
qgis-providers
Suggested packages:
gpsbabel
The following NEW packages will be installed:
grass qgis qgis-plugin-grass qgis-providers
0 upgraded, 4 newly installed, 0 to remove and 2 not upgraded.
Need to get 0 B/12.7 MB of archives.
After this operation, 22.8 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Selecting previously unselected package qgis-providers.
(Reading database ... 398057 files and directories currently installed.)
Preparing to unpack .../qgis-providers_1%3a3.4.2+28bionic_amd64.deb ...
Unpacking qgis-providers (1:3.4.2+28bionic) ...
Selecting previously unselected package qgis.
Preparing to unpack .../qgis_1%3a3.4.2+28bionic_amd64.deb ...
Unpacking qgis (1:3.4.2+28bionic) ...
Selecting previously unselected package qgis-plugin-grass.
Preparing to unpack .../qgis-plugin-grass_1%3a3.4.2+28bionic_amd64.deb ...
Unpacking qgis-plugin-grass (1:3.4.2+28bionic) ...
Selecting previously unselected package grass.
Preparing to unpack .../archives/grass_7.4.0-1_all.deb ...
Unpacking grass (7.4.0-1) ...
Setting up grass (7.4.0-1) ...
Setting up qgis-providers (1:3.4.2+28bionic) ...
/usr/lib/qgis/crssync: symbol lookup error: /usr/lib/libgdal.so.20: undefined symbol: sqlite3_column_table_name
dpkg: error processing package qgis-providers (--configure):
installed qgis-providers package post-installation script subprocess returned error exit status 127
dpkg: dependency problems prevent configuration of qgis:
qgis depends on qgis-providers (= 1:3.4.2+28bionic); however:
Package qgis-providers is not configured yet.

dpkg: error processing package qgis (--configure):
dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
Processing triggers for mime-support (3.60ubuntu1) ...
Processing triggers for desktop-file-utils (0.23-1ubuntu3.18.04.2) ...
dpkg: dependency problems prevent configuration of qgis-plugin-grass:
qgis-plugin-grass depends on qgis (= 1:3.4.2+28bionic); however:
Package qgis is not configured yet.

dpkg: error processing package qgis-plugin-grass (--configure):
dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
Processing triggers for man-db (2.8.3-2ubuntu0.1) ...
Processing triggers for shared-mime-info (1.9-2) ...
Processing triggers for gnome-menus (3.13.3-11ubuntu1.1) ...
Processing triggers for hicolor-icon-theme (0.17-2) ...
Errors were encountered while processing:
qgis-providers
qgis
qgis-plugin-grass
E: Sub-process /usr/bin/dpkg returned an error code (1)


Why is it failing on something to do with sqlite tables?



I followed this:
Dependency issues when trying to install qgis python-qgis qgis-plugin-grass



And trying to install:



sudo apt install libmysqlclient-dev 


Produces the same error about qgis for some reason.



This seems to have permanently messed up my system. Anything I try to install produces this error.



Edit for debug



$ dpkg -S /usr/lib/libgdal.so.20
libgdal20: /usr/lib/libgdal.so.20






package-management dependencies sqlite3 qgis






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 29 at 19:20

























asked Nov 29 at 16:55









Mittenchops

71441534




71441534












  • Please add output of dpkg -S /usr/lib/libgdal.so.20 and ldd /usr/lib/libgdal.so.20 to the question. Also note that your install command end with success on clean Ubuntu 18.04.1 LTS VM without PPAs. It opens qgis and reports that it has 2.18 version. Do you have any PPAs added to the system?
    – N0rbert
    Nov 29 at 18:37










  • Thanks, @N0rbert. ldd seems to have a lot of output but ldd /usr/lib/libgdal.so.20 grep | gdal returns nothing
    – Mittenchops
    Nov 29 at 19:20










  • Please share full output of ldd /usr/lib/libgdal.so.20 and apt-cache policy libgdal20.
    – N0rbert
    Nov 29 at 19:22




















  • Please add output of dpkg -S /usr/lib/libgdal.so.20 and ldd /usr/lib/libgdal.so.20 to the question. Also note that your install command end with success on clean Ubuntu 18.04.1 LTS VM without PPAs. It opens qgis and reports that it has 2.18 version. Do you have any PPAs added to the system?
    – N0rbert
    Nov 29 at 18:37










  • Thanks, @N0rbert. ldd seems to have a lot of output but ldd /usr/lib/libgdal.so.20 grep | gdal returns nothing
    – Mittenchops
    Nov 29 at 19:20










  • Please share full output of ldd /usr/lib/libgdal.so.20 and apt-cache policy libgdal20.
    – N0rbert
    Nov 29 at 19:22


















Please add output of dpkg -S /usr/lib/libgdal.so.20 and ldd /usr/lib/libgdal.so.20 to the question. Also note that your install command end with success on clean Ubuntu 18.04.1 LTS VM without PPAs. It opens qgis and reports that it has 2.18 version. Do you have any PPAs added to the system?
– N0rbert
Nov 29 at 18:37




Please add output of dpkg -S /usr/lib/libgdal.so.20 and ldd /usr/lib/libgdal.so.20 to the question. Also note that your install command end with success on clean Ubuntu 18.04.1 LTS VM without PPAs. It opens qgis and reports that it has 2.18 version. Do you have any PPAs added to the system?
– N0rbert
Nov 29 at 18:37












Thanks, @N0rbert. ldd seems to have a lot of output but ldd /usr/lib/libgdal.so.20 grep | gdal returns nothing
– Mittenchops
Nov 29 at 19:20




Thanks, @N0rbert. ldd seems to have a lot of output but ldd /usr/lib/libgdal.so.20 grep | gdal returns nothing
– Mittenchops
Nov 29 at 19:20












Please share full output of ldd /usr/lib/libgdal.so.20 and apt-cache policy libgdal20.
– N0rbert
Nov 29 at 19:22






Please share full output of ldd /usr/lib/libgdal.so.20 and apt-cache policy libgdal20.
– N0rbert
Nov 29 at 19:22

















active

oldest

votes











Your Answer








StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1097177%2finstalling-qgis-in-ubuntu-18-04-error-with-sqlite-tables-can-no-longer-use-apt%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown






























active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes
















draft saved

draft discarded




















































Thanks for contributing an answer to Ask Ubuntu!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.





Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


Please pay close attention to the following guidance:


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1097177%2finstalling-qgis-in-ubuntu-18-04-error-with-sqlite-tables-can-no-longer-use-apt%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Ellipse (mathématiques)

Quarter-circle Tiles

Mont Emei