You are not logged in.

#1 2012-04-02 22:31:47

rWarrior
Member
Registered: 2008-12-28
Posts: 26

[Solved] sqlite3: SQLite header and source version mismatch

Is anyone else getting this error?

$ sqlite3
SQLite header and source version mismatch
2009-09-11 14:05:07 b084828a771ec40be85f07c590ca99de4f6c24ee
2012-03-20 11:35:50 00bb9c9ce4f465e6ac321ced2a9d0062dc364669

I just performed a full system upgrade

$ pacman -Syyu

I tried re-installing:

$ pacman -Rdd sqlite3
$ pacman -S sqlite3

I tried updating the shared library links (as suggested by a post):

$ ldconfig

None of the above steps helped...


$ pacman -Qs sqlite3
local/sqlite3 3.7.11-1
    A C library that implements an SQL database engine
$ uname -a
Linux mdt3 3.2.13-1-ARCH #1 SMP PREEMPT Sat Mar 24 09:10:39 CET 2012 x86_64 AMD Opteron(tm) Processor 6128 AuthenticAMD GNU/Linux

Last edited by rWarrior (2012-04-25 21:03:38)

Offline

#2 2012-04-02 23:13:20

karol
Archivist
Registered: 2009-05-06
Posts: 25,440

Re: [Solved] sqlite3: SQLite header and source version mismatch

Cannot reproduce on my 32-bit Arch.
Try redownloading http://www.archlinux.org/packages/core/ … /download/

Offline

#3 2012-04-04 16:40:08

rWarrior
Member
Registered: 2008-12-28
Posts: 26

Re: [Solved] sqlite3: SQLite header and source version mismatch

I removed the cached sqlite3 package, and re-downloaded sqlite3 manually from your link.
But I still get the same error.

Last edited by rWarrior (2012-04-04 16:47:07)

Offline

#4 2012-04-04 16:49:44

Gcool
Member
Registered: 2011-08-16
Posts: 1,456

Re: [Solved] sqlite3: SQLite header and source version mismatch

Try removing the sqlite3 package again and afterwards see if by any chance any "libsqlite" files still exist in /usr/lib. If so, toss em out and then reinstall sqlite3.


Burninate!

Offline

#5 2012-04-12 18:29:55

rWarrior
Member
Registered: 2008-12-28
Posts: 26

Re: [Solved] sqlite3: SQLite header and source version mismatch

I have tried removing the libsqlite.so.* files and uninstalling sqlite3.
But I still get the same error.

It seems that I don't have this error on another x86_64 system...

But this header and source mismatch error keeps occuring, no matter how I reinstall or uninstall...

Is there another package that is causing the problem?

Offline

#6 2012-04-25 21:03:12

rWarrior
Member
Registered: 2008-12-28
Posts: 26

Re: [Solved] sqlite3: SQLite header and source version mismatch

It turned that another libsqlite3.so installed elsewhere was wreaking havoc...
I removed the other copy, and things went back to normal.

Offline

#7 2012-04-27 19:53:59

TeddyRO
Member
Registered: 2012-04-27
Posts: 1

Re: [Solved] sqlite3: SQLite header and source version mismatch

Hi,
I've got the same problem...

SQLite header and source version mismatch
2011-06-23 19:49:22 4374b7e83ea0a3fbc3691f9c0c936272862f32f2
2012-03-20 11:35:50 00bb9c9ce4f465e6ac321ced2a9d0062dc364669

Can u tell me how to fix it? This occured when I've unpacked sqlite-autoconf-3071100.tar.gz, entered into unpacked directory with terminal and used commands:

./configure
make
sudo make install
sqlite3

As u've said before the problem is with libsqlite3.so... So i've searched it in File System. And the result is:
One file with name libsqlite3.so - /usr/local/lib
Two files with name libsqlite3.so.0 One is here - /usr/local/lib and another here - /usr/lib/i386-linux-gnu
Two files with name libsqlite3.so.0.8.6 One is here - /usr/local/lib and another here - /usr/lib/i386-linux-gnu

So... can u tell me which one to delete (in which folder)? What to do next? I am newbie... so if it's possible tell in little steps.

Thanks in advance.

Best wishes,
Teddy.

Last edited by TeddyRO (2012-04-27 19:57:18)

Offline

#8 2012-08-08 16:37:09

TrungDV
Member
Registered: 2012-08-08
Posts: 1

Re: [Solved] sqlite3: SQLite header and source version mismatch

Hi Teddy.

I've got same problem, I solved it by replacing libssqlite3.so.0.8.6 and libsqlite3.so.0 in /usr/lib/i386-linux-gnu by the same name files in /usr/local/lib.
Hope this is helpful with you.

Best regards,
TrungDV

Last edited by TrungDV (2012-08-08 16:38:07)

Offline

Board footer

Powered by FluxBB