Resolved 500 Error: Call to a member function setQuery() on null

Hello,

That is a weird error because setQuery is used all over the place in Joomla. Running PHP 7 is actually a good thing. Which database driver has been selected in the global configuration?

Have you updated both the CSVI Component and the VirtueMart add-on so that they are the same version?

Hi Rolandd,

I thought everything had been updated to the latest, but now not entirely sure. Could you tell me which items you are referring to? As you can see, there are several modules and plugins, and not quite sure which two to compare.

Also, where would I look for the db driver? If you are referring to the db type on the server tab, it is set to MySQLi.

Hello,

The second screenshot where you filtered on csvi shows it all. The version column has for the most extensions 7.0.0 and for some 6.5.7. Most notably the CSVI Pro - VirtueMart has version 6.5.7. This is the VirtueMart addon of CSVI. This must also be version 7.0.0 or rather now everything is 7.0.2. If you update that one, you should be good to go.

Thank you for the help! At least the error has changed now. Any clue where I screwed up on this?

Error

Unknown column 'Accounting Code' in 'field list' SQL=SELECT `#__virtuemart_products`.`virtuemart_product_id`, `#__virtuemart_products`.`product_parent_id`, `Accounting Code`, `Acquired Date`, `#__virtuemart_product_categories`.`virtuemart_category_id`, `#__virtuemart_products`.`created_by`, `#__virtuemart_products`.`created_on`, `Door Type`, `#__virtuemart_products`.`locked_by`, `#__virtuemart_products`.`locked_on`, `#__virtuemart_products`.`modified_by`, `#__virtuemart_products`.`modified_on`, `Other Charge`, `product_availability`, `product_parent_id`, `#__virtuemart_product_prices`.`product_price`, `#__virtuemart_product_prices`.`virtuemart_shoppergroup_id`, `#__virtuemart_currencies`.`currency_code_3`, `#__virtuemart_products`.`product_url`, `#__virtuemart_products`.`published`, `Roof Type`, `#__virtuemart_products`.`virtuemart_vendor_id` FROM `#__virtuemart_products` LEFT JOIN `#__virtuemart_product_prices` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_prices`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `#__virtuemart_product_categories` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_currencies` ON `#__virtuemart_currencies`.`virtuemart_currency_id` = `#__virtuemart_product_prices`.`product_currency` LEFT JOIN `#__virtuemart_product_shoppergroups` ON `#__virtuemart_product_shoppergroups`.`virtuemart_product_id` = `#__virtuemart_products`.`virtuemart_product_id` WHERE #__virtuemart_products.virtuemart_product_id IN (12132,12133,12134,12135,12136,12141,12143,12144,12145,12146,12147,12148,12149,12150,12152,12153,(edited out many numbers here)15128,15129,15130,15131,15132,15133,15134,15135,15138,15139,15015) GROUP BY #__virtuemart_products.virtuemart_product_id LIMIT 49999

Hello,

Accounting Code is not a VirtueMart database field so I guess it is a custom field you use. Did you run the Update on the Available Fields page in CSVI? See if that helps.

Hello,
The fields Accounting Code, Acquired Date, Door Type, Other Charge are not VirtueMart tables core fields and so the query is not able to find them in VirtueMart product table. How did you get these fields? did you add them to VirtueMart tables?

Well that did get closer. Now it times out after 30 seconds. With exception to sku, and price, almost all other fields we use are custom, so if memory serves, there are around 90 custom fields in use.

Hello,

Was updating the available fields enough to get it running?

The message you see doesn't necessarily mean that the export has stopped but CSVI simply doesn't know if the server killed the export or not. To see if the export actually works or not, you could set a number of records to export in your template.

Depending on what kind of hosting package you have you could also set the maximum execution time in your template on the Limit tab, visible after clicking on the Advanced button. This may only work if you have a VPS or dedicated hosting.

Finally, you can also check with your hosting provider why the export doesn't finish. If an error is generated, this should show up in the server log.