a while back I wanted to install some plugins for Trac but it required python 2.5 I tried installing it (I don't remember how) and the only thing I managed was to have two versions of python (2.4 and 2.5). Trac still uses the old version but the console uses 2.5 (python -V = Python 2.5.2). Anyway, the problem is not python, the problem is yum (which uses python).

I am trying to upgrade my PHP version from 5.1.x to 5.2.x. I tried following this tutorial but when I reach the step with yum I get this error:

>[root@XXX]# yum update  
Loading "installonlyn" plugin  
Setting up Update Process  
Setting up repositories  
Reading repository metadata in from local files  
Traceback (most recent call last):  
  File "/usr/bin/yum", line 29, in ?  
    yummain.main(sys.argv[1:])  
  File "/usr/share/yum-cli/yummain.py", line 94, in main  
    result, resultmsgs = base.doCommands()  
  File "/usr/share/yum-cli/cli.py", line 381, in doCommands  
    return self.yum_cli_commands[self.basecmd].doCommand(self, self.basecmd, self.extcmds)  
  File "/usr/share/yum-cli/yumcommands.py", line 150, in doCommand  
    return base.updatePkgs(extcmds)  
  File "/usr/share/yum-cli/cli.py", line 672, in updatePkgs  
    self.doRepoSetup()  
  File "/usr/share/yum-cli/cli.py", line 109, in doRepoSetup  
    self.doSackSetup(thisrepo=thisrepo)  
  File "/usr/lib/python2.4/site-packages/yum/__init__.py", line 338, in doSackSetup  
    self.repos.populateSack(which=repos)  
  File "/usr/lib/python2.4/site-packages/yum/repos.py", line 200, in populateSack  
    sack.populate(repo, with, callback, cacheonly)  
  File "/usr/lib/python2.4/site-packages/yum/yumRepo.py", line 91, in populate  
    dobj = repo.cacheHandler.getPrimary(xml, csum)  
  File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 100, in getPrimary  
    return self._getbase(location, checksum, 'primary')  
  File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 86, in _getbase  
    (db, dbchecksum) = self.getDatabase(location, metadatatype)  
  File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 82, in getDatabase  
    db = self.makeSqliteCacheFile(filename,cachetype)  
  File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 245, in   makeSqliteCacheFile  
    self.createTablesPrimary(db)  
  File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 165, in   createTablesPrimary  
    cur.execute(q)  
  File "/usr/lib/python2.4/site-packages/sqlite/main.py", line 244, in execute  
    self.rs = self.con.db.execute(SQL)  
_sqlite.DatabaseError: near "release": syntax error  

Any help?

Thank you.

Update

OK, so I've managed to update yum hoping it would solve my problems but now I get a slightly different version of the same error:

[root@XXX]# yum -y update
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * addons: mirror.skiplink.com
 * base: www.gtlib.gatech.edu
 * epel: mirrors.tummy.com
 * extras: yum.singlehop.com
 * updates: centos-distro.cavecreek.net

(process:30840): GLib-CRITICAL **: g_timer_stop: assertion `timer != NULL' failed

(process:30840): GLib-CRITICAL **: g_timer_destroy: assertion `timer != NULL' failed
Traceback (most recent call last):
  File "/usr/bin/yum", line 29, in ?
    yummain.user_main(sys.argv[1:], exit_code=True)
  File "/usr/share/yum-cli/yummain.py", line 309, in user_main
    errcode = main(args)
  File "/usr/share/yum-cli/yummain.py", line 178, in main
    result, resultmsgs = base.doCommands()
  File "/usr/share/yum-cli/cli.py", line 345, in doCommands
    self._getTs(needTsRemove)
  File "/usr/lib/python2.4/site-packages/yum/depsolve.py", line 101, in _getTs
    self._getTsInfo(remove_only)
  File "/usr/lib/python2.4/site-packages/yum/depsolve.py", line 112, in _getTsInfo
    pkgSack = self.pkgSack
  File "/usr/lib/python2.4/site-packages/yum/__init__.py", line 661, in <lambda>
    pkgSack = property(fget=lambda self: self._getSacks(),
  File "/usr/lib/python2.4/site-packages/yum/__init__.py", line 501, in _getSacks
    self.repos.populateSack(which=repos)
  File "/usr/lib/python2.4/site-packages/yum/repos.py", line 260, in populateSack
    sack.populate(repo, mdtype, callback, cacheonly)
  File "/usr/lib/python2.4/site-packages/yum/yumRepo.py", line 190, in populate
    dobj = repo_cache_function(xml, csum)
  File "/usr/lib/python2.4/site-packages/sqlitecachec.py", line 42, in getPrimary
    self.repoid))
TypeError: Can not create packages table: near "release": syntax error

I'm guessing that this "release" thing has something to do with a repository, but I didn't find anything...

I went to the sqlitecachec.py at line 42 which writes (line numbers added for convenience):

39:        return self.open_database(_sqlitecache.update_primary(location,
40:               checksum,
41:                                                              self.callback,
42:                                                              self.repoid))

Update 2

I think I found the problem. This post suggests that the problem is sqlite and not yum. The version of sqlite I have installed is 3.6.10 but I have no idea which version does python 2.4 uses. ld.so.config contains the following:

include ld.so.conf.d/*.conf
/usr/local/lib

In folder /usr/local/lib I find a symbolic link named libsqlite3.so that points to libsqlite3.so.0.8.6

WHAT IS HAPPENING??????? :S