Hello All,
I was recently approached by someone looking for better error parsing
in MySQL. He does queries on large sets of data for research using
MySQL, and the vagueness of the "you have an error before ;" messages
often returned leave him desiring more. My goal is to develop some
kind of adv
The comma at the end of the SELECT statement needs to be removed
Naz Gassiep wrote:
Hi,
I'm trying to execute this query:
SELECT group_post.group_thread_id,
FROM group_post
LEFT OUTER JOIN group_post_moderation ON (group_post.group_post_id
= group_post_moderation
Hi,
I'm trying to execute this query:
SELECT group_post.group_thread_id,
FROM group_post
LEFT OUTER JOIN group_post_moderation ON (group_post.group_post_id =
group_post_moderation.group_post_id)
LEFT OUTER JOIN group_post_mod_option ON
(group_post_moderati
sheeri kritzer wrote:
MySQL usually gives a syntax error *where* the error happens. In this
case, it would indicate a problem with "SEC_TO_TIME(" but there
shouldn't be a problem, both according to the manual AND according to
my example.
The parser reads the query left-to-right and always qu
Mike Blezien wrote:
Hello,
this is a continued problem we are having from a earlier posting to the
list regarding a query. We need to calculate the SUM of the column
'agent_product_time' which is a TIME datatype column and according to
the manual:
http://dev.mysql.com/doc/refman/4.1/en/date-
Hi Sheeri,
Is your 'u.modified' column a TIME datatype '00:00:00'
Mike
- Original Message -
From: "sheeri kritzer" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Wednesday, May 17, 2006
Mike,
I can't really help except to ask if you're sure you copied and pasted
the query correctly. I did a similar query against a test system:
select u.uid,u.username,b.buddyUid,SEC_TO_TIME(SUM(TIME_TO_SEC(u.modified)))
as mins from Users u left join BuddyList b on u.uid = b.uid where
u.modifie
Hello,
this is a continued problem we are having from a earlier posting to the list
regarding a query. We need to calculate the SUM of the column
'agent_product_time' which is a TIME datatype column and according to the
manual:
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-type-overvie
Hi,
I'm running a 2-node cluster with MySQL 5.0.18 on two Solaris 10 boxes -
call them sun3 and sun5.
Each server is running as a storage node (i.e. ndbd) and a MySQL server
node (mysqld).
I created the cluster by converting an existing database from MyISAM
engine type to "ndbcluster". sun3 host
nm ... I found the problem ... I need to use BINARY(LPAD ...)
-Original Message-
From: Rob Brooks [mailto:[EMAIL PROTECTED]
Sent: Monday, December 19, 2005 10:04 AM
To: mysql@lists.mysql.com
Subject: Query Error Help
Hello, I have this query:
SELECT FL3_PatientControlNumber
Hello, I have this query:
SELECT FL3_PatientControlNumber, claims.RecordKey as reckey,
FL1_ProviderName, CalcFlag
FROM claims INNER JOIN service_line ON service_line.ClaimKey =
claims.RecordKey
WHERE ( service_line.FL42_ServiceLineRevCode BETWEEN LPAD('110',4,'0') AND
LPAD('210',4,'0' ) ) OR
Hello.
Start points for you problem:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
> socket=/home.dbdata/mysql/mysql.sock
What is your client thinks about the location of mysqld socket?
Put the same
Hi all
First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2
with MySQL 4.1.12, rpm install.
Changed the data directory.
My /etc/my.conf
---
[mysqld]
datadir=/home.dbdata/mysql
socket=/home.dbdata/mysql/mysql.sock
# Default to using old password format for compa
without any problems and
waiting for connections.
>>ps -aux shows that mysql is running
And for the same reason I mentioned above, you are seeing this.
Hope this helps.
sujay
-Original Message-
From: Sanjay Arora [mailto:[EMAIL PROTECTED]
Sent: Monday, November 14, 2005 4:46 PM
To: MySql
Hi all
First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2
with MySQL 4.1.12, rpm install.
Changed the data directory.
My /etc/my.conf
[mysqld]
datadir=/home.dbdata/mysql
socket=/home.dbdata/mysql/mysql.sock
# Default to using old password format for compatibility with mys
Is there any way to find log of queries that returned errors. Syntax
errors or column not found, for example?
The General Log simply logs the query without giving any information as
to whether the query was successful or not
Thank you in advance.
Best regards,
TS
On Tue, 14 Sep 2004 19:55:42 -0700, Soheil Shaghaghi <[EMAIL PROTECTED]> wrote:
> I have a subroutine which checks for multiple entries and if a user has
> voted once in the same day, it will not calculate the vote. However, I
> found out that it does not really do this.
> What it does is only look
Hello.
I have a subroutine which checks for multiple entries and if a user has
voted once in the same day, it will not calculate the vote. However, I
found out that it does not really do this.
What it does is only look at the last entry. If the user IP address is
the last entry it does not calculat
Ed
The MS Access SQL syntax for if() is iif(condition, then stuff, else stuff)
Maybe that's the problem, I am not sure - try it
Freddie
-Ursprüngliche Nachricht-
Von: Ed Reed [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 26. Februar 2004 02:09
An: [EMAIL PROTECTED]
Betreff:
PROTECTED]> 2/26/04 12:25:03 PM >>>
Ed
The MS Access SQL syntax for if() is iif(condition, then stuff, else
stuff)
Maybe that's the problem, I am not sure - try it
Freddie
-Ursprüngliche Nachricht-
Von: Ed Reed [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 26. Februar
Hello Everyone,
If I run the following query in MySQL Control Center or MySQL-Front it
works correctly,
SELECT -1 AS ProductID, "Add New Part" AS PartNumber, "" AS
VendorPartNo, "" AS Description, "" AS VendorStatus
FROM Products
UNION SELECT ProductID, PartNumber, If(SubNo=1135,
VendorPart,A
age-
From: Geeta Rajaraman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 10:00 AM
To: Chris
Subject: Re: MySQL sub-query error.
See..I changed it = only coz the IN wouldn't work. I am guessing its a MySQL
version issue. I am using a version below 4.0.
I am curious about
3 AM
To: [EMAIL PROTECTED]
Subject: MySQL sub-query error.
Good Morning everyone:
I need help figuring out what is wrong with this query. I have tried to
use the LEFT JOIN, but it doesn't solve the purpose.
This is what I am trying to run:
SELECT group_id,name,'SELEC
Good Morning everyone:
I need help figuring out what is wrong with this query. I have tried to
use the LEFT JOIN, but it doesn't solve the purpose.
This is what I am trying to run:
SELECT group_id,name,'SELECTED' FROM groups WHERE group_id = (SELECT
group_id FROM user_groups WHERE use
Timotius Alfa wrote:
Pls help me guys.
what's wrong with this command ?
select a.siswa_id,a.nama,b.Nilai from Query_DataSiswa a left join ( select siswa_id,Nilai,Tes_Id from Nilai_Harian where tes_id = 1 and pertemuan = 1 and paket_id = 1 and tingkat = 1) b on a.siswa_id = b.siswa_id where a.p
Pls help me guys.
what's wrong with this command ?
select a.siswa_id,a.nama,b.Nilai from Query_DataSiswa a left join ( select
siswa_id,Nilai,Tes_Id from Nilai_Harian where tes_id = 1 and pertemuan = 1 and
paket_id = 1 and tingkat = 1) b on a.siswa_id = b.siswa_id where a.paket_id = 1 and
a
Hi!
I've look a bit around google for theese errors - but i can't find any
useful answers to my problem.
My setup is;
web frontend running apache/php for dynamic page creation (p4 - 2,4
Ghz - 1Gb - ide)
sql backend running mysql 4.0.12-log (p3 - 1 Ghz - ide)
both machines running deb
Hello.
How can I recover query errors done on a mysql server?
Is there a log file?
It's very important to me to know about this.
Thanx so much!!!
Lorenzo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In the last episode (Nov 21), ck nuke said:
> I have a problem about : mysql query
> I need help for this.
> Sever: mysql Version: 4.0.4-bata
> SELECT p.pid, p.dateline, t.tid, t.replies FROM cdb_threads t,
> cdb_posts p WHERE p.tid=t.tid AND t.fid='24' ORDER BY p.dateline DESC LIMIT
> 0,1
Hi
I have a problem about : mysql query
I need help for this.
Sever: mysql Version: 4.0.4-bata
SELECT p.pid, p.dateline, t.tid, t.replies FROM cdb_threads t,
cdb_posts p WHERE p.tid=t.tid AND t.fid='24' ORDER BY p.dateline DESC LIMIT
0,1
When use this command, no result
---
y for connections
021117 23:10:31 Slave I/O thread: connected to master
'repl@director:3306', replication started in log
'FIRST' at position
4
021117 23:10:31 Error updating slave list: Query
error
021117 23:10:31 Slave I/O thread exiting, read up to
log 'FIRST',
p
Hi All,
I have a table in mysql as "Attributes", which has 10
recordsin it.
If I run the query as "select * from Attributes", it
gives me 10 records, but if i run the query as "Select
Attribute from Attributes" it gives me 9 records. But
this error does not occur every time. It comes very
rarely
Odhiambo Washington wrote:
>Hello gurus,
>
>
>Please help. Where is my mistake?
>
>
>
>I get the following error...
>
>MYSQL: query failed: You have an error in your SQL syntax near ') < rei_ts' at line 1
>
>
>When I run the query below
>
>
> SELECT rei_ip \
> FROM relay_ip \
> WHERE
Hello gurus,
Please help. Where is my mistake?
I get the following error...
MYSQL: query failed: You have an error in your SQL syntax near ') < rei_ts' at line 1
When I run the query below
SELECT rei_ip \
FROM relay_ip \
WHERE rei_ip="${sender_host_address}" AND DATE_SUB(N
Mark,
Mark Matthews wrote:
> Richard S. Huntrods wrote:
>
>> I have been running MySQL on a W2K platform for over a year now. The
>> system is normally accessed through servlets, using the "mm" jdbc
>> driver.
>>
>> I have a number of standalone java programs that also access the
>> database
Richard S. Huntrods wrote:
> I have been running MySQL on a W2K platform for over a year now. The
> system is normally accessed through servlets, using the "mm" jdbc driver.
>
> I have a number of standalone java programs that also access the
> database using the "mm" driver. These have alway
I have been running MySQL on a W2K platform for over a year now. The
system is normally accessed through servlets, using the "mm" jdbc driver.
I have a number of standalone java programs that also access the
database using the "mm" driver. These have always worked quite well,
until today.
One
I have been running MySQL on a W2K platform for over a year now. The
system is normally accessed through servlets, using the "mm" jdbc driver.
I have a number of standalone java programs that also access the
database using the "mm" driver. These have always worked quite well,
until today.
O
When I issue the following query from phpMyAdmin,
SELECT b.* FROM newblocks b LEFT JOIN groups_blocks_link l ON
l.block_id=b.bid WHERE (l.groupid=3) AND b.isactive=1 AND b.side=0 AND
b.visible=1 ORDER BY b.weight,b.bid
I get the following error
Can't create/write to file '/var/tmp/#sql3f2_194_0.
Franco,
Friday, June 21, 2002, 6:03:16 AM, you wrote:
FMG> I'm using mysql-3.23.41 and initially able to use it without any problem.
However, after I issued this command, "grant all privileges on *.* to root@localhost
identified by 'mypassword' with
FMG> grant option; ", mysql will simply dis
Hello to everyone!
I'm using mysql-3.23.41 and initially able to use it without any problem. However,
after I issued this command, "grant all privileges on *.* to root@localhost
identified by 'mypassword' with grant option; ", mysql will simply display the message
"Ignoring query to other da
-
From: WANG_FAITH??îÈõ-þì?L <[EMAIL PROTECTED]>
To: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]>
Date: Saturday, December 29, 2001 03:25
Subject: query error
>Hi, all
>When I query data from a table ,the following error occurs:
>ERROR 1030: Got error 127 from table handler
Hi, all
When I query data from a table ,the following error occurs:
ERROR 1030: Got error 127 from table handler.
Would you please tell me the reason to cause the error and how to deal with
it?
Thank you!
-
Before posting, please
hi,
try your first SELECT statement, but with
ORDER BY table1.table1_row
maybe this helps (I didnt try it).
Anton Tichawa
> -Original Message-
> From: Bruno Faé [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 22, 2001 5:44 PM
> To: [EMAIL PROTECTED]
> Subje
Hi !
I´m trying to query some news with multiple rows in my database. I´m
receiving an error when i use:
"SELECT table1.*, table2.table2_row FROM table1,table2 ORDER BY
table1_row"
but, if I try:
"SELECT table1.table1_row, table2.table2_row FROM table1,table2 ORDER BY
table1_row"
or
"SELECT ta
On 14-Jul-01 [EMAIL PROTECTED] wrote:
>>Descritpion:
> Hello,
>
> I've got MySQL installed on a P-III 1ghz machine running RedHat 7. I
am
> havign the same error, over and over again when I attempt to delete anything
> from any table. I've tried this delete from being ROOT to being a peo
>Descritpion:
Hello,
I've got MySQL installed on a P-III 1ghz machine running RedHat 7. I am
havign the same error, over and over again when I attempt to delete anything from any
table. I've tried this delete from being ROOT to being a peon user.
Heres my query:
DELETE FROM topicexc
Did you follow the rest of the instructions?
Did you create the mysql user?
Did you run mysql_install_db --user=mysql ?
Did you start the server ?
"Foresight Systems Ltd." wrote:
>
> Dear Sir,
>
> We are trying to install and configure mysql version .23.32 on Linux Red
> Hat 7.
> Usinf the con
First try to find out where you socket is located:
# lsof -p {$PID_OF_MYSQL] |grep unix
mysqld 1277 root 4u unix 0xcb596580 1712 /var/lib/mysql/mysql.sock
And then point to this file in mysql conf file:
# more /etc/my.cnf
[client]
socket=/var/lib/mysql/mysql.sock
[mysqld]
socket=/var/lib/mysq
Dear Sir,
We are trying to install and configure mysql version .23.32 on Linux Red
Hat 7.
Usinf the configure option
./configure --prefix=/usr/local --localstatedir=/usr/local/mysql/data
--with-unix-socket-path=/usr.local/mysql/tmp/mysql.sock
the make and make install.
we have tried several varia
50 matches
Mail list logo