Resolved error import on joomla 3

soura123
RO CSVI
Thursday, 12 March 2015
Subscribe via email

can you help what is going wrong.. on joomla 3 and vm 3 i get this:
PHP Warning: get_html_translation_table() expects at most 2 parameters, 3 given in /home/galor/public_html/TEST/ROSSI/libraries/joomla/filter/input.php on line 691
PHP Warning: Invalid argument supplied for foreach() in /home/galor/public_html/TEST/ROSSI/libraries/joomla/filter/input.php on line 693
PHP Warning: strtr(): The second argument is not an array in /home/galor/public_html/TEST/ROSSI/libraries/joomla/filter/input.php on line 699
Processing started: 12th March 2015, 6:42 pm
Template name: xml_expus_sync
You are not authorised to view this resource.
Processing finished: 12th March 2015, 6:42 pm
Process ran for 0 seconds
User has been logged out

Responses (13)

rolandd

Accepted Answer Pending Moderation

Hello,

I don't know what generates the warnings but the problem I do see is this:

You are not authorised to view this resource.

and this probably triggers the warnings.

The user you are using for the cron job, does it have access rights to the backend and the CSVI extension?

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
# 1

soura123

Accepted Answer Pending Moderation

yes the user is super user... i user csvi months now and i start building my site to joomla 3 and vm 3 to a test directory and on the tests i done for everything i get this error... how can see what is going on?

more than a month ago
RO CSVI
# 2

rolandd

Accepted Answer Pending Moderation

It is difficult to see what is going on. The main problem is that the user doesn't have the right privileges or maybe not loaded. Easiest way for CSVI 5 Pro is to remove the lines



// Access check.

if (!JFactory::getUser()->authorise('core.manage', 'com_csvi')) {

	$jinput = JFactory::getApplication()->input;

	$cron = $jinput->get('cron', false, 'bool');

	if ($cron) {

		echo JText::_('JERROR_ALERTNOAUTHOR')."\n";

		return false;

	}

	else return JError::raiseWarning(404, JText::_('JERROR_ALERTNOAUTHOR'));

}

from the file administrator/components/com_csvi/csvi.php

For CSVI 6 Pro, this check is not used anymore and it uses a secret key you can set in the template. Since you are building a new site, it might be a good time to test the CSVI 6 Pro as well. This has better VM 3 support than CSVI 5 has.

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
# 3

soura123

Accepted Answer Pending Moderation

well on the 6 beta version... on the templates section on the components has no virtuemart and no custom filters so....

more than a month ago
RO CSVI
# 4

soura123

Accepted Answer Pending Moderation

i remove the lines as you told but i get this:
PHP Warning: get_html_translation_table() expects at most 2 parameters, 3 given in /home/galor/public_html/TEST/ROSSI/libraries/joomla/filter/input.php on line 949
PHP Warning: Invalid argument supplied for foreach() in /home/galor/public_html/TEST/ROSSI/libraries/joomla/filter/input.php on line 951
PHP Warning: strtr(): The second argument is not an array in /home/galor/public_html/TEST/ROSSI/libraries/joomla/filter/input.php on line 957
PHP Warning: get_html_translation_table() expects at most 2 parameters, 3 given in /home/galor/public_html/TEST/ROSSI/libraries/joomla/filter/input.php on line 949
PHP Warning: Invalid argument supplied for foreach() in /home/galor/public_html/TEST/ROSSI/libraries/joomla/filter/input.php on line 951
PHP Warning: strtr(): The second argument is not an array in /home/galor/public_html/TEST/ROSSI/libraries/joomla/filter/input.php on line 957
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-gb" lang="en-gb" dir="ltr">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<title>Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 SQL=SELECT name
FROM galore_csvi_template_settings
WHERE id =</title>
<link rel="stylesheet" href="/templates/isis/css/template.css" type="text/css" />
<link href="/templates/isis/favicon.ico" rel="shortcut icon" type="image/vnd.microsoft.icon" />
<script src="../media/jui/js/jquery.js" type="text/javascript"></script>
<script src="../media/jui/js/jquery-noconflict.js" type="text/javascript"></script>
<script src="../media/jui/js/bootstrap.js" type="text/javascript"></script>
<script src="/templates/isis/js/template.js" type="text/javascript"></script>

</head>

<body class="admin com_csvi view-products layout- task-doimport " data-spy="scroll" data-target=".subhead" data-offset="87">

<nav class="navbar navbar-inverse navbar-fixed-top">
<div class="navbar-inner">
<div class="container-fluid">
<a class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</a>
<a class="admin-logo" href=""><span class="icon-joomla"></span></a>

<a class="brand hidden-desktop hidden-tablet" href="http://www.galore.gr/" title="TPL_ISIS_PREVIEW" target="_blank">Galore.gr <span class="icon-out-2 small"></span></a>

<div class="nav-collapse">
<ul class="nav nav-user pull-right">
<li class="dropdown">
<a class="dropdown-toggle" data-toggle="dropdown" href="#"><span class="icon-cog"></span>
<b class="caret"></b></a>
<ul class="dropdown-menu">
<li>
<span>
<span class="icon-user"></span>
<strong></strong>
</span>
</li>
<li class="divider"></li>
<li class="">
<a href="index.php?option=com_admin&task=profile.edit&id=0">TPL_ISIS_EDIT_ACCOUNT</a>
</li>
<li class="divider"></li>
<li class="">
<a href="/index.php?option=com_login&task=logout&6214b19070637931d4937afb86e2fcae=1">TPL_ISIS_LOGOUT</a>
</li>
</ul>
</li>
</ul>
<a class="brand visible-desktop visible-tablet" href="http://www.galore.gr/" title="TPL_ISIS_PREVIEW" target="_blank">Galore.gr <span class="icon-out-2 small"></span></a>
</div>

</div>
</div>
</nav>

<header class="header">
<div class="container-logo">
<img src="/templates/isis/images/logo.png" class="logo" />
</div>
<div class="container-title">
<h1 class="page-title">Error</h1>
</div>
</header>
<div class="subhead-spacer" style="margin-bottom: 20px"></div>

<div class="container-fluid container-main">
<section id="content">

<div class="row-fluid">
<div class="span12">

<h1 class="page-header">An error has occurred.</h1>
<blockquote>
<span class="label label-inverse">1064</span> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 SQL=SELECT name
FROM galore_csvi_template_settings
WHERE id = </blockquote>
<p><a href="" class="btn"><i class="icon-dashboard"></i> Return to Control Panel</a></p>

</div>
</div>

</section>
<hr />
</div>
<script>
(function($){
// fix sub nav on scroll
var $win = $(window)
, $nav = $('.subhead')
, navTop = $('.subhead').length && $('.subhead').offset().top - 40
, isFixed = 0

processScroll()

// hack sad times - holdover until rewrite for 2.1
$nav.on('click', function ()
{
if (!isFixed) setTimeout(function () { $win.scrollTop($win.scrollTop() - 47) }, 10)
})

$win.on('scroll', processScroll)

function processScroll()
{
var i, scrollTop = $win.scrollTop()
if (scrollTop >= navTop && !isFixed)
{
isFixed = 1
$nav.addClass('subhead-fixed')
} else if (scrollTop <= navTop && isFixed)
{
isFixed = 0
$nav.removeClass('subhead-fixed')
}
}
})(jQuery);
</script>
</body>
</html>

any ideas please...

more than a month ago
RO CSVI
# 5

soura123

Accepted Answer Pending Moderation

i test csvi without cron fron the proccess button with a smaller fiel and it is working correctly...
so the problem is with the cron... ...any ideas please?

more than a month ago
RO CSVI
# 6

rolandd

Accepted Answer Pending Moderation

on the templates section on the components has no virtuemart and no custom filters so....

In that case you have either not installed the VirtueMart addon or the follow-up steps are not yet performed. After installing the VirtueMart addon you need to go to Maintenance -> Tasks -> Reset and after that Maintenance -> Available fields Update. This makes VirtueMart available in CSVI.

i test csvi without cron fron the proccess button with a smaller fiel and it is working correctly...
so the problem is with the cron... ...any ideas please?

You cannot compare these two, because they operate very differently.

There is an error

Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 SQL=SELECT name
FROM galore_csvi_template_settings
WHERE id =

There is no template ID.

Which command are you executing via cron?

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
# 7

soura123

Accepted Answer Pending Moderation

#!/bin/sh

/usr/bin/php /home/galor/public_html/TEST/ROSSI/administrator/components/com_csvi/helpers/cron.php username='' passwd='' template_id='20'

i have the above on a .sh file and i call that a sh with a cron... is what i m doing so far on joomla 2.5 and vm2

more than a month ago
RO CSVI
# 8

rolandd

Accepted Answer Pending Moderation

Which Joomla 3 version are you using? Joomla 3.4.0 introduced some unexpected changes that broke a few things. You are running CSVI Pro 5.21.1?

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
# 9

soura123

Accepted Answer Pending Moderation

3.4.0 and csviv 5.21.1

more than a month ago
RO CSVI
# 10

rolandd

Accepted Answer Pending Moderation

So I have been doing some testing on both Joomla 2.5 and 3.4.0 but I haven't seen any issues.

Joomla 2.5

Processing started: 13th March 2015, 4:50 pm
Template name: Example VirtueMart Product export
Results for ExampleVirtueMartProductexport
=============================================
No log details have been found
Processing finished: 13th March 2015, 4:50 pm
Process ran for 2 seconds
User has been logged out

Joomla 3.4.0

Processing started: 13th March 2015, 4:56 pm
Template name: Example VirtueMart Product export
Results for ExampleVirtueMartProductexport
=============================================
No log details have been found
Processing finished: 13th March 2015, 4:56 pm
Process ran for 2 seconds
User has been logged out

All this using PHP 5.5.14 and tried it with a subfolder as well. Which PHP version is your SH command using?

So we have to look at why it is failing on your system as the code seems to be OK.

Not sure if it matters for your system but the template_id='20' has single quotes while the rest has double quotes.

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
# 11

soura123

Accepted Answer Pending Moderation

ok fixed it... it was wrong command on the sh i add this and it is fixed:

#!/bin/sh

/opt/rh/php54/root/usr/bin/php

more than a month ago
RO CSVI
# 12

rolandd

Accepted Answer Pending Moderation

Thanks, that helps indeed to use an up-to-date PHP version.

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
# 13

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 error import on joomla 3

RO CSVI

RO Payments

RO Users

RO Single Sign On