Columns not getting set to autoincrement

Search Options	close
Search the following clips: All Clips

news science politics food economy art
technology health internet religion psychology

Sign Up Install Learn More Login


	Columns not getting set to autoincrement

bestcoupon

9-7-2009 6:26 AM

71 views

tags:

webhosting, couponshost, webhost, autoincrement, hosting, coupons

bestcoupon says:

I’d like to figure out why the upgrade of the tables wasn’t properly executed so that I can upgrade safely in the future.

Add a Comment

Login to Comment. Not a member yet? Sign up

Today's Top Clips

visit the Top Clips page

View the Top Clips from September 7, 2009

Embed This Clip In Your Site...

<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/a68f70e0-8374-486f-a57f-a84e9ac9fad6/92DBE410-986E-4059-B448-359DB74D3E85/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://www.hostingcoupons.org/columns-not-getting-set-to-autoincrement/" href="http://www.hostingcoupons.org/columns-not-getting-set-to-autoincrement/" style="font-size: 11px;">www.hostingcoupons.org</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.hostingcoupons.org/columns-not-getting-set-to-autoincrement/"><H1><A title="Permanent Link to Columns not getting set to autoincrement" rel="bookmark" href="http://www.hostingcoupons.org/columns-not-getting-set-to-autoincrement/">Columns not getting set to autoincrement</A></H1></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.hostingcoupons.org/columns-not-getting-set-to-autoincrement/"><div align="center"><img src="http://content7.clipmarks.com/blog_cache/www.hostingcoupons.org/img/26CA511C-984B-4494-B3BE-3885A8EA6A24" alt="" /></div></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.hostingcoupons.org/columns-not-getting-set-to-autoincrement/"><P>I’m in the <A href="http://www.hostingcoupons.org/drupal-hosts-problem-upgrading-from-610-to-611/">process of upgrading a site from Drupal</A> 5 to Drupal 6, and I’ve run across a strange problem. In the upgrade process, so far I’ve found 2 different contrib modules (user relationships and guestbook) specify as part of the upgrade (in the upgrade portion of their .install files) to change their primary key column to be type “serial”. After some investigation, it seems one of the attributes of a serial column is that it is set to auto-increment. The problem I’m seing is that the columns for some reason did not get to auto increment, and did not get set to be primary keys. The result is, for example, that all new guestbook entries were getting created with the same ID of zero. This leads to faulty <A href="http://www.hostingcoupons.org/magento-hosting-add-custom-module-in-admin-panel-menu-bar/">behavior of the module</A>. Once I discovered the problem I manually set the columns to be autoincrement, deleted the entries with ID = 0, and everything works.</P></blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/92DBE410-986E-4059-B448-359DB74D3E85/blog/" title="blog or email this clip"><img src="http://content8.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>

New from the makers of Clipmarks: Amplify.com - Don't just share the news...Amplify it!

Clipmarks: Home; New Clips; Top Clips; Dashboard

Popular Topics: News; Life; Science; Technology; Entertainment

Get Started: Sign Up; Install Clipping Tool; How Clipping Works; Clip-to-Blog™; ClipSearch

Tools and Resources: FAQ; ClipWeek; Top Clippers; Top Tags; Site Map

About Clipmarks: About Us; Contact; Copyright; Privacy; EULA

Search Options

Today's Top Clips