Warning: mysql_num_rows

More
01 Jun 2011 03:27 #1250 by ilDirty
joomlamailer version: 1.7
Joomla! version: 1.5.14
PHP version: 5.2.14
MySQL version:
And lots of other components, modules etc because its for testing purposes.

Hi we have this error when trying start new campaing
Code:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /data03/virt24698/domeenid/www.ourdomain.com/htdocs/subdomain/libraries/joomla/database/database/mysql.php on line 344

My guess is that VirtueMart with 15.000 products causes huge load. It loads few minutes new campaing tabs :D

Is there anything how we can solve this little issue?

Greetings from Finland, land of midnight sun :-)

Please Log in or Create an account to join the conversation.

More
03 Jun 2011 00:44 #1269 by compojoom
Replied by compojoom on topic Warning: mysql_num_rows
Is there any way that you could share your virtuemart database with us? 15k dummy product table is not easy to get :)

Please Log in or Create an account to join the conversation.

More
03 Jun 2011 13:29 #1273 by ilDirty
Replied by ilDirty on topic Warning: mysql_num_rows
Yes its possbile but i have to ask coder to take that because theres under development stuff too. We can give backend access to Pete or someone Joomlamailer staff who knows what he is doing.

Please Log in or Create an account to join the conversation.

More
06 Jun 2011 19:09 #1291 by pete
Replied by pete on topic Warning: mysql_num_rows
Hello ilDirty,

The error you're wuoting is nothing to worry about. We didn't get around to fix it but it doesn't influence the functionality in any way. It just doesn't look nice.
The site taking minutes to load is quite sure caused by the amount of VM products in combination with joomlamailer lacking a pagination in the VM products list. We have that on the todo list and it will be fixed in one of the next versions.

Kind regards,
Pete

Please Log in or Create an account to join the conversation.

More
07 Jun 2011 19:03 #1310 by ilDirty
Replied by ilDirty on topic Warning: mysql_num_rows
Hi Pete,

Thank you for your response. We notice that too that it doesent effect functionality.

Is there possbile to comment out VirtueMart part in source because its too slow to make newsletter? Or just add searchbox where place product number(s) what to add newsletter.

If not, then i have to figure how to get 2 products in row and have few rows. I know that my previous question is noob one :) I have found and used this:
Code:
<#vm_products#> <h3>Top Products</h3> <table> <#vm_repeater#> <tr> <td align="center"> <p> <#vm_content#> </p> </td> </tr> <#/vm_repeater#> </table> <#/vm_products#>

Byteway our test newsletters have product photos in full size, no thumbnail at all. What im doing wrong?

Best Regards, Pasi

Please Log in or Create an account to join the conversation.

More
10 Jun 2011 18:29 #1368 by pete
Replied by pete on topic Warning: mysql_num_rows
Hi Pasi,

It surely is possible to comment out Virtuemart but then you won't be able to add VM products and as I understand thats what you want to do?!

Have you enabled "Enable Dynamic Thumbnail Resizing?" in the VM configuration? That should fix the thumbnail issue.

Kind regards,
Pete

Please Log in or Create an account to join the conversation.

More
10 Jun 2011 18:55 #1370 by ilDirty
Replied by ilDirty on topic Warning: mysql_num_rows
Hi Pete,

Yes you are kind a right that commenting out VirtueMart. But we do it at this moment different (read harder) way as our content template supports it. We will take your solutin in full use but at this moment its urgent to get few newsletters out. We have allready over 2600 subscribers eagerly waiting our mails.

Yes. Enable Dynamic Thumbnail Resizing in enabled allready.

Thank you.

Please Log in or Create an account to join the conversation.

More
10 Jun 2011 19:06 #1371 by pete
Replied by pete on topic Warning: mysql_num_rows
Removing VM is an easy task. Edit the file: /administrator/components/com_joomailermailchimpintegration/models/create.php

Find: function getVMproducts(){ (around line 298)

Add right behind the curly brackets { this code:

return false;

Also edit: /administrator/components/com_joomailermailchimpintegration/views/create/tmpl/default.php

At line 90 there is:

} else {
$vm_installed = false;
}

After this add:

$vm_installed = false;

This should turn off Virtuemart on the create page.

Kind regards,
Pete

Please Log in or Create an account to join the conversation.