Re: ViewVC with CVSNT - checkin database setup

Just thought I'd post a follow-up to
my message from yesterday, in case anyone else is having similar problems.

I got past my first problem by changing
two lines in cvsdb.py, as described here: 
        http://viewvc.tigris.org/servlets/ReadMsg?listName=users&msgNo=4753

I could then run cvsdbadmin, but nothing
was showing up in the database.  I researched that, and found that
I needed to switch my MySQL tables from InnoDB to MyISAM, as described
here:
        http://viewvc.tigris.org/issues/show_bug.cgi?id=262

That cleared things up, for the most
part, except for one last thing that I needed to change in viewvc.conf.
 I had to change:
        cvs_roots
= cvs: /cvs/repo
to: 
        cvs_roots
= cvs: d:/cvs/repo
Apparently, the "/cvs/repo"
works fine for everything except the checkin database stuff, since I didn't
have any problems until I started playing with that.

Hope this message is helpful to someone
else at some point!

-- Andrew Huey

mis@xxxxxxxxxxxx wrote on 03/20/2007 05:12:17 PM:

> 
> Hello all.  I'm using ViewVC 1.0.3 with CVSNT 2.5.03 build 2382.
 
> I've got pretty much everything working fine now, except for the 
> checkin database, which I'm just now trying to set up.  I installed
> MySQL 5.0.37 and MySQL-Python 1.2.2 (for Python 2.4).  (This
is all 
> running on a Windows 2003 server.)  The make-database script
seems 
> to have run OK.  When I try to do the "cvsdbadmin rebuild
<repo>", 
> though, I get the error shown below: 
> 
> Using repository root `D:\cvs\repo' 
> [CVSROOT/checkoutlist [1 commits]] 
> Traceback (most recent call last): 
>   File "bin\cvsdbadmin", line 151, in ? 
>     RecurseUpdate(db, repository, path_parts, update) 
>   File "bin\cvsdbadmin", line 81, in RecurseUpdate
>     RecurseUpdate(db, repository, path, update) 
>   File "bin\cvsdbadmin", line 85, in RecurseUpdate
>     UpdateFile(db, repository, path, update) 
>   File "bin\cvsdbadmin", line 67, in UpdateFile 
>     db.AddCommit(commit) 
>   File "d:\viewvc-1.0.3\lib\cvsdb.py", line 265, in
AddCommit 
>     cursor.execute(sql, sql_args) 
>   File "D:\Python24\Lib\site-packages\MySQLdb\cursors.py",
line 166,in execute
>     self.errorhandler(self, exc, value) 
>   File "D:\Python24\Lib\site-packages\MySQLdb\connections.py",
line 
> 35, in defaulterrorhandler 
>     raise errorclass, errorvalue 
> _mysql_exceptions.OperationalError: (1366, "Incorrect integer
value:
> '' for column 'addedlines' at row 1") 
> 
> Can anyone point me in the right direction as to what I may be 
> missing?  I started tracing back through the Python code, but
I'm 
> not familiar enough with CVS or ViewVC to know what I'm looking for.
> Any pointers would be appreciated.  Thanks. 
> 
> -- Andrew Huey