duplicate-entry

mysql duplicate entry error when there is no duplicate entry (bulk load via php)

i am using mysql (5.0.32-Debian_7etch6-log) and i've got a nightly running bulk load php (5.2.6) script (using Zend_DB (1.5.1) via PDO) which does the following: truncating a set of 4 'import' tables bulk inserting data into these 4 'import' tables (re-using ids that have previously been in the tables as well, but i truncated the whole...

MySQL: duplicate entry error with SELECT...INSERT INTO with UNIQUE constraint

I've got the following table: CREATE TABLE `products_quantity` ( `id` int(11) NOT NULL auto_increment, `product_id` varchar(100) NOT NULL, `stock_id` int(11) NOT NULL, `quantity` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `product_id` (`product_id`,`stock_id`), KEY `products_quantity_product_id` (`product_id`), KE...

Duplicate entry error in MySQL/Hibernate

Hi all, I am facing the following problem and can't find a proper solution. I have a relation A with the attributes id, x (foreign key), y (sequence number) and z (content). Further there is a uniqueness constraint on x-y. That is usually I have tuples like (455, 159, 1, ...), (456, 159, 2, ...), (457, 159, 3, ...), etc. I'm using Hiber...

removing duplicates in my values in database

I have a Vb form that inserts data into multiple tables and maintains the foreign key using a sope_identity. I am using an insert procedure to deal with the insertion. My problem is that why i insert my values in VB and click the insert button the values in the database are duplicated. i need to prevent this from happeing. Any ideas p...

Hibernate join tables duplicate entry - Could not execute JDBC batch update

I have a simple domain class Licensee: @Entity @Table(name = "LICENSEE") @Cache(usage = CacheConcurrencyStrategy.READ_WRITE) public class Licensee implements Serializable, Comparable { private Integer id; private String orgName; /* ... */ private Set<Address> address = new HashSet<Address>(); @Id @Column(name ...

Can you integrate Java 1.6 classes into Eclipse Blackberry project?

i am using the latest IDE for eclipse and have attached the blackberry 5.0 sim. i am a new bb developer and i was wondering if there is any way of integrating java 1.6 classes (or any 3rd party jars) within the blackberry project without getting an error similar to the following: org.apache.axis2.util.Utils$3: Warning!: Duplicate metho...

Duplicate key issue with Spring and Hibernate - assistance needed

--Summary (shortened)-- I have a controller that loads a profile object from the corresponding DAO. It updates some properties, many of them sets, and then calls saveOrUpdate (via save in the DAO) to reattach and update the profile object. At seemingly random intervals, we get an org.hibernate.exception.ConstraintViolationException, w...

Log4net duplicate logging entires

I recently switched out log4net logging from using config files to being set up programmatically. This has resulted in the nhiberate entries getting repeated 2 or sometimes 3 times. Here's the code. It uses a string which looks something like this "logger1|debug,logger2|info" private void SetupLog4netLoggers() { IAppe...

Searching through large data set

how would i search through a list with ~5 mil 128bit (or 256, depending on how you look at it) strings quickly and find the duplicates (in python)? i can turn the strings into numbers, but i don't think that's going to help much. since i haven't learned much information theory, is there anything about this in information theory? and si...

ASP.Net MVC 2 - better ModelBinding for Dictionary<int, int>

Hi, In some special cases you will need a list of textboxes (to deal with n - n associations) whose id is not know before runtime. Something like this : http://screencast.com/t/YjIxNjUyNmU In that particular sample I'm looking to associate a count to some of my 'templates'. in ASP.Net MVC 1 I coded a Dictionary ModelBinder to have a c...

MySQL: updating a row and deleting the original in case it becomes a duplicate

I have a simple table made up of two columns: col_A and col_B. The primary key is defined over both. I need to update some rows and assign to col_A values that may generate duplicates, for example: UPDATE `table` SET `col_A` = 66 WHERE `col_A` = 70 This statement sometimes yields a duplicate key error. I don't want to simply ignore...

Duplicate entry when trying to edit a record

When i try to a edit a entry.. its creating a duplicate entry in the database. i have made sure i add an hidden id field when i go to the edit form. Restaurant RestaurantAttribute RestaurantContact these are the models i am using. tried reinitialize the id $this->Restaurant->id = $this->Restaurant->id; strange... in the db the ex...

how to prevent duplicate data if data get from DB?

dear all. i have a form that consist of two textfield and one combobox. i want prevent the duplicate entry data from client side. i get combobox data from DB, like: <select id="line" name="faline" > <?php $sql="SELECT `Line_Name` FROM `prod_sch` WHERE `Line_Name` LIKE 'FA %' GROUP BY `Line_Name` ORDER BY `Line_Name`"; if ($sql) { ...

fbconnect include not found by xcode

when the following include is added to my project, xcode fails to find it: import "FBConnect/FBConnect.h" i have added the facebook src directory to the header include path and the user header include path in the project and target settings. when i change the include to #import "FBConnect.h" the file is found, but i get a duplicate sy...