Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 12th June 2006, 13:41
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,034
Thanks: 265
Thanked 152 Times in 132 Posts
Default Error in SQL query? OK on Fedora. Not OK with Debian?

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:
Quote:
#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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=171' at line 5
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
Reply With Quote
Sponsored Links
  #2  
Old 12th June 2006, 16:34
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
Originally Posted by edge
Or.. is there an easy way to update the MySQL 4.0.24 to a newer version?

Thanks
Yes, there's a MySQL 4.1 package available for Debian Sarge.
You can check with
Code:
apt-cache search mysql
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 12th June 2006, 17:08
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,034
Thanks: 265
Thanked 152 Times in 132 Posts
Default

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.
..
..
Reply With Quote
  #4  
Old 12th June 2006, 17:18
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,034
Thanks: 265
Thanked 152 Times in 132 Posts
 
Default

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 :-)
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
The Perfect Setup - Fedora Core 4 british.assassin Server Operation 9 21st February 2008 17:29
e-mail problem!!! Debian 3.1 maroonworks Installation/Configuration 18 6th December 2005 14:42


All times are GMT +2. The time now is 02:32.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.