Resolved Only 1 Product gets exported

Hello,

We are trying to figure out why your server is not listening to us If it was easy, we would give the solution immediately. So if we look at what is happening, CSVI requests the data from the database and when nothing else comes out of the database the export file is created. In your case CSVI gets only 1 record out of the database.

If you go to the Global Configuration and then the server tab, what do you see for the Database Type? If this is not MySQLi, please set it to MySQLi and check if the export returns more than 1 record.

Hi tharuna,

no sorry. the Testpage is clone of live site.

So how can we get this to work?
Should be easy but we are burning so much time with this :-(

Hope we can finde a solution soon.

Greetings

Hello,

I answer your Questions: 1.
Here is the error log for this:
2019-05-12T06:35:05+00:00 controller Holding edit ID com_csvi.edit.template.4 Array ( [0] => 4 )
2019-05-12T06:35:12+00:00 controller Releasing edit ID com_csvi.edit.template.4 Array ( )
2019-05-12T06:35:13+00:00 controller Holding edit ID com_csvi.edit.template.4 Array ( [0] => 4 )
2019-05-12T06:35:15+00:00 controller Releasing edit ID com_csvi.edit.template.4 Array ( )
2019-05-12T06:35:16+00:00 controller Holding edit ID com_csvi.edit.template.4 Array ( [0] => 4 )
2019-05-12T06:35:21+00:00 controller Releasing edit ID com_csvi.edit.template.4 Array ( )
2019-05-12T06:35:21+00:00 controller Holding edit ID com_csvi.edit.template.4 Array ( [0] => 4 )
2019-05-12T06:35:29+00:00 controller Releasing edit ID com_csvi.edit.template.4 Array ( )
2019-05-12T06:35:33+00:00 controller Holding edit ID com_csvi.edit.template.4 Array ( [0] => 4 )
2019-05-12T06:35:47+00:00 controller Releasing edit ID com_csvi.edit.template.4 Array ( )
2019-05-12T06:35:52+00:00 controller Holding edit ID com_csvi.edit.template.2 Array ( [0] => 2 )
2019-05-12T06:36:01+00:00 controller Releasing edit ID com_csvi.edit.template.2 Array ( )
2019-05-12T06:36:50+00:00 controller Holding edit ID com_csvi.edit.template.2 Array ( [0] => 2 )
2019-05-12T06:37:40+00:00 controller Releasing edit ID com_csvi.edit.template.2 Array ( )

These are not actually errors or atleast errors because of export. From the looks of it, it says about the CSVI template id which has been edited and then releasing the edited template id.

No sorry this is not possible at the moment. We have a clean test stage but same problem there.

Does this test stage have only Joomla and CSVI Pro installed?

Hello Tharuna,

sorry for the late reply. There was much work to do.
Hope we can now finaly complete this.

I answer your Questions: 1.
Here is the error log for this:
2019-05-12T06:35:05+00:00 controller Holding edit ID com_csvi.edit.template.4 Array ( [0] => 4 )
2019-05-12T06:35:12+00:00 controller Releasing edit ID com_csvi.edit.template.4 Array ( )
2019-05-12T06:35:13+00:00 controller Holding edit ID com_csvi.edit.template.4 Array ( [0] => 4 )
2019-05-12T06:35:15+00:00 controller Releasing edit ID com_csvi.edit.template.4 Array ( )
2019-05-12T06:35:16+00:00 controller Holding edit ID com_csvi.edit.template.4 Array ( [0] => 4 )
2019-05-12T06:35:21+00:00 controller Releasing edit ID com_csvi.edit.template.4 Array ( )
2019-05-12T06:35:21+00:00 controller Holding edit ID com_csvi.edit.template.4 Array ( [0] => 4 )
2019-05-12T06:35:29+00:00 controller Releasing edit ID com_csvi.edit.template.4 Array ( )
2019-05-12T06:35:33+00:00 controller Holding edit ID com_csvi.edit.template.4 Array ( [0] => 4 )
2019-05-12T06:35:47+00:00 controller Releasing edit ID com_csvi.edit.template.4 Array ( )
2019-05-12T06:35:52+00:00 controller Holding edit ID com_csvi.edit.template.2 Array ( [0] => 2 )
2019-05-12T06:36:01+00:00 controller Releasing edit ID com_csvi.edit.template.2 Array ( )
2019-05-12T06:36:50+00:00 controller Holding edit ID com_csvi.edit.template.2 Array ( [0] => 2 )
2019-05-12T06:37:40+00:00 controller Releasing edit ID com_csvi.edit.template.2 Array ( )

Question 2.
No sorry this is not possible at the moment. We have a clean test stage but same problem there.

Hope you can help to solve this.
Greetings

Hello,
We did not hear back from you on the issue. Was your issue solved? If yes, Can you tell us how you solved it?

Hello,
You must be seeing more rows with query, the first page shows 25 rows as page display limit is 25. With the screenshot it is confirmed that export query is not having any problem in fetching the records from database but when writing to export file, it writes only one record. Two things we can check here.

1. Can you check if there is any error on your server error log? I know there is no error shown on export but we need to find why one record is being written to export file. Just wanted to check if there is any error logged in server error logs.
2. Can you also check the export with another fresh Joomla instance and only CSVI Pro installed?

Hi Tharuna,

first of all, thanks for the great support.
I now get 25 results from your query.

I Post a Screenshot here.


Greetings and thanks for help.

Hello,
That error is because of using MySQL 5.7 version. Can you run the below query and check? Same as above replace the table prefix before running the query.

SELECT `#__virtuemart_products`.`virtuemart_product_id`,

`#__virtuemart_products`.`product_parent_id`,

`product_sku`,

`#__virtuemart_product_categories`.`virtuemart_category_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`

GROUP BY #__virtuemart_products.virtuemart_product_id, `#__virtuemart_products`.`product_parent_id`,

`product_sku`,

`#__virtuemart_product_categories`.`virtuemart_category_id`

Hello,

ok no problem, it gets me the following error:

#1055 - Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'XXX_virtuemart_product_categories.virtuemart_category_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

I removed #_ with the correct tag.

Greetings

Hello,
Yes that helped. I don't see any reason for your products not exporting. Can you run the below query in phpMyAdmin and check how many rows you see there? Select your database, click on SQL tab, copy and paste the below query and click Go. Don't forget to replace #_ with your table prefix before running the query. If you are finding this difficulty, do send me the phpMyAdmin details on Private message and I will check it in there.

SELECT `#__virtuemart_products`.`virtuemart_product_id`,

`#__virtuemart_products`.`product_parent_id`,

`product_sku`,

`#__virtuemart_product_categories`.`virtuemart_category_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`

GROUP BY #__virtuemart_products.virtuemart_product_id

Hi tharuna,

yes... you must know our virtuemart is full customs for vendors.
So any products has his own vendor and the site itself is not the vendor.

So in Product overview you have to set vendor to empty (bitte wählen) to see all products.
It is the right panel to select where the pagename stands.
Then press Go to see all products.

Hope it help.
Greetings..

Hello,
Thank you for sending debug log and the administrator access. I logged into your site and had a look at VirtueMart by going Components >> VirtueMart >> Products page and i do not see any products in there. Why is that so? If i do a product export i see only one product with SKU 753.140410.121257. Wonder where this product is coming from when there are no products on VirtuMart Products page.

Hi,

debug report via email and login via pm was send.

Greetings

Hello,

I send you the debug report right now.

How did you send it? I did not get it.

Hope you can help to solve this. I can give you login as well, because it is my test stage only.

You can send the login details with Private message or email to the address as above.

Hi there,

changed the language does not work. I get an error "you dont have En Gb Database" so i changed back to german.

Yes all products have more than one categories. I can see this in frontpage.

I send you the debug report right now.

Hope you can help to solve this. I can give you login as well, because it is my test stage only.
Greetings

Hello Alex,

I selected Categorpath and Category ID as well, but i dont see them in Export file.

Check the language set in your import template on Options tab. Could be possible that you are exporting from a wrong VirtueMart language table. But this also makes me think if your products have category assigned. When you check the product on VirtueMart page, do you see category assigned to them?

Can i post Error log here in Forum?

I dont want that to see other people.

You can send it as a private message or email it to tharuna@csvimproved.com.

Note: If i change the ordering of the export products, another product gets exported, but it is always only 1 product in the list.

Will look into your latest debug log and let you know on what i find.

Note: If i change the ordering of the export products, another product gets exported, but it is always only 1 product in the list.

Greetings

Can i post Error log here in Forum?

I dont want that to see other people.

Greetings

Hi Tharuna,

is send you csv export and newest log for Forum Posting
https://csvimproved.com/forum?view=topic&catid=44&id=34601

I selected Categorpath and Category ID as well, but i dont see them in Export file.

Greetings Alex

Hello,
Can you post your latest export debug log? Also can you do a VirtueMart product export with fields product_sku, category_id and category_path and send the exported CSV file? Also tell me the product_sku of the one product which was exported.