View Full Version : Error when updating alpha10 to alpha11 db
dpsantos
03-08-2005, 16:09
it gives the following error:
ERROR 1051 (42S02) at line 5: Unknown table 'escalation_rules':
I would just comment the line
drop table escalation_rules;
in patch.sql
mconigliaro
03-08-2005, 18:14
it might be a good idea to update the sql scripts to use 'drop table if exists' syntax. that will suppress these errors.
chocho63
04-08-2005, 15:16
Ignore this error, the script works fine, the database is updated.
The line 'drop table escalation' tries to drop a table that doesn't exist.
mconigliaro
12-08-2005, 19:59
my suggestion was for alexei. in general, its good practice to use the 'drop table if exists' syntax for mysql.
my suggestion was for alexei. in general, its good practice to use the 'drop table if exists' syntax for mysql.
I agree. Thanks for the excellent idea!