Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    ERROR #1064: near '0'', PRIMARY KEY iisys_const_get__id

    Scheduled Pinned Locked Moved Allgemein
    7 Posts 2 Posters 2.2k Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • H Offline
      hdollnig
      last edited by

      Hallo zusammen!

      Wollte gerade i-doit installieren auf einem Windows System (Apache Webserver, Mysql 5.0) und komme bis zum Schritt 6 der Installation - dann erhalte ich folgende Fehlermeldung:

      ERROR (#1064: 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 '0'', PRIMARY KEY (isys_const_get__id)) ENGINE=InnoDB DEFAULT CHARSET=utf8 CO' at line 1)

      Könnt ihr mir bitte helfen????

      Danke

      Helli

      1 Reply Last reply Reply Quote 0
      • dsD Offline
        ds
        last edited by

        Welche Version genau willst du installieren?

        1 Reply Last reply Reply Quote 0
        • H Offline
          hdollnig
          last edited by

          0.9.8-1 habs auch schon mit der version 0.9.7 probiert

          1 Reply Last reply Reply Quote 0
          • dsD Offline
            ds
            last edited by

            Versuch mal die Datei setup/sql/idoit_system.sql unter einem anderen Encoding abzuspeichern, zB utf-8

            1 Reply Last reply Reply Quote 0
            • H Offline
              hdollnig
              last edited by

              wie mach ich das ?

              1 Reply Last reply Reply Quote 0
              • H Offline
                hdollnig
                last edited by

                Hab ich gemacht - die dateien im editor aufgerufen und "Speichern unter" im UTF-8 abgespeichert

                hat nichts genützt

                1 Reply Last reply Reply Quote 0
                • dsD Offline
                  ds
                  last edited by

                  Wie hast du MySQL installiert - ist das XAMP oder die Standard installation?
                  Kannst du mal versuchen die Datei setup/sql/idoit_system.sql manuell in eine neue Datenbank zu importieren (z.B. über phpmyadmin)?

                  1 Reply Last reply Reply Quote 0

                  Hello! It looks like you're interested in this conversation, but you don't have an account yet.

                  Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

                  With your input, this post could be even better 💗

                  Register Login
                  • First post
                    Last post