PHP :: Change From Win To Linux Server Caused Error SQL State 01S02

PHPMYADMIN Upgrade Caused Table Structure To Change
My host provider recently upgraded the phpmyadmin to 2.9.2 and mysteriously there were then problems with my website.

First of all, in some tables enum fields were changed. For example Paragon 1,2,3,4 got changed to Paragon 1ÿ2ÿ3ÿ4. Replaced the , commas with y with 2 dots. Also, my cart whcih uses cookies starting to act very strange.

Has anyone ever experienced anything like this. Host provider cannot understand this. I did spot an error when I logged into phpmyadmin that the mbstring was not installed so the host porovider fixed this and all seems to go back to normal but I would like to find out what exactly happened.

Date In Apache2's Error Log When Error Caused By PHP
I've noticed since moving from Apache1/mod_php4/linux to
Apache2/mod_php5/linux that when an error is produced by PHP and put in
the error_log, the date is no longer logged as well:

Apache1/php4/linux example in Apache error_log:

[Thu Jan 8 15:06:52 2004] [error] PHP Warning: opendir(/foo/bar/): failed to open dir: No such file or directory in /blah/something/listing.html on line 84

Apache2/php5/linux example in Apache error_log:

[client 1.2.3.4] PHP Notice: Undefined variable: browserline in /foo/bar/zing.html on line 18

Is there any way to restore this, either at PHP or Apache level?

Prevent DB Timeout Caused By Server Load
Is there any way to prevent mysql from timing out after 60 seconds without a connection? I am having trouble with php pages taking a long time loading on my web host. I called them, but they said it was a temporary overload on my domain. The thing is, temporary doesn't seem temporary; it seems like a lot longer then that.

So does any one know a way to display database content with mysql after 60 seconds with no connection? I'm sure the answer probably is "no", but I figure it would not hurt to ask.

SQL Error: , SQL State 00000 In SQLConnect
Client is running PHP 4.0.5. on Win2K Professonal SP2 outfitted with Apache 1.3.2. Trying to connect to an Access 2000 DB using a standard odbc_connect() call. The DB is fine, all looks good, but this error is returned:

Warning: SQL error: , SQL state 00000 in SQLConnect in c:program filesapache groupapachehtdocsstaffindex.php on line 10

Anyone seen this one before?

Change From FreeBDS To Linux
Our main host is changing from FreeBDS (Is that right?) version 4.11

to Linux : CGI30 2.4.1,

Is there any major changes that need to be aware of?

Or should I wait until i encounter an actual problem....

(my scripts dont use any fancy commands or anything - Mainly fopens /fwrite / echos etc... ) - but ive got a few other commands throughout my many scripts...

Warning: SQL Error: [Caché ODBC][State : 08S01][Native Code 461]
I'm trying to connect PHP on Caché Database and I'm having a problem. This is the error:

Warning: SQL error: [Caché ODBC][State : 08S01][Native Code 461] [c:phpphp.exe] UNKNOWN MSG, SQL state 08S01 in SQLConnect in c:program filesapache groupapachehtdocscache_test.php on line 27

PHP knowed the ODBC Driver for InterSystem's Caché, but it stops in this problem. How can I resolve this?

SMTP Server - Sending Post From Php Script On Linux Server
Does any body know why send() is returning false..
where are the additional settings of SMTP server?

E-mail From Linux Server But Not Windows Server
The following one-liner sends mail from a Linux server but not from their Windows server.

mail ("admin@mydomain.com", "Subject", "body");

What do I need to check / change, please?

Linux Php -> Nt Sql Server
How can I connect from a Linux Apache server with PHP 4.0 to a Windows NT SQL Server?

On NT this is easy (load the module), but on Linux I didn't see such an option. Also I didn't see anything like --with-mssql in configure. Is it even possible?

PING Php Linux Server?
Anyone know how i can ping from a linux server to a remote machine then echo the results to the screen?

Windows Server To Linux
I have the code below which worked fine when I was using it on my windows server. However I had a few problem with the windows server then I had to switch to a Linux based server. Once the switch was completed I started having problems with a number of my codes which worked fine previously. I have managed to solve quiet a few of them with the exeption of this one which I cant figure out and was hoping you could help. Code:

Upload Script On Linux Server
My upload script is not working on Linux ,which is working perectly fine on windows 2000(localhost). my php version on linux is php version 4.2.2. Php Code:

Moving Files On A Linux Server
I need to find a way of moving files on my linux server using PHP. Because of security the folders I am moving files to require you to be logged in as the super user.

Windows PHP Connect Into LINUX Server
I want to built a windows php website---> connect to the linux box--->read all settings value from the .ini files->display it into the php website->user can then change the values->save the .ini file base on the user modification close the file-->for back up reason of settings, also save the values into SQL database. I also need to reboot the linux box after apply changes to the .ini.

Anyone knows how to approach this problem? What do I need? Does php have a built in ssh?

Mail() On Linux To Use Other Smtp Server
I have written a php site that uses the mail() on windows and i had to state in the php.ini file which smtp server to use.

have now migrated this site to a redhat 9 server, but i still want the emails to be sent via the smtp server i stated earlier.

this may infact be a sendmail question, im not sure, (perhaps changing sendmail_path in php.ini) but has anyone managed to send email via mail() in php, on a linux box, that uses an external smtp server?

Connecting MSSQL SERVER From SYBASE At LINUX
I have installed sybase ase on Linux and it is working fine. I have a database on sybase ans I am using PHP3 for accessing the database from the browser.

Now I would like to connect the MS-SQLSERVER which is on a NT server in the same network. How to set up the interface file to run both the databases.

Server Wide Scripts In A Linux Environment
I have developed a content management system and every time I want to
create some short of server wide repository of the classes I am using.

So when I update a bug I don't have to go and edit the code or upload
the new file to every virtual site I have on the server.

Do you have any ideas of what is the best way to do it ?
I am on a Linux OS by the way.

Dynamic Creation Of Graphic On Linux Web Server
I have a small PHP Project

- Accept three strings posted from form in a web page

- One of the strings will be encoded set of X/Y points
defining curves
Decode the string to X/Y points

- Create Graphic image from the data

- Send back graphic as web page to the browser

- Also save the original strings in a database and

I'd welcome any sample code.

Php Form To Create A Folder On Linux Server
Is there a simplier way rather than via the Networking tutorial example "shh with php"...? Would I still need to create the priv and pub keys? This is a form creating a folder, both on the same server btw.

Change Server Header With PHP
I would like to change my following server header for security concerns but I do not have access to httpd.conf. Is it possible to somehow override this header and provide another fake one ?

header:
Server: Apache Webserver

Photo Upload - Wont Work On Linux Server
I have this code, works perfectly on Windows server, but now i'm trying
to run it on a Linux server, the form submits, i get no errors, but the
photo doesnt upload, and the caption file doesnt write.... any ideas why?

<?php

include 'gall_settings.inc'

//check if the directory exist or not.
if (!is_dir("$upload_dir"))
{
die ("The directory <b>($upload_dir)</b> doesn't exist");
}

//check if the directory is writable.
if (!is_writeable("$upload_dir")){
die ("The directory <b>($upload_dir)</b> is NOT writable,
Please Chmod (777)");
}

//Check first if a file has been selected
//is_filetoupload_file('filename') returns true if
//a file was filetoupload via HTTP POST. Returns false otherwise.
if (is_uploaded_file($_FILES['filetoupload']['tmp_name']))
{
//Get the Size of the File
$size = $_FILES['filetoupload']['size'];
//Make sure that $size is less than 1MB (1000000 bytes)
if ($size > $size_bytes)
{
echo "<b>Error!</b><br>";
echo "File Too Large. Please try again.";
include ('gall_footer.php');
exit();

Testing Tool That Connects To External Linux Server
I seem to be having difficulties finding a tool that will allow me to debug
my PHP scripts on a remote server. All the tools I have found that run on
windows, assume a windows installation of PHP.

Configure PHP To Use A Remote SMTP Server For Sending Mail On Linux
On Linux, can you configure a remote SMTP server to send mail? I set SMTP = mySMTPserver under [mail function] in PHP.ini; I also stopped sendmail service on my local machine. There are no mails send out. If I run the local sendmail service, mails are sent out.

Compiling Error With Php 5.0.4 On Gentoo Linux 2005.1
After I installed with the instruction (as it is described in the
README) Apache 2.0 I tried to compile php.

The configure command:
../configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql
--with-openssl --with-kerberos --enable-dbx

The compilation error results:
/tmp/php-5.0.4/main/reentrancy.c: In function `php_readdir_r':
/tmp/php-5.0.4/main/reentrancy.c:193: error: too few arguments to
function `readdir_r'

How can I solve that problem?!

Email Notification When A Server File Change?
I'm looking for an script that will notify me by email or log file when any server file change.

Php Errors Going To Apache Error Log - Can't Change
I've got a problem with a bunch of "PHP Warning" and "PHP Notice"
messages being dumped into my apache error log, on a FC4 server. I
tried editing the /etc/php.ini file, changing the "error_log =" to it's
own file, and even tried turning off logging all together. No luck.
No matter what I do, these messages still end up my apache log.

Error Reading WWW Server Response (HTTP Header). Error Code: 0
I have been trying out the web based email program on this website to connect to a pop 3 client...it worked ok...but now when i try to logg in all i get is this error message...on the page Error occurred!

Description: Error reading WWW server response (HTTP Header). Error code: 0(0 = client terminated the connection unexpectedly, 2 = too many header lines) Code:

Duplication In Database Caused By Script?
I have instigated a duplication check per an earlier discussion, but now I am getting multiple additions to the data base. Here is an abbreviation of the code I am using....

Have Win/Unix New Line Markers Ever Caused Problems?
I just noticed that sometimes the php files that I upload to my webhost have different new line markings when I download the files back to my PC and open it in EditPlus (notepad and some other editors just hide the difference). I am aware that there are different new line markers vs etc. I've just never really worried about it, as my FTP client seems to do things right.

But theoretically can it break a PHP script if the new line markers weren't translated properly somewhere along the way?

I wondering if I should manually set the upload to text mode or binary mode in the FTP client, just in case.

Blank Page Caused By Undefined Index
I upgraded my php from 4.4.7 to 5.2.4 and now the entire website doesn't work. So I am trying to learn PHP and go through the site one error at a time. If you have a idea why the upgrade caused the site to fail that would be great.

But in the meantime this is the problem i am stuck on.

I get this error now when transferring to a page

Notice - PHP Notice: Undefined index: REMOTE_ADDR in c:locationSession.php on line 45.

That line has the following code.

$GLOBALS["$SessionName"]=md5 (microtime() . $GLOBALS[REMOTE_ADDR"]);

Like I said this code worked before the upgrade. Any idea what I can do to fix this problem?

Page State With Php?
I'm trying to create a site that pages through data retrieved from a database.

Let's say there are 12 items, and only 3 at a time can be displayed on a single
web page.

So the user needs to see some king of navigation control (a simple link would
suffice) that tells him there X items ahead and Y items behind. This way he can
page through all 12 items, 3 at a time, moving forward and backward.

Does this require some king of page/session state? How will my code know if
items 1 through 3 or 6 through 9 are currently displayed?

My guess is I'm not the first one who has needed to solve this kind of problem.

Search By Zipcode And State
I began in MySQL section (with your help I built a database) and now into the PHP stage of my project. Basically client wants a search capability on his site. He makes a product, sells to dealers, dealers sell directly to customers. He wants to be able to search dealer contact info by Zip and by State.

DevShed member Baddy was kind enough to offer the following script geared towards the State search. Following his lead, I developed the Zip portion- this is my first stab at PHP- and I basically mirrored whatever he did for State- I did for Zip! Code:

Saving Memory State
Is that possible to save memory state to a file? (i.e. the content of every variable)

Search City,State OR Zip Code
I would like to build a search box like the one found here at CitySearch.com .

Depending on what the user entered, the results would be sorted by (1) Zip Code, (2) City, or (3) State. If the user entered a Zip Code, I'd like to have all results be sorted by it since a Zip Code would represent the smallest geographical area. If no zip given sort by City and State. It would be easy enough to accomplish if the fields were seperated into different input fields, but I wanted to replicate the CitySearch box exactly because it doesn't take up much room on the page with only one input field.

Carry Logging State Across Pages
After login in on first page , how to carry logging state across pages. So, every login names will be displayed on the every pages. I use oracle as my back-end database.

Mainting State Inside A Function?
I have a question which no doubt will pose you people with nor problem whatsoever to help me with

I have written a function to display coherent error messages throughout my entire site

I pass it 2 vars, which contain only text
one is for the document's title, one for the error message in the body (ofcourse there is formatting etc, but thats all inside the function and CSS)

problem is, when the function gets called, it loses state, ie.: the generated page doesnt start the session properly, even though I do this inside the function

what can I do to prevent this? some elements of the site are only shown when a user is logged in, so the effects are rather dramatic ....

Create State-cty Dropdown Lists
I've gotten everything up and running except for this -- I'd like to
be able to have people have a dropdown list of cities in the US to use
(or wherever) and not have to input them manually into a text field.
When you do then there are issues of misspellings, etc.

Now I have a list of cities from each state that is a sample that
works in an html page. Problem is that it takes up 2 MB! Way too much
to load on a single page and I was wondering how this is accomplished
best -- do people use javascripts that can pull information from
another flat flie? Do people use PHP to connect to a mysql database
that might have a list of these fields and then reloads the page?

I'm really not sure of best options and would be grateful for anyone
to give me pointers or whether there are other examples and even
places to buy these databases (not likely but good to have if I decide
to do so.)

Multi-domain Session State
Does anybody have a solution on how to keep a PHP session alive across multiple domains ? A solution that does not involved writing the session ID in the URL because I can't do that.

Setting Radio Button State
I am trying to set the state of a radio button. I do not see what I am
doing wrong. Sorry, I am new at this.. I need another set of eyes to
look at this snip of code. I am trying to set the radio button with this
link of code:

echo 'SCRIPT language=JavaScript
setCheckedValue("'.$_SESSION['abbr_letter'].'");</SCRIPT>' //?

<snip of code>

<?php
session_start();
if(!isset($_SESSION['abbr_letter'])) {
$_SESSION['abbr_letter'] = 'A'
}
require_once 'includes/config.inc.php'
require_once 'includes/header.inc.php'

if (xdebug_is_enabled())
echo "enable";
else
xdebug_enable();

//
// Start a Form
?>
<HTML>
<HEAD>
<link href="quotesCss.css" rel="stylesheet" type="text/css">
<SCRIPT TYPE="text/javascript">

500 Server Error
I am installed www.phplist.com to my server but I am fetting 500 error.

I deleted "php_flag magic_quotes_gpc on" and changed permissions of admin folder to 777 and files to 644 but its the same.

And this is what I got from my provider:

This is caused by a .htaccess file that is incorrect, and you will need to remove or fix this file your website will work. More detailed information on the errors caused can be found in the logfiles folder on the root of your hosting.

Validating A Country / State Form Input
I'm having trouble validating a state and country input. I didn't write it so I'm confused about why my code isn't working with it. Code:

Server Configuration Error With PHP
I'm running into problems with a bit of test code. So, I'd like to figure out where my configuration problems lie before continuing on to build the DB.

I'm working on an NT Server, behind a firewall that is only visibile to the Intranet of a company. This server already acts as our webserver.

The Error I receive is:

HTTP Error 401

401.3 Unauthorized: Unauthorized due to ACL on resource

unless I choose to login using my Network password. I do not want users to have to login to view this site.

The PHP test code is a very simple "echo" time on server script. If I login, I can view the page.

Yes, I am an admin on the server. NO, I do not know NT Server administration well.

Internal Server Error
with the keyfocus webserver using php i get this error.

"Internal Server Error", 500 error when using a CGI request

There are many reason why a CGI request could fail, it could be that the
CGI Filter is not properly configured or the CGI application itself has
failed.

i am using frames with php and html and the problem is definitely
intermittent.

my question becomes if i put this on a web host where they use a
different
server and operating system could that eliminate the problem?
or am i stuck and have to get to the bottom of it because my code is
causing the problem?

i start off with basicframe.html and then change what goes in the
individual frames (3) using php code. when i want to reload
basicframe.html to its original appearance (the home page(s) i guess)
i use
<a href="http://127.0.0.1:8125/basicframe.html" target="_top" >
<img src="http://127.0.0.1:8125/gifs/home2.gif"></a>
and when this code is clicked sometimes i get internal server error
and sometimes i dont.

this is what my system.log shows

[2004/08/10 04:50:25.999 2 -0400] Debug MIME {INFO} <type:
application/x-httpd-php CGI action: c:phpphp.exe file: header.php>
[2004/08/10 04:50:26.059 2 -0400] External application error {INFO}
<Path: c:phpphp.exe; OS err: 0 {}>

Strange Error In Server Log
I have two Apache servers running the same site code, on on most page
accesses one gives the following error in the server's log:

PHP Fatal error: Nesting level too deep - recursive dependency? in
Unknown on line 0, referer:

The other has no errors reported. I only use require_once to include files.

Display Server Error
Is there a way, using PHP, to detect and display an error from a MySQL
server? Can I, by using error numbers or some similar method, create my own
error messages?

Array_sum() Error On Particular Server
hi I got this code of mine which works great on my test server but fails on my clients server. The 2 locations are as follows:

put some numeric values to generate triangles.... The code on both servers are identical but fails to produce any output on my clients server. It fails on an array_sum function which gives the following error:

Warning: The argument to array_sum() should be an array in /usr/local/httpd/htdocs/www.livingyourdesign.com/Jeff/index.php on line 69

The function I use is: PHP Code:

Internal Server Error
Can someone tell me why I would possibly get an Internal Server Error when trying to insert text file via phpmyadmin?

IE Cannot Find Server Or DNS Error
I have a few php3 scripts that have been working well for the past month. But as of yesterday I was working on another pc and I sometime get an error in IE saying that it cannot find the server. I does not happen all the time and it looks to appear more often when I try to upload files using php.

Smtp Server Error
First of all, I'm new to PHP. For my website I have some PHP scripts to run
a photo database. New users have to register them selfs. After registring
the new user is getting an e-mail maid by an php script. But if the user
clicks on the button to sent his info, so the PHP can sent him an e-mail, it
always results in this error
Warning: mail(): SMTP server response: 451 Request action aborted; local
processing error in {the file en line number}
In the PHP.ini smtp = localhost is set {I'm running apache under windows XP
pro) and have a mail server on the same server.

--
# Antwoord onderaan en op een lege regel, dus niet achter >>> tekens #
Ik lees alleen mail gepost naar onderstaand adres.
Mike@familie-smit.nl