I'm trying to get to the bottom of the 1205 exceptions I've been getting. I
understand it's a lock, but I don't understand exactly why it's happening
and how I can fix (either by recoding, table restructure, or mysql
configuration). Also, I should note that I'm a Java developer using JPA,
and not
> Hi,
>
> Apologies for not posting this in the 'replication' list, but that seems
> not very active...
>
> I have setup replication between two 4.1.10 databases, and I noticed
> that the SLAVE THREAD had stopped because of an SQL error.
>
> The errorlog says:
Hi,
Apologies for not posting this in the 'replication' list, but that seems
not very active...
I have setup replication between two 4.1.10 databases, and I noticed
that the SLAVE THREAD had stopped because of an SQL error.
The errorlog says: "Fix the problem and restart the s
ue Sanchez Vela [mailto:[EMAIL PROTECTED]
Sent: Monday, August 01, 2005 7:21 PM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: RE: possible mysql/sql error...
Bruce,
the shell is catching "system" and tries to execute
whatever follows it, MySQL ignores it 100%.
try using &#
> ignored...!!!
>
> hope this clarifies what i stated earlier...
>
> -bruce
>
>
>
> -Original Message-
> From: bruce [mailto:[EMAIL PROTECTED]
> Sent: Sunday, July 31, 2005 1:15 PM
> To: mysql@lists.mysql.com
> Subject: possible mysql/sql error
bruce [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 31, 2005 1:15 PM
To: mysql@lists.mysql.com
Subject: possible mysql/sql error...
update...
it appears that the 'system' word has to be at the beginning of a line in
the comment for the error to occur!
i'm willing to bet this is a
update...
it appears that the 'system' word has to be at the beginning of a line in
the comment for the error to occur!
i'm willing to bet this is a bug that hasn't been filed what are the
odds that someone would run across it!!
hi...
i created the following simple test of sql for mys
hi...
i created the following simple test of sql for mysql. i included some
comments that use the word 'system' in the comments. the comments are
wrapped in the '/* ... */' delimiters..
i get an error stating 'sh: foo command not found.' i traced the error/msg
to the fact that the word 'system' i
Hi,
I get an SQL Error 1030 with error 124 (MySQL error: 124 = Wrong index
given to function) during the execution of the following SQL statement:
select t.Datum, t.kmStand, t.kmStand - max(h.kmStand) as km, t.Betrag,
round(t.Menge,1) as Liter,
round(t.Menge * 100 / (t.kmStand - max(h.kmStand
Hi,
I get an SQL Error 1030 with error 124 (MySQL error: 124 = Wrong index
given to function) during the execution of the following SQL statement:
select t.Datum, t.kmStand, t.kmStand - max(h.kmStand) as km, t.Betrag,
round(t.Menge,1) as Liter,
round(t.Menge * 100 / (t.kmStand - max(h.kmStand
Rhino wrote:
From: "Ravi Malghan" <[EMAIL PROTECTED]>
Hi: I am building perl scripts which can insert data into a database
independent of the type of database. The following query works in
postgresql, but I am getting the following error when I run sql query in
mysql
mysql> SELECT ipaddress FRO
- Original Message -
From: "Ravi Malghan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 28, 2004 6:34 PM
Subject: sql error
Hi: I am building perl scripts which can insert data into a database
independent of the type of database. The fo
Hi: I am building perl scripts which can insert data into a database independent of
the type of database. The following query works in postgresql, but I am getting the
following error when I run sql query in mysql
mysql> SELECT ipaddress FROM ip_via_pingsweep WHERE ipaddress NOT IN (SELECT ipadd
Hi,
I'm using Win2k,Apache,PHP(V4) and mysql . When I'm running php page ,noticing error
" Notice: Undefined variable".
Let me know how to fix pl?
thx -seena
-
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
look at the PRIMARY_KEY
I suspect it is Auto Increment?
Martin
- Original Message -
From: "System Administrator a.k.a. The Root of the Problem"
<[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 12:09 PM
Subject: [EMAIL PROTECTED]: sql error]
What should I do to correct his?
Looks like a slippage in MySQl.
Using phpMyAdmin to correct this error.
- Forwarded message from -
Hi Dave, we get an error when we try to post or reply to any post on our
forums,,www.gamershaven.ca/Forums
mySQL query error: INSERT INTO ib
"HA. Mooduto" <[EMAIL PROTECTED]> wrote:
> dear all,
> what is the problem sql error : 1036 ...table is read only.
> please help me..
This table is compressed with myisampack or MySQL server doesn't have permissions on
the table files.
--
For technical
Does the mysql user have write permissions on the files?
HA. Mooduto wrote:
dear all,
what is the problem sql error : 1036 ...table is read only.
please help me..
thank's...
--
This mail sent through PSP: http://www.polinpdg.
dear all,
what is the problem sql error : 1036 ...table is read only.
please help me..
thank's...
--
This mail sent through PSP: http://www.polinpdg.ac.id/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
--Original Message-
>
> CREATE TABLE nuke_contactbook(
> workphone varchar( 255 ) ,
> homepage varchar( 255 ) ,
> IM varchar( 255 ) ,
> events text,
> reminders int( 11 ) ,
> notes text,
> PRIMARY KEY ( contactid ) ,
> KEY contactid( contactid ) ,
> KEY uid( uid )
You seem
Hi People,
Please, how are the error whit my sql?
I receive this message when I execute it in phpMyAdmin 2.5.0:
My sql host server is the portlandsql.
Erro
comando SQL :
CREATE TABLE nuke_contactbook(
uid int( 11 ) DEFAULT '0' NOT NULL ,
contactid int( 11 ) NOT NULL AUTO_INCREMENT ,
firstnam
"skjois" <[EMAIL PROTECTED]> wrote:
> I get this error
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
>
> how can i get rid of this?
Easily. Start MySQL and get rid of the message. :-)
--
For technical support contracts, goto https://order.mysql.
Hello,
I get this error
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
how can i get rid of this?
Regards,
Shashi Kiran.
I am getting error number -30996 when trying to update a MySQL BDB type
table using
transaction logging. Can anyone tell me what this number means, or where I
can get a list of BDB error numbers?
Thanks
Vivien
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
-
Vivien
Hi all,
I would like to know what means the following error in my application:
General SQL Error
[MyODBC][ODBC 3.51 Driver][mysqld-3.21.33b-log]parse error near
'`id`,`dia`,`mes`,`ano`,`pernormal`,`pernoturno`,`totdia`,`local`,`descricao`'
at line 1.
My application was de
Hi all,
I would like to know what means the following error in my application:
General SQL Error
[MyODBC][ODBC 3.51 Driver][mysqld-3.21.33b-log]parse error near
'`id`,`dia`,`mes`,`ano`,`pernormal`,`pernoturno`,`totdia`,`local`,`descricao`'
at line 1.
My application was de
"CHAR"
Fieldtype for the queried table at my MySQL.
It ran properly from Kylix (I have not compiled it)
but the problem is now it doesn't work anymore. I
don't know why.
Each time I activate the ClientDataSet I always find
this error message : "SQL Error : Error Mapping
Fail
I may found a solution to my problem
>Today my slave aborted replication with error (this is the third time
in 2 days)
Note that it worked for couple of months without a glitch
>It has aborted since the sql query had an error ?
>1. i think that if the query would have an error it should no
Today my slave aborted replication with error (this is the third time in
2 days)
---
06 9:21:23 Slave: error running query 'insert into user_lock
(what,user,locked) values('front edit','ninas'Ý¿ô;'
06 8:27:40 Error running query, slave aborted. Fix the problem,
and re-start the sla
> As far as I know, there'll be no other solution than recovering from
backup.
For the old data, that is quite alright -- what I'm trying to figure out now
is how to selectively restore information out of my (very large) binary
database transaction log file. (Anyone have tools to this effect???)
---> Reply is under the quoted text <---
=>From: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
=>Subject: SQL Error?
=>
=>I have a table that contains hourly work done on projects. It has
=>a basic structure of (extra
tions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
- Original Message -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesd
I have a table that contains hourly work done on projects. It has
a basic structure of (extraneous fields left out):
++--+--+
| Field | Type | Null |
++--+--+
| ID | int(10) unsigned | |
| ProjectID |
At 4:20 PM -0700 7/23/01, Dan Huston wrote:
>Hello All,
>
>I am getting this error:
>
>DBD::mysql::st execute failed: You have an error in your SQL syntax
>near ''user_id', 'sem1_acad_id', 'sem1_course_id', 'sem1_ver',
>'Sem_1_Final') VALUES (' at line 1 at flatten_er5.pl line 132,
> line 13634
Hello All,
I am getting this error:
DBD::mysql::st execute failed: You have an error in your SQL syntax near
''user_id', 'sem1_acad_id', 'sem1_course_id', 'sem1_ver', 'Sem_1_Final')
VALUES (' at line 1 at flatten_er5.pl line 132, line 136342.
in the trace log I see this:
Setting mysql_use_
35 matches
Mail list logo
