RE: E200030 error on checkout

Correcting the subject line to reflect the actual error code

From: mferreira_at_navisite.com
Sent: Tuesday, August 21, 2012 1:45 PM
To: users_at_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
mferreira_at_navisite.com<mailto:mferreira_at_navisite.com>
Office: (978) 946-7747
Mobile: (978) 631-9810
[cid:image001.jpg_at_01CD803E.34A13440]

________________________________
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.