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 http://www.howtoforge.com/perfect_setup_debian_sarge)

    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:

    Code:
    CREATE TABLE `google` (
  `ID` int(10) NOT NULL auto_increment,
  `ip_address` varchar(255) default NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=171 ;
    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?

    Thanks
     
    edge, Jun 12, 2006
    #1
  2. falko

    falko Super Moderator Howtoforge Staff

    Yes, there's a MySQL 4.1 package available for Debian Sarge.
    You can check with
    Code:
    apt-cache search mysql
     
    falko, Jun 12, 2006
    #2
  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:

    Code:
    # deb cdrom:[Debian GNU/Linux 3.1 r2 _Sarge_ - Official i386 Binary-1 (20060419)]/ unstable contrib main

deb http://security.debian.org/ stable/updates main contrib
deb http://http.us.debian.org/debian stable main contrib non-free
deb http://non-us.debian.org/debian-non-US stable/non-US main contrib non-free
deb http://security.debian.org 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!)

    Code:
    ..
..
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.
..
..
     
    edge, Jun 12, 2006
    #3
  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 :)
     
    edge, Jun 12, 2006
    #4

Share This Page