View Issue Details

IDProjectCategoryView StatusLast Update
0001326Anope Development (1.9.x series)Ext DB Supportpublic2011-08-27 21:17
ReporterObiWan Assigned ToAdam  
PrioritynormalSeverityminorReproducibilityhave not tried
Status resolvedResolutionfixed 
Summary0001326: [Anope-1.9-git] SQL Errors on SQLSYNC
DescriptionThis sadly appears when upading the MySQL database:

Error executing query UPDATE `anope_cs_levels` SET `level` = '5' WHERE `channel` = '#iks_may\'nes' AND `position` = '6' ON DUPLICATE KEY UPDATE level=VALUES(level), position=VALUES(position): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE level=VALUES(level), position=VALUES(position)' at line 1
TagsNo tags attached.



2011-08-27 21:17

administrator   ~0005943

Fixed in 309dfa36e7bf65a3e0bc1a52bcf5b818493e8cd3

Issue History

Date Modified Username Field Change
2011-08-27 15:50 ObiWan New Issue
2011-08-27 21:17 Adam Note Added: 0005943
2011-08-27 21:17 Adam Status new => resolved
2011-08-27 21:17 Adam Resolution open => fixed
2011-08-27 21:17 Adam Assigned To => Adam