I've put together a clean install of 6.19. There were some troubles in the beginning with memory management, but after I figured out a way to increase the memory limit from 32M I started everything over by doing "DROP DATABASE drupal; CREATE DATABASE drupal;" and running install.php again.

Now, every day that I log in to set up more features, the first thing that happens is that the site slower than normal and I get error messages after a bit about failed "INSERT INTO system" queries. They fail because they are trying to install themes that already exist (primary key interferes).

This includes all system themes (garland, pushbutton, minelli, etc.) and my own themes in /sites/all/themes (like zen). It does not include any modules.

Comments

andrewjsledge’s picture

andrewjsledge CreditAttribution: andrewjsledge commented

This sounds more like a database or file corruption (perhaps download corruption) issue, rather than a drupal issue. I was just able to download and install Drupal 6.19 to a test environment along with a copy of Zen theme with no issues. Perhaps try to verify the download wasn't corrupted by matching the md5 hash (for Drupal 6.19, the hash can be found at http://drupal.org/node/880546). If this doesn't resolve your issue, post some of the errors from your logs.

meustrus’s picture

meustrus CreditAttribution: meustrus commented

I looked into where this is happening, and it's in system.module on line 822, function system_theme_data. It would seem that for some reason, the "DELETE FROM {system} WHERE type = 'theme'" query doesn't work as expected. There's no error for that query, though, only the rest. It could be a problem with my MySQL server, which I'm finding sometimes "goes away" under heavy load, in which case this wouldn't be a problem with functionality, but error reporting and failing gracefully.

Status: Active » Closed (outdated)

Automatically closed because Drupal 6 is no longer supported. If the issue verifiably applies to later versions, please reopen with details and update the version.