Common Problems with MySQL and PHP

July 13, 2006 § Leave a comment

We get some common problems during our development work by PHP/MySQL. Here is a short list of common problems with MySQL and PHP along with possible solutions:

  • Error: Maximum Execution Time Exceeded: This is a PHP limit; go into the php.ini file and set the maximum execution time up from 30 seconds to something higher, as needed. It is also not a bad idea to double the RAM allowed per script to 16MB instead of 8MB.
  • Fatal error: Call to unsupported or undefined function mysql_connect() in …: This means that your PHP version isn’t compiled with MySQL support. You can either compile a dynamic MySQL module and load it into PHP or recompile PHP with built-in MySQL support. This process is described in detail in the PHP manual.
  • Error: Undefined reference to ‘uncompress’: This means that the client library is compiled with support for a compressed client/server protocol. The fix is to add -lz last when linking with -lmysqlclient.
  • Error: Client does not support authentication protocol: This is most often encountered when trying to use the older mysql extension with MySQL 4.1.1 and later. Possible solutions are: downgrade to MySQL 4.0; switch to PHP 5 and the newer mysqli extension; or configure the MySQL server with –old-passwords. (See “Client does not support authentication protocol”, for more information.)
  • [reference: http://dev.mysql.com%5D

    See more about it here:
    http://dev.mysql.com/doc/refman/5.0/en/php-problems.html

    Enjoy PHPing !

    Regards,
    Rupom

    Being a Moderator of Weberforums.Com

    July 6, 2006 § 1 Comment

    I got the moderatorship of WeberForums. Site admin Berber proposed me this moderatorship. I was really very excited getting this offer. It’s really a good option to contribute the Open Source Community. I am hoping that I will be able to contribute there more and more.

    Here is the list of forums I have been moderator for :
    ——————————————————————-
    1. PHP General
    2. PEAR
    3. MySQL General
    4. Security
    5. JavaScript
    6. SEO
    7. XML & XSL
    ——————————————————————–

    My special thanks to the WeberForums admin Berber. Now it’s time to contribute there as well as phpResource Group.

    I am very happy !

    $Rupom

    Google Checkout API :: Another Option for Online Transaction

    July 6, 2006 § Leave a comment

    Google Checkout is a checkout process that you integrate with your website, enabling your customers to buy from you quickly and securely, using a single username and password. Once they do, you can use Google Checkout to charge their credit cards, process their orders, and receive payment in your bank account.

    Google Checkout works with Google’s search advertising program, AdWords, to increase your sales and minimize your expenses. Shoppers who see the Google Checkout badge on your AdWords ads will more easily find you when they search, and for every dollar you spend on AdWords, you can process $10 in sales for free.

    See more of Google Checkout API

    Google Checkout will spread light to the world of online transaction — no doubt.
    Google is greatly serving the online peoples and making life easier.

    $Rupom

    Superior Code at Planet Source Code

    July 5, 2006 § Leave a comment

    Planet Source Code(http://www.planet-source-code.com) has selected my code the Superior Code for the coding contest of month June, 2006. This month I am getting many good results – this is one of them. Really nice to get such good news. I will be given a prize from their list of prizes. Planet Source Code authority has also given me a badge to show in my site/blog. Here’s that:


    My code has been placed to Planet Source Code’s All-Time Hall of Fame.

    It made me happy and encouraged a lot to contribute the Open Source Community more and more.

    Rupom

    Got $100 From WeberDev Coding Contest

    July 3, 2006 § Leave a comment

    I won the first prize at WeberDev coding contest for June, 2006. My codes were published there. I submitted maximum number of codes there. To get the first prize, one needs to submit at least 5 codes. I have submitted 6 codes there and won the first prize ($100 Cash). The amount is not big but it’s always amazing to get prizes and awarded. It gives inspirarions — same for me. I won the “Innovation Award” at phpclasses.org and then won the first prize at Weberdev. These two gave me a lot of inspirations to go ahead strongly.

  • Prize and Winners for June, 2006
  • My Codes at WeberDev.Com
  • Happy PHP Coding !!

    $Rupom

    Being The “Innovation Award Winner” of May, 2006

    July 1, 2006 § Leave a comment

    Finally my class Graph Coloring won the “Innovation Award” at PHP Classes. I am very happy for this achievement. I got light to my life getting the result from PHP Classes authority. I got 33.33% votes among all classes nominated in May, 2006. My thanks to the users those liked my class and voted me.

    Graph Coloring is one of the most important branch of Computer Science. Efficient graph coloring is very muh useful in many applications. Graph Coloring even can encrypt huge data. I have done a bit research on that. My paper “Graph Coloring for Encryption : A New Approach of Huge Data Secretion” was accepted and published in the proceedings of International Conference on Electrical, Electronics and Computer Engineering (ICEECE), 2003. This was also an innovative work and has been marked so. You can find a lot of innovative research topics in Graph Coloring. So lets start innovative works.

    The winners ranking list (of month May,2006) is here:
    http://www.phpclasses.org/winners.html

    PHP Classes authority has given me a badge to let me mention that my
    package is the winner of this award. Here is that:

    This achievement will greatly encourage and motivate me to contribute the Open Source Community more and more.

    My special thanks to the users those voted me. Also thanks to the PHP Classes authority for grabbing it to their innovation list.

    Regards,
    MA Razzaque Rupom

    Where Am I?

    You are currently viewing the archives for July, 2006 at Rupom Here.