Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: SQL Error Anope 1.7.18  (Read 7192 times)

0 Members and 1 Guest are viewing this topic.

X-Trancer

  • Guest
SQL Error Anope 1.7.18
« 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
Logged

owine

  • Anope User
  • Offline Offline
  • Posts: 130
(No subject)
« Reply #1 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?
Logged

Pieter Bootsma

  • Team
  • *
  • Offline Offline
  • Posts: 189
    • http://geniusdex.net/
(No subject)
« Reply #2 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
Logged

netstat

  • Anope User
  • Offline Offline
  • Gender: Male
  • Posts: 37
(No subject)
« Reply #3 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
Logged

X-Trancer

  • Guest
(No subject)
« Reply #4 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
Logged

Jan Milants

  • Team
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 1372
(No subject)
« Reply #5 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
Logged
If you like me donate coins to 1FBmZVT4J8WAUMHKqpWhgNVj3XXnRN1cCk :)

katsklaw

  • Guest
(No subject)
« Reply #6 on: January 06, 2007, 05:54:37 PM »

fixed in r1219
Logged

Jappy

  • Anope User
  • Offline Offline
  • Posts: 14
    • www.irc-blog.com
(No subject)
« Reply #7 on: January 15, 2007, 05:05:47 PM »

quote : fixed in r1219

where can we found it ??
Logged

Jan Milants

  • Team
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 1372
(No subject)
« Reply #8 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/
Logged
If you like me donate coins to 1FBmZVT4J8WAUMHKqpWhgNVj3XXnRN1cCk :)

katsklaw

  • Guest
(No subject)
« Reply #9 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.
Logged

Jappy

  • Anope User
  • Offline Offline
  • Posts: 14
    • www.irc-blog.com
(No subject)
« Reply #10 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 :)
Logged

n00bie

  • Anope User
  • Offline Offline
  • Gender: Male
  • Posts: 411
(No subject)
« Reply #11 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
Logged
I am always doing things that which I cannot do, in order that I may learn how to do it.
Pages: [1]   Go Up