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
