with the MySQL codebase can see some possible
pitfalls in this fix.
Thx
ImRe
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 23 November 2006 12:14
To: 'mysql@lists.mysql.com'
Subject: Weird error with stored function
Hi,
I am trying to use stored
Hi,
I am trying to use stored functions through the prepared statement C API. I
have one application that issues relatively long running queries, while the
other is doing some inserts, updates, and short queries. If the second
application somehow calls a stored function (either directly through
Hello,
Today we tried to create a new field on a table in one of our databases. When
we tried to save the field we get the error:
Error on rename of ./DBNAME/TABLENAME.MYI to ./DBNAME/#SQL2-210-174.MYI
(Errorcode: 13)
Has anyone ever seen this before?
Thanks,
James
James Sherwood schrieb:
Hello,
Today we tried to create a new field on a table in one of our databases. When
we tried to save the field we get the error:
Error on rename of ./DBNAME/TABLENAME.MYI to ./DBNAME/#SQL2-210-174.MYI
(Errorcode: 13)
Has anyone ever seen this before?
Thanks,
James
James, that is a permission denied OS error.
When you run an alter table command (adding a field) MySQL builds a new
table alongside the old, then swaps them. Some file move/rename
perations are associated with that.
I would check that the mysql user on your system has full privileges on
: mysqllist mysql@lists.mysql.com
Sent: Monday, June 19, 2006 11:56 AM
Subject: Re: Weird error when creating a field
James, that is a permission denied OS error.
When you run an alter table command (adding a field) MySQL builds a new
table alongside the old, then swaps them. Some file move
Whenever I try to update an ISAM table (through a join
with nother small lookup table, also ISAM), I get the
following error:
Error Code : 1114
The table '#sql_910_0' is full
I read the following in the documentation:
http://dev.mysql.com/doc/mysql/en/full-table.html
But none of the reasons
Check the size of your partition that contains /tmp directory.
Just in case symlink it to a bigger partition. Your temporary table may
be bigger than the available space in /tmp
Luck,
Mihail
Homam S.A. wrote:
Whenever I try to update an ISAM table (through a join
with nother small lookup table,
, April 01, 2004 1:16 PM
To: Jason Chuong; [EMAIL PROTECTED]
Subject: Re: Weird Error message
It would really help if you could tell us at least which version of MySQL
you are using. It might also help to know which OS you are using and what
command you issued to get this error message.
Rhino
Hi All,
has anyone seen this error message before
040331 0:26:00 ft_read_next: Got error 127 when reading table ./
040331 0:26:38 ft_read_next: Got error 127 when reading table ./
040401 0:23:10 ft_read_first: Got error 127 when reading table ./
040401 0:23:19 ft_read_next: Got error
: Thursday, April 01, 2004 12:40 PM
Subject: Weird Error message
Hi All,
has anyone seen this error message before
040331 0:26:00 ft_read_next: Got error 127 when reading table ./
040331 0:26:38 ft_read_next: Got error 127 when reading table ./
040401 0:23:10 ft_read_first: Got error 127 when
Description:
When I create a fulltext index I get:
ERROR 1005: Can't create table './inventory/#sql-4024_116c.frm' (errno: 140)
How-To-Repeat:
alter table inventory.item add fulltext(storeId, catId, itemNo, title,
type, publisher, condition, color, subCategory,
Hi,
I am getting a weird error message in mysql.
I am doing this query
SELECT t0.sid, t1.stid, t0.clubname, t1.longheadline FROM club t0, story t1
WHERE t0.sid = t1.siteid AND t1.hold='no' AND t0.test = 0 AND t1.synd = '1'
AND t0.sport='football' ORDER BY `stid` DESC LIMIT 10;
and I am
Yup I used repair table as well.
Also I have resarted mysql and that made no difference
John
- Original Message -
From: Karthik [EMAIL PROTECTED]
To: John Wards [EMAIL PROTECTED]
Sent: Thursday, September 05, 2002 11:11 AM
Subject: Re: Weird error message
Hi,
Try using this command
John,
and I am getting this error message
ERROR 1030: Got error 28 from table handler
# perror 28
Error code 28: No space left on device
Free some disk space!
I have figured out that it is t0.test that is causeing the problem as when i
remove it the query works. This query has been
perror 28
No space left on device.
I guess your disk is getting full.
John Wards wrote:
Hi,
I am getting a weird error message in mysql.
I am doing this query
SELECT t0.sid, t1.stid, t0.clubname, t1.longheadline FROM club t0, story t1
WHERE t0.sid = t1.siteid AND t1.hold='no' AND t0.test
has anyone ever seen this MySQL error? The database has a high-traffic table
with about a million rows, is this the problem?
Warning: MySQL: Unable to save result set
TIA,
Sincerely,
Daren Cotter
CEO, InboxDollars.com
[EMAIL PROTECTED]
http://www.inboxdollars.com
(507) 382-0435
.
I have the above weird error when im trying to insert into a database. No
matter what I try, I cannot seem to find the error. Any suggestions that
im missing here. Its driving me nuts. the syntax seems to be okay as far
as I can tell.
Any suggestions here greatly appreciated
hi,
MATCH is a reserved word. Try to rename your table.
HTH.
Anton Tichawa.
-Original Message-
From: Chris Aitken [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 1:09 PM
To: [EMAIL PROTECTED]
Subject: Weird Error Inserting
Aitken [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 25, 2001 12:08 PM
Subject: Weird Error Inserting
Unable to insert [
insert into match (league_id,round_id,team_id_1,team_id_2) VALUES
('1','3','2','3')
]: You have an error in your SQL
Hi,
Unable to insert [
insert into match (league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')
]: You have an error in your SQL syntax near 'match
(league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')' at line 1.
MATCH is a keyword... :) How did you manage to
Hi All!
Unable to insert [
insert into match (league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')
]: You have an error in your SQL syntax near 'match
(league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')' at line 1.
(Yes, I see the reserved word comments.)
Debug
I'll bet somebody did a
cat afile /usr/local/mysql/bin/mysql
instead of
cat afile | /usr/local/mysql/bin/mysql
That is why you should not be doing stuff as root.
s . keeling wrote:
On Sat, Sep 01, 2001 at 04:43:25AM +0100, christopher sagayam wrote:
so how to fix the error ?
How did
can anyone please tell me what is happening here ?
[root@ns dump]# /usr/local/mysql/bin/mysql
/usr/local/mysql/bin/mysql: DROP: command not found
/usr/local/mysql/bin/mysql: syntax error near unexpected token `('
/usr/local/mysql/bin/mysql: /usr/local/mysql/bin/mysql: line 12: `CREATE
TABLE
31, 2001 3:01 PM
Subject: weird error that I have not encountered in 2 years
can anyone please tell me what is happening here ?
[root@ns dump]# /usr/local/mysql/bin/mysql
/usr/local/mysql/bin/mysql: DROP: command not found
/usr/local/mysql/bin/mysql: syntax error near unexpected token
so how to fix the error ?
How did file /usr/local/mysql/bin/mysql
become a text file ?
chris
- Original Message -
From: Lezz Giles [EMAIL PROTECTED]
To: christopher sagayam [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Saturday, September 01, 2001 2:36 AM
Subject: Re: weird error that I
On Sat, Sep 01, 2001 at 04:43:25AM +0100, christopher sagayam wrote:
so how to fix the error ?
How did file /usr/local/mysql/bin/mysql
become a text file ?
You tell us.
Regardless, is your data still intact? Make sure it's safe, rip out
mysql, and re-install.
Binaries don't just become
Dejan,
It seems that you have to add blahblahblah.com to the hosts allowed to
connect to the server.
Check the privilegies table and add that domain to the list.
On Fri, 27 Jul 2001 22:49:32 -0700 Dejan Nikic [EMAIL PROTECTED] wrote:
| Warning: Host 'blahblahblah.com' is not
Hi,
I worked with PHP and MySQL for about a year now, but this is the first time
I did my own MySQL instalation on my server instead of having it
preinstalled. This is when i got a very weird error that I've never seen
before.
Warning: Host 'blahblahblah.com' is not allowed to connect
29 matches
Mail list logo