mysql

Quick Drupal setup using Acquia's DAMP stack

Submitted by Charles on Mon, 03/09/2009 - 07:35

Acquia have released an all in one Drupal install which includes Acquia Drupal, Apache, MySQL, PHP, PhpMyAdmin, and an Acquia Drupal Control Panel, to allow users to easily test and play around with Drupal, without having to get into the technical details of installing separate instances of Apache, MySQL, PHP etc.

Check it out here: http://acquia.com/downloads

Drupal node insert error related to the sequences table

Submitted by Charles on Fri, 02/09/2007 - 12:53

I recently added a lot of data to a drupal site by running some scripts that I'd created in php. This was to save me the time of manually capturing the content. After successfully adding the content, when I tried to add a new content item, I got the following error: Warning: Duplicate entry '503-503' for key 1 query: INSERT INTO node (nid, vid, title, type, uid, status, created, changed, comment, promote, moderate, sticky) VALUES (503, 503, 'World Bank ', 'content_organisation', 1, 1, 1171017191, 1171017191, 2, 1, 0, 0) in It turns out that Drupal uses the sequences table to keep track of what the highest id in certain tables is. I had forgotten to update this table with the id of the most recent node that I'd added.