Page 1 of 1

phpMyAdmin,Help Please

Posted: Tue Oct 29, 2002 11:55 pm
by mrrobotto
:? Win98SE, I have been trying to get phpMyAdmin 2.2.6 configured with mysql 3.23.53-max-debug and PHP 4.2.3 running on Apache 1.3.27. The directories are as follows:

C:\php folder and mysql folder
C:\Windows\sapi folder with the files php.ini and php4ts.dll
C:\Programs files\Apache Group\Apache
PhpMyAdmin is as follows:
C:\Program files\Apache Group\Apache\ht.docs\phpMyAdmin

I have read all the documents, installation, configuration, faq’s on Apache.org, php.net, mysql.com, and phpMyAdmin.com along with hunting through the support forum form phpMyAdmin for similar problems to try and find a remedy.

I am connecting to phpMyAdmin like so http://127.0.0.1/phpMyAdmin/index.php this is loop back not the internet so ignore the hyper link and I get the phpMyAdmin showing that it is connected to mysql server. If I use the same address as above with omitting the index.php and just use phpMyAdmin I get index of/phpMyAdmin showing me everything that is in phpMyAdmin.

The problem that I am experiencing is that phpMyAdmin is running and shows that it is connected to mysql server I can make a data base and everything seems to work fine the problem is that above Welcome to phpMyAdmin I am getting the following warnings


Warning: Cannot add header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\phpmyadmin\config.inc.php:288) in c:\program files\apache group\apache\htdocs\phpmyadmin\main.php on line 16

Warning: Cannot add header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\phpmyadmin\config.inc.php:288) in c:\program files\apache group\apache\htdocs\phpmyadmin\libraries\ob.lib.php on line 53

Warning: Cannot add header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\phpmyadmin\config.inc.php:288) in c:\program files\apache group\apache\htdocs\phpmyadmin\header.inc.php on line 23

And it continues with the same warnings except it just states what line it is on the continuing numbers are 24, 25, 26, 27, and 29 then in the left hand bar is the following warnings:

Warning: Cannot add header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\phpmyadmin\config.inc.php:288) in c:\program files\apache group\apache\htdocs\phpmyadmin\libraries\ob.lib.php on line 53

Warning: Cannot add header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\phpmyadmin\config.inc.php:288) in c:\program files\apache group\apache\htdocs\phpmyadmin\left.php on line 45

And continuing on the numbers are: 46, 47, 48, 49, and 51.

I found the following from phpMyAdmin documentation faq
[2. Configuration]
[2.1] The error message "Warning: Cannot add header information - headers already sent by ..." is displayed, what's the problem?
Edit your config.inc.php or .php3 file and ensure there is nothing (ie no blank lines, no spaces, no characters...) neither before the <?php tag at the beginning, neither after the ?> tag at the end.
I check this and could find nothing wrong. Then I found a similar problem that was posted on a forum and the answer was that Into php.ini file :

;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;
file_uploads = On
upload_tmp_dir ="/Your_exact_temporary_directory_path/"
upload_max_filesize = 2M

François
Hi!

Since you did not define your "upload_tmp_dir", PHP tries to put uploaded files to the "./tmp" one that do not exists or can't be reached.

Loïc
I checked the php.ini file and it reads the same as above and the upload_tmp_dir= is empty but it states that if it is empty that it will default to your system; below is out of the actual file.
Whether to allow HTTP file uploads.
file_uploads = On

; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
;upload_tmp_dir =

; Maximum allowed size for uploaded files.
upload_max_filesize = 2M
However, if I had to put a location in here I am not sure what to put. Would it be like the temp folder in windows or what? I have not been able to locate any documentation on this particular entry maybe I am just missing something here that is probably something simple.
Like I stated previously it seems to be working with the exception of these warnings, which I would like to clear up. There is one thing that I have been pondering on is that there has been some reported problems with PHP 4.2.3 that people have been having with registered_globals because it has been set to off by default and I have turned it back on so I could follow the code that is being used in a class that I have and the server that I have access to has an older version of PHP on it. But I really don’t think that would cause the problem.
I have read through so many documents trying to resolve this problem That I am probably starting to think of things that have no bearing on the problem. So I guess that means it is getting time to take a break.
Any help with this would be greatly appreciated as I have almost exhausted all the means I know of at this time. TIA

“The only source of knowledge is experience” Albert Einstein

Posted: Wed Oct 30, 2002 2:24 am
by twigletmac
Have you tried installing the latest version of phpMyAdmin (http://www.phpmyadmin.net/) you might have a buggy one.

Mac

Posted: Wed Oct 30, 2002 7:09 am
by mrrobotto
I have the most recent stable recommended version and have redownloaded and reinstalled once already. I guess I could do it again if I have to.

Posted: Wed Oct 30, 2002 7:16 am
by twigletmac
Try installing version 2.3.2 which is the most current version. If you still get the error message, post what's on and around the line in the config.inc.php file mentioned in the error message (in the error messages that you posted this would be line 288).

Mac

Re: twigletmac

Posted: Wed Oct 30, 2002 12:18 pm
by mrrobotto
:D I found the problem it was the two blank lines at the end of config.inc.php file. The problem was pointed out to me in the following:

[2. Configuration]
[2.1] The error message "Warning: Cannot add header information - headers already sent by ..." is displayed, what's the problem?
Edit your config.inc.php or .php3 file and ensure there is nothing (ie no blank lines, no spaces, no characters...) neither before the <?php tag at the beginning, neither after the ?> tag at the end.

Now I have one other small problem to clear up and that is I have to use phpMyAdmin/index.php to get it to open. If I use just phpMyAdmin I get Index of/phpMyAdmin showing me the index listing.

I think that problem is in Apache httpd config file. What do you think about if that could be it.

I didn't have a php text editor so I didn't catch it. It works great so far. Thanks for your help.

“The only source of knowledge is experience” Albert Einstein

Posted: Thu Oct 31, 2002 2:19 am
by twigletmac
You need to adjust the DirectoryIndex directive in your config file from something like:

Code: Select all

DirectoryIndex index.html
to something like

Code: Select all

DirectoryIndex index.php index.html
to have index.php recognised throughout your site as a default page.

For turning off automatic directory listings: http://httpd.apache.org/docs/misc/FAQ.html#indexes

Mac

Posted: Thu Oct 31, 2002 4:09 am
by mrrobotto
Thanks for the help appreciate it. :)