vmError: renderMail get Template failed vm 2.0.4

[teobgeno]

I get an error when i change order status at backened   joomla 1.5.26 Vm 2.0.4

vmError: renderMail get Template failed: Table 'photo.jos_template_styles' doesn't exist SQL=SELECT `template` FROM `jos_template_styles` WHERE `client_id`="0" AND `home`="1"

I know this table does not exists in joomla 1.5.x versions and is probably at newer versions of joomla.
Is there a setting to disable this procedure or it is source code case.

[Studio 42]

in normal case j1.5 use
'SELECT `template` FROM `#__templates_menu`

and we test the joomla version, it's very strange , you have this query in joomla 1.5.

I have updated to the new method to compare joomla version, but it's only in the SVN files for now.

[teobgeno]

Can you give me a guide where this  check of joomla version exists in the source code ?
Thank you

[Studio 42]

try to change in ROOT\administrator\components\com_virtuemart\models\config.php
line 55

Code Select Expand

if(version_compare(JVERSION,'1.6.0','ge')) {

to

Code Select Expand


if (JVM_VERSION === 2) {

[teobgeno]

Thank you for your reply

The administrator/components/com_virtuemart/models/config.php is ok the error was at

com_virtuemart/helpers/shopfunctionf/shopfunctionsf.php  -> function renderMail (line 186)

Code Select Expand


if(JVM_VERSION == 2){
   $q = 'SELECT `template` FROM `#__template_styles` WHERE `client_id`="0" AND `home`="1"';
} else {
  $q = 'SELECT `template` FROM `#__template_styles` WHERE `client_id`="0" AND `home`="1"';
}


The if statement functionality is correct  but the query is the same for both versions. This must be modified as

Code Select Expand


if(JVM_VERSION == 2){
   $q = 'SELECT `template` FROM `#__template_styles` WHERE `client_id`="0" AND `home`="1"';
} else {
  $q = 'SELECT `template` FROM `#__templates_menu` WHERE `client_id` ="0" ';
}


[Thomas Kuschel]

Thank you teobgeno!
On my Joomla 1.5, it works now after changing the com_virtuemart/helpers/shopfunctionf/shopfunctionsf.php
Thomas

[Milbo]

Imho the fix is too dirty, please look here
http://forum.virtuemart.net/index.php?topic=100927.0

[teobgeno]

glad i could help thoma kai apo oti katalaba Elina kiolas