Error in SQL query? OK on Fedora. Not OK with Debian?

Discussion in 'Server Operation' started by edge, Jun 12, 2006.

  1. edge

    edge Active Member Moderator

    I've just finished installing a test server running Debian Sarge, and till now it looks like all is working. (I did the The Perfect Setup - Debian Sarge (3.1) from

    I'm now trying some sites that have 'special' settings.
    One of the sites is using MySQL, but for some reason I can not create the database on the new Debian server.

    This is how the query looks:

    CREATE TABLE `google` (
      `ID` int(10) NOT NULL auto_increment,
      `ip_address` varchar(255) default NULL,
      UNIQUE KEY `ID` (`ID`)
    The error I get is:
    The strange thing is that this query is working fine on the Fedora RC4 server.
    The MySQL on the Fedora server is: MySQL 4.1.16 running on localhost as root@localhost

    The MySQL on the Debian server is: MySQL 4.0.24_Debian-10sarge2-log running on localhost as root@localhost

    I guess they must have changed some things in the 4.1.16 version.

    Is there anyone here who can see what is wrong with the SQL query, and how to fix it to make it work with MySQL 4.0.24_Debian-10sarge2?

    Or.. is there an easy way to update the MySQL 4.0.24 to a newer version?

  2. falko

    falko Super Moderator Howtoforge Staff

    Yes, there's a MySQL 4.1 package available for Debian Sarge.
    You can check with
    apt-cache search mysql
  3. edge

    edge Active Member Moderator

    Hi Falko,

    Should I install the mysql-server-4.1 (with: apt-get install mysql-server-4.1), and if so.. Will ISPconfig still work?

    Also.. I have this in my /etc/apt/sources.list file:

    # deb cdrom:[Debian GNU/Linux 3.1 r2 _Sarge_ - Official i386 Binary-1 (20060419)]/ unstable contrib main
    deb stable/updates main contrib
    deb stable main contrib non-free
    deb stable/non-US main contrib non-free
    deb stable/updates main contrib non-free
    Are this the correct Debian sources?

    This is what I get with apt-cache search mysql
    (note: I'm only listing the files starting with mysql!)

    mysql-client - mysql database client binaries
    mysql-client-4.1 - mysql database client binaries
    mysql-common - mysql database common files (e.g. /etc/mysql/my.cnf)
    mysql-common-4.1 - mysql database common files (e.g. /etc/mysql/my.cnf)
    mysql-server - mysql database server binaries
    mysql-server-4.1 - mysql database server binaries
    mysql-admin - GUI tool for intuitive MySQL administration
    mysql-admin-common - Architecture independent files for MySQL Administrator
    mysql-navigator - GUI client program for MySQL database server
    mysql-query-browser - Official GUI tool to query MySQL database
    mysql-query-browser-common - Architecture independent files for MySQL Query Browser
    mysqltcl - Interface to the MySQL database for the Tcl language.
  4. edge

    edge Active Member Moderator

    As it's a test server I did do the: apt-get install mysql-server-4.1

    guess what... I'm now running MySQL 4.1.11-Debian_4sarge4-log, and all is working fine now :)

Share This Page