升级到Pylogs 1.15beta SVN-224后，使用原有的DB会报错?

[XStar]

我使用的sqlite作为DB，刚才重新通过SVN将blog更新为最新版本，但将原有的pylogs.db复制过来无法正常工作（错误后附）。而重新
用python ./manage.py syncdb重新生成db文件则可正常运行。

已测试：在执行syncdb后，用老的pylogs.db覆盖，仍然会报错。

请问需要怎么样才能保留原有数据？

附错误信息：
2009-07-01 21:19:02: (mod_fastcgi.c.2610) FastCGI-stderr: Traceback
(most recent call last):
File "/var/lib/python-support/python2.6/flup/server/fcgi_base.py",
line 558, in run
protocolStatus, appStatus = self.server.handler(self)
File "/var/lib/python-support/python2.6/flup/server/fcgi_base.py",
line 1116, in handler
result = self.application(environ, start_response)
File "/var/lib/python-support/python2.6/django/core/handlers/
wsgi.py", line 239, in __call__
response = self.get_response(request)
File "/var/lib/python-support/python2.6/django/core/handlers/
base.py", line 128, in get_response
return self.handle_uncaught_exception(request, resolver, exc_info)
File "/var/lib/python-support/python2.6/django/core/handlers/
base.py", line 159, in handle_uncaught_exception
callback, param_dict = resolver.resolve500()
File "/var/lib/python-support/python2.6/django/core/
urlresolvers.py", line 218, in resolve500
return self._resolve_special('500')
File "/var/lib/python-support/python2.6/django/core/
urlresolvers.py", line 207, in _resolve_special
callback = getattr(self.urlconf_module, 'handler%s' % view_type)
File "/var/lib/python-support/python2.6/django/core/
urlresolvers.py", line 198, in _get_urlconf_module
self._urlconf_module = __import__(self.urlconf_name, {}, {}, [''])
File "/home/yuanxing/pylogs/urls.py", line 5, in <module>
from blog import feeds
File "/home/yuanxing/pylogs/blog/feeds.py", line 16, in <module>
current_site = Site.objects.get_current().name
File "/var/lib/python-support/python2.6/django/contrib/sites/
models.py", line 22, in get_current
current_site = self.get(pk=sid)
File "/var/lib/python-support/python2.6/django/db/models/
manager.py", line 93, in get
return self.get_query_set().get(*args, **kwargs)
File "/var/lib/python-support/python2.6/django/db/models/query.py",
line 309, in get
% self.model._meta.object_name)
DoesNotExist: Site matching query does not exist.

[XStar]

与1.5b比较，1.5b224 blog_post表中增加了个字段：
"markup" varchar(64) NOT NULL,

有什么办法可以比较方便地调整sqlite3中的表结构增加该字段？

[lv yi]

2009/7/2 XStar <lon...@gmail.com>:

> 与1.5b比较，1.5b224 blog_post表中增加了个字段：
> "markup" varchar(64) NOT NULL,
>
> 有什么办法可以比较方便地调整sqlite3中的表结构增加该字段？

$ python manage.py dbshell
sqlite> ALTER TABLE blog_post ADD COLUMN "markup" varchar(64) DEFAULT "html" ;

> >
>

--
----------------------------------------------------------
爱词霸 爱生活
-----------------------------------------------------------
吕毅 <lvyi AT kingsoft.com> 15101530895
邮编: 100185 ; 地址: 北京市海淀区小营西路33号金山软件大厦
Gtalk: lvs...@gmail.com | MSN: lvs...@msn.com

[XStar]

谢谢！