NYCPHP Meetup

[Jon Baer]

Ive had this come up a few times ... for the most part if your SQL is  
simple joins it will not really cause problems, the real problems are  
if you are using anything like prepared statements or something meant  
for mysqli extension.  http://us.php.net/mysqli (requires 4.1.3)

However since the advantages of using prepared statements (for you and  
your ISP) pretty much outweigh everything else it's probably good to  
be even more paranoid and use them :-)

Im sure you will get bit by something else down the road but if you  
test w/ a command line 4.1.x MySQL client and it chokes on one of your  
queries it would pretty much show you what will work + what will not.

Since PHPMyAdmin is more of a tool it will probably throw more admin  
related queries for info and bail out.  This type of situation is  
where it's nice to get a VPS setup vs. a normal ISP / shared hosting  
deal since you can compile and install this yourself.

- Jon

On Jan 6, 2008, at 12:06 PM, Don Pavlish wrote:

> Hi everyone,
>
> Longtime lurker, posting for the first time.  :)
>
> I'm coding a LAMP site now where the development server is running  
> MySQL Server version 5.0.45 and PHP MySQL client library 5.0.41.   
> Everything is working great.
>
> However, the final server we'll be deploying the site on is through  
> a different hosting provider.  They're also running MySQL 5.0.45,  
> but an older version of the PHP MySQL client library -- version  
> 4.1.22.
>
> I've googled exhaustively but can't find any good documentation as  
> to whether or not this will cause problems.  PHPMyAdmin seems to  
> think so -- it warns me that "Your PHP MySQL library version 4.1.22  
> differs from your MySQL server version 5.0.54. This may cause  
> unpredictable behavior."
>
> Thus far I've run some simple tests on the final server and haven't  
> seen any problems.  But I'm still concerned.  My gut feeling is that  
> the MySQL version and the PHP client library should be the same  
> major version... or am I just being paranoid?
>
> Has anyone any experience / thoughts?
>
> thanks!
> - Don
>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php