Anope IRC Services

Anope Support => 1.8.x/1.7.x Support (Read Only) => Topic started by: X-Trancer on January 03, 2007, 06:34:37 AM

Title: SQL Error Anope 1.7.18
Post by: X-Trancer on January 03, 2007, 06:34:37 AM
hi all

I have a problem wiht the mysql on Anope 1.7.18

This is in the Logfile

Quote

[Jan 03 07:16:46 2007] Info: Reflecting database records.
[Jan 03 07:18:13 2007] Unable to run query: Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen (diese kann für verschiedene Server-Versionen unterschiedlich sein) bei ', active) VALUES (0, 1, 'German-IRC hat einen neuen Service http://denora.german' in Zeile 1
 : Success
[Jan 03 07:18:14 2007] Unable to run query: Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen (diese kann für verschiedene Server-Versionen unterschiedlich sein) bei ', active) VALUES (0, 1, 'German-IRC hat einen neuen Service http://denora.german' in Zeile 1
 : Success
[Jan 03 07:18:15 2007] Unable to run query: Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen (diese kann für verschiedene Server-Versionen unterschiedlich sein) bei ', active) VALUES (0, 1, 'German-IRC hat einen neuen Service http://denora.german' in Zeile 1
 : Success
[Jan 03 07:18:16 2007] Unable to run query: Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen (diese kann für verschiedene Server-Versionen unterschiedlich sein) bei ', active) VALUES (0, 1, 'German-IRC hat einen neuen Service http://denora.german' in Zeile 1
 : Success
[Jan 03 07:18:17 2007] Unable to run query: Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen (diese kann für verschiedene Server-Versionen unterschiedlich sein) bei ', active) VALUES (0, 1, 'German-IRC hat einen neuen Service http://denora.german' in Zeile 1
 : Success
[Jan 03 07:18:18 2007] MySQL query warning: Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen (diese kann für verschiedene Server-Versionen unterschiedlich sein) bei ', active) VALUES (0, 1, 'German-IRC hat einen neuen Service http://denora.german' in Zeile 1 : Success
[Jan 03 07:18:18 2007] Can't create sql query: INSERT DELAYED INTO anope_os_news (type, num, ntext, who, time`, active) VALUES (0, 1, 'German-IRC hat einen neuen Service http://denora.german-irc.net/ mehr infos auf dieser Seite', 'X-Trancer', 1129975591, 1) : Success
[Jan 03 07:18:18 2007] MySQL query warning: Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen (diese kann für verschiedene Server-Versionen unterschiedlich sein) bei ', active) VALUES (0, 1, 'German-IRC hat einen neuen Service http://denora.german' in Zeile 1 : Success
[Jan 03 07:18:18 2007] Unable to save NewsItem 1 - News RDB save failed.


Sorry this Text is in German please help me for fix the Problem
Title:
Post by: owine on January 03, 2007, 06:55:57 AM
im gonna take a guess on this one since i dont know german. did you update your tables with the changes.sql file after upgrading?
Title:
Post by: Pieter Bootsma on January 03, 2007, 09:01:10 AM
Could you apply the patch at http://geniusdex.net/anope/patches/mysql1.diff and see if it fixes things?

Instructions for applying a patch:
1) Make sure you are in the anope-1.7.18/ directory
2) Run: wget http://geniusdex.net/anope/patches/mysql1.diff
3) Run: patch -p0 < mysql1.diff
4) Recompile (Run make and make install again)
5) Restart Anope
Title:
Post by: netstat on January 03, 2007, 11:48:17 AM
i had the same problem. and with you patch no problems at the moment. it seems to be work  :D
Title:
Post by: X-Trancer on January 03, 2007, 05:12:19 PM
Ok this patch works fine

Is this normally the services need 3 mins to connect to Hub?

No additional Modules are installed
Title:
Post by: Jan Milants on January 03, 2007, 08:12:46 PM
usually, not no, but if i remember correctly - it s been a very long time since i tried using MySQL though- when MySQL is active it tends to be a lot slower at starting up, depends on the size of the database as well i guess and the speed and number of queries the sql server allows per interval
Title:
Post by: katsklaw on January 06, 2007, 05:54:37 PM
fixed in r1219
Title:
Post by: Jappy on January 15, 2007, 05:05:47 PM
quote : fixed in r1219

where can we found it ??
Title:
Post by: Jan Milants on January 15, 2007, 05:37:59 PM
in version 1.7.19, or in the SVN version, but note that svn may contain untested code(fixes)...

SVN: svn://zero.org/repos/anope/trunk/
Title:
Post by: katsklaw on January 17, 2007, 06:50:21 AM
To be clear, 1.7.19 does not exist yet, however , r1219 is an svn release made after the release of 1.7.18.
Title:
Post by: Jappy on January 18, 2007, 11:39:02 AM
Thank. may i have the way to get de svn on the top of the 1.7.18 actual , or how can i get it :)

i'm very unfamiliar with SVN :)
Title:
Post by: n00bie on January 18, 2007, 11:49:31 AM
Links: svn://zero.org/repos/anope/trunk
or from the shell: svn co svn://zero.org/repos/anope/trunk anope