Я имею проблему с модулем CIP [RESOLVED]

[Dyrcio 0]

Я имею проблему с модулем CIP

в install.xml я имею:

<?xml version="1.0" encoding="utf-8" standalone="yes"?>

<contrib>

<description>

<details contrib_ref="0" forum_ref="0" contrib_type="Modul" status="0" last_update="2007-07-26"/>

<comments><![CDATA[

Polska lokalizacja cd.:

Polska strefa podatkowa,

6 klas podatkowych

6 podatków

]]></comments>

<credits><![CDATA[

Autor: D. Szyndler Jump.Net

CIP: Jump.Net

]]></credits>

</description>

<sql>

<query><![CDATA[

INSERT INTO geo_zones (`geo_zone_id`, `geo_zone_name`, `geo_zone_description`, `last_modified`, `date_added`) VALUES

('', 'Polska', 'podatki dla polski', '', '');

]]></query>

<remove_query><![CDATA[

DELETE FROM geo_zones WHERE geo_zone_name = 'Polska';

]]></remove_query>

</sql>

<sql>

<query><![CDATA[

SET @strefa = (SELECT geo_zone_id FROM geo_zones WHERE geo_zone_name = 'Polska');

INSERT INTO zones_to_geo_zones (`association_id`, `zone_country_id`, `zone_id`, `geo_zone_id`, `last_modified`, `date_added`) VALUES ('', '170', '0', @strefa, '', '');

]]></query>

<remove_query><![CDATA[

DELETE FROM zones_to_geo_zones WHERE zone_country_id = '170';

]]></remove_query>

<query><![CDATA[

INSERT INTO tax_class (`tax_class_id`, `tax_class_title`, `tax_class_description`, `last_modified`, `date_added`) VALUES

('', 'VAT 22', '22% VAT', '', ''),

('', 'VAT 7', '7% VAT', '', ''),

('', 'VAT 5', '5% VAT', '', ''),

('', 'VAT 3', '3% VAT', '', ''),

('', 'VAT 0', '0% VAT', '', ''),

('', 'ZWL', 'zwolnona', '', '');

]]></query>

<remove_query><![CDATA[

DELETE FROM tax_class WHERE tax_class_title = 'VAT 22' OR tax_class_title = 'VAT 7' OR tax_class_title = 'VAT 5' OR tax_class_title = 'VAT 3' OR tax_class_title = 'VAT 0' OR tax_class_title = 'ZWL';

]]></remove_query>

</sql>

К тому месту, всё хорошо

В том месте, ошибка

<sql>

<query><![CDATA[

INSERT INTO tax_rates (`tax_rates_id`, `tax_zone_id`, `tax_class_id`, `tax_priority`, `tax_rate`, `tax_description`, `last_modified`, `date_added`) VALUES

('', (SELECT geo_zone_id FROM geo_zones WHERE geo_zone_name = 'Polska'), (SELECT tax_class_id FROM tax_class WHERE tax_class_title = 'VAT 22'), '1', '22.0000', '22% VAT', '', '')

]]></query>

<remove_query><![CDATA[

DELETE FROM tax_rates WHERE tax_description = '22% VAT';

]]></remove_query>

</sql>[/

Сэрвэр BBB работает с 99, 5% и не добавляет тот.

Через phpadmin, всё хорошо.

Пожалуйста о помощь

Sorry for my russion.

[support 447]

Try to rewrite this sql query, more simple

[Dyrcio 0]

How?

SET @strefa = (SELECT geo_zone_id FROM geo_zones WHERE geo_zone_name = 'Polska');

SET @tax = (SELECT tax_class_id FROM tax_class WHERE tax_class_description = 'zwolniona');

INSERT INTO tax_rates (tax_rates_id, tax_zone_id, tax_class_id, tax_priority, tax_rate, tax_description, last_modified, date_added) VALUES ('', @strefa, @tax, '6', '0.0000', 'zwolniona', '', '');

SQL error :1193 - Unknown system variable '@strefa'

SET `@strefa` = (SELECT geo_zone_id FROM geo_zones WHERE geo_zone_name = 'Polska'); SET `@tax` = (SELECT tax_class_id FROM tax_class WHERE tax_class_description = 'zwolniona');

<sql> #1

I don't understand this.

In phpadmin, it is OK

Please, help me.

[Dyrcio 0]

Solution:

<sql>

<query><![CDATA[

INSERT INTO tax_rates (tax_rates_id, tax_zone_id, tax_class_id, tax_priority, tax_rate, tax_description, last_modified, date_added) VALUES ('', '1000', '1000', '6', '0.0000', 'zwolniona', '', '');

]]></query>

<remove_query><![CDATA[

DELETE FROM tax_rates WHERE tax_description = 'zwolniona';

]]></remove_query>

</sql>

<sql>

<query><![CDATA[

UPDATE tax_rates SET tax_zone_id = (SELECT geo_zone_id FROM geo_zones WHERE geo_zone_name = 'Polska');

UPDATE tax_rates SET tax_class_id = (SELECT tax_class_id FROM tax_class WHERE tax_class_title = 'ZWL');

]]></query>

</sql>

I thank you (Спасибо)

PS. The shop is excellent