moving servers stops queries from working?

Coruba67

Hi Guys,

Have recently moved a site that I had running sweet with a MySQL backend. The old server was an IIS server - I know - now an Apache Server. However some MySQL queries no longer work..

this used to work just fine and now no longer does

$query = "SELECT distinct(Name), ID FROM Level WHERE BID='6' AND LevelName!='A' AND LevelName!='B'";

$result = mysql_query($query);

while ($row = mysql_fetch_array($result))

This used to work great on IIS, so I was wondering if anyone knew why it doesn't work on Apache? I get this error

mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Any help would be greatly appreciated

MarkR

We can't diagnose the above for you without more information.

Please turn on E_ALL, and paste the ENTIRE PHP error log generated by the page. Please state

What version of PHP, Mysql you used on your old server
What version of PHP and MySQL you have on your new server

The following are a bit big to paste into a message, maybe you can upload them somewhere and link to them:
- Output of phpinfo() on old server
- Output of phpinfo() on new server

It's far more likely to be due to PHP or MySQL version or configuration difference than to do with the web server.

Mark

MarkR

Oh yes - one other thing... I take it your databases have an identical schema?

It may be that MySQL table name case sensitivity varies between operating systems. You may want to tell us what OS the old and new servers are on too.

Mark

Coruba67

hmmm... on turning on E_ALL I didn't get any more detailed error message. Just

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /webhome/240/www.central-site.com/www/docs/Manager/php/ModifyContactList.php on line 540

The old server is a windows 2003 web edition server. Mysql was 4.1, php version 4.3.10, ran the site on IIS all good.

The new server is a Fedora (I think, I don't actually own the new server), Apache, MySQL version 3.23.49, PHP 4.1.

MarkR

I don't normally use the raw mysql API, so I don't know how it handles errors. Add whatever error handling code is necessary to mysql_query() to output or log the details of the error. The query is clearly failing.

My hunch currently, is that MySQL table case sensitivity varies between platforms / filesystems.

Mark

Coruba67

yeah... actually I found the import adjusted all the tables in the database to be purely lower case... such is not the way in the original database... After a few tests it appears to be the problem. I wonder why it changed that!?

Eh... twas you comment about the database schema being different that started me sniffing down that path..

Thanks for the help!