Welcome, Guest

Want to take part in these discussions? Sign in if you have an account, or apply for one below

• Forgot your password?
• Apply for membership

1. • CommentAuthorsilencio
   • CommentTimeOct 19th 2006

    permalinkBuy a Drink
   I am just curious if WordPress can be installed on a Windows server okay with php and mysql installed on it. Anyone have any experience with this type of install?
   
   Charlie
2. • CommentAuthorBuchwald
   • CommentTimeOct 20th 2006

    permalink
   I have don ones - I have taken the information from wordpres Italy.
   
   http://www.wordpress-it.it/forum/topic.php?id=296
   
   To translat italien to english i use http://babelfish.altavista.com/
   
   If that not help you just try:
   http://www.google.com/search?hl=en&q=wordpress+on+windows+server&meta=
   
   Best
3. • CommentAuthorsilencio
   • CommentTimeOct 20th 2006

    permalinkBuy a Drink
   Buchwald,
   
   Thanks I will check that out.
   
   I installed it, set the permissions (which is done differently than with a Linux machine) and then received this error
   
   
   
   WordPress database error: [Data truncated for column 'autoload' at row 1]
   INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('sm_cpages', 'a:0:{}', 'Storage for custom pages of the sitemap plugin', '')
   
   
   Thoughts?
4. •  
     CommentAuthorDenis
   • CommentTimeOct 20th 2006

    permalinkBuy a Drink

   Hi Charlie,

   My laptop (my primary development site) is running Windows XP with IIS, php as cgi, and MySQL. So things should work fine. From the looks of your site, it is a MySQL config problem. Please verify that your server is running a very recent version of either MySQL 4 or 5. If it is running MySQL 5, make sure it is NOT running in strict mode, as a casting problem is likely causing your truncated error (the query tries to insert an empty string into an integer field).

   Also, the democracy autoinstaller apparently wasn't triggered. You can disable the plugin, and reenable it to manually force it.

   Best, Denis

5. • CommentAuthorsilencio
   • CommentTimeOct 20th 2006

    permalinkBuy a Drink
   Thanks, I deactivated the democary plugin and have contacted support. Thanks much that helps a lot to pin it down.
   
   Charlie
6. • CommentAuthorsilencio
   • CommentTimeOct 20th 2006

    permalinkBuy a Drink
   Denis,
   
   Here is their reply
   
   "I believe I have corrected this problem. You currently have MySql 5.0.26 installed. The default sql mode for this version of mysql is "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION". I changed the mode to "MYSQL40" and restarted MySql on the VPS. I am no longer seeing any error on the page. I am not 100% sure that this is the sql mode the application requires. You may want to double check with your developers to see what mode they recommend."
   
   Seems to be working better but now I have an adspace problem.
   
   "WordPress database error: [Table 'mycoloradomort.wp_ad_blocks' doesn't exist]
   SELECT ad_blocks.* FROM wp_ad_blocks as ad_blocks INNER JOIN wp_ad_block2tag as ad_block2tag ON ad_block2tag.ad_block_id = ad_blocks.ad_block_id WHERE ad_block2tag.ad_tag_id = 'inline' ORDER BY ad_blocks.ad_block_name"
   
   When I deactivate it I don't get this error.
   
   Any Suggestions?
   
   Charlie
7. •  
     CommentAuthorDenis
   • CommentTimeOct 21st 2006

    permalinkBuy a Drink

   Eww, that one's tricky, because Ad Spaces never was designed to be reinstalled... You can try the following query in phpmyadmin:

   delete from options where option_name = 'sem_ad_space_params';

   And then visit an admin page. This will trigger the autoinstaller once again. You might get a couple of errors on the first page load, but it should work fine right after.

   D.