[PHP-DB] PHP4.0.5 and PHP 4.0.6
...ive checked both versions, but they all have the same "error" inside. Lets start in the beginning. For several months my webserver has used mysql 3.23.38 AND php4.0.1 on Apache 1.3.12. I had never ANY problems so the motto was: Never touch a runnning system (oh murphy you are so damn right!). Well, i have several sites (about 40) running on this server. Never a performance issue appeared so i was glad. Within these 40 servers i have several forums and contentmanagementsystems and some stats-systems. lets take as an example: www.usrangers.net/stats/hlstats.php (hlstats 1.01) alliance.usrangers.net (phpnuke5) alliance.usrangers.net/forum (vBulletin2) these three should be a good example to the php prob i have. One day i had to install an addon to hlstats (the first link). but hlstats needs at least 4.0.4 (php) so i had to update from 4.0.1 to a more recent version. i choosed 4.0.5 because it was the most recent rpm i could find. so i did install 4.0.5 and my problems began. from now on i get a lot of times 2014:command out of sync when php did try to connect to the mysqldatabase. also i did realise that the did remove the command connection_timeout() (btw: bad attitude! never remove commands replace them by dummies! you never know how many system you will affect when you remove a command!), but that was fixed pretty fast. first i thought only hlstats is affected by this "bug" but then i realised that the other sites were too. hlstats is only more often the "caseofemergency" because it does use more often the database (it uses pretty complex and large queries). but phpnuke and vbulleting had problems as well! So please help me i dont know what to do next. i think i have tried everything, but hey - you may have an idea! Here is the webservers coniguration: dual celeron 500mhz 512mb ram 29160 u-lvd controller 130gb u-lvd harddisks (5 harddisks) intel network adapter (reference model) redhat 6.2 with most recent patches and updates kernel 2.2.18 uptime: 10:33am up 45 days, 8:14, 4 users, load average: 0.07, 0.09, 0.11 as i said before the system is 100% stable and the ONLY factor i did change WAS php4 from 4.0.1 to 4.0.5 (i did check 4.0.6 as well but there was no significant change!) sincerly Simon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Date format in MSSQL
How I can format date in php query from MSSQL? Jack -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Date format in MSSQL
Hi Have a look in Books Online - the e-docs for MSSQL - search for the convert function and all will be revealed. Peter - Original Message - From: Jack [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 5:49 PM Subject: [PHP-DB] Date format in MSSQL How I can format date in php query from MSSQL? Jack -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Oracle and adodb recordcount
Hi, I've read that Oracle (oci8) doesn't support the adodb function RecordCount : it returns -1. Is it true with adodb 1.20 ? is there a smart workaround? thanks in advance, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] ODBC error
hi everybody, when i call to my file (my_file.php), the next error occurs: [the scenario] Winnt 4.0 SP6 IIS 4 php 4.0.5 [my_file.php] ?php $con = odbc_connect('the_dsn', '', ''); odbc_close($con); ? [the error: i translated it from the spanish (or at least i tried to...)] Warning: SQL error. [Microsoft] [Microsoft Access ODBC Driver] The Microsoft Jet data base engine can't open the file '(unknown)'. It's opened in exclusive mode for other user or you need privileges to read it., SQL state $1000 in SQLConnect in C:\the_path\my_file.php on line 5. however, nobody has opened the data base and i actually have all the privileges too. I've put the file and the data base into another different computer (with the same operative system and configuration) and everything works perfectly. Tip: With a similar asp file i have no problem: [my_file.asp] % set con=server.createobject(ADODB.Connection) con.open dsn=the_dsn con.close % any advise? thanks in advance, galfano carboni. Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PHP Ingres
Anyone using the Ingres routines in PHP 4.0.6 to access Ingres II? We have the problem that the database always sees the connection as coming from the username under which we run Apache, no matter what is specified in the ingres_connect() routine. Versions: PHP 4.0.6, Apache 1.3.20, Solaris 8, Ingres II 2.0 I'd welcome any help or advice on this! thanks -- David Osborne Academic Computing Services The University of Nottingham Nottingham NG7 2RD, UK -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] multiple queries in one php statement....
Hello everyone... Could someone give me a tip ang tell me if i can insert more than one queries in a mysql_query() statement?? etc $quer=mysql_query(" BEGIN WORK , QUERY 1 , QUERY 2, COMMIT",$db) Thanks. ___ PGP KEY ID: 0xA86600E9 ___
Re: [PHP-DB] multiple queries in one php statement....
Could someone give me a tip ang tell me if i can insert more than one queries in a mysql_query() statement?? etc $quer=mysql_query(" BEGIN WORK , QUERY 1 , QUERY 2, COMMIT",$db) No, you can't. You've got to execute them one at a time. -- -Ryan :: ICQ - 595003 :: GigaBoard - http://www.gigaboard.net/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Error 127
Hi everybody, All of the sudden I got an error one of mysql tables. Got error 127 from table handler. Can't browse it not even from phpmyadmin get the same error. Anybody had this before? What do I do to recuperate my table? I really appreciate any help, Thanks, Cami -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Error 127
the only time i've had this (not sure if it was 127) but i couldn't get the properties etc was after i named a table with a name that was a keyword. check the list in the docs as the list is quite long. i called mine 'returns' doh! Steve Cami [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi everybody, All of the sudden I got an error one of mysql tables. Got error 127 from table handler. Can't browse it not even from phpmyadmin get the same error. Anybody had this before? What do I do to recuperate my table? I really appreciate any help, Thanks, Cami -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Error 127
Cami, Here's what I found on the error and what to do about it: http://www.mysql.com/doc/R/e/Repair.html Hope that helps! My 2 ¢ John Pickett http://www.bvstudios.com/ Co-Author: Inside Dreamweaver 4 http://www.amazon.com/exec/obidos/ASIN/0735710848/xtremist - Original Message - From: Cami To: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 8:56 AM Subject: [PHP-DB] Error 127 Hi everybody, All of the sudden I got an error one of mysql tables. Got error 127 from table handler. Can't browse it not even from phpmyadmin get the same error. Anybody had this before? What do I do to recuperate my table? I really appreciate any help, Thanks, Cami -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Oracle and adodb recordcount
EOF shoud do the trick for my purpose (just want to know if my select returns a row or not). If not EOF just after a select, this means that the select returns at least one row. No more need to use recordcount. Thanks Philippe. Well, you're welcome, Philippe Regards, ... Philippe Philippe Saladin [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] Hi, I've read that Oracle (oci8) doesn't support the adodb function RecordCount : it returns -1. Is it true with adodb 1.20 ? is there a smart workaround? thanks in advance, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Error 127
Thanks everybody for pointing me to the right place. I manage to recover it. Thank God. Cami -Original Message- From: Cami [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 3:57 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Error 127 Hi everybody, All of the sudden I got an error one of mysql tables. Got error 127 from table handler. Can't browse it not even from phpmyadmin get the same error. Anybody had this before? What do I do to recuperate my table? I really appreciate any help, Thanks, Cami -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Error 127
you know i did this last week and can't remember the functions is used. i had exactly the same problem but had to dump the records as plain text files. i used get_html_translation_table . if you look at the example in the compiled html help file for php there is a section of code that uses this function and then array_flip to get the converted chars back into their original symbols. Steve John Pickett [EMAIL PROTECTED] wrote in message 001f01c11064$d3fc8400$4c6146a6@notebook">news:001f01c11064$d3fc8400$4c6146a6@notebook... Howdy ;-) I have a problem when trying to display data in HTML from a MySQL query. Here's what happens: 1) I convert the text entered using htmlentities (). I then insert it into the database table. If I do a query from a terminal on the data it looks fine. 2) When I do a select query on the data and then echo () it into a HTML page, all of the ' characters are preceded by an escape character \. I don't want this to happen... A few questions... First, would replacing the ' and characters with their HTML equiv pose problems when using them in say an img tag? I mean, does HTML expect the actual ' and characters instead of quot; or whatever it is? If it doesn't matter, I can just convert everything to HTML. My other question requires explanation of what I'm doing... I'm trying to make it so my client can add their own news updates. Really simple stuff. However, sometimes I'll want to add news items for them that include some HTML (like an email link or whatever). However, the and characters are being converted to lt; and gt; Will this actually work? Or do I need the and ? If so, how can I convert everything BUT actual HTML tags...? I'm not far enough along yet where I can test this stuff myself, sorry :-/ Thanx! My 2 ¢ John Pickett http://www.bvstudios.com/ Co-Author: Inside Dreamweaver 4 http://www.amazon.com/exec/obidos/ASIN/0735710848/xtremist -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] RE: Probably a stupid home server question ........
Make sure ahead of time whether the cable ISP gives you a static IP address or a dynamic one... Most of them in the US only give you dynamic IP's. They don't change all that often, but it does make it tough to host a domain name if your IP address is liable to change at any given moment. Also, read through the Terms of Service... the ISP may explicitly forbid you from running *any* kind of a server on their connection. But otherwise, it's a lot of fun running a server at home... it's a great use for an old box that would otherwise be gathering dust, and being able to compile and configure your web server exactly the way you want it is great. Even if you don't have a static address, you can sign up with a service like dyndns.org. And of course, make sure your home server is secure, especially if you use it as a web gateway as well as an http server :) -Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Subject: Probably a stupid home server question I have Windows 2000 with php, mysql, mssql etc . and redhat linux 6.2 with the same - would it be possible to set it up from home bearing in mind my website will be the only site hosted on it? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Error ORA-24327
I can connect my oracle server from apache with php function OCILogon(user,pwd,dbname); without problems... but sometimes when i reload the same web page i get the ORA-24327 error OCISessionBegin: Error while trying to retrieve text for error ORA-24327 My machine is a Sun solaris whit APACHE 1.3.20 php 4.0.6 the oracle db is remote... Which is the problem? thanks cristiano -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Warning messages
Hi guys I've got a form in my web site which is working just fine, that is, it does everything I want, however whenever I load the page I get the following warning messages: Warning: Unable to open '' for reading: No such file or directory in /home/thesis/public_html/thesis/php_pages/InputTesis2.php on line 137 Warning: Unlink failed (No such file or directory) in /home/thesis/public_html/thesis/php_pages/InputTesis2.php on line 138 Warning: Unable to open '' for reading: No such file or directory in /home/thesis/public_html/thesis/php_pages/InputTesis2.php on line 144 Warning: Unlink failed (No such file or directory) in /home/thesis/public_html/thesis/php_pages/InputTesis2.php on line 145 *** Anyone knows what it means? Any help will be highly appreciated --- Wilmar Pérez IT Manager - Central Library University of Antioquia Medellín - Colombia tel: ++57(4)2105145 --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Warning messages
At 02:08 PM 7/19/01 -0500, Wilmar Pérez wrote: Hi guys I've got a form in my web site which is working just fine, that is, it does everything I want, however whenever I load the page I get the following warning messages: Warning: Unable to open '' for reading: No such file or directory in /home/thesis/public_html/thesis/php_pages/InputTesis2.php on line 137 Without seeing you code ... It appears as if you are passing the name of a file to a variable, but that is not getting assigned, hence the empty pair of quotes. Of course, because that failed and you don't have a file handle the other errors follow. Same thing for line 144. How to avoid? Test for content in the variable you are passing before executing the line. Also, there is the Is there gas in the tank? test. Does the file you expect to open exist where you think it does? Does it have permissions which allow the web server to read it? Hope this get's you on the right track. Cheers - Miles Thompson Warning: Unlink failed (No such file or directory) in /home/thesis/public_html/thesis/php_pages/InputTesis2.php on line 138 Warning: Unable to open '' for reading: No such file or directory in /home/thesis/public_html/thesis/php_pages/InputTesis2.php on line 144 Warning: Unlink failed (No such file or directory) in /home/thesis/public_html/thesis/php_pages/InputTesis2.php on line 145 *** Anyone knows what it means? Any help will be highly appreciated --- Wilmar Pérez IT Manager - Central Library University of Antioquia Medellín - Colombia tel: ++57(4)2105145 --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] RE: Probably a stupid home server question ........
On Thursday 19 July 2001 19:25, Andrew Chase wrote: Make sure ahead of time whether the cable ISP gives you a static IP address or a dynamic one... Most of them in the US only give you dynamic IP's. They don't change all that often, but it does make it tough to host a domain name if your IP address is liable to change at any given moment. You can always use dynamic dns for this. See http://www.dyndns.org. -- Kriheli Meir -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Date Format
Friends, I have a design, up and running scripts connected to MySQL. How do I retrieve date formats and have it displayed as dd-mm- ? I store them as DATE. CK Raju -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Converting MS Access to MySQL
Can anyone suggest a good utility for converting database from MS Access to MySQL? Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Converting MS Access to MySQL
yeah, cut and paste, jk, im curious too - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 2:15 PM Subject: [PHP-DB] Converting MS Access to MySQL Can anyone suggest a good utility for converting database from MS Access to MySQL? Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Converting MS Access to MySQL
You can use ODBC to go from Access to MySQL. Get the MyODBC driver for Windows and setup your datasource so you can get to it via Access. You can do a direct export from Access to the MySQL database that way. There may be some differences, but I'm not sure of what all of them would be. Hope that helps some. Josh Hoover KnowledgeStorm, Inc. [EMAIL PROTECTED] Searching for a new IT solution for your company? Need to improve your product marketing? Visit KnowledgeStorm at www.knowledgestorm.com to learn how we can simplify the process for you. KnowledgeStorm - Your IT Search Starts Here Can anyone suggest a good utility for converting database from MS Access to MySQL? Thanks.
Re: [PHP-DB] multiple queries in one php statement....
cant... since the function returns a code if the call is true or not. if you try multiple statements, you cant know which failed and which was good... Koutsogiannopoulos Karolos wrote: Hello everyone... Could someone give me a tip ang tell me if i can insert more than one queries in a mysql_query() statement?? etc $quer=mysql_query( BEGIN WORK , QUERY 1 , QUERY 2, COMMIT,$db) Thanks. ___ PGP KEY ID: 0xA86600E9 ___ -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] special characters in odbc-queries
Hi there, can anyone tell me, how I have to handle special characters in an odbc-query? for example: 'select * from $table where primary-key=\'1\' ' doesn't work because of the dash in primary-key Thx Kobi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PASSWORD('xxxxx') and PHP
Is there a way to encode a string in PHP exactly like MySQL does it in its PASSWORD() Function? Reason being Is I have a table with PASSWORD() encoded fields that I need to compare from PHP. Thanks, Andrew -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Date Format
?php $date = 2001-07-19; // as if it just came from the db $date_array = explode('-',$date); $date = $date_array[1] . - . $date_array[2] . - . $date_array[0]; ? That should do it = Good luck! Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of system Sent: Friday, July 13, 2001 8:17 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Date Format Friends, I have a design, up and running scripts connected to MySQL. How do I retrieve date formats and have it displayed as dd-mm- ? I store them as DATE. CK Raju -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]