So, I will safely ignore these errors then! Thank you for your replies! On Fri, May 15, 2009 at 1:34 PM, Jacques Le Roux < [email protected]> wrote:
> Right, and ? > > Jacques > > From: "abdullah shaikh" <[email protected]> > > You can have a look at this >> https://issues.apache.org/jira/browse/OFBIZ-2208 >> >> >> On Fri, May 15, 2009 at 11:34 AM, Anshuman Manur < >> [email protected]> wrote: >> >> Hey, >>> >>> We're three developers working on building an e-commerce store with >>> ofbiz. >>> For code sharing and versioning, we've setup a SVN server on a local LAN >>> machine. We're using a MySQL database ver 5.0. What we usually do is when >>> we >>> make changes that affect the DB, (such as adding new products) we take a >>> mysql dump of the db and version the file on the SVN server. The >>> developer >>> checking out code gets the .sql file and updates his DB. But I notice >>> this >>> strange error in the logs: >>> >>> Exception: org.ofbiz.entity.GenericDataSourceException >>> Message: SQL Exception while executing the following:INSERT INTO >>> SERVER_HIT >>> (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, >>> RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, >>> SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, >>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, >>> INTERNAL_CONTENT_ID, >>> PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES >>> (?, >>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or >>> update a child row: a foreign key constraint fails (`xsport/SERVER_HIT`, >>> CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` >>> (`VISIT_ID`))) >>> >>> Every hit to the server gives this error. I know this is not normal and I >>> was wondering if this is caused because we abruptly change the db's state >>> whenever we check-out from the repo, and the db is somehow out of sync >>> with >>> the servelt engine. Also, any better ways for code sharing and db >>> consistency? I'd love to hear what everyone thinks. >>> >>> Thanks, >>> Anshuman Manur >>> >>> >> >> >> -- >> Regards, >> >> Abdullah Shaikh >> Viithiisys >> >> >
