I migrated two Drupal ites from one development server (Windows XP, Apache and LAMP) to another development machine (Vista Ultimate, IIS 7, and WAMP). The production server will be Windows Web Server 2008 and IIS 7.
After I copied everything, the sites both look fine.
However, no changes occur to any settings. For example, the one site was left in Maintenance mode. If we tried to turn off Maintenance mode from Drupal Administration, the setting simply would not change. However, if we go to the mySQL databases and access the Variables table, we can change the setting manually from phpMyAdmin and everything changes just fine.
We're using the mySQLi driver for the Drupal sites.
This is weird that Drupal can read the tables but cannot save any changes back to the tables.
That leads me to wonder if Drupal is using a read-only cursor.
The logs are free of errors. Both the Drupal logs and the Windows event logs.
Cheers,
Mitch
Comments
Problem Fixed
This took lots of time to figure out.
IIS 7.0 with FastCGI enabled does not handle URI_REQUEST like Apache. This causes problems with Drupal (and several aother CMS, such as Joomla and Wordpress).
Microsoft has released a fix. I download it and installed it, and then everything worked fine.
Cheers,
Mitch