Search results matching tag 'php error'

PHP EXCEL EXPORT error!!

gvardan — Mon, 28 Sep 2009 15:32:37 GMT

Hi,

We just moved all our php based web applications to windows server running IIS 6.0.
Exporting to Excel function is unfortunately not working in the applications only in Internet Explorer.
I believe its something to do with IIS MIME types after i went through some forums. I set the MIME type for .xls and .xla as application/vnd.ms-excel in IIS.
But still I'm getting error attached below..

This is my header details in php

    header("Content-Disposition: attachment;filename=QueryExport-NRBN".date("Y-m-d_hms").".xls");
    header("Content-Type = application/download");
    header("Content-Transfer-Encoding: binary");
    header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    header("Expires: 0");

i hope someone can help me out.

Thank you,

IIS 6; PHP 5; MSSQL 2000; PHP exec() command

jdarbyshire — Fri, 05 Dec 2008 02:10:55 GMT

I am running a Win2k3 server with IIS 6 with PHP 5 installed as a CGI executable.

I have the following code:

<?php
exec("c:\windows\system32\schtasks.exe /Query", $output);
print_r($output);
?>

In 'schedule.php', which runs fine on my local test server (Win XP, Apache, PHP 5) returning an array containing all the scheduled tasks on this computer.

When migrated to the server the page loads with no PHP errors, however returns an empty array. It also appears that schtasks is not run.

I suspect this is to do with windows user permissions. So added %COMPUTERNAME%/IUSR_%COMPUTERNAME% to the security tag of the C:\ and D:\ drives and the C:\PHP folder, C:\WINDOWS, C:\WINDOWS\System32 and also SCHTASKS.exe. No avail - still no exec() command.

I have queried the server using the php system() command which returns no username, but implies that the default user profile is being used to run the page. Code used as follows:

<?php
echo '<pre>';
system('set', $retval);
echo ' </pre>';
?>

I am wanting to use exec() to run schtasks and query scheduled tasks, create tasks and delete them so I can do server maintenance from a web interface.

Using ASP is not really an option as there is a possibility that in the future it may need to be run on a Linux based system.

Thanks for any help in advance. Much appreciated!!

PHP-phpcfg failed

cjnr — Wed, 03 Dec 2008 23:29:27 GMT

Hi Everyone

I run IIS7 on windows server 2008 and Plesk 8.6 Control Panel

The server is returning the following error :
Server Error
404 - File or directory not found.
The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.

If i change the PHP version to 4.4.7, i have a error message.
Then i change it back to 5.2.6, i have about the same error message (check below)
If i try again change the PHP version to 4.4.7, it works.
Then i change it back to 5.2.6, it works.
Then the website is working.

BUT, after a couple of hours, it stop working.

Then i have to redo the same operation to get it back !

How i can fix this issue ?

----------------------------
phpcfg failed: Execute websrvmng --set-scripts "--vhost-name=domainname.com" "--scripts=<scripts action='add'><script name='php' php_version='5' php_handler_type='cgi' /></scripts>" "--app-name=/" failed: C Exception: 3221225477
---------------------- Debug Info -------------------------------
0: plib\class.PhpManager.php:207
PhpManager->callPHPCfg(array)
1: plib\class.PhpManager.php:97
PhpManager->setVersion(string '5')
2: htdocs\domains\php_changeversion.php:30

mssql_connect() failed with remote SQL Server

MainMa — Thu, 17 Jul 2008 11:50:07 GMT

Hello.

I have a problem with mssql_connect() when connecting to SQL server over network.

My computer is inside a domain. There are two SQL servers: the first one on my PC (on localhost), the second one on a Windows Server 2008 remote computer (remote) inside the domain. Both are SQL Servers 2005.

On localhost, I have IIS7 with PHP5 running through Isapi. When I try to connect to the SQL Server on localhost with $this->Link = mssql_connect();, it works great. But $this->Link = mssql_connect('remote'); fails with "mssql_connect(): Unable to connect to server" error.

I tried everything described in the comments at http://www.php.net/manual/en/function.mssql-connect.php. Nothing seems to work, and I cannot connect to SQL Server on remote neither through Windows authentication, nor through SQL one. By the way, I can connect to remote (both with Windows authentication and SQL one) with SQL Server Management Studio.

What's the problem?

PS. On remote, both TCP/IP and Named Pipes are enabled. Disabling firewalls on localhost and remote does not solve the problem.

Re: PHP.INI not picked up by IIS

khichi — Tue, 10 Jun 2008 11:51:19 GMT

You have not told that you are using PHP installer or trying to install manually,

If you are using installer than no problem, If not than try to use installer, Its best for beginners,

After installing you can find the php.ini file in system32 (C:\WINNT\system32) directory, where you can make any changes that works, and remember that after making changes in php.ini please restart the IIS to take effect.

Sorry for my bad english,

PHP5 + IIS6

Ilya_Guy — Fri, 30 May 2008 14:45:12 GMT

Hello.

I have a following problem:

I configure IIS6 @ Win 2k3sp2 to use PHP5 in ISAPI mode.

But I can see only index page with http://host:8085/ address.

If I write same address as http://host:8085/index.php I receive 404 Page not found.

This IIS support several virtual hosts and I need PHP only in one of them.

HTTP 404 PHP installed with IIS7

WhiteTimer — Mon, 14 Apr 2008 22:20:15 GMT

Hi ... I am really new to IIS7 & PHP and having followed all the suggested install and congifuration tutorials, i still cant get it to work.

I am currently running Windows Server 2008 & IIS7. I have PHP installed, set the Environmental Variable, have IIS7 fully installed and have set PHP as ISAPI.

Any suggestions as to why i am getting this error ... ?

Many Many Thanks ...

WhiteTimer

Issues with php-cgi.exe

Teryus — Tue, 26 Feb 2008 18:39:32 GMT

Hi, im new in this forum, and my english is not to good, but i tried to comunicate with us.

I installed php 5.2.5 in my web farm, and i see for many days how the task manager show a task many times with the name php-cgi.exe, that task do it to my server performance is full !!!, the server present a 100% to use in the part of performance.

If i killed the tasks php-cgi.exe, the server estabilize

I check my migration to php 5.2.5 in my web farm, and i see correct, i not see any error

Could you please help me, i dont know what is the problem in my servers, but the migration of php to the version php 5.2.5 start the problem of performance in my server.

I read about the fastcgi extension, but i dont know if to migrate to that version of php fixed my problem.

Thanks !!

Teryus

PHP file upload on IIS 6

axelay — Thu, 20 Dec 2007 11:08:36 GMT

Hi,

This is my first post here and I am pleased to find a place dedicated to IIS AND PHP.
My problem is one that has been going around for a long time as far as I can see by doing searches on google. I have a Windows 2003 SP2 server with IIS 6 installed and PHP 5. All is working fine, DB access, etc.... Apart from uploading large files (that is > 1Mb).

I found several people always asking the same question and I think I might have tried all the possible answers to this problem.
I have done the following with no success:

changed PHP.INI post_max_size and upload_max_filesize variables to higher values (20M in this case)
edited MetaBase.xml and changed the AspMaxRequestEntityAllowed variable to accept 10Mb (I think this variable is only for ASP though), added another variable MaxRequestEntityAllowed also set to 10Mb

Despite any server restart, IIS reset, server-kicking, nothing works. Any File can be uploaded without a problem as long as they are less than 1Mb. Past that size, FireFox displays "The connection was reset" and IE displays "The page cannot be displayed" straight after hitting the submit button (browsers don't even try to think)
I repeat once again that my forms and everything else works fine as long as the file being uploaded is less than 1Mb. I have the exact same script on our beta server running Windows 2000 and IIS 5 and everything work as it should.

I am not trying to point a dirty finger at anybody but this is a frustrating problem that just does not seem to have a solution. If any MS guru is around or if anybody sorted this issue, I would like some pointers.

Thanks for reading, Alex

Configuring PHP on IIS7 : Newbie question

wildthing4ever — Sun, 16 Sep 2007 13:50:52 GMT

Hi all,

I'm pretty new to all this, so please bear with me!

I wanted to run PHP+MySQL on IIS7. I've installed PHP5, and configured ISAPI as the default handler (not FastCGI). I was able to get this done, but when I get a PHP error, I get the IIS7 generic error page - error 500. It doesn't show me the exact error (missing ; etc). For example, I get:

Server Error in Application "Default Web Site"

HTTP Error 500.0 - Internal Server Error

Description: The page cannot be displayed because an internal server error has occurred.

Error Code: 0x00000000

Notification: ExecuteRequestHandler

Module: IsapiModule

Requested URL: http://localhost:80/test/test2.php

Physical Path: C:\demo\test2.php

How do I configure IIS7 to show the actual error?

Thanks!