Withut knowledge of your setup: My guess would be that your setup accidentally picks up an older Sqlite as this syntax is supported by all our supported Sqlite versions. (Maybe by using a different library at runtime that at compile time).
If you are upgrading Sqlite specifically I would recommend going to a very
recent 3.7 version as there are relevant optimizer fixes that may speed up
several operations.
Bert
From: Ferreira, Matthew [mailto:mferre...@navisite.com]
Sent: woensdag 22 augustus 2012 14:15
To: users@subversion.apache.org
Subject: RE: E200030 error on checkout
Correcting the subject line to reflect the actual error code
From: mferre...@navisite.com
Sent: Tuesday, August 21, 2012 1:45 PM
To: users@subversion.apache.org
Subject: e20300 error on checkout
When using the svn client, seeing the following:
svn: E200030: near "OLD": syntax error, executing statement 'CREATE TRIGGER
nodes_insert_trigger AFTER INSERT ON nodes WHEN NEW.checksum IS NOT NULL
BEGIN UPDATE pristine SET refcount = refcount + 1 WHERE checksum =
NEW.checksum; END; CREATE TRIGGER nodes_delete_trigger AFTER DELETE ON nodes
WHEN OLD.checksum IS NOT NULL BEGIN UPDATE pristine SET refcount =
refcount - 1 WHERE checksum = OLD.checksum; END; CREATE TRIGGER
nodes_update_checksum_trigger AFTER UPDATE OF checksum ON nodes WHEN
NEW.checksum IS NOT OLD.checksum BEGIN UPDATE pristine SET refcount =
refcount + 1 WHERE checksum = NEW.checksum; UPDATE pristine SET refcount
= refcount - 1 WHERE checksum = OLD.checksum; END; '
When I searched around I found a lot of users seeing issues with CygWin, but
I'm using Solaris 9 Sparc w/ sqlite 3.6.18
It creates the directory with the wc.db file and a couple others but doesn't
check anything out
Thanks in Advance
Matt Ferreira
Web Services Engineer, Sr. - Managed Web Serivces
NaviSite - A Time Warner Cable Company
mferre...@navisite.com
Office: (978) 946-7747
Mobile: (978) 631-9810
Description: cid:image001.jpg@01CC038E.F3B18AC0
_____
This e-mail is the property of NaviSite, Inc. It is intended only for the
person or entity to which it is addressed and may contain information that
is privileged, confidential, or otherwise protected from disclosure.
Distribution or copying of this e-mail, or the information contained herein,
to anyone other than the intended recipient is prohibited.
<<image001.jpg>>
