Drupal 5 to 6 duplicate entry problem

I moved one of my last sites over here to my new hosting environment. This is probably my oldest. It's been around since some time in the Drupal 4 series, at least 3 years.

When I moved it here I upgraded it to Drupal 6 from 5.7. This created some problems that resulted in not being able to make comments as well as other issues that boiled down to minor problems with the database causing big problems.

Here is an example error message we received from the watchdog module. The comment module provided something similar.

user warning: Duplicate entry '0' for key 1 query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (24, 'user', 'Session opened for %name.', 'a:1:{s:5:\"%name\";s:2:\"Ed\";}', 5, '', 'http://site.com/node/353?destination=node%2F353', 'http://site.com/node/353', '', 1215526129) in /home/user/public_html/modules/dblog/dblog.module on line 144.

It turned out that these database tables simply didn't have auto_increment set. In Drupal 6, the developers changed the way they handle the incrementing of the record IDs. They are using the database feature to handle it now instead of doing it themselves in the code.

The resolution to this was a couple of simple SQL commands to turn on auto_increment where it was needed. Here they are.

alter table comments modify cid int(10) auto_increment;
alter table watchdog modify wid int(5) auto_increment;

perumahan batununggal bandung

The other active ingredient in Anthem isperumahan batununggal bandung. Universities have conducted research on both ingredients since the early

I think it is one of the best

I think it is one of the best writing services, rushessay.com reviews topessayservices.com and I am said to develop our education and business life. So we are getting good thoughts. Thanks for providing your education tips to me and to us.

Watercolor Paintings

This particular exercise probably offers root base inside considerably more mature exercise associated with dental messaging in addition to may have been Watercolor Paintingsbuilt using a pre-existing national infrastructure.

Hologram projection

We've by now book marked this site. This short article is method greater than the last content We have study. I appreciated Hologram projection reading this post as well as I entirely trust your current thoughts and opinions. Maintain the great operate.

What should we do with the

What should we do with the duplicate lines? Should I remove them?

I will use what you said, I

I will use what you said, I will try to implement your code!

For sure you will solve this

For sure you will solve this problem. Your strategy is the best, I will do it!
click here

First You got a great blog .I

First You got a great blog .I will be interested in more similar topics. i see you got really very useful topics , i will be always checking your blog thanks.
buy instagram followers cheap

Durpal up-gradation will

Durpal up-gradation will continue unless you change your script in your hosting files where it has proper destination. I think you must hire some one who is an expert in knockdownreviews and may know how to write java and c language scripts. It is what we are looking for because we also need some one specialist to change website language which is designed in php format. If you think then you must send us latest updates.


I have already bookmarked this blog. This article is way better than the previous articles I've read.I really enjoyed reading this post and I totally agree with your opinion. Keep up the great work. Thanks a lot!
- vacation rental lombok
- http://www.asian-retreats.com


Now my business is holding that issue as well as our send chimp kitchen table insertions. In which failed to build the DIABETES EXHIBITION actual auto-increment about, i really further which for your nid collection. About a fresh retest Now my business is nevertheless trying to keep the difficulty. Any kind of ideas can be loved.

Gemtot Ibeacons online

Now i am possessing this matter together with my personal mailchimp table insertions. That did not develop the auto-increment about, and so i extra that for the nid line. Upon a new retest Now Gemtot Ibeacons online i am nevertheless keeping the trouble. Any kind of suggestions would be treasured.

One of the biggest arguments

One of the biggest arguments for fibre channel against iSCSI is the speed advantage it has.

World best iBeacons for sale

This nid line within your mail chimp dining room table probably ought not automotive increment. I avoid mail chimp so cannot claim beyond doubt, however the nid is probably the mention of the the particular node that is stashed in another dining room table where by it would automotive increment there rather than within the mailchimp dining room table. There may be another line in which indicates an exclusive report in mailchimp's files.World best iBeacons for sale

didn't work for me

I'm having this problem with my mailchimp table insertions. It did not have the auto-increment on, so I added it to the nid column. Upon a retest I'm still having the problem. Any ideas would be appreciated.

The nid column in your

The nid column in your mailchimp table probably should not auto increment. I don't use mailchimp so can't say for sure, but the nid is probably a reference to the node that is stored in another table where it would auto increment there instead of in the mailchimp table. There may be another column that indicates a unique record in mailchimp's records.

I received this question

I received this question through my contact form, but the email address is bad so let me bring it out here.
"Just quick question. When you say "where it was needed" in this post what do you mean? Where is "where it was needed"? I am kind of new to Drupal but am comign along nicely but I have no idea where to start with this one?"

My answer:
Where it was needed means the columns that require auto increment. In the SQL commands above you see, 'cid' and 'wid' as the column names. These had to be turned into auto_increment enabled columns. These commands do exactly that.


Yeah indeed it is true that the author has been revolving around drupal old version for quite some time. Even though I have done the up gradation from 5 to 6. I have encountered the same error message while upgrading to the newer version.
golden age cheese