osCmax v2.5 User Manual
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Warning not valid MySQL in installe RC4

This is a discussion on Warning not valid MySQL in installe RC4 within the osCmax v2 Installation issues forums, part of the osCmax v2.0 Forums category; Hello when i installe RC4 in end installe i have an error on my header. Warning: mysql_num_rows(): supplied argument is ...

      
  1. #1
    New Member Vincent_w's Avatar
    Join Date
    Jan 2009
    Posts
    11
    Rep Power
    0


    Default Warning not valid MySQL in installe RC4

    Hello

    when i installe RC4 in end installe i have an error on my header.

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home6/f/furets/www/Boutique/install/includes/functions/database.php on line 39

    it' a sql error in file i think but i odn't understand

  2. #2
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: Warning not valid MySQL in installe RC4

    Hi, that is a warning not an error. Does the installation process finish and you end up with a working install?

    I cannot reproduce the issue on our test servers. What are all your platform versions: OS, PHP version, MySQL version, Apache version, etc...
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    Active Member
    Join Date
    Mar 2004
    Posts
    139
    Rep Power
    15


    Default Re: Warning not valid MySQL in installe RC4

    I also received this warning on a new install rc4 running linux with PHP version 5.2.8, MySQL version 5.0.67-community, Apache version 2.2.11 (Unix).
    Installation finished successfully and everything seems to work.

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/user/public_html/install/includes/functions/database.php on line 39

  4. #4
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: Warning not valid MySQL in installe RC4

    PHP version 5.2.8, MySQL version 5.0.67-community, Apache version 2.2.11 (Unix).
    Must be a difference in server/php/mysql configuration as I am testing on the same versions as you and get a clean finish to the installer with no warnings. I will keep trying to reproduce, but so far on 3 different servers no luck.
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  5. #5
    jpf
    jpf is offline
    osCMax Testing Team
    jpf's Avatar
    Join Date
    Sep 2003
    Location
    Manitoba, Canada
    Posts
    2,699
    Rep Power
    22


    Default Re: Warning not valid MySQL in installe RC4

    This seams to stem from install_4.php line 33-36:
    PHP Code:
      $check_query osc_db_query('select admin_username from ' TABLE_ADMINISTRATORS ' where admin_user_name = "' trim($HTTP_POST_VARS['CFG_ADMINISTRATOR_USERNAME']) . '"');

      if (
    osc_db_num_rows($check_query)) { 
    I had received this once before. (Does not affect the install - have not seen it since)

    And from what I understand - something is not being qualified properly in the query - that is being them passed to to db_num_rows and is causing the warning.

    Possibly your using a "reserved" work for admin_user_name. I will check into this a bit later.
    JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
    Try out our osCMax at: Live Catalog Demo
    Limited access Admin: Live Admin Demo
    Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!

  6. #6
    osCMax Development Team
    pgmarshall's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    2,678
    Rep Power
    49


    Red face Re: Warning not valid MySQL in installe RC4

    Hi,

    I am testing RC4 on localhost with a view to migrating from RC3 once declared stable - not looking forward to reinstalling the mods!!

    I also got the error

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:/wamp/www/rc4/catalog/install/includes/functions/database.php on line 39
    (I have dropped in some test data from my live site using easypopulate)

    1) On a fresh site when editting a products it has AJAX_FIRST_RUN or similar half way down the page. This goes after putting in some products.

    2) Once you populate with some data I get the following error
    Warning: Cannot modify header information - headers already sent by (output started at C:/wamp/www/rc4/catalog/admin/attributeManager/languages/english/attributeManager.php:1) in C:/wamp/www/rc4/catalog/admin/attributeManager/attributeManager.php on line 72
    Link to Screenshot

    3) On the Attributes Manager if you try and edit a product it send me to
    http://localhost/rc4/catalog/admin/%3C?=$PHP_SELF?>
    4) In Products_attributes.php I can see all the attributes but when I click INSERT (bottom right) to create a new attribute I get the following error
    1136 - Column count doesn't match value count at row 1

    insert into products_attributes values (null, '18', '2', '5', '0', '+')

    [TEP STOP]
    5) When I click on Create Account in the Customers Tab (Admin) I get the following error
    Parse error: syntax error, unexpected $end in C:/wamp/www/rc4/catalog/admin/includes/modules/account_details.php on line 485
    6) I have changed the setting to display product attributes with a radio box not the drop down and get the following error on the product page. If I switch it back to multiple_dropdowns the error goes.
    Warning: Invalid argument supplied for foreach() in C:/wamp/www/rc4/catalog/includes/classespad_base.php on line 387
    Not sure if this helps with testing (and it probably me installing it incorrectly!) Apologies if it is - otherwise I hope this helps.

    pgmarshall

  7. #7
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: Warning not valid MySQL in installe RC4

    pgmarshall,

    I cannot reproduce any of these issues with a clean install of RC4 except #4. It looks to me like some of the files failed to properly upload via ftp (if you used FTP to upload that is).

    1) On a fresh site when editting a products it has AJAX_FIRST_RUN or similar half way down the page. This goes after putting in some products.
    This should display a little info icon with the following text next to it:
    Save Product before adding options

    That is what displays on a clean install for me when I add a new product.


    2) Once you populate with some data I get the following error Quote:
    Warning: Cannot modify header information - headers already sent by (output started at C:/wamp/www/rc4/catalog/admin/attributeManager/languages/english/attributeManager.php:1) in C:/wamp/www/rc4/catalog/admin/attributeManager/attributeManager.php on line 72
    I can't repeat this one either.

    3) On the Attributes Manager if you try and edit a product it send me to Quote:
    http://localhost/rc4/catalog/admin/%3C?=$PHP_SELF?>
    Unable to repeat this.

    4) In Products_attributes.php I can see all the attributes but when I click INSERT (bottom right) to create a new attribute I get the following error Quote:
    1136 - Column count doesn't match value count at row 1

    insert into products_attributes values (null, '18', '2', '5', '0', '+')

    [TEP STOP]
    I am able to repeat this. Darned if I know how it snuck in. Working on a fix now.

    5) When I click on Create Account in the Customers Tab (Admin) I get the following error Quote:
    Parse error: syntax error, unexpected $end in C:/wamp/www/rc4/catalog/admin/includes/modules/account_details.php on line 485
    Unable to repeat. This looks like a bad upload (truncated file).


    6) I have changed the setting to display product attributes with a radio box not the drop down and get the following error on the product page. If I switch it back to multiple_dropdowns the error goes. Quote:
    Warning: Invalid argument supplied for foreach() in C:/wamp/www/rc4/catalog/includes/classespad_base.php on line 387
    I have to verify, but I don't think any of the QTpro files were changed. When I get a bit more time I will try to reproduce it.

    Other than #4, it looks to me like your upload had multiple ftp errors which as corrupted several files.
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  8. #8
    osCMax Development Team
    pgmarshall's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    2,678
    Rep Power
    49


    Default Re: Warning not valid MySQL in installe RC4

    Thanks for the response Michael. I have tried a fresh install - I am using WAMP5 on localhost so no FTPs.

    This should display a little info icon with the following text next to it:
    Save Product before adding options
    On my install it actually says -
    AM_AJAX_FIRST_SAVE
    So I am not sure if there is a language file missing here? But I have repeated it.

    Instead of importing through Easypopulate this time I manually tried to add a product ... got the following error - (vanilla install nothing changed other than tunring off 2 language packs ie. english only)

    Warning: Cannot modify header information - headers already sent by (output started at C:/wamp/www/rc4/catalog/admin/attributeManager/languages/english/attributeManager.php:1) in C:/wamp/www/rc4/catalog/admin/includes/functions/general.php on line 90
    However - it does actually add the product!

    When I go back into this product I still get the error

    Warning: Cannot modify header information - headers already sent by (output started at C:/wamp/www/rc4/catalog/admin/attributeManager/languages/english/attributeManager.php:1) in C:/wamp/www/rc4/catalog/admin/attributeManager/attributeManager.php on line 72
    I also can see that the drop down for AJAX says "AM_AJAX_TEMPLATES" - could be language file problem?

    3) is still there for me - here is html extract for relevant code.

    <!-- articles_eof //--><!-- left_navigation_eof //-->
    </table></td>
    <!-- body_text //-->
    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

    <TR>
    <TD class="pageHeading" colspan="3"><?=$pageTitle?></TD>
    </TR>
    <FORM ACTION="<?=$PHP_SELF?>" NAME="SELECT_PRODUCT" METHOD="POST">
    <INPUT TYPE="HIDDEN" NAME="action" VALUE="select">
    <TR><TD class="main"><BR><B>Please select a product to edit:<BR></TD></TR><TR><TD class="main"><SELECT NAME="current_product_id"><OPTION VALUE="1">Aspen Bread Basket</SELECT></TD></TR><TR><TD class="main"><input type="image" src="includes/languages/english/images/buttons/button_edit.gif"></TD></TR></FORM>

    </table></TD>
    </TR>
    <!-- body_eof //-->
    4) I will await a fix.

    5) My file ends
    <?php
    if ( (!$error) || ($entry_password_error) ) {
    ?>
    <tr>
    <td class="main">&nbsp;<?php echo ENTRY_PASSWORD_CONFIRMATION; ?></td>
    <td class="main">&nbsp;
    <?php
    echo tep_draw_password_field('confirmation') . '&nbsp;' . ENTRY_PASSWORD_CONFIRMATION_TEXT;
    ?></td>
    </tr>
    <?php
    }
    ?>
    </table></td>
    </tr>
    </table></td>
    </tr>
    */ ?>
    <?php
    // }
    ?>
    </table>
    Not sure if this is truncated - but it doesn't look like it.

    6) I think this was a bug in RC3 that people had experienced - link to thread

    Not sure why I am getting these errors ... may try on remote host rather than localhost. (Running MLSQL 5.0.45.)

    pgmarshall

  9. #9
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: Warning not valid MySQL in installe RC4

    Since I couldn't reproduce on a LAMP setup, I moved to a WAMP setup for testing.

    I am using xampp (current version) on my windows server.

    Here is what I was able to reproduce:


    1. Final step of installer: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in catalog/install/includes/functions/database.php on line 39


    2. Products Attributes: 1136 - Column count doesn't match value count at row 1
      insert into products_attributes values (null, '1', '1', '1', '0', '+')
      [TEP STOP]

    I cannot reproduce any of the other issues with a clean install on a WAMP setup.

    Could you post your php.ini? I want to test it with your exact php setup. Maybe I can get it to pop those errors.
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  10. #10
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: Warning not valid MySQL in installe RC4

    To fix this issue:
    1136 - Column count doesn't match value count at row 1

    Do the following:

    Edit /catalog/attributeManager/classes/attributeManagerConfig.class.php

    Find this line (line 60):
    PHP Code:
    $this->add('AM_USE_SORT_ORDER' true); 
    and change to
    PHP Code:
    $this->add('AM_USE_SORT_ORDER' false); 


    2.
    Remove the folowing field from the products_attributes table:
    products_options_sort_order

    The issue is that the file was set to automatically add the field to the products_attributes table, thus breaking the normal attributes page.

    The full osCMax download has the fixed file in it, so this will no longer happen for new installs.

    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

Page 1 of 2 12 LastLast

Similar Threads

  1. valid XHTML Catalog Side 2.3---is this mod compatible with--
    By Christy in forum osCmax v2 Customization/Mods
    Replies: 2
    Last Post: 11-04-2006, 08:03 PM
  2. Another warning for me!
    By [wicked] in forum osCmax v2 Customization/Mods
    Replies: 4
    Last Post: 02-09-2006, 12:57 PM
  3. Warning: mysql_result(): supplied argument is not a valid My
    By doumawis in forum osCmax v1.7 Discussion
    Replies: 0
    Last Post: 02-27-2005, 05:49 AM
  4. EasyPopulate:Images Valid & U/L, then "Can't find i
    By xoomxoomang in forum osCommerce 2.2 Modification Help
    Replies: 3
    Last Post: 06-18-2004, 09:08 PM
  5. supplied argument is not a valid MySQL result resource ...
    By Dragonmom in forum osCmax v1.7 Discussion
    Replies: 2
    Last Post: 10-30-2003, 06:53 AM

Bookmarks

Posting Permissions

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