[PHP-DB] Move from PHP4 to PHP5 , and to Zend Platform - any gotchas? (MYSQL and SQL SERVER)

2008-12-10 Thread Weaver Hickerson
Greetings list. We are planning to move our "legacy" php4/apache system to PHP5 and also move to the Zend Platform. Wondering if anyone has any gotchas/horror stories.. The system interfaces with both MySQL and SQL Server. Any thoughts appreciated! Weaver Hic

Re: [PHP-DB] MySQLDump through PHP/HTML UI

2008-12-10 Thread Chris
phphelp -- kbk wrote: Hi, Chris -- -- -- -- Yes, thanks for the suggestion: it runs from the command line just fine. I run them often, and it works in Windows. However, I just was able to gain access again to the error log (long story), and I see that the page is throwing an unrelated error

Re: [PHP-DB] MySQLDump through PHP/HTML UI

2008-12-10 Thread Ken Kixmoeller.com
On Dec 10, 2008, at 3:21 PM, Yves Sucaet wrote: What PHP-function/command are you using to invoke the mysqldump command? As I said in the original post, I have used both system() and exec(), both with the same result. Try including a flush() statement right before you start dumpin

Re: [PHP-DB] SimpleXML broke while I was sleeping.

2008-12-10 Thread Jack van Zanen
I'll pass we all have a senior moment every now and than :-) Jack 2008/12/11 Nicholas Mercier <[EMAIL PROTECTED]> > Jack wins the right to call me an idiot for a long time. WoWhead changed > their configuration slightly I think, that is what messed it up. I believe > it is working now. Than

Re: [PHP-DB] SimpleXML broke while I was sleeping.

2008-12-10 Thread Nicholas Mercier
Jack wins the right to call me an idiot for a long time. WoWhead changed their configuration slightly I think, that is what messed it up. I believe it is working now. Thank you - I was just convinced it was something dumb on my end. On Wed, Dec 10, 2008 at 9:44 PM, Chris <[EMAIL PROTECTED]> wrote:

Re: [PHP-DB] MySQLDump through PHP/HTML UI

2008-12-10 Thread phphelp -- kbk
Hi, Chris -- -- -- -- Yes, thanks for the suggestion: it runs from the command line just fine. I run them often, and it works in Windows. However, I just was able to gain access again to the error log (long story), and I see that the page is throwing an unrelated error that it does not th

Re: [PHP-DB] SimpleXML broke while I was sleeping.

2008-12-10 Thread Chris
This is the error message I now get: *Warning*: SimpleXMLElement::__construct() [simplexmlelement.--construct]: http%3A%2F%2Fwww.wowhead.com%2F%3Fsearch%3DAngelista%27s%2BSash%26xml:84: parser error : Entity 'nbsp' not defined in * /

Re: [PHP-DB] SimpleXML broke while I was sleeping.

2008-12-10 Thread Jack van Zanen
did they change the source at WoWhead? 2008/12/11 Nicholas Mercier <[EMAIL PROTECTED]> > So I had a code project that took the name of a piece of equipment in World > of Warcraft - pulled the XML from WoWhead and pulled the database item > number from the XML file. It worked for a long while a

[PHP-DB] SimpleXML broke while I was sleeping.

2008-12-10 Thread Nicholas Mercier
So I had a code project that took the name of a piece of equipment in World of Warcraft - pulled the XML from WoWhead and pulled the database item number from the XML file. It worked for a long while and the code simply sat around not being used. I went back to pull the project out for inclusion in

Re: [PHP-DB] MySQLDump through PHP/HTML UI

2008-12-10 Thread Chris
phphelp -- kbk wrote: Hello - - -- - I have a utility which creates a MySQLDump of selected tables or the whole database. This works fine on my development machine, a W2K box. It does not work on the testing server, a linux box. I'll post code if you want, but it is very simple: 1. I creat

Re: [PHP-DB] MySQLDump through PHP/HTML UI

2008-12-10 Thread Yves Sucaet
What PHP-function/command are you using to invoke the mysqldump command? Try including a flush() statement right before you start dumping. I don't know why it works, but it's solved some of my problems in the past. Must be something with buffer management. hth, Yves - Original Message -

Re: [PHP-DB] MySQLDump through PHP/HTML UI

2008-12-10 Thread Ken Kixmoeller.com
Merci, Yves - -- It takes the blink of an eye. It seems like none of the string is running at all. Also, yeah, the slashes thing used to trip me up, too, when I first started working around Linux boxes. However, the file *is* being created and it is in the right place, just nothing in it.

Re: [PHP-DB] MySQLDump through PHP/HTML UI

2008-12-10 Thread Yves Sucaet
Hi Ken, How long does the mysqldump operation last? Maybe it's a script timeout problem? And maybe you have different settings on both machines? Other idea: what about pathnames? Linux uses "/" to separate paths, Windows uses "\". That's all I have for now, Yves - Original Message --

[PHP-DB] MySQLDump through PHP/HTML UI

2008-12-10 Thread phphelp -- kbk
Hello - - -- - I have a utility which creates a MySQLDump of selected tables or the whole database. This works fine on my development machine, a W2K box. It does not work on the testing server, a linux box. I'll post code if you want, but it is very simple: 1. I create the "dump" language