Author Topic: SQL-Error  (Read 3347 times)

Harthas

  • Guest
SQL-Error
« on: December 26, 2007, 01:06:17 am »
Good Evening

When I installed ths version I received following error-message:

Error: '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 '')' at line 1' executing 'INSERT INTO deathmessages VALUES (0,'"{goodguyname} has been slain {where} by {badguy}.',1,0,1,Nightborn')'.

Error: '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 '')' at line 1' executing 'INSERT INTO deathmessages VALUES (1,'"{goodguyname} has been defeated {where} by {badguy}.',0,1,1,Nightborn')'.
2.


It showed up while adding the fields to the tables....

Nightborn

  • Administrator
  • Sr. Member
  • *****
  • Posts: 320
  • Karma: +20/-0
    • View Profile
    • Shinobilegends
Re: SQL-Error
« Reply #1 on: January 03, 2008, 12:36:23 pm »
Thanks, I'll update it.

one " is in the statement too much and one ' too few -_- sorry.

fixed
« Last Edit: January 03, 2008, 12:38:27 pm by Nightborn »
It should be fixed, but it won't be easy and it won't be fast. If you want
to help - wonderful. But keep in mind that it will take months of wading
through the ugliest code we have in the tree. If you've got a weak stomach -
stay out. I've been there and it's not a nice place.

   - Al Viro

Patti

  • Guest
Re: SQL-Error
« Reply #2 on: January 09, 2008, 03:33:21 pm »
Hi by new Installation

Code: [Select]
Table Synchronization Logs:
Synchronizing table accounts..
Synchronizing table accounts_output..
Synchronizing table companions..
Synchronizing table deathmessages..
Synchronizing table paylog..
Synchronizing table armor..
Synchronizing table bans..
Synchronizing table clans..
Synchronizing table commentary..
Synchronizing table creatures..
Synchronizing table debuglog..
Synchronizing table faillog..
Synchronizing table gamelog..
Synchronizing table logdnetbans..
Synchronizing table logdnet..
Synchronizing table mail..
Synchronizing table masters..
Synchronizing table moderatedcomments..
Synchronizing table module_event_hooks..
Synchronizing table module_hooks..
Synchronizing table module_objprefs..
Synchronizing table module_settings..
Synchronizing table module_userprefs..
Synchronizing table modules..
Synchronizing table motd..
Synchronizing table mounts..
Synchronizing table nastywords..
Synchronizing table news..
Synchronizing table petitions..
Synchronizing table pollresults..
Synchronizing table referers..
Synchronizing table settings..
Synchronizing table taunts..
Synchronizing table untranslated..
Synchronizing table translations..
Synchronizing table weapons..
Synchronizing table titles..

The tables now have new fields and columns added, I'm going to begin importing data now.
Version 1.1.1.0 Dragonprime Edition +nb: 2 SQL statements...
Doing:
Error: 'Duplicate entry '1' for key 1' executing 'INSERT INTO deathmessages VALUES (1,'{goodguyname} has been defeated {where} by {badguy}.',0,1,1,'Nightborn')'.
2.

And if I only z.b. there race modules wants to add by the installation, there is a white side.

########

Und wenn ich nur z.b. rasen Module hinzufügen will bei der Installation , gibt es eine weisse Seite .


version 07.01.2008




Nightborn

  • Administrator
  • Sr. Member
  • *****
  • Posts: 320
  • Karma: +20/-0
    • View Profile
    • Shinobilegends
Re: SQL-Error
« Reply #3 on: January 10, 2008, 07:11:25 pm »
The duplicate entry was solved yesterday.


If you DO want to install TOO many modules (the installer takes up quite a bit of memory!) then you will get a white page.

Check your /var/log/apache2/error.log
and
/var/log/syslog

to get the error text.
It should be fixed, but it won't be easy and it won't be fast. If you want
to help - wonderful. But keep in mind that it will take months of wading
through the ugliest code we have in the tree. If you've got a weak stomach -
stay out. I've been there and it's not a nice place.

   - Al Viro