[Erp5-report] r13741 - in /erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog: Ca...
nobody at svn.erp5.org
nobody at svn.erp5.org
Wed Mar 28 11:22:44 CEST 2007
Author: vincent
Date: Wed Mar 28 11:22:43 2007
New Revision: 13741
URL: http://svn.erp5.org?rev=13741&view=rev
Log:
Fix problem when generating a list of more than one id for a non-existing id_group.
Modified:
erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_portal_ids_generate_id.xml
erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision
Modified: erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_portal_ids_generate_id.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_portal_ids_generate_id.xml?rev=13741&r1=13740&r2=13741&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_portal_ids_generate_id.xml (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_portal_ids_generate_id.xml Wed Mar 28 11:22:43 2007
@@ -112,7 +112,7 @@
INSERT INTO\n
portal_ids (`id_group`, `last_id`)\n
VALUES\n
- (<dtml-sqlvar id_group type="string">, LAST_INSERT_ID(<dtml-sqlvar default type="int">))\n
+ (<dtml-sqlvar id_group type="string">, LAST_INSERT_ID(<dtml-sqlvar expr="default + id_count" type="int">))\n
ON DUPLICATE KEY UPDATE\n
`last_id` = LAST_INSERT_ID(`last_id` + <dtml-sqlvar id_count type="int">)\n
<dtml-var sql_delimiter>\n
@@ -162,7 +162,7 @@
INSERT INTO\n
portal_ids (`id_group`, `last_id`)\n
VALUES\n
- (<dtml-sqlvar id_group type="string">, LAST_INSERT_ID(<dtml-sqlvar default type="int">))\n
+ (<dtml-sqlvar id_group type="string">, LAST_INSERT_ID(<dtml-sqlvar expr="default + id_count" type="int">))\n
ON DUPLICATE KEY UPDATE\n
`last_id` = LAST_INSERT_ID(`last_id` + <dtml-sqlvar id_count type="int">)\n
<dtml-var sql_delimiter>\n
Modified: erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision?rev=13741&r1=13740&r2=13741&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision Wed Mar 28 11:22:43 2007
@@ -1,1 +1,1 @@
-36
+38
More information about the Erp5-report
mailing list