# HG changeset patch
# User Sylvain Thénault <sylvain.thenault@logilab.fr>
# Date 1253686566 -7200
# Node ID d5bd1b659ce8233b026c0d9dbe09e286b067bf19
# Parent  26b89dfe4170113cf472be1fefd109c1fad359ba
[db-check] fix sql to fix bad eid referenced by inlined relation

diff -r 26b89dfe4170 -r d5bd1b659ce8 server/checkintegrity.py
--- a/server/checkintegrity.py	Tue Sep 22 18:59:00 2009 +0200
+++ b/server/checkintegrity.py	Wed Sep 23 08:16:06 2009 +0200
@@ -211,8 +211,8 @@
                     if not has_eid(cursor, eid, eids):
                         bad_related_msg(rschema, 'object', eid, fix)
                         if fix:
-                            sql = 'UPDATE %s SET %s = NULL WHERE %seid=%s;' % (
-                                table, column, SQL_PREFIX, eid)
+                            sql = 'UPDATE %s SET %s=NULL WHERE %s=%s;' % (
+                                table, column, column, eid)
                             session.system_sql(sql)
             continue
         cursor = session.system_sql('SELECT eid_from FROM %s_relation;' % rschema)