MySQL Error: 1146 in Egroupware

2005-01-20 Thread Shahzad, Saleem
BY link_lastmod DESC mysql Error: 1146 (Table 'egroupware.phpgw_links' doesn't exist) File: /var/www/html/egroupware/infolog/inc/class.solink.inc.php Line: 132 Function: calendar.uicalendar.view 3.23.58 I am using php 4.2.2 and MySQL, also have no background of php and Mysql, Please help

Re: MySQL Error: 1146 in Egroupware

2005-01-20 Thread Duncan Hill
' AND link_id1 = '5') OR (link_app2 = 'calendar' AND link_id2 = '5') ORDER BY link_lastmod DESC mysql Error: 1146 (Table 'egroupware.phpgw_links' doesn't exist) This is nothing to do with MySQL - you installed eGroupware incorrectly by the looks. Suggest RTM of the eGroupware install docs again

Re: MySQL Error: 1146 in Egroupware

2005-01-20 Thread Chris Ramsay
Database error: Invalid SQL: SELECT * FROM phpgw_links WHERE (link_app1 = 'calendar' AND link_id1 = '5') OR (link_app2 = 'calendar' AND link_id2 = '5') ORDER BY link_lastmod DESC mysql Error: 1146 (Table 'egroupware.phpgw_links' doesn't exist) That would indicate to me 2 possibilities: 1

mysql_store_result - Error: 2000 (CR_UNKNOWN_ERROR) Message: Unknown MySQL error

2005-01-17 Thread David Jonas
: Line 387: if (!(res_read = mysql_store_result(mysql_read))) { One line above does not fail, called on the same MySQL struct: Line 381: if (mysql_query(mysql_read,SqlBufRead)) { Dumping mysql_errno and mysql_error to syslog show this: errno=2000 error=Unknown MySQL error The mysql error log

Re: mysql error

2005-01-12 Thread Gleb Paharenko
Hello. Such errors often occurs when you already have installed MySQL service. freshm4n [EMAIL PROTECTED] wrote: I got a mysql-4.1.8-win.zip,when installed,i got a error:Cannot create Windows service for MySQL.Error:0~~How to solve?thanks~~ :) sorry for my poor english~~ -- For

mysql error

2005-01-11 Thread freshm4n
I got a mysql-4.1.8-win.zip,when installed,i got a error:Cannot create Windows service for MySQL.Error:0~~How to solve?thanks~~ :) sorry for my poor english~~ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Cannot create Windows service for MySql. Error: 0

2005-01-06 Thread Gleb Paharenko
Command Line? Eugenia Mariani [EMAIL PROTECTED] wrote: My O.S in Win Xp Pro SP2. My web server is Apache 5.0 While I am trying to install MySql Server 4.1, I have the following error and I cannot install the Server: Cannot create Windows service for MySql. Error: 0 Can someone

RE: Cannot create Windows service for MySql. Error: 0

2005-01-06 Thread Mark Leith
Paharenko [mailto:[EMAIL PROTECTED] Sent: 06 January 2005 08:31 To: mysql@lists.mysql.com Subject: Re: Cannot create Windows service for MySql. Error: 0 Hello. While I am trying to install MySql Server 4.1, What exact version do you install? Use 4.1.8. Did you stop the previous instance

Cannot create Windows service for MySql. Error: 0

2005-01-05 Thread Eugenia Mariani
My O.S in Win Xp Pro SP2. My web server is Apache 5.0 While I am trying to install MySql Server 4.1, I have the following error and I cannot install the Server: Cannot create Windows service for MySql. Error: 0 Can someone help me to install without error? Thanks Eugenia Mariani

RE: Cannot create Windows service for MySql. Error: 0

2005-01-05 Thread Tom Crimmins
Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Eugenia Mariani [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 05, 2005 11:57 AM To: mysql@lists.mysql.com Subject: Cannot create Windows service for MySql. Error: 0 My O.S in Win Xp Pro SP2. My web server

Re: installing mysql / error

2005-01-03 Thread David Katz
: mysql@lists.mysql.com Sent: Thursday, December 30, 2004 2:32 PM Subject: RE: installing mysql / error [snip] When I try 'mysql -u root' I get the same error, except root is in the place of ODBC ERROR 1045 (28000): Access denied for user 'root' @'localhost' (using password: NO) [/snip

RE: installing mysql / error

2005-01-03 Thread J.R. Bullington
Message- From: David Katz [mailto:[EMAIL PROTECTED] Sent: Monday, January 03, 2005 10:30 AM To: Tom Crimmins Cc: mysql@lists.mysql.com Subject: Re: installing mysql / error I did the first 2 step you listed below, but when I typed in the mysql -u root, I got a new error message ERROR 2003 (HY000

Fw: installing mysql / error

2004-12-30 Thread David Katz
We loaded a new server with Windows XP professional, and mysql server 4.1. We can't get Mysql to run. After installing mysql and trying to execute it we get the following message: ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost' (using password: NO) Any ideas on what we can

Re: Fw: installing mysql / error

2004-12-30 Thread SGreen
David Katz [EMAIL PROTECTED] wrote on 12/30/2004 12:34:31 PM: We loaded a new server with Windows XP professional, and mysql server 4.1. We can't get Mysql to run. After installing mysql and trying to execute it we get the following message: ERROR 1045 (28000): Access denied for user

Re: Fw: installing mysql / error

2004-12-30 Thread David Katz
I'm going to the dos window on the server and typing mysql to kick it off. That's when I get the error. - Original Message - From: [EMAIL PROTECTED] To: David Katz [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Thursday, December 30, 2004 1:13 PM Subject: Re: Fw: installing mysql

RE: installing mysql / error

2004-12-30 Thread Tom Crimmins
[snip] We loaded a new server with Windows XP professional, and mysql server 4.1. We can't get Mysql to run. After installing mysql and trying to execute it we get the following message: ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost' (using password: NO) [/snip] Try starting

RE: installing mysql / error

2004-12-30 Thread Tom Crimmins
[snip] We loaded a new server with Windows XP professional, and mysql server 4.1. We can't get Mysql to run. After installing mysql and trying to execute it we get the following message: ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost' (using password: NO) [/snip] Ignore my

Re: Fw: installing mysql / error

2004-12-30 Thread SGreen
Corporation - Spruce Pine - Original Message - From: [EMAIL PROTECTED] To: David Katz [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Thursday, December 30, 2004 1:13 PM Subject: Re: Fw: installing mysql / error David Katz [EMAIL PROTECTED] wrote on 12/30/2004 12:34:31 PM

Re: installing mysql / error

2004-12-30 Thread David Katz
@lists.mysql.com Sent: Thursday, December 30, 2004 1:57 PM Subject: RE: installing mysql / error [snip] We loaded a new server with Windows XP professional, and mysql server 4.1. We can't get Mysql to run. After installing mysql and trying to execute it we get the following message: ERROR 1045 (28000

RE: installing mysql / error

2004-12-30 Thread Tom Crimmins
: mysql@lists.mysql.com Subject: Re: installing mysql / error When I try 'mysql -u root' I get the same error, except root is in the place of ODBC ERROR 1045 (28000): Access denied for user 'root' @'localhost' (using password: NO) - Original Message - From: Tom Crimmins [EMAIL PROTECTED

Re: Odd MySQL error

2004-10-22 Thread Egor Egorov
Rich West [EMAIL PROTECTED] wrote: Check limits for the MySQL user account in Fedora. Check that the init script is original from MySQL, not the Fedora one. Tail the dmesg output and look for suspictious messages. I have searched the archives (well, the search never came back...), and I

Odd MySQL error

2004-10-20 Thread Rich West
I have searched the archives (well, the search never came back...), and I have searched the web, but found very little that could help with the scenario that we are currently experiencing. We have the 4.0.21 RPM's installed direct from MySQL.com on a Fedora Core 2 server. The previous

Re: DBI and Mysql error 2006

2004-08-27 Thread Yannick Warnier
Le ven 27/08/2004 à 00:37, Yannick Warnier a écrit : Hi there, I'm having a problem with MySQL within a Perl::DBI usage. I've turned it upside-down and cannot find what it's related to. My Perl script creates multiple databases and populates them with tables. The problem appears when

DBI and Mysql error 2006

2004-08-26 Thread Yannick Warnier
Hi there, I'm having a problem with MySQL within a Perl::DBI usage. I've turned it upside-down and cannot find what it's related to. My Perl script creates multiple databases and populates them with tables. The problem appears when creating the second database (in the foreach statement): # #

mysql error: Record has changed since last read in table 'table'

2004-08-18 Thread Unreal HSHH
Sometimes,my php program query the mysql using SELECT. And I got this error, mysql error: Record has changed since last read in table 'table' mysql error number: 1020 The table is HEAP type,and this error will appear sometimes. Not always. Why did me get this error?Any suggestion? I am using

mysql error

2004-06-03 Thread starofframe
Hi all, I have a problem when I'm trying to connect to mysql server at my web hosting... appears error message like this : Could not connect to MySQL server! 2002: Can't connect to local MySQL server through socket '/usr/home/greatdynamic/mysql/mysql-greatdynamic.sock' (2) never appeared such

mySQL error 1016

2004-05-02 Thread Mike Blezien
Hello, Trying to fix this problem mySQL error 1016 I found this at the InnoDB site. Another symptom of an out-of-sync data dictionary is that MySQL prints an error that it cannot open a file yourtablename.InnoDB

RE: mysql error file

2004-04-15 Thread Luc Foisy
So I am guessing this is not a bug, and that I will have to modify the script myself? -Original Message- From: Luc Foisy Sent: Monday, April 12, 2004 4:34 PM To: Michael Stassen; MYSQL-List (E-mail) Subject: RE: mysql error file Michael wrote: mm... Have you looked in /etc/rc.d/init.d

RE: mysql error file

2004-04-12 Thread Luc Foisy
I changed mysql_safe to mysqld_safe and it is still sending the error output to $HOSTNAME.err -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 11:17 AM To: Luc Foisy; MYSQL-List (E-mail) Subject: Re: mysql error file At 10:10 -0400 4/7/04

RE: mysql error file

2004-04-12 Thread Luc Foisy
) Subject: RE: mysql error file I changed mysql_safe to mysqld_safe and it is still sending the error output to $HOSTNAME.err -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 11:17 AM To: Luc Foisy; MYSQL-List (E-mail) Subject: Re: mysql error

Re: mysql error file

2004-04-12 Thread Michael Stassen
14712 pts/0S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/usr/data/mysql --user=mysql --pid-file=/usr/data/mysql/mysql.pid -Original Message- From: Luc Foisy Sent: Monday, April 12, 2004 9:12 AM To: Paul DuBois; MYSQL-List (E-mail) Subject: RE: mysql error file I changed

RE: mysql error file

2004-04-12 Thread Luc Foisy
Actually, that didn't change anything. Still writing to $HOSTNAME.err -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Monday, April 12, 2004 12:03 PM To: Luc Foisy Cc: Paul DuBois; MYSQL-List (E-mail) Subject: Re: mysql error file Note (see ps output) that you

Re: mysql error file

2004-04-12 Thread Michael Stassen
, April 12, 2004 12:03 PM To: Luc Foisy Cc: Paul DuBois; MYSQL-List (E-mail) Subject: Re: mysql error file Note (see ps output) that you are using safe_mysqld, rather than mysqld_safe, as you have mysql 3.23.58. Hence, you need to change [mysqld_safe] to [safe_mysqld] in your my.cnf. See http

RE: mysql error file

2004-04-12 Thread Luc Foisy
Michael wrote: mm... Have you looked in /etc/rc.d/init.d/mysql to see what, exactly, it oes when you tell it to start? Michael I briefly looked in there. This is the same script it uses to start MySQL, and was installed with the rpm of MySQL. I would think it should come with all available

mysql error file

2004-04-07 Thread Luc Foisy
I have the following in my /etc/my.cnf [mysqld] datadir=/usr/data/mysql pid-file=/usr/data/mysql/mysql.pid socket=/usr/data/mysql/mysql.sock user=mysql [mysql_safe] log-error=/usr/data/mysql/mysql.err [client] socket=/usr/data/mysql/mysql.sock I tried originally to put the log-error= in the

Re: mysql error file

2004-04-07 Thread Paul DuBois
At 10:10 -0400 4/7/04, Luc Foisy wrote: I have the following in my /etc/my.cnf [mysqld] datadir=/usr/data/mysql pid-file=/usr/data/mysql/mysql.pid socket=/usr/data/mysql/mysql.sock user=mysql [mysql_safe] log-error=/usr/data/mysql/mysql.err [client] socket=/usr/data/mysql/mysql.sock I tried

RE: Should there be an entry in the mysql error log?

2004-03-24 Thread Daniel Gaddis
WHERE entryID = 168 the error (see below) seems to be the first indication of a corrupt table. So wouldn't that be a server issue and be appropriate to log into the mysql error log? Incorrect key file for table: 'referenceEntries'. Try to repair it The manual makes a reference to this error

RE: Should there be an entry in the mysql error log?

2004-03-24 Thread Paul DuBois
WHERE entryID = 168 the error (see below) seems to be the first indication of a corrupt table. So wouldn't that be a server issue and be appropriate to log into the mysql error log? I suppose you could consider it such, but on the other hand, it's not the sort

RE: Should there be an entry in the mysql error log?

2004-03-24 Thread Daniel Gaddis
From: Paul DuBois [mailto:[EMAIL PROTECTED] I suppose you could consider it such, but on the other hand, it's not the sort of error that prevents the server from running or processing other queries. In any case, logging it to the error log isn't going to help the client know what is going

RE: Should there be an entry in the mysql error log?

2004-03-24 Thread Daniel Gaddis
From: Paul DuBois [mailto:[EMAIL PROTECTED] I don't understand that second sentence, but you can submit feature requests at http://bugs.mysql.com/ For example, I would like the error log to look something like... MySQL: ready for connections. Version: '4.0.18-max-nt-log' socket: '' port:

Should there be an entry in the mysql error log?

2004-03-22 Thread Daniel Gaddis
in the mysql error log similar to... Incorrect key file for table: 'referenceEntries'. Try to repair it But there is no entry in the mysql error log. Any thoughts why not? Thanks, Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Should there be an entry in the mysql error log?

2004-03-22 Thread Paul DuBois
there should also be something in the mysql error log similar to... Incorrect key file for table: 'referenceEntries'. Try to repair it But there is no entry in the mysql error log. Any thoughts why not? The error log is for messages pertaining to problems with the operational state

Re: Should there be an entry in the mysql error log?

2004-03-22 Thread Victor Pendleton
= NULLWHERE entryID = 168 The contents makes me think there should also be something in the mysql error log similar to... Incorrect key file for table: 'referenceEntries'. Try to repair it But there is no entry in the mysql error log. Any

RE: mysql error grant tables, help

2004-03-17 Thread Victor Medina
; [EMAIL PROTECTED] Subject: Re: mysql error grant tables, help Hi! try to look at your my.cnf you haven't config it correctly! At 05:54 p.m. 12/03/2004, Chris Sanchez wrote: get this when i run scripts

RE: mysql error grant tables, help

2004-03-15 Thread Chris Sanchez
-Original Message- From: Victor Medina [mailto:[EMAIL PROTECTED] Sent: Saturday, March 13, 2004 10:37 AM To: Chris Sanchez; [EMAIL PROTECTED] Subject: Re: mysql error grant tables, help Hi! try to look at your my.cnf you haven't config it correctly! At 05:54 p.m. 12/03/2004, Chris Sanchez

Re: mysql error grant tables, help

2004-03-13 Thread Victor Medina
Hi! try to look at your my.cnf you haven't config it correctly! At 05:54 p.m. 12/03/2004, Chris Sanchez wrote: get this when i run scripts/mysql_install_db. also tried mysqld --skip-grant and got the same thing. how do i fix? mysql-standard-4.0.18-sun-solaris2.8-sparc binary on SunOS ipdev1 5.8

mysql error grant tables, help

2004-03-12 Thread Chris Sanchez
get this when i run scripts/mysql_install_db. also tried mysqld --skip-grant and got the same thing. how do i fix? mysql-standard-4.0.18-sun-solaris2.8-sparc binary on SunOS ipdev1 5.8 Generic_108528-06 sun4u sparc SUNW,Ultra-5_10. [EMAIL PROTECTED]:/usr/local/mysql $ scripts/mysql_install_db

InnoDB or MySQL error ?

2004-03-02 Thread Dyego Souza Dantas Leal
The script of database are uploaded to: support.mysql.com/pub/mysql/secret The name is sqlreg_italo.sql.gz I'am testing with MySQL 4.0.18-pro on Debian Linux Box. Kernel 2.4 and 2.6 There is an error in MySQL optimizer !!! test: mysql SET FOREIGN_KEY_CHECKS=0; Query OK, 0 rows affected

Re: InnoDB or MySQL error ?

2004-03-02 Thread Chris Nolan
If there's a bug in the optimiser, you'll find it's in the higher levels of the codebase. InnoDB doesn't have any SQL optimisation code in it, so any bugs in this area aren't in InnoDB. Regards, Chris Dyego Souza Dantas Leal wrote: The script of database are uploaded to:

Re: InnoDB or MySQL error ?

2004-03-02 Thread Heikki Tuuri
PROTECTED] Lähetetty: Tuesday, March 02, 2004 2:39 PM Aihe: InnoDB or MySQL error ? The script of the database is attached. The name is sqlreg_italo.sql.gz I'am testing with MySQL 4.0.18-pro on Debian Linux Box. Kernel 2.4 and 2.6 There is an error in MySQL optimizer !!! test

Re[2]: InnoDB or MySQL error ?

2004-03-02 Thread Dyego Souza Dantas Leal
Heikki: Hi, I would like to explain what is going on with the straight_join when it is used with my database. Suppose the command bellow: explain select table1 left join table2 on A=B left join table3 on C=D where ID = 1; When it is executed on one of our servers, mySql uses

Re: Re[2]: InnoDB or MySQL error ?

2004-03-02 Thread Heikki Tuuri
Dyego, - Alkuperäinen viesti - Lähettäjä: Dyego Souza Dantas Leal [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Kopio: [EMAIL PROTECTED] Lähetetty: Tuesday, March 02, 2004 3:09 PM Aihe: Re[2]: InnoDB or MySQL error ? Heikki: Hi, I would like to explain what

Mysql error message

2004-02-04 Thread vincent\.gueu
I've installed mysql under Linux and what I do, I always have this number of error message :040204. Please I need your help! Thank u Vinx Accédez au courrier électronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,34€/mn) ; tél : 08 92 68 13 50 (0,34€/mn) -- MySQL General Mailing

Re: Mysql error message

2004-02-04 Thread vpendleton
Are you able to start the MySQL server? Is there anything being logged to the hostname.err log? Original Message On 2/3/04, 7:23:50 PM, vincent.gueu [EMAIL PROTECTED] wrote regarding Mysql error message: I've installed mysql under Linux and what I do, I always have this number of error

RE: Mysql error message

2004-02-04 Thread Mike Johnson
From: vincent.gueu [mailto:[EMAIL PROTECTED] I've installed mysql under Linux and what I do, I always have this number of error message :040204. Please I need your help! Thank u I have no idea what your problem is, but I'd be amused if you had the number 040205 tomorrow (those being

Re: Mysql error

2004-01-06 Thread Heikki Tuuri
- a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Don Matlock [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Tuesday, January 06, 2004 2:07 AM Subject: Mysql error Hi all

Mysql error

2004-01-05 Thread Don Matlock
Hi all, Larry Brown tried to help me out with this one (much appreciated Larry), anyways, when I start up fedora I get this error from mysql that says it has timed out...it still works, but this error shows up in the mysql logs: 040104 18:38:37 mysqld started Cannot initialize InnoDB as

Mysql Error 1065

2003-12-23 Thread Gronau, Jens
Hello I need help MySQL 3.23.47 running on localhost linux I want to create an Test Instance. Based on my Production Instance. My Batch (it has work for month) head prax2test.sh time mysqldump -u transfer -ptransfer timesheet timesheet.temp echo drop database timetest; timetest.sql echo

Re: mysql error

2003-12-11 Thread Egor Egorov
Alex E.Wintermann [EMAIL PROTECTED] wrote: MySQL 4.1.0-alpha-max-nt phpMyAdmin 2.5.4 /* BEGIN DUMP */ CREATE TABLE `sp_tovar_vid` ( `id` int(11) NOT NULL auto_increment, `id_tovar_vid` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `description` varchar(255)

MySQL Error

2003-12-10 Thread Pushpinder Singh
Hello All, I am trying to import data from a text file into MySQL. I am using phpMyAdmin to control the database. When I try to execute the query I keep getting this error. Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Can anyone throw some light on this. Thanks in

RE: MySQL Error

2003-12-10 Thread Joshua Thomas
] --- In theory there is no difference between theory and practice. In practice there is. - Yogi Berra --- -Original Message- From: Pushpinder Singh [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 12:14 PM To: [EMAIL PROTECTED] Subject: MySQL Error Hello All, I am

mysql error

2003-12-10 Thread Alex E.Wintermann
Hello mysql, MySQL 4.1.0-alpha-max-nt phpMyAdmin 2.5.4 /* BEGIN DUMP */ CREATE TABLE `sp_tovar_vid` ( `id` int(11) NOT NULL auto_increment, `id_tovar_vid` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `description` varchar(255) NOT NULL default '', UNIQUE KEY

Re: MySQL Error

2003-12-10 Thread Pushpinder Singh
Thanks Josh, I wish that were the case.. I am already inside phpMyAdmin and I can manually edit and add new records. However when I try to add records from a file I keep getting the same error. If the user master2 did nto exist or have the required GRANT rights, then I wud not have been

RE: MySQL Error

2003-12-10 Thread Joshua Thomas
If the user master2 did nto exist or have the required GRANT rights, then I wud not have been able to get into the database itslef in the first place. Thanks again though. Any ideas ? If you read the GRANT section of the mySQL manual (http://www.mysql.com/doc/en/GRANT.html) you'll see that you

mysql error log and syslog

2003-12-01 Thread Tom Kleinpeter
Hello, I have about half a dozen servers running mysql. I'd like to be able to consolidate all of the error logs in one place so that I can just tail -f one log file to watch for any problems. It seems like this would be very easy to do if I could send the error log to syslog, and have the

mysql error

2003-11-19 Thread Hsiu-Hui Tseng
Hi, I keep getting the following error in mysql error file. Could anyone tell me what's going on and how to avoid this kind of error? 031117 2:44:37 Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 031117 2:44:37 Slave: Failed reading log

mysql error

2003-11-17 Thread vikas kamble
Hi, I Install R.H. 9.0 one dedicate pc but when i going restart mysql service or access database it's given me following error. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Please guide me what should i do. even i try to instal nushere tool

Re: mysql error

2003-11-17 Thread Victoria Reznichenko
vikas kamble [EMAIL PROTECTED] wrote: I Install R.H. 9.0 one dedicate pc but when i going restart mysql service or access database it's given me following error. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Please guide me what

Please help. MySQL Error.

2003-11-14 Thread William Bailey
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I am currently getting the following error on one of the mysql servers im looking after and wonder if anybody knows what specifically it relates to. Error in accept: Too many open files Im currently running MySQL version '4.0.14' under

RE: Please help. MySQL Error.

2003-11-14 Thread Victor Pendleton
do a show status like 'open_files' and a show variables like 'open_files_limit' -Original Message- From: William Bailey [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 6:56 AM To: [EMAIL PROTECTED] Subject: Please help. MySQL Error. -BEGIN PGP SIGNED MESSAGE- Hash

Re: MySQL ERROR in LOAD DATA

2003-08-29 Thread [EMAIL PROTECTED]
I use a CPanel Shared hosting environment where MySQL user is not permitted with FILE privilege. Please help me by telling what is the alternate process to LOAD DATA from a text data file to MySQL table. Thanks in advance -- MySQL General Mailing List For list archives:

Re: MySQL ERROR in LOAD DATA

2003-08-29 Thread Victoria Reznichenko
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I use a CPanel Shared hosting environment where MySQL user is not permitted with FILE privilege. Please help me by telling what is the alternate process to LOAD DATA from a text data file to MySQL table. You can use LOAD DATA LOCAL. In this case

MySQL ERROR in LOAD DATA

2003-08-28 Thread [EMAIL PROTECTED]
Hi, I am currently using MySQL 4.0.14-standard along with PHP 4.3.2 in Apache 1.3.28. I have written following code to upload some data from the hosting directory to database table. But LOAD DATA statement always fails. I have checked the same SQL using Sql-Front. It is showing Access denied.

Re: MySQL ERROR in LOAD DATA

2003-08-28 Thread Victoria Reznichenko
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I am currently using MySQL 4.0.14-standard along with PHP 4.3.2 in Apache 1.3.28. I have written following code to upload some data from the hosting directory to database table. But LOAD DATA statement always fails. I have checked the same SQL

Re: MySQL error code 1064:K@N@!:

2003-07-28 Thread Kenneth Illingsworth
=mysql+error+1064) would have found it for you. The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It would have been saying You have an error in your SQL syntax near It occurred on a submitted insert statement originating

Fwd: MySQL error code 1064:K@N@!:

2003-07-28 Thread Kenneth Illingsworth
I suspect that this is some kind of issue with privileges. However, the account I am using has been given 'ALL' privileges to the database I am trying to insert to. Am I save to assume that ALL includes insert privileges? ---BeginMessage--- I cannot seem to find this in the MYSQL Reference. Are

MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It occurred on a submitted insert statement originating in an application. The insert

Re: MySQL error code 1064

2003-07-25 Thread David Precious
On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote: I cannot seem to find this in the MYSQL Reference. Are there other places I should check? It's a syntax error. A quick Google (http://www.google.com/search?q=mysql+error+1064) would have found it for you. The message text in my

Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I streamlined the application so as to target the offending object more precisely for testing purposes. And, now the error is 1602 with no text. I am currently still looking for any error references. Once again, thanks in advance for your time. Kenneth Illingsworth [EMAIL PROTECTED] 07/25/03

Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I found the following by performing a google search: 1602 Btree unpacked page size (from header) does not match size loaded from disk Not sure what this means, but still looking for a better error reference. The link found in the google search was:

Fwd: Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I found a syntax error which caused the 1602 error and corrected it. I am now back to struggling with the '1064 - You have...' error. Unfortunately, I have been unable to find any reference to this particular error. ---BeginMessage--- I streamlined the application so as to target the offending

Fwd: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I suspect that this is some kind of issue with privileges. However, the account I am using has been given 'ALL' privileges to the database I am trying to insert to. Am I save to assume that ALL includes insert privileges? ---BeginMessage--- I cannot seem to find this in the MYSQL Reference. Are

Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
=mysql+error+1064) would have found it for you. The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It would have been saying You have an error in your SQL syntax near It occurred on a submitted insert statement originating

MySQL Error 28

2003-07-16 Thread Oswaldo Castro
Hi List I got an no space left on device error. Is there a way to drop an index without having MySQL create a temporary table? Can I delete the .myi file directly from the operating system? Thanks in advance Oswaldo Castro

MySQL Error Log problem.

2003-06-18 Thread Pushpinder Singh Garcha
Hello everyone, I am unable to start the mysqld, i keep getting mysqld ended error. - [psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe [5] 703 [psg:/usr/local/mysql] psgarcha%

Re: MySQL Error Log problem.

2003-06-18 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-18 12:24:06 -0400: [psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe [5] 703 [psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases from /usr/local/mysql/data 030618 11:50:09 mysqld ended [5]Done sudo

Re: buffer overflows in MySQL error messages (e.g. in 4.0.10-gamma)

2003-03-20 Thread Maarten LITMAATH
Sergei Golubchik wrote: Though your changes looked innocent - that is they most probably could do no harm - I failed to understand when they'll do any good. You replaced a set of checks for buffer overflow by some other set of checks, which looked equivalent to the old one. Hi, it turns out that

Re: buffer overflows in MySQL error messages (e.g. in 4.0.10-gamma)

2003-03-17 Thread Maarten LITMAATH
Sergei Golubchik wrote: Ok, I took a look at this. (btw, this was not a diff at all, but rather tarball of new and old files. Having a real unified diff would make your changes MUCH easier to understand). Hi, I did not want to force a particular diff format on the reader; having the original and

Re: buffer overflows in MySQL error messages (e.g. in 4.0.10-gamma)

2003-03-15 Thread Sergei Golubchik
Hi! On Mar 14, Maarten LITMAATH wrote: Sergei Golubchik wrote: On Mar 12, Maarten LITMAATH wrote: Description: MySQL (e.g. version 4.0.10-gamma) does not check for buffer overflows when formatting error messages: the code just assumes that no message will ever be larger than

Re: buffer overflows in MySQL error messages (e.g. in 4.0.10-gamma)

2003-03-14 Thread Sergei Golubchik
Hi! On Mar 12, Maarten LITMAATH wrote: Description: MySQL (e.g. version 4.0.10-gamma) does not check for buffer overflows when formatting error messages: the code just assumes that no message will ever be larger than SC_MAXWIDTH (256), ERRMSGSIZE (SC_MAXWIDTH) or MYSQL_ERRMSG_SIZE (200).

Re: buffer overflows in MySQL error messages (e.g. in 4.0.10-gamma)

2003-03-14 Thread Maarten LITMAATH
Sergei Golubchik wrote: On Mar 12, Maarten LITMAATH wrote: Description: MySQL (e.g. version 4.0.10-gamma) does not check for buffer overflows when formatting error messages: the code just assumes that no message will ever be larger than SC_MAXWIDTH (256), ERRMSGSIZE (SC_MAXWIDTH) or

buffer overflows in MySQL error messages (e.g. in 4.0.10-gamma)

2003-03-12 Thread Maarten LITMAATH
Description: MySQL (e.g. version 4.0.10-gamma) does not check for buffer overflows when formatting error messages: the code just assumes that no message will ever be larger than SC_MAXWIDTH (256), ERRMSGSIZE (SC_MAXWIDTH) or MYSQL_ERRMSG_SIZE (200). This has been observed to lead to memory

MySQL error

2003-02-02 Thread Mike
Hi All Running FreeBSD 4.7 MySQL 3.23. When trying to run or start MySQL I get 030201 16:32:59 Can't start server : Bind on unix socket: Permission denied 030201 16:32:59 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030201 16:32:59 Aborting 030201 16:32:59

MySQL error

2003-02-02 Thread Mike
Hi All Running FreeBSD 4.7 MySQL 3.23. When trying to run or start MySQL I get 030201 16:32:59 Can't start server : Bind on unix socket: Permission denied 030201 16:32:59 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030201 16:32:59 Aborting 030201

Re: MySQL error

2003-02-02 Thread Nasser Ossareh
Create a symlink for mysqld.sock in /tmp. ln -s /path/to/your/mysql.sock /tmp This should resolve the problem in over 90% of the cases. once this is fixed it is likely that you have other problems. but we'll discuss them when we get there ;-) --- Mike [EMAIL PROTECTED] wrote: Hi

Re: MySQL error (Errcode: 13)

2003-01-28 Thread Stefan Hinz, iConnect \(Berlin\)
: Monday, January 27, 2003 10:25 PM Subject: MySQL error (Errcode: 13) Anybody have an idea about the following error (Errcode: 13)? I am simply trying to add one more field in the table timesheet. My phpMySQL version is 3.23.55-nt Thanks. -Dhanashri Peramanu

MySQL error (Errcode: 13)

2003-01-27 Thread Dhanashri Peramanu
Anybody have an idea about the following error (Errcode: 13)? I am simply trying to add one more field in the table timesheet. My phpMySQL version is 3.23.55-nt Thanks. -Dhanashri Peramanu

MySQL error messages list

2003-01-18 Thread Stefan Hinz
Dear all (especially MySQL gurus), I have another question regarding MySQL error messages. I know that error messages are stored in errmsg.txt for different languages. We all love error 1064 (You have an error in your SQL syntax). My question: Where can I find a list of _all_ (not just common

Mysql Error

2003-01-15 Thread Daniel Florian
When I try to connect to the MySql server on localhost I get the following error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I am not quite sure what this means. I am running Mac OS X 10.2.3. Before I upgraded from 10.1, I had no problems, but now am unable to

RE: Mysql Error

2003-01-15 Thread Simon Green
PROTECTED] Subject: Mysql Error When I try to connect to the MySql server on localhost I get the following error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I am not quite sure what this means. I am running Mac OS X 10.2.3. Before I upgraded from 10.1, I had

<    1   2   3   4   >