Results 1 to 6 of 6

Thread: PHP / SQL

  1. #1
    Join Date
    Oct 2007
    Posts
    39

    PHP / SQL

    Hi!

    I run a website that uses PHP and MySql.

    It was working fine till today, when our webhost (Lunarpages) decided to upgrade their servers. Now my site's scripts don't work, everytime I click on a link from the home page I get this:

    MySQL: query error:

    SELECT *
    FROM abcProducts
    WHERE nID =

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/abc/public_html/includes/products.php on line 111

    What do I do guys?

    Can recommend a reliable person/company to fix this for me?

    Thanks

    Rick

  2. #2
    Join Date
    Nov 2001
    Location
    Philadelphia, Pa
    Posts
    949
    does your site require register_globals to be turned on? It seems like the value in the where clause isn't being populated anymore.

  3. #3
    Join Date
    Oct 2007
    Posts
    39
    Quote Originally Posted by derek.bodner View Post
    does your site require register_globals to be turned on? It seems like the value in the where clause isn't being populated anymore.
    I am sorry, but I just dont know. How can I find out?

    Thanks.

  4. #4
    Join Date
    Nov 2001
    Location
    Philadelphia, Pa
    Posts
    949
    put up a page that has only the following:
    <?php
    phpinfo();
    ?>

    Then load that page in a web browser, search for the following:
    register_globals Off Off

    And paste the results here.

  5. #5
    Join Date
    Oct 2007
    Posts
    39
    You were right! This is what they say (after 7 hours from openig the support ticket):


    I apologize for the inconvenience.

    Customers on our Massar server were notified on December 19, 2007 that MySQL and Mail Service Upgrades would be taking place December 28 - 30, 2007.

    This was also posted on our forum:
    http://www.lunarforums.com/lunarpage...-t45427.0.html

    On Sunday, December 30, 2007 at 11pm PST, we will upgrade the following:

    MySQL

    Where PHP 5.X is installed, this will be upgraded to the latest version 5.2.4. PHP 4.4.4 will be upgraded to 4.4.7 on the server.

    MySQL will upgrade to 5.0.27 from 4.1 series. The MySQL upgrade is due to the older MySQL 4 and 4.1 versions having been phased out for support by MySQL last year. Additionally, MySQL 5 is already running on our newest Linux shared servers, so this will allow us to run the same version across our entire Linux server network.

    For further information on the now deprecated MySQL 4 / 4.1 please see:

    http://dev.mysql.com/doc/refman/4.1/en/

    For more details on MySQL and specifically MySQL 5 series, please review the Wikipedia article on it at http://en.wikipedia.org/wiki/MySQL

    Most scripts should run normally without issues on MySQL 5, however, if you are running any scripts which are older or not up-to-date, please ensure to obtain the most current copy of the script from the script development site so that the script will function properly with MySQL 5. If you have installed the script via Fantastico, please upgrade in Fantastico in cPanel to the most recent version if you have not already done so.

    Some scripts such as phpBB or SMF may need patched if you do not have the most up-to-date copy. Please note that running an older copy of any script is a security risk as you should always have the most up-to-date, secured copies of scripts on your account.

    Finally, please note that PHP register_globals will be set to Off in our global php.ini file. You can change this back to on simply by adding a php.ini file onto your account with the following details:

    register_globals = On

    This can be placed into your public_html folder.

    Feel free to contact us if you require further assistance or have any questions, or consult our forums at http://lunarforums.com

  6. #6
    Join Date
    Oct 2007
    Posts
    39
    So (keeping in mind I have no knowledge of php) what should I do. I know how to create a text file and can rename it to php.ini and save it in the public_html folder. Is that it? The text file to say (only) register_globals = On ?

    Would really appreciate any feedback, thanks again.

    Rick

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •