Categories
View Replies (6)

Resolved Internal server error exporting Virtuemart Cat.

  1. a.terracina
    a.terracina
  2. RO CSVI
  3. Tuesday, 19 April 2016
  4.  Subscribe via email
Joomla Version:3.5.1
CSVI Pro Version: 6.5.6
CSVI PRO EXTENSIONS version: 6.5.6.1
VirtueMart 3.0.14
Hi,
exporting virtuemart categories (using Example Virtuemart Category export template) I get a 500 internal server error
The export log begins:
#
#<?php die('Forbidden.'); ?>
#Date: 2016-04-19 07:59:02 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

#Fields: date time line_nr action comment
2016-04-19 07:59:02 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-04-19 07:59:02 0 [QUERY] SELECT csvi_log_id FROM j3_csvi_logs ORDER BY csvi_log_id
2016-04-19 07:59:03 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-04-19 07:59:03 0 [QUERY] SELECT csvi_log_id FROM j3_csvi_logs ORDER BY csvi_log_id
2016-04-19 07:59:03 0 [DEBUG] CSVI Pro Version: 6.5.6
2016-04-19 07:59:03 0 [DEBUG] Joomla! version: 3.5.1
2016-04-19 07:59:03 0 [DEBUG] PHP version: 5.6.3
2016-04-19 07:59:03 0 [DEBUG] =========================
2016-04-19 07:59:03 0 [DEBUG] action: export
2016-04-19 07:59:03 0 [DEBUG] component: com_virtuemart
2016-04-19 07:59:03 0 [DEBUG] operation: category
2016-04-19 07:59:03 0 [DEBUG] localpath: C:\xampp5_6_3\htdocs\aremedia_s
2016-04-19 07:59:03 0 [DEBUG] ftphost:
2016-04-19 07:59:03 0 [DEBUG] ftpport:
2016-04-19 07:59:03 0 [DEBUG] ftproot:
2016-04-19 07:59:03 0 [DEBUG] ftpfile:
2016-04-19 07:59:03 0 [DEBUG] export_email_subject:
2016-04-19 07:59:03 0 [DEBUG] export_email_body:
2016-04-19 07:59:03 0 [DEBUG] export_filename: categorie
2016-04-19 07:59:03 0 [DEBUG] export_file: csv
2016-04-19 07:59:03 0 [DEBUG] field_delimiter: ,
2016-04-19 07:59:03 0 [DEBUG] text_enclosure:
2016-04-19 07:59:03 0 [DEBUG] include_column_headers: Sì
2016-04-19 07:59:03 0 [DEBUG] signature: Sì
2016-04-19 07:59:03 0 [DEBUG] publish_state:
2016-04-19 07:59:03 0 [DEBUG] recordstart:
2016-04-19 07:59:03 0 [DEBUG] recordend:
2016-04-19 07:59:03 0 [DEBUG] export_date_format: d/m/Y H:i:s
2016-04-19 07:59:03 0 [DEBUG] export_price_format_decimal: 2
2016-04-19 07:59:03 0 [DEBUG] export_price_format_decsep: .
2016-04-19 07:59:03 0 [DEBUG] export_price_format_thousep:
2016-04-19 07:59:03 0 [DEBUG] header:
2016-04-19 07:59:03 0 [DEBUG] body:
2016-04-19 07:59:03 0 [DEBUG] footer:
2016-04-19 07:59:03 0 [DEBUG] language: it-IT
2016-04-19 07:59:03 0 [DEBUG] target_language: it-IT
2016-04-19 07:59:03 0 [DEBUG] category_separator: /
2016-04-19 07:59:03 0 [DEBUG] groupbyfields:
2016-04-19 07:59:03 0 [DEBUG] sortfields:
2016-04-19 07:59:03 0 [DEBUG] use_system_limits: No
2016-04-19 07:59:03 0 [DEBUG] max_execution_time:
2016-04-19 07:59:03 0 [DEBUG] memory_limit:
2016-04-19 07:59:03 0 [DEBUG] =========================
2016-04-19 07:59:03 0 [DEBUG] Export field: category_path
2016-04-19 07:59:03 0 [DEBUG] Export field: category_description
2016-04-19 07:59:03 0 [DEBUG] Export field: file_url
2016-04-19 07:59:03 0 [DEBUG] Export field: file_url_thumb
2016-04-19 07:59:03 0 [DEBUG] Export field: published
2016-04-19 07:59:03 0 [DEBUG] Export query
SELECT `#__virtuemart_categories`.`virtuemart_category_id`,
`#__virtuemart_category_medias`.`virtuemart_media_id`,
`published`
FROM `#__virtuemart_categories`
LEFT JOIN `#__virtuemart_categories_it_it` ON `#__virtuemart_categories_it_it`.`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`
2016-04-19 07:59:03 1 [DEBUG] Get cat ID1
2016-04-19 07:59:03 1 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `j3_virtuemart_category_categories` AS `x` LEFT JOIN `j3_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `j3_virtuemart_categories_it_it` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 1
2016-04-19 07:59:03 1 [DEBUG] Get cat ID1
2016-04-19 07:59:03 1 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `j3_virtuemart_category_categories` AS `x` LEFT JOIN `j3_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `j3_virtuemart_categories_it_it` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 1
2016-04-19 07:59:03 1 [DEBUG] Get cat ID1
2016-04-19 07:59:03 1 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `j3_virtuemart_category_categories` AS `x` LEFT JOIN `j3_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `j3_virtuemart_categories_it_it` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 1
2016-04-19 07:59:03 1 [DEBUG] Get cat ID1
2016-04-19 07:59:03 1 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `j3_virtuemart_category_categories` AS `x` LEFT JOIN `j3_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `j3_virtuemart_categories_it_it` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 1
...............................

and the last two rows are repeated about a million times
I think there is a loop in the query generation ... or what?
Help me please!
Thank you!
0
Responses (6)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I have checked the database dump you sent me and your data is corrupted. In the database you have set that category with ID 1 is a child of itself. That is impossible of course and this causes the loop.

So you will need to clean up your categories. In the virtuemart_category_categories table find the entry where parent ID and child ID are both 1 and set the child ID to 0. That should make things work again.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

That is odd, because that number 1 is the first value the main query returns as category ID, however that entry does not seem to exist. Could you send me an export of your tables
  • j3_virtuemart_category_categories
  • j3_virtuemart_categories
  • j3_virtuemart_categories_it_it
in a zipfile in a private message? I will check what is wrong or not with the data structure.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
a.terracina
a.terracina
Accepted Answer Pending Moderation
Hello,
I run your query and I got 0 results.
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I have created my own category export and I see that there is an issue with your categories. A category has a tree structure, so we look for the first entry and then the second lower one and go down the tree that way. In your case, the value that comes back from the first search isn't correct as it keeps trying the same one.

If you know how, go to PhpMyAdmin (or another database tool) and execute this query 
	SELECT `category_parent_id`,`l`.`category_name` FROM `j3_virtuemart_category_categories` AS `x` LEFT JOIN `j3_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `j3_virtuemart_categories_it_it` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 1
what is the result of that?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
a.terracina
a.terracina
Accepted Answer Pending Moderation
Yes! My Database Type is setted to MySQLi
And... yes! My log file is about 203.208KB and contains exactly 1.017.575 rows!!!.
My store contains 174 categories....
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

and the last two rows are repeated about a million times
Is that a figure of speech or you counted them :)

The debug log looks perfectly fine except for the repeating query. In your site under Global Settings -> Server -> Database Type do you have MySQLi set?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


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