Category: OS independence (Non-Linux, Windows/IIS, Mac, BSD)

When opening Admin>Admin home on a Windows-Server, you get the Error-Message:
{img src=images/code.png}%%% {CODE()}
Warning: fsockopen() [function.fsockopen]: unable to connect to tikiwiki.org:80 (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ) in D:\server\htdocs\tiki\lib\twversion.class.php on line 51

Notice: Undefined variable: major in D:\server\htdocs\tiki\lib\twversion.class.php on line 114
{CODE}

This is might be related that the Server needs a proxy to connect to the Internet but i'm not sure how to set it up in Apache/PHP (Using Apache 2.2.2, MySQL 5.0.21, PHP 5.1.4 + PHP 4.4.2-pl1 + PEAR, Server W2003 R2)

User Rajesh got the same Error:
[hhttp://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=28971&highlight=fsockopen|here]

{syntax type="tiki" editor="plain"}
On updating Tiki 5.2 and earlier to 6 errors occur during installation.

^Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement
fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO MYSQL_ATTR_USE_BUFFERED_QUERY attribute.^

The problem is discussed [http://tiki.org/tiki-view_forum_thread.php?comments_parentId=39458&topics_offset=5&topics_sort_mode=lastPost_desc&forumId=6|over here]

--
Chealer:
This does not happen upgrading from a clean install of 5.3 to 6.0. But it happens when upgrading from 5.0 to 6.0. The most problematic script appears to be 20100927_better_column_fix_tiki. The first query (getOne() on information_schema) seems to be the sticky unbuffered query sometimes, since the following, second query fails. I tried but couldn't find how to confirm what query is stuck. It's odd that this problem only happens in the installer. getOne() just like query() use fetchAll() so we shouldn't see this problem. Setting MYSQL_ATTR_USE_BUFFERED_QUERY doesn't seem to help. After some 10 hours of debugging I'm under the impression this is a PDO bug. This looks like http://bugs.php.net/bug.php?id=44081 If anyone wants to try fixing, I recommend speaking to me first. The PDO documentation is very poor, making this really difficult.
20100927_better_column_fix_tiki was introduced in 5.3.

I found upgrades would work with PDO in certain environments. I had the bug on PHP 5.2.13 but upgrading to 5.3.3 fixed. PHP 5.3 can use mysqlnd, which I suspect doesn't have this problem. The upgrade worked for me on vanilla PHP 5.3.3 or PHP 5.3.3 from EasyPHP, both with mysqlnd. I have no clue why this problem seems to only affect Windows, but I saw reports of similar problems on Debian etch, so it may not be completely Windows-specific. Anyone who experiences this problem, please report your PHP version, and if you use PHP 5.3, indicate whether you use libmysql or mysqlnd.

The goal is to have a USB key version of Tiki.

Possible uses:
#Easy testing on a Windows desktop
#Have a backup of your Tiki on your MP3 player
#etc


Possible partners:
http://www.easyphp.org/
http://portableapps.com/apps/development/xampp
http://www.uniformserver.com/

Environment: Windows Server 2008 + IIS7

Problem: After installation, you're directed to tiki-change_password.php. The URL ist correct (in my case: "http://www.prohibition-online.com/tiki-change_password.php[...]"). I change the password and land on "http://www.prohibition-online.com/tiki-index.php".

Now I click onto logout and the URL I get to is:
"http://www.prohibition-online.com\/tiki-index.php".

Notice the "\" after my website name.

If I remove the "\", I access my index page as expected.

When I login, the "\" reappears.

same error as: http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=2250&trackerId=5&show=view