Warning not valid MySQL in installe RC4

[Vincent_w]

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

[michael_s]

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...

[altenter]

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

[michael_s]

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.

[jpf]

This seams to stem from install_4.php line 33-36:

   $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.

[pgmarshall]

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

[michael_s]

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.

[pgmarshall]

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

[michael_s]

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_s]

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):

 $this->add('AM_USE_SORT_ORDER' , true); 
  

and change to

 $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.