Resolved 504 Exporting Error

simonhodgkiss
RO CSVI
Saturday, 18 April 2020
Subscribe via email

Hello,

I appear to be having issues with Exporting category or products from my Virtuemart website.

Please can you help?

The same 7222 line is repeated 1.6 million times on the debug file.



#

#<?php die('Forbidden.'); ?>

#Date: 2020-04-18 13:34:37 UTC

#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT



#Fields: date	time	line_nr	action	comment

2020-04-18	13:34:37	0	[DEBUG]	Clean up old logs. Found 25 logs and threshold is 25 logs

2020-04-18	13:34:38	0	[DEBUG]	Clean up old logs. Found 25 logs and threshold is 25 logs

2020-04-18	13:34:38	0	[DEBUG]	Setting system limits:

2020-04-18	13:34:38	0	[DEBUG]	Setting max_execution_time to 1000000 seconds

2020-04-18	13:34:38	0	[DEBUG]	Setting memory_limit to 6000M

2020-04-18	13:34:38	0	[DEBUG]	RO CSVI Version: 7.15.0

2020-04-18	13:34:38	0	[DEBUG]	Joomla! version: 3.8.8

2020-04-18	13:34:38	0	[DEBUG]	PHP version: 7.3.16

2020-04-18	13:34:38	0	[DEBUG]	=========================

2020-04-18	13:34:38	0	[DEBUG]	action: export

2020-04-18	13:34:38	0	[DEBUG]	component: com_virtuemart

2020-04-18	13:34:38	0	[DEBUG]	operation: category

2020-04-18	13:34:38	0	[DEBUG]	override: 

2020-04-18	13:34:38	0	[DEBUG]	0: todownload

2020-04-18	13:34:38	0	[DEBUG]	output_empty_file: Yes

2020-04-18	13:34:38	0	[DEBUG]	localpath: /home/rccarshop/public_html

2020-04-18	13:34:38	0	[DEBUG]	ftphost: 

2020-04-18	13:34:38	0	[DEBUG]	ftpport: 

2020-04-18	13:34:38	0	[DEBUG]	sftp: No

2020-04-18	13:34:38	0	[DEBUG]	ftproot: 

2020-04-18	13:34:38	0	[DEBUG]	ftpfile: 

2020-04-18	13:34:38	0	[DEBUG]	export_email_subject: 

2020-04-18	13:34:38	0	[DEBUG]	export_email_body: 

2020-04-18	13:34:38	0	[DEBUG]	database_username: 

2020-04-18	13:34:38	0	[DEBUG]	database_host: 

2020-04-18	13:34:38	0	[DEBUG]	database_portno: 

2020-04-18	13:34:38	0	[DEBUG]	database_name: 

2020-04-18	13:34:38	0	[DEBUG]	database_table: 

2020-04-18	13:34:38	0	[DEBUG]	primary_key_source: category_name

2020-04-18	13:34:38	0	[DEBUG]	primary_key_target: id

2020-04-18	13:34:38	0	[DEBUG]	create_new_columns: Yes

2020-04-18	13:34:38	0	[DEBUG]	export_filename: category-export.csv

2020-04-18	13:34:38	0	[DEBUG]	export_file: csv

2020-04-18	13:34:38	0	[DEBUG]	field_delimiter: ,

2020-04-18	13:34:38	0	[DEBUG]	text_enclosure: 

2020-04-18	13:34:38	0	[DEBUG]	include_column_headers: Yes

2020-04-18	13:34:38	0	[DEBUG]	include_empty_nodes: Yes

2020-04-18	13:34:38	0	[DEBUG]	signature: No

2020-04-18	13:34:38	0	[DEBUG]	publish_state: 

2020-04-18	13:34:38	0	[DEBUG]	recordstart: Yes

2020-04-18	13:34:38	0	[DEBUG]	recordend: 50

2020-04-18	13:34:38	0	[DEBUG]	export_date_format: d/m/Y H:i:s

2020-04-18	13:34:38	0	[DEBUG]	export_price_format_decimal: 2

2020-04-18	13:34:38	0	[DEBUG]	export_price_format_decsep: .

2020-04-18	13:34:38	0	[DEBUG]	export_price_format_thousep: 

2020-04-18	13:34:38	0	[DEBUG]	header: 

2020-04-18	13:34:38	0	[DEBUG]	body: 

2020-04-18	13:34:38	0	[DEBUG]	footer: 

2020-04-18	13:34:38	0	[DEBUG]	language: en-GB

2020-04-18	13:34:38	0	[DEBUG]	target_language: en-GB

2020-04-18	13:34:38	0	[DEBUG]	category_separator: /

2020-04-18	13:34:38	0	[DEBUG]	groupbyfields: 

2020-04-18	13:34:38	0	[DEBUG]	sortfields: 

2020-04-18	13:34:38	0	[DEBUG]	use_system_limits: Yes

2020-04-18	13:34:38	0	[DEBUG]	max_execution_time: 1000000

2020-04-18	13:34:38	0	[DEBUG]	memory_limit: 6000

2020-04-18	13:34:38	0	[DEBUG]	csvi_template_id: 18

2020-04-18	13:34:38	0	[DEBUG]	tags: 

2020-04-18	13:34:38	0	[DEBUG]	=========================

2020-04-18	13:34:38	0	[DEBUG]	Export field: category_name

2020-04-18	13:34:38	0	[DEBUG]	Export field: category_path

2020-04-18	13:34:38	0	[DEBUG]	Export query

SELECT `#__virtuemart_categories`.`virtuemart_category_id`

FROM `#__virtuemart_categories`

LEFT JOIN `#__virtuemart_categories_en_gb` ON `#__virtuemart_categories_en_gb`.`virtuemart_category_id` = `#__virtuemart_categories`.`virtuemart_category_id`

LEFT JOIN `#__virtuemart_category_medias` ON `#__virtuemart_category_medias`.`virtuemart_category_id` = `#__virtuemart_categories`.`virtuemart_category_id` LIMIT 49

2020-04-18	13:34:38	1	[DEBUG]	Get cat ID7222

2020-04-18	13:34:38	1	[QUERY]	 SELECT `category_parent_id`,`l`.`category_name` FROM `jos_virtuemart_category_categories` AS `x` LEFT JOIN `jos_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `jos_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 7222

2020-04-18	13:34:38	1	[DEBUG]	Get cat ID7222

2020-04-18	13:34:38	1	[QUERY]	 SELECT `category_parent_id`,`l`.`category_name` FROM `jos_virtuemart_category_categories` AS `x` LEFT JOIN `jos_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `jos_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 7222

2020-04-18	13:34:38	1	[DEBUG]	Get cat ID7222

2020-04-18	13:34:38	1	[QUERY]	 SELECT `category_parent_id`,`l`.`category_name` FROM `jos_virtuemart_category_categories` AS `x` LEFT JOIN `jos_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `jos_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 7222

2020-04-18	13:34:38	1	[DEBUG]	Get cat ID7222

2020-04-18	13:34:38	1	[QUERY]	 SELECT `category_parent_id`,`l`.`category_name` FROM `jos_virtuemart_category_categories` AS `x` LEFT JOIN `jos_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `jos_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 7222

2020-04-18	13:34:38	1	[DEBUG]	Get cat ID7222

2020-04-18	13:34:38	1	[QUERY]	 SELECT `category_parent_id`,`l`.`category_name` FROM `jos_virtuemart_category_categories` AS `x` LEFT JOIN `jos_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `jos_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 7222

2020-04-18	13:34:38	1	[DEBUG]	Get cat ID7222

2020-04-18	13:34:38	1	[QUERY]	 SELECT `category_parent_id`,`l`.`category_name` FROM `jos_virtuemart_category_categories` AS `x` LEFT JOIN `jos_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `jos_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 7222

2020-04-18	13:34:38	1	[DEBUG]	Get cat ID7222

2020-04-18	13:34:38	1	[QUERY]	 SELECT `category_parent_id`,`l`.`category_name` FROM `jos_virtuemart_category_categories` AS `x` LEFT JOIN `jos_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `jos_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 7222

2020-04-18	13:34:38	1	[DEBUG]	Get cat ID7222

2020-04-18	13:34:38	1	[QUERY]	 SELECT `category_parent_id`,`l`.`category_name` FROM `jos_virtuemart_category_categories` AS `x` LEFT JOIN `jos_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `jos_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 7222

2020-04-18	13:34:38	1	[DEBUG]	Get cat ID7222

2020-04-18	13:34:38	1	[QUERY]	 SELECT `category_parent_id`,`l`.`category_name` FROM `jos_virtuemart_category_categories` AS `x` LEFT JOIN `jos_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `jos_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 7222

2020-04-18	13:34:38	1	[DEBUG]	Get cat ID7222

2020-04-18	13:34:38	1	[QUERY]	 SELECT `category_parent_id`,`l`.`category_name` FROM `jos_virtuemart_category_categories` AS `x` LEFT JOIN `jos_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `jos_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 7222

2020-04-18	13:34:38	1	[DEBUG]	Get cat ID7222

2020-04-18	13:34:38	1	[QUERY]	 SELECT `category_parent_id`,`l`.`category_name` FROM `jos_virtuemart_category_categories` AS `x` LEFT JOIN `jos_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `jos_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 7222

2020-04-18	13:34:38	1	[DEBUG]	Get cat ID7222

Responses (5)

tharuna

Accepted Answer Pending Moderation

Hello,

The same 7222 line is repeated 1.6 million times on the debug file.

The code seems to be struck in a loop and so you are seeing those lines repeated in debug log. Can you run the below query from your PhpMyAdmin and send us a screenshot on what you see? Please make sure to replace #_ to your table prefix before running the query.

SELECT `#__virtuemart_categories`.`virtuemart_category_id`

FROM `#__virtuemart_categories`

LEFT JOIN `#__virtuemart_categories_en_gb` ON `#__virtuemart_categories_en_gb`.`virtuemart_category_id` = `#__virtuemart_categories`.`virtuemart_category_id`

LEFT JOIN `#__virtuemart_category_medias` ON `#__virtuemart_category_medias`.`virtuemart_category_id` = `#__virtuemart_categories`.`virtuemart_category_id` LIMIT 49

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

more than a month ago
RO CSVI
# 1

simonhodgkiss

Accepted Answer Pending Moderation

Please see the attached image.

more than a month ago
RO CSVI
# 2

tharuna

Accepted Answer Pending Moderation

Hello,
As per the screenshot the ids look fine. Can you send me the Joomla administrator login details and (S)FTP details of your site? Let me check what is going on with your export. You can paste the details on Site Details tab under your reply.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

more than a month ago
RO CSVI
# 3

simonhodgkiss

Accepted Answer Pending Moderation

Hello,

Thank you for the reply.

Do you know if PHP 5.6 has issues?

Also when I change to PHP 7.3 I get a cart error

"Call to undefined function mcrypt_encrypt()"

This seems odd since mcrypt is no longer in PHP 7.3 but why should the latest Virtuemart needed it?

Thanks

more than a month ago
RO CSVI
# 4

rolandd

Accepted Answer Pending Moderation

Hello Simon,

RO CSVI requires at least PHP 7.1 so should run fine on PHP 7.3. It will not run on PHP 5.6. I don't think VM requires mcrypt itself but this looks like a function of their own or perhaps a plugin you are using.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

more than a month ago
RO CSVI
# 5

Page :
1

There are no replies made for this post yet.
Be one of the first to reply to this post!

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

Resolved 504 Exporting Error

RO CSVI

RO Payments

RO Users

RO Single Sign On