Categories
View Replies (16)

Resolved export template error

  1. joely666
    joely666
  2. RO CSVI
  3. Monday, 21 September 2015
  4.  Subscribe via email
Hi,
csvi 6.1.2
joomla 3.4.4
vm 3.0.10

I get a 500 error saving any export template. The template is however created, but clicking on it also leads to a 500 error. Fields can be added to it via 'template fields", but exporting leads to the following error:
Error
Table 'tarea3_HB2.x79kf_virtuemart_manufacturers_' doesn't exist SQL=SELECT `mf_name` FROM `x79kf_virtuemart_manufacturers_` LEFT JOIN `x79kf_virtuemart_product_manufacturers` ON `x79kf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `x79kf_virtuemart_manufacturers_`.`virtuemart_manufacturer_id` WHERE `virtuemart_product_id` = 13

This is the relevant bit of the server log for the 500 error:

219.44.201.0 - - [21/Sep/2015:12:09:11 +0100] "POST /hbv4/administrator/index.php HTTP/1.1" 200 20494 "http://mydomain.com/hbv4/administrator/index.php?option=com_csvi&view=templates"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:15 +0100] "GET /hbv4/administrator/index.php?option=com_csvi&view=tasks&task=loadtasks&format=json&action=export&component=com_csvi HTTP/1.1" 200 52 "http://mydomain.com/hbv4/administrator/index.php" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:17 +0100] "GET /hbv4/administrator/index.php?option=com_csvi&view=tasks&task=loadtasks&format=json&action=export&component=com_virtuemart HTTP/1.1" 200 500 "http://mydomain.com/hbv4/administrator/index.php" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:39 +0100] "POST /hbv4/administrator/index.php?option=com_csvi&view=template&id= HTTP/1.1" 303 - "http://mydomain.com/hbv4/administrator/index.php" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:39 +0100] "GET /hbv4/administrator/index.php?option=com_csvi&view=template&task=edit&id=9 HTTP/1.1" 404 - "http://mydomain.com/hbv4/administrator/index.php" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/media/jui/css/chosen.css HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/media/jui/css/sortablelist.css HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/index.php?option=com_csvi&view=templates"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/administrator/components/com_csvi/assets/css/display.css HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/index.php?option=com_csvi"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/administrator/templates/isis/css/template.css?facb1fcd55d2c63f30d35341ae4fab5a HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/index.php" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/media/akeeba_strapper/css/strapper.css HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/index.php?option=com_csvi"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/media/akeeba_strapper/css/bootstrap.j3.css HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/index.php?option=com_csvi"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/administrator/index.php?option=com_csvi&view=templates HTTP/1.1" 200 40034 "http://mydomain.com/hbv4/administrator/index.php?option=com_csvi&view=processes"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/media/jui/js/jquery.min.js HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/media/jui/js/jquery-migrate.min.js HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/media/system/js/core.js HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/media/system/js/multiselect.js HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/index.php?option=com_installer&view=update"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/media/jui/js/jquery.ui.core.min.js HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/index.php?option=com_csvi&view=templates"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/media/jui/js/sortablelist.js HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/index.php?option=com_csvi&view=templates"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/media/akeeba_strapper/js/namespace.js HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/index.php?option=com_csvi"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/administrator/components/com_csvi/assets/js/csvi.js HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/index.php?option=com_csvi"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:47 +0100] "GET /hbv4/media/jui/js/chosen.jquery.min.js HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:48 +0100] "GET /hbv4/administrator/templates/isis/js/template.js?facb1fcd55d2c63f30d35341ae4fab5a HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/index.php" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:48 +0100] "GET /hbv4/media/jui/js/bootstrap.min.js HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:48 +0100] "GET /hbv4/media/jui/js/jquery-noconflict.js HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:48 +0100] "GET /hbv4/media/jui/js/jquery.ui.sortable.min.js HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/index.php?option=com_csvi&view=templates"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:48 +0100] "GET /hbv4/administrator/templates/isis/images/logo.png HTTP/1.1" 304 - "http://mydomain.com/hbv4/administrator/index.php" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
219.44.201.0 - - [21/Sep/2015:12:09:51 +0100] "GET /hbv4/administrator/index.php?option=com_csvi&view=template&id=9 HTTP/1.1" 404 - "http://mydomain.com/hbv4/administrator/index.php?option=com_csvi&view=templates"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"

Thanks
0
Responses (16)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I get a 500 error saving any export template.
What is the exact error you get?

but exporting leads to the following error
This error happens because no language is selected in the export template. Do you have English installed on the site as well?

Can you backup your template via Maintenance and post it here? I will check it and see if I can fix it so you can at least open this template.
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
joely666
joely666
Accepted Answer Pending Moderation
HI,

I have installed the CSVi templates and I have the same error trying to open all of the export ones.
The error message says 'Internal server error' and contact sys admin.

The site is in English only - I don't see any option for language selection when creating a template.
When trying to export from the default templates I get another internal server error, unlike when I try to export from my template which I suppose is tripping up on the lack of set language before the other error kicks in...

I haven't a clue! do you suppose it's something local to the server?

Cheers
Attachments (1)
csvi_templates_20150922.xml
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The error message says 'Internal server error' and contact sys admin.
That is the worst of all errors. It just says there is an error but I won't tell you what. The real error is saved in the server error log. You will need to contact your hosting provider to get the real error, they should be able to find that in the server log.

Ok, I have updated your template, you can load it via the Maintenance and restore option. It will create a new template with the same name but now with more options pre-selected.

In case you haven't done this before you can also try to go to Maintenance -> Tasks -> Reset and confirm and then go to Maintenance -> Available Fields and click Update. This resets the tasks and available fields.
Attachments (1)
csvi_templates_20150922_update.xml
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. # 3
joely666
joely666
Accepted Answer Pending Moderation
Thanks Roland,

The edited template now gives a 500 error like the others. Here are the errors from the Apache log:
[Wed Sep 23 12:19:33 2015] [error] [client 217.42.201.0] Premature end of script headers: index.php, referer: http://mydomain.com/hbv4/administrator/index.php?option=com_csvi&view=templates

[Wed Sep 23 12:19:33 2015] [error] [client 217.42.201.0] File does not exist: /home/tarea3/public_html/500.shtml, referer: http://mydomain.com/hbv4/administrator/index.php?option=com_csvi&view=templates

Does it mean anything useful to you?

Cheers
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The error Premature end of script headers means that the server stopped CSVI before it could complete it's request. This is also the real error as to why it doesn't work.

One of the reasons for this can be the maximum execution time being exceeded, in that case this should be increased. If you get the error as soon as you start the export, let's say within 20 seconds, it will be another reason. In that case, the hosting company may be able to tell you why this error happens. Ultimately it is the server that stops CSVI from continuing, so the question is what is it that triggers the server to stop the export.
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. # 5
joely666
joely666
Accepted Answer Pending Moderation
The hosting company can shed no further light on it. They asked if there were any specific PHP setting required for CSVi...

I suppose I should try uninstalling and starting from scratch?

The other log output for this that I could find is below:
217.42.201.0 - - [23/Sep/2015:12:19:11 +0100] "POST /hbv4/administrator/index.php?option=com_csvi&view=export HTTP/1.1" 200 28942 "http://mydomain.com/hbv4/administrator/index.php?option=com_csvi&view=exports"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"
217.42.201.0 - - [23/Sep/2015:12:19:12 +0100] "GET /hbv4/administrator/index.php?option=com_csvi&view=exports&task=export&format=json&runId=42&_=1443007153825 HTTP/1.1" 500 - "http://mydomain.com/hbv4/administrator/index.php?option=com_csvi&view=export"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/600.8.9 (KHTML, like Gecko) Version/8.0.8 Safari/600.8.9"

Cheers
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
They asked if there were any specific PHP setting required for CSVi...
The only thing that may be required is an increased max_execution_time setting but you get the error on opening a template, so this is not applicable.

Let's retrace the steps. If you click on New for creating a new template, everything is OK, correct? When you then click Save you get the 500 error, correct?
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. # 7
joely666
joely666
Accepted Answer Pending Moderation
Yes, but only for export templates. The template is nevertheless created, but gives an error when trying to edit the template or run it. Import templates save fine and run fine.
  1. more than a month ago
  2. RO CSVI
  3. # 8
rolandd
rolandd
Accepted Answer Pending Moderation
but gives an error when trying to edit the template or run it.
Can you post a screenshot of the error you get on editing the template?
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. # 9
joely666
joely666
Accepted Answer Pending Moderation
When clicking the link to edit the export template I just get a white screen saying 'internal server error'. When trying to export from the same template I get the 500 error, but in a dialouge box, as seen in the attached. It states that there was an 'error on the import', but I can confirm that this was definitely an export. The export file is created in the 'tmp' folder with column headers only - no content.
  1. more than a month ago
  2. RO CSVI
  3. # 10
rolandd
rolandd
Accepted Answer Pending Moderation
It states that there was an 'error on the import', but I can confirm that this was definitely an export.
An issue with the language string I think. The least of our worries ;)

Something else in regards to the script headers. Are you by any chance running PHP 5.3? If so, it is time for an update. If not, send me a private message with Joomla/FTP login details and I will take a look.
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. # 11
joely666
joely666
Accepted Answer Pending Moderation
Yes 5.3.19. I'll do that now. Run another test and let you know. Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 12
joely666
joely666
Accepted Answer Pending Moderation
Unfortunately I can't upgrade at the moment. The server hosts a few other sites so I need to test them first...

If you think that the PHP version is a likely cause would you suggest downgrading to an earlier CSVi version?
Let me know if you still want login details and I'll PM you.

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 13
rolandd
rolandd
Accepted Answer Pending Moderation
If you think that the PHP version is a likely cause
I actually confirmed it on another server.

would you suggest downgrading to an earlier CSVi version?
Not really because I believe that all software must be up-to-date, not just Joomla. Especially when it comes to a PHP version that is so old, I would expect from a hoster to keep their systems up-to-date.

If you have no choice, all you can do is downgrade to CSVI 5, depending on what you need to do, this might cause issues with the latest VirtueMart versions. It is sort of a can of worms when mixing old and new software. That is why the requirements state you need PHP 5.4 for CSVI 6, as it will work. Even that is a minimum version as PHP 5.4 is no longer supported either by PHP.
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. # 14
joely666
joely666
Accepted Answer Pending Moderation
Understood. I'll try and work out what impact the PHP upgrade will have on my other sites and take it from there.

Cheers
  1. more than a month ago
  2. RO CSVI
  3. # 15
rolandd
rolandd
Accepted Answer Pending Moderation
Sounds like a good plan, in addition you get a much faster PHP :)
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. # 16
  • Page :
  • 1


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