Re: URGENT!!!! MySQL user table is read only...
Check the permissions on the directories you are using for data, as well as
checking the user the MySQL deamon is running as.
j- k-
On Wednesday 20 June 2001 06:55, [EMAIL PROTECTED] wrote:
> MySQL newbie question here!!
>
> I have MySQL installed on Red Hat Linux 7. I have a Test, Backup and Live
> environment. All with the same installations of Linux, MySQL and CF. The
> problem that I am having is that I am trying to create a new database user
> in the table "user" in MySQL. It works find in my Test and Backup
> Environment... but for some reason, my Live environment reports back that
> the table is read only.
>
>
> mysql>USE mysql;
> mysql>INSERT INTO user (Host, User, Password)
> ->VALUES ("localhost", "cfuser", PASSWORD(""));
> ERROR 1036: Table 'user' is read only
> -
>
> If anyone could help me it would be greatly, greatly appreciated!! I think
> I may have to throw my server out the window soon!!
>
> Thanks in advance...
> Sean Blenkhorn
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: URGENT!!!! MySQL user table is read only...
OK now I feel dumb I thought I had checked that... but what has
happened was that there were multiple instances of the file... so while I
changed the write access on the mysql files I thought were being used
it still didn't work... but low and behold... there was another directory
with the "real" mysql files (well actually several instances... but
apparently we don't feel the need to delete old files!!) so thank
you... it is now fixed!!
Cheers,
Sean
Gerald Clark
cc: Nessi <[EMAIL PROTECTED]>,
[EMAIL PROTECTED]
Subject: Re: URGENT MySQL
user table is read only...
06/20/01 01:53 PM
ls -l /var/mysql/mysql/user.*
Replace above path with actual path on your system.
Does mysql have write privileges on the files?
[EMAIL PROTECTED] wrote:
> Unfortunately I have tried that. Attempted to GRANT all privelages to
the
> root user it failed with the same error message stating that the
Table
> "user" is read only.
>
> UGH Too frustrating!!
>
>
>
>
>
>
> Nessi
> .de> cc: [EMAIL PROTECTED]
> Subject: Re: URGENT
MySQL user table is read only...
> 06/20/01
> 11:23 AM
>
>
>
>
>
> Why dont you use the GRANT command?
>
> GRANT ALL ON database.* TO newuser@localhost IDENTIFIED BY 'password';
> FLUSH PRIVILEGES;
>
> Something like that...
>
> Cheers, Nessi
>
>
> At 15:55 20/06/01 , you wrote:
>
>> MySQL newbie question here!!
>>
>> I have MySQL installed on Red Hat Linux 7. I have a Test, Backup and
Live
>> environment. All with the same installations of Linux, MySQL and CF. The
>> problem that I am having is that I am trying to create a new database
user
>> in the table "user" in MySQL. It works find in my Test and Backup
>> Environment... but for some reason, my Live environment reports back
that
>> the table is read only.
>>
>>
>> mysql>USE mysql;
>> mysql>INSERT INTO user (Host, User, Password)
>> ->VALUES ("localhost", "cfuser", PASSWORD(""));
>> ERROR 1036: Table 'user' is read only
>> -
>>
>> If anyone could help me it would be greatly, greatly appreciated!! I
>
> think
>
>> I may have to throw my server out the window soon!!
>>
>> Thanks in advance...
>> Sean Blenkhorn
>>
>>
>> -
>> Before posting, please check:
>>http://www.mysql.com/manual.php (the manual)
>>http://lists.mysql.com/ (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: URGENT!!!! MySQL user table is read only...
ls -l /var/mysql/mysql/user.*
Replace above path with actual path on your system.
Does mysql have write privileges on the files?
[EMAIL PROTECTED] wrote:
> Unfortunately I have tried that. Attempted to GRANT all privelages to the
> root user it failed with the same error message stating that the Table
> "user" is read only.
>
> UGH Too frustrating!!
>
>
>
>
>
>
>
> Nessi
>
>
> .de> cc: [EMAIL PROTECTED]
>
> Subject: Re: URGENT MySQL user
>table is read only...
> 06/20/01
>
> 11:23 AM
>
>
>
>
>
>
>
>
> Why dont you use the GRANT command?
>
> GRANT ALL ON database.* TO newuser@localhost IDENTIFIED BY 'password';
> FLUSH PRIVILEGES;
>
> Something like that...
>
> Cheers, Nessi
>
>
> At 15:55 20/06/01 , you wrote:
>
>> MySQL newbie question here!!
>>
>> I have MySQL installed on Red Hat Linux 7. I have a Test, Backup and Live
>> environment. All with the same installations of Linux, MySQL and CF. The
>> problem that I am having is that I am trying to create a new database user
>> in the table "user" in MySQL. It works find in my Test and Backup
>> Environment... but for some reason, my Live environment reports back that
>> the table is read only.
>>
>>
>> mysql>USE mysql;
>> mysql>INSERT INTO user (Host, User, Password)
>> ->VALUES ("localhost", "cfuser", PASSWORD(""));
>> ERROR 1036: Table 'user' is read only
>> -
>>
>> If anyone could help me it would be greatly, greatly appreciated!! I
>
> think
>
>> I may have to throw my server out the window soon!!
>>
>> Thanks in advance...
>> Sean Blenkhorn
>>
>>
>> -
>> Before posting, please check:
>>http://www.mysql.com/manual.php (the manual)
>>http://lists.mysql.com/ (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail <[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: URGENT!!!! MySQL user table is read only...
Unfortunately I have tried that. Attempted to GRANT all privelages to the
root user it failed with the same error message stating that the Table
"user" is read only.
UGH Too frustrating!!
Nessi
cc: [EMAIL PROTECTED]
Subject: Re: URGENT MySQL user table
is read only...
06/20/01
11:23 AM
Why dont you use the GRANT command?
GRANT ALL ON database.* TO newuser@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
Something like that...
Cheers, Nessi
At 15:55 20/06/01 , you wrote:
>MySQL newbie question here!!
>
>I have MySQL installed on Red Hat Linux 7. I have a Test, Backup and Live
>environment. All with the same installations of Linux, MySQL and CF. The
>problem that I am having is that I am trying to create a new database user
>in the table "user" in MySQL. It works find in my Test and Backup
>Environment... but for some reason, my Live environment reports back that
>the table is read only.
>
>
>mysql>USE mysql;
>mysql>INSERT INTO user (Host, User, Password)
>->VALUES ("localhost", "cfuser", PASSWORD(""));
>ERROR 1036: Table 'user' is read only
>-
>
>If anyone could help me it would be greatly, greatly appreciated!! I
think
>I may have to throw my server out the window soon!!
>
>Thanks in advance...
>Sean Blenkhorn
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: URGENT!!!! MySQL user table is read only...
Why dont you use the GRANT command?
GRANT ALL ON database.* TO newuser@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
Something like that...
Cheers, Nessi
At 15:55 20/06/01 , you wrote:
>MySQL newbie question here!!
>
>I have MySQL installed on Red Hat Linux 7. I have a Test, Backup and Live
>environment. All with the same installations of Linux, MySQL and CF. The
>problem that I am having is that I am trying to create a new database user
>in the table "user" in MySQL. It works find in my Test and Backup
>Environment... but for some reason, my Live environment reports back that
>the table is read only.
>
>
>mysql>USE mysql;
>mysql>INSERT INTO user (Host, User, Password)
>->VALUES ("localhost", "cfuser", PASSWORD(""));
>ERROR 1036: Table 'user' is read only
>-
>
>If anyone could help me it would be greatly, greatly appreciated!! I think
>I may have to throw my server out the window soon!!
>
>Thanks in advance...
>Sean Blenkhorn
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
URGENT!!!! MySQL user table is read only...
MySQL newbie question here!!
I have MySQL installed on Red Hat Linux 7. I have a Test, Backup and Live
environment. All with the same installations of Linux, MySQL and CF. The
problem that I am having is that I am trying to create a new database user
in the table "user" in MySQL. It works find in my Test and Backup
Environment... but for some reason, my Live environment reports back that
the table is read only.
mysql>USE mysql;
mysql>INSERT INTO user (Host, User, Password)
->VALUES ("localhost", "cfuser", PASSWORD(""));
ERROR 1036: Table 'user' is read only
-
If anyone could help me it would be greatly, greatly appreciated!! I think
I may have to throw my server out the window soon!!
Thanks in advance...
Sean Blenkhorn
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
my sql and pattern search--bug(most urgent)
Hi, Can someone get back to me at the earliest regarding mysql's support for backslash characters in pattern search.I am not able to search based on the string which contains a backslash character even after escaping.. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
my sql and patter matching ....bug(Urgent)
Hi, I am facing the following problem in pattern matching: I want to check the pattern matching using LIKE on a field that is declared as Binary and also contains back slashes. eg: ID INT, NAME VARCHAR(128) BINARY I am using C-API of mysql to escape the characters like '\' for this field. The samples field values for the above are: "XYZ\ABC","PQR\ABC","DEFABC". If I use the follwoing statement for pattrn matching: SELECT NAME FROM [TABLE-NAME] WHERE NAME LIKE "%\\ABC%" . Tried the other way too like this: SELECT NAME FROM [TABLE-NAME] WHERE NAME LIKE "%\\ABC%" it returns all the three values instead of only two Is this a bug or what is the solution. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
URGENT Help pl.
Hi all, I need to convert the records from mysql database into MS.Access. I don't have ODBC.The mysql is in different machine(stand alone).So i need to convert that into a flat file then put into MS-Access. Can u pl.help me in this regard. It's very urgent.It'll b very much useful if i get a reply soon. Thank u in adv. kala _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql query urgent!!!
>i, >I have to write simple mysql script. I need folowing things: > >Number of people logged in previous 0 to 24 hours >Number of people logged in previous 24.5 to 48 hours >Number of people logged in previous 48.5 to 72 hours >Number of people logged in previous 72.5 hours to 7 days >Number of people logged in previous 7.5 to 14 days >Number of people logged in previous 14.5 days onwards > > >My tables is as follows: >mysql> select * from User limit 1; >+--+---+-+--+ >| partner_name | user_name | last_login | mailbox_size | >+--+---+-+--+ >| foo.net | edward| 2001-06-02 09:37:41 | 229099 | >+--+---+-+--+ >1 row in set (0.62 sec) > >I also want to save the output to comma delimited file. >Cheers >kapil Sir, redefine the last_login column as a timestamp and try the following; CREATE TEMPORARY TABLE time_groups SELECT If( Unix_timestamp(CURRENT_TIMESTAMP) - Unix_timestamp(last_login) <= 86400 , '01 day' , If( Unix_timestamp(CURRENT_TIMESTAMP) - Unix_timestamp(last_login) <= 172800 , '02 days' , If( Unix_timestamp(CURRENT_TIMESTAMP) - Unix_timestamp(last_login) <= 259200 , '03 days' , If( Unix_timestamp(CURRENT_TIMESTAMP) - Unix_timestamp(last_login) <= 604800 , '07 days' , If( Unix_timestamp(CURRENT_TIMESTAMP) - Unix_timestamp(last_login) <= 1209600 , '14 days' , '>14 days' ) ) ) ) ) AS time_group FROM User; SELECT time_group, Count(*) FROM time_groups GROUP BY time_group; It works on my machine. The time_group values are chosen so that they will display in the proper order. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak MySQL list magic words: sql query database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql query urgent!!!
i, I have to write simple mysql script. I need folowing things: Number of people logged in previous 0 to 24 hours Number of people logged in previous 24.5 to 48 hours Number of people logged in previous 48.5 to 72 hours Number of people logged in previous 72.5 hours to 7 days Number of people logged in previous 7.5 to 14 days Number of people logged in previous 14.5 days onwards My tables is as follows: mysql> select * from User limit 1; +--+---+-+--+ | partner_name | user_name | last_login | mailbox_size | +--+---+-+--+ | foo.net | edward| 2001-06-02 09:37:41 | 229099 | +--+---+-+--+ 1 row in set (0.62 sec) I also want to save the output to comma delimited file. Cheers kapil _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: URGENT Disappear - Reappear Problem
I have only seen this when some thing was looking are the db files independed of mysqld. This was when I used isamchk to resort and fix a table but did not flush tables after. Hope this helps Simon -Original Message- From: Richard McKenney [mailto:[EMAIL PROTECTED]] Sent: 05 June 2001 13:09 To: [EMAIL PROTECTED] Subject: URGENT Disappear - Reappear Problem We have a table whose entries seem to be disappearing at random. We are accessing our MySQL 3.22.32 database with PHP4 on a Linux 6.0 586 machine. Up until yesterday, we would lose about one entry per week in a single table. The rest of the tables seem fine. However, yesterday one of our entries reappeared. Our affected table has 39 fields with one auto-increment primary key zerofill field. isamchk returned that everything was fine. Has anyone seen this happen before? Thanks in advance. Shawn McKenney [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
URGENT Disappear - Reappear Problem
We have a table whose entries seem to be disappearing at random. We are accessing our MySQL 3.22.32 database with PHP4 on a Linux 6.0 586 machine. Up until yesterday, we would lose about one entry per week in a single table. The rest of the tables seem fine. However, yesterday one of our entries reappeared. Our affected table has 39 fields with one auto-increment primary key zerofill field. isamchk returned that everything was fine. Has anyone seen this happen before? Thanks in advance. Shawn McKenney [EMAIL PROTECTED]
Re: URGENT !! Hanging query
Please send me the actual physical query that was locking things up. This sounds like a simple join, include table/key structures in your response. More than likely you aren't joining somewhere "nicely", and if you don't, you end up with really really large result sets. - Original Message - From: "Paul Wilkinson" <[EMAIL PROTECTED]> To: "Help MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, May 29, 2001 1:08 PM Subject: URGENT !! Hanging query > PLEASE if anyone can help!! We are past deadline > > Object: Retrieve rows from table D. > > GIVEN: > 1. MySQL ver 3.23.33 (but must run on 3.22.25!) > 2. Table D is connected to tables E,F,K through tables dE,dF,dK. > 3. Table D is connected to table L through tables dK then Lk. > > D - dE - E > D - dF - F > D - dK - K > D - dK - Lk - L > > 4. All query WHERE clauses use string fields (VAR or VARCHAR) in E, F, K, L > 5. Each table E,F,K,L has less than 1000 rows. > 6. Each string field is indexed > 7. Each joiner field is indexed > > NEED: > 1. WHERE clause which checks exact matches for E,F and L tables and > substring match for words in K. > 2. Multiple words to limit results to intersection of returns > 3. Ordered by number of rows in dE,dF, then dK (both L and K) > 4. List only unique rows in D > > I have tryed several things to create various queries in PHP, some which are > as large as 2500 characters! > > The only thing that I can think of now is Does each AND section of the WHERE > clause have to have ALL unique table aliases? (down to the last common one?) > > Paul > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: URGENT !! Hanging query
Bruce, Thanks for your reply! 1- Yes I've tested using MySQL GUI 1.7.4 with the same results 2 - Don't know, will have to find out 3 - I'll find and check that too > Paul, > > Have you tried the SQL from mysql to see wht it does outside of PHP? IS the MySQL server configured to log all queries? What do the logs say is being sent to the server? These are the places I start from. > > Bruce Ferrell > > > > > > PLEASE if anyone can help!! We are past deadline > > > > Object: Retrieve rows from table D. > > > > GIVEN: > > 1. MySQL ver 3.23.33 (but must run on 3.22.25!) > > 2. Table D is connected to tables E,F,K through tables dE,dF,dK. > > 3. Table D is connected to table L through tables dK then Lk. > > > > D - dE - E > > D - dF - F > > D - dK - K > > D - dK - Lk - L > > > > 4. All query WHERE clauses use string fields (VAR or VARCHAR) in E, F, K, L > > 5. Each table E,F,K,L has less than 1000 rows. > > 6. Each string field is indexed > > 7. Each joiner field is indexed > > > > NEED: > > 1. WHERE clause which checks exact matches for E,F and L tables and > > substring match for words in K. > > 2. Multiple words to limit results to intersection of returns > > 3. Ordered by number of rows in dE,dF, then dK (both L and K) > > 4. List only unique rows in D > > > > I have tryed several things to create various queries in PHP, some which are > > as large as 2500 characters! > > > > The only thing that I can think of now is Does each AND section of the WHERE > > clause have to have ALL unique table aliases? (down to the last common one?) > > > > Paul > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
URGENT !! Hanging query
PLEASE if anyone can help!! We are past deadline Object: Retrieve rows from table D. GIVEN: 1. MySQL ver 3.23.33 (but must run on 3.22.25!) 2. Table D is connected to tables E,F,K through tables dE,dF,dK. 3. Table D is connected to table L through tables dK then Lk. D - dE - E D - dF - F D - dK - K D - dK - Lk - L 4. All query WHERE clauses use string fields (VAR or VARCHAR) in E, F, K, L 5. Each table E,F,K,L has less than 1000 rows. 6. Each string field is indexed 7. Each joiner field is indexed NEED: 1. WHERE clause which checks exact matches for E,F and L tables and substring match for words in K. 2. Multiple words to limit results to intersection of returns 3. Ordered by number of rows in dE,dF, then dK (both L and K) 4. List only unique rows in D I have tryed several things to create various queries in PHP, some which are as large as 2500 characters! The only thing that I can think of now is Does each AND section of the WHERE clause have to have ALL unique table aliases? (down to the last common one?) Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: characters - URGENT!!
It is frequently faster. Although, not a problem in mysql, msql
frequently ran an order of magnitude faster if the "joins" were done in
perl rather than in the SQL statements.
On Thu, 24 May 2001, Brian Kaney wrote:
> Date: Thu, 24 May 2001 10:01:04 -0400
> From: Brian Kaney <[EMAIL PROTECTED]>
> To: Selvin Sakal <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: RE: characters - URGENT!!
>
> I've noticed some people seem to be forgetting about their
> middleware when approaching a programming challenge. In many
> cases, information to and from the database is processed using C,
> java, perl, php, etc. These languages can do pre and post
> processing of data. I have found this approach is easier and
> sometimes quicker than building a complicated SQL statement.
>
> Since I am familiar with perl and php, I would use regular
> expressions either before you issue your insert command or after
> the data is selected.
>
> Cheers,
> Brian
>
> -Original Message-
> From: Selvin Sakal [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 24, 2001 7:43 AM
> To: [EMAIL PROTECTED]
> Subject: characters - URGENT!!
>
>
> Hi,
> i have a mysql database, can anyone tell me any characters that
> cannot be
> entered into mysql (like !@#$%, etc).
>
> Also i have a string and i would like to remove html tags,
> characters (like
> ~!@#$%^&*()_+|`-=\{}[]:"<>?;',./ ) out of it, so basically i want
> the string
> to be just left with words.
>
> any help would be helpful,
>
> Thanks
> Selvin
>
> P.S. this is urgent i need this very quickly
> _
>
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com.
>
>
> -
>
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: characters - URGENT!!
I've noticed some people seem to be forgetting about their
middleware when approaching a programming challenge. In many
cases, information to and from the database is processed using C,
java, perl, php, etc. These languages can do pre and post
processing of data. I have found this approach is easier and
sometimes quicker than building a complicated SQL statement.
Since I am familiar with perl and php, I would use regular
expressions either before you issue your insert command or after
the data is selected.
Cheers,
Brian
-Original Message-
From: Selvin Sakal [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 7:43 AM
To: [EMAIL PROTECTED]
Subject: characters - URGENT!!
Hi,
i have a mysql database, can anyone tell me any characters that
cannot be
entered into mysql (like !@#$%, etc).
Also i have a string and i would like to remove html tags,
characters (like
~!@#$%^&*()_+|`-=\{}[]:"<>?;',./ ) out of it, so basically i want
the string
to be just left with words.
any help would be helpful,
Thanks
Selvin
P.S. this is urgent i need this very quickly
_
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
<[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: characters - URGENT!!
I would say it depends on what you're using to put the data into your
database.
PHP comes with several functions that make this sort of thing very easy
(strip_tags, for example, will remove all HTML tags from a string)
If you're using Perl or something else that supports regex, I think that's
going to have to be the best way.
HTH
Jon
-Original Message-
From: Selvin Sakal [mailto:[EMAIL PROTECTED]]
Sent: 24 May 2001 12:43
To: [EMAIL PROTECTED]
Subject: characters - URGENT!!
Hi,
i have a mysql database, can anyone tell me any characters that cannot be
entered into mysql (like !@#$%, etc).
Also i have a string and i would like to remove html tags, characters (like
~!@#$%^&*()_+|`-=\{}[]:"<>?;',./ ) out of it, so basically i want the string
to be just left with words.
any help would be helpful,
Thanks
Selvin
P.S. this is urgent i need this very quickly
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
'The information included in this Email is of a confidential nature and is
intended only for the addressee. If you are not the intended addressee,
any disclosure, copying or distribution by you is prohibited and may be
unlawful. Disclosure to any party other than the addressee, whether
inadvertent or otherwise is not intended to waive privilege or
confidentiality'
**
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
characters - URGENT!!
Hi,
i have a mysql database, can anyone tell me any characters that cannot be
entered into mysql (like !@#$%, etc).
Also i have a string and i would like to remove html tags, characters (like
~!@#$%^&*()_+|`-=\{}[]:"<>?;',./ ) out of it, so basically i want the string
to be just left with words.
any help would be helpful,
Thanks
Selvin
P.S. this is urgent i need this very quickly
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: my sql database and locking issues(URGENT)
> 2. > The following is the extract from mysql documentation: > " > In MySQL Version 3.23.7 and above, you can insert rows > into MyISAM tables at the same time other threads are > reading from the table. Note that currently this only > works if there are no holes after deleted rows in the > table at the time the insert is made. > " > ACTUALLY,VERSION 3.23.7 IS NOT RELEASED.ARE THESE THE > EXPECTED FEATURES IN THE COMING VERSION? > 3.23.7 is long gone! we know on 3.23.38 > Regards, > Ravi > > > > Do You Yahoo!? > Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk > or your free @yahoo.ie address at http://mail.yahoo.ie > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
my sql database and locking issues(URGENT)
Hi, 1. Does mysql inherently implement locking implicitly? 2. The following is the extract from mysql documentation: " In MySQL Version 3.23.7 and above, you can insert rows into MyISAM tables at the same time other threads are reading from the table. Note that currently this only works if there are no holes after deleted rows in the table at the time the insert is made. " ACTUALLY,VERSION 3.23.7 IS NOT RELEASED.ARE THESE THE EXPECTED FEATURES IN THE COMING VERSION? Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Urgent: fatal error on mysql_connect()
Hi! Thanks! Mine is the redhat distribution v7 I solved it by removing and installing php and mysql downloaded from the rh updates. Now it works. Thanks again. :) Regards Annie "I should always thank Him." -- Unknown >This error message indicates that the version of PHP that you are using does >not have MySQL support built into it. > >See http://www.php.net/manual/en/ref.mysql.php >and http://www.php.net/manual/en/installation.php > >--zak > >- Original Message - >From: <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, May 16, 2001 2:34 PM >Subject: Urgent: fatal error on mysql_connect() > > > > Hi all! > > I need to know how to solve this. > > I keep on having this error whenever my scripts using mysql_connect()... > > > > Fatal error: Call to undefined function: mysql_connect() in > > /www/html/phpMyAdmin/lib.inc.php on line 255 > > > > TIA!!! > > > > Regards > > Annie > > > > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Urgent: fatal error on mysql_connect()
This error message indicates that the version of PHP that you are using does not have MySQL support built into it. See http://www.php.net/manual/en/ref.mysql.php and http://www.php.net/manual/en/installation.php --zak - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 16, 2001 2:34 PM Subject: Urgent: fatal error on mysql_connect() > Hi all! > I need to know how to solve this. > I keep on having this error whenever my scripts using mysql_connect()... > > Fatal error: Call to undefined function: mysql_connect() in > /www/html/phpMyAdmin/lib.inc.php on line 255 > > TIA!!! > > Regards > Annie > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgent: fatal error on mysql_connect()
Hi all! I need to know how to solve this. I keep on having this error whenever my scripts using mysql_connect()... Fatal error: Call to undefined function: mysql_connect() in /www/html/phpMyAdmin/lib.inc.php on line 255 TIA!!! Regards Annie
URGENT : BROKEN PIPE problem
Hi, I am getting the following exception regularly. After getting this I have to restart the DB. Please let me know, is there any remedy for this. Please help me out. Thanks and Regards, Saravanakumar.M >12:21:23 PM java.io.IOException: Broken pipe >12:21:23 PM at java.net.SocketOutputStream.socketWrite(Native Method) >12:21:23 PM at java.net.SocketOutputStream.socketWrite(Compiled Code) >12:21:23 PM at java.net.SocketOutputStream.write(Compiled Code) >12:21:23 PM at java.io.BufferedOutputStream.flushBuffer(Compiled Code) >12:21:23 PM at java.io.BufferedOutputStream.flush(Compiled Code) >12:21:23 PM at java.io.DataOutputStream.flush(Compiled Code) > at org.gjt.mm.mysql.MysqlIO.send(Compiled Code) >12:21:23 PM at org.gjt.mm.mysql.MysqlIO.sendCommand(Compiled Code) >12:21:23 PM at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Compiled Code) >12:21:23 PM at org.gjt.mm.mysql.Connection.execSQL(Compiled Code) >12:21:23 PM at org.gjt.mm.mysql.PreparedStatement.executeUpdate(Compiled Cod >e) Get free email and a permanent address at http://www.netaddress.com/?N=1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(URGENT) Help mysql+redhat automatically reboot.
Hi all, My RedHat 6.1 + MySQL server box has some rare thing happens today. This box is sitting on the 192.168 network. It allows a cgi program to select and update its records. The cgi program was triggered by the Internet. This box was received a lot of query this afternoon. Suddenly, it(redhat) reboot itself (I did not send any halt command to it). After it restarted mysqld was not start as usual (runlevel 3, mysqld startup by default). I have to manually start mysqld by typing in ./S99mysql start. After that, everything works like normal. I have checked the server box and its log. It does not look like it was hacked. I checked the power supply and everything work fine, the UPS is protecting this server and also we have no black out here. I have spent the whole afternoon to read the server logs and hope to fine something. However, all the logs show just like a normal reboot at that time. Do you have the same experience before? If yes, please share your experience with me. Thank you. Kind Regards, Fear - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Urgent Help Needed
Hi,
Tried that and also got an error, I just hope someone has had to do this type
of search!! Would have thought so!
Just need to search a MATCH and others at the same time. Thanks all.
Barry
In a message dated 14/5/01 10:54:16 am, [EMAIL PROTECTED] writes:
<< > The one we tried was:
>
> $SQL = " SELECT * FROM cvtemplate WHERE employment_type =
> '$employment_type'
> AND location = '$location' AND related_discipline =
> '$related_discipline',
> MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree,
> wxcdfour AGAINST
> ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY
> score DESC";
>
> From this we get the following error:
>
> You have an error in your SQL syntax near ' MATCH specific_work_profile,
> wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('CE' at line 1
Have you tried:
SELECT * FROM cvtemplate, MATCH (specific_work_profile, wxcdone, wxcdtwo,
wxcdthree, wxcdfour) AGAINST ('$keywords') AS score FROM cvtemplate WHERE
employment_type = '$employment_type' AND location = '$location' AND
related_discipline = '$related_discipline' HAVING score != 0 ORDER BY score
DESC
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--- Headers
Return-Path: <[EMAIL PROTECTED]>
Received: from rly-yc04.mx.aol.com (rly-yc04.mail.aol.com [172.18.149.36])
by air-yc05.mail.aol.com (v77_r1.36) with ESMTP; Mon, 14 May 2001 05:54:16
2000
Received: from web.mysql.com (web.mysql.com [192.58.197.162]) by
rly-yc04.mx.aol.com (v77_r1.36) with ESMTP; Mon, 14 May 2001 05:54:11 -0400
Received: (qmail 8607 invoked by uid 7797); 14 May 2001 09:49:46 -
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
List-ID:
Precedence: bulk
List-Help: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[EMAIL PROTECTED]>
List-Subscribe: <mailto:[EMAIL PROTECTED]>
Delivered-To: mailing list [EMAIL PROTECTED]
Received: (qmail 8567 invoked from network); 14 May 2001 09:49:45 -
From: "Chris Bolt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: Urgent Help Needed
Date: Mon, 14 May 2001 03:52:32 -0600
Message-ID: <[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
In-Reply-To: <[EMAIL PROTECTED]>
Importance: Normal
>>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Urgent Help Needed
Hi I escape all the characters as the values are passed to the page.
It is driving me mad, just to get this to work! Not many people I know have
the solution. I would have thought searching FULLTEXT and other fields at
the same time would be easy. Any help again appreciated.
Barry
In a message dated 14/5/01 11:02:42 am, [EMAIL PROTECTED] writes:
<< Hi,
Does $keywords contain a quote ?
You must escape special characters in strings before using them in SQL
statements. If you are using Perl DBI look use 'quote' function otherwise,
check MySQL API for your programming language.
Hope this helps
--
Joseph Bueno
NetClub/Trader.com
[EMAIL PROTECTED] wrote:
>
> Hi Group,
>
> I posted this question before, and need help urgently. The problem is using
a
> specific search! What we are trying to do is intially search 3 fields and
> then once the results are found it needs to be able to narrow down the
> results by searching the intial 3 criteria and also a keywords search on a
> full text index. I have tried but got no success as I keep getting SYNTAX
> error. Can anyone please help, this is most urgent.
>
> The one we tried was:
>
> $SQL = " SELECT * FROM cvtemplate WHERE employment_type = '$employment_type'
> AND location = '$location' AND related_discipline = '$related_discipline',
> MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST
> ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY score DESC";
>
> >From this we get the following error:
>
> You have an error in your SQL syntax near ' MATCH specific_work_profile,
> wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('CE' at line 1
>
> Is there a specific way we need to do this query! Basically we are trying to
> do a MATCH and additional query on the same. Your help is truly appreciated.
>
> Thanks
>
> Barry Zimmerman
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--- Headers
Return-Path: <[EMAIL PROTECTED]>
Received: from rly-zd02.mx.aol.com (rly-zd02.mail.aol.com [172.31.33.226])
by air-zd01.mail.aol.com (v77_r1.36) with ESMTP; Mon, 14 May 2001 06:02:42
2000
Received: from smtp-gw.netclub.com (home.paris.trader.com [195.68.19.162])
by rly-zd02.mx.aol.com (v78.43) with ESMTP; Mon, 14 May 2001 06:02:30 -0400
Received: from [127.0.0.1] (helo=trader.com)
by smtp-gw.netclub.com with esmtp (Exim 3.13 #1)
id 14zFBm-Mi-00; Mon, 14 May 2001 12:02:54 +0200
Sender: jbueno
Message-ID: <[EMAIL PROTECTED]>
Date: Mon, 14 May 2001 12:02:54 +0200
From: Joseph Bueno <[EMAIL PROTECTED]>
X-Mailer: Mozilla 4.73 [en] (X11; I; Linux 2.2.15-4mdkfb i686)
X-Accept-Language: en
MIME-Version: 1.0
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Urgent Help Needed
References: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
>>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Urgent Help Needed
Hi,
Does $keywords contain a quote ?
You must escape special characters in strings before using them in SQL
statements. If you are using Perl DBI look use 'quote' function otherwise,
check MySQL API for your programming language.
Hope this helps
--
Joseph Bueno
NetClub/Trader.com
[EMAIL PROTECTED] wrote:
>
> Hi Group,
>
> I posted this question before, and need help urgently. The problem is using a
> specific search! What we are trying to do is intially search 3 fields and
> then once the results are found it needs to be able to narrow down the
> results by searching the intial 3 criteria and also a keywords search on a
> full text index. I have tried but got no success as I keep getting SYNTAX
> error. Can anyone please help, this is most urgent.
>
> The one we tried was:
>
> $SQL = " SELECT * FROM cvtemplate WHERE employment_type = '$employment_type'
> AND location = '$location' AND related_discipline = '$related_discipline',
> MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST
> ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY score DESC";
>
> >From this we get the following error:
>
> You have an error in your SQL syntax near ' MATCH specific_work_profile,
> wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('CE' at line 1
>
> Is there a specific way we need to do this query! Basically we are trying to
> do a MATCH and additional query on the same. Your help is truly appreciated.
>
> Thanks
>
> Barry Zimmerman
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Urgent Help Needed
> The one we tried was:
>
> $SQL = " SELECT * FROM cvtemplate WHERE employment_type =
> '$employment_type'
> AND location = '$location' AND related_discipline =
> '$related_discipline',
> MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree,
> wxcdfour AGAINST
> ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY
> score DESC";
>
> From this we get the following error:
>
> You have an error in your SQL syntax near ' MATCH specific_work_profile,
> wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('CE' at line 1
Have you tried:
SELECT * FROM cvtemplate, MATCH (specific_work_profile, wxcdone, wxcdtwo,
wxcdthree, wxcdfour) AGAINST ('$keywords') AS score FROM cvtemplate WHERE
employment_type = '$employment_type' AND location = '$location' AND
related_discipline = '$related_discipline' HAVING score != 0 ORDER BY score
DESC
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgent Help Needed
Hi Group,
I posted this question before, and need help urgently. The problem is using a
specific search! What we are trying to do is intially search 3 fields and
then once the results are found it needs to be able to narrow down the
results by searching the intial 3 criteria and also a keywords search on a
full text index. I have tried but got no success as I keep getting SYNTAX
error. Can anyone please help, this is most urgent.
The one we tried was:
$SQL = " SELECT * FROM cvtemplate WHERE employment_type = '$employment_type'
AND location = '$location' AND related_discipline = '$related_discipline',
MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST
('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY score DESC";
>From this we get the following error:
You have an error in your SQL syntax near ' MATCH specific_work_profile,
wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('CE' at line 1
Is there a specific way we need to do this query! Basically we are trying to
do a MATCH and additional query on the same. Your help is truly appreciated.
Thanks
Barry Zimmerman
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: urgent!!
I don't see how this could possibly be an "urgent" request. You haven't even started the project design yet. Now, if the project were all done, and you're scheduled to go live with it tomorrow, and you suddenly discover that all your indexes are corrupt, and the boss is cursing your name -- well _that's_ urgent. :> Saying "I want to build a database someday" is not urgent. Please don't cry "wolf." Anyway, start with the MySQL manual, and any of a great number of basic books on data design and SQL. >Can anybody please help me with the making of this database or atleast >guide me with the making of this..please. >Thank You good luck, /Rob ~ Robert Alexander ~~ Software Designer/Analyst/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca "I give you this one rule of conduct. Do what you will, but speak out always. Be shunned, be hated, be ridiculed, be scared, be in doubt, but don't be gagged." -- John Jay Chapman, commencement address to the Graduating Class, Hobart College, 1900 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: urgent!!
> >Can anybody please help me with the making of this database or atleast >guide me with the making of this..please. >Thank You I suggest you start reading on database normalization (www.devshed.com has an article on this in the mysql part of their website). Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
urgent!!
Dear Friends, I am a newbie at MYSQL.I am up with a problem that involves creating a database which has to work in a client server environment.My friends suggested me to use mysql and thence was my entry to it.With very little time left for the deadline,I need your kind help to finish the project on time. Here goes my problem. Many clients send data to a server that maintains the database.Data is sent at regular frequency with each client being polled once in each cycle.The time and date at which this data is sent should also be part of the database.The data from each client(max 5 clients) comprises of following tags client code equipment code(each client can have many equipments and everytime the value for all the equipments have to be sent) value of the equipment parameter(each equipment can have at max 3 parameters ) time date This info from client is sent as a file to the server which maintains the database.The query can be based on time and date or on the client overall data history or on an equipments overall data history. My client server program is in C. Can anybody please help me with the making of this database or atleast guide me with the making of this..please. Thank You - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: My Sql C_API(Urgent)
Hi , Infact I tried it out that way.There is a problem with my_sql_real_escape_string() .I.e at the time of linking it is giving an Unresolved External Symbol for this function.For rest of the API functions it's OK. I checked up with the .def file in the includes directory and found that this functionis not listed in that.Tried it out with another download of MYSQL but same is the case. Regards, Ravi --- Shambhu Kumar singh <[EMAIL PROTECTED]> wrote: > Hi, > > Instead of working with the strmov function use > pointers to work on it, like I had to > Ex: > > char myQuery[1024]=""; > > CurrentAddress = myQuery; > CurrentAddress+= mysql_real_escape_string( > &MysqlStruct,CurrentAddress, string, strlen(string) > ); > > Best of Luck, > S.K. Singh. > > - Original Message -- > =?iso-8859-1?q?VVM=20Ravikumar=20Sarma=20Chengalvala?= > <[EMAIL PROTECTED]> wrote: > To:[EMAIL PROTECTED] > From:=?iso-8859-1?q?VVM=20Ravikumar=20Sarma=20Chengalvala?= > <[EMAIL PROTECTED]> > Date:Fri, 11 May 2001 16:35:21 +0100 (BST) > Subject: My Sql C_API(Urgent) > > Hi, > I am using my_sql_real_escape_string and in that the > strmov function of mysqlclient library. > I am getting the following errors while compiling: > > d:\program files\mysql\include\m_string.h(143) : > error > C2061: syntax error : identifier 'uint' > d:\program files\mysql\include\m_string.h(146) : > error > C2061: syntax error : identifier 'uint' > d:\program files\mysql\include\m_string.h(147) : > error > C2061: syntax error : identifier 'uint' > d:\program files\mysql\include\m_string.h(149) : > error > C2061: syntax error : identifier 'uint' > d:\program files\mysql\include\m_string.h(151) : > error > C2061: syntax error : identifier 'pchar' > d:\program files\mysql\include\m_string.h(154) : > error > C2061: syntax error : identifier 'my_string' > d:\program files\mysql\include\m_string.h(155) : > error > C2146: syntax error : missing ';' before identifier > 'strinstr' > d:\program files\mysql\include\m_string.h(155) : > fatal > error C1004: unexpected end of file found > Error executing cl.exe. > I could not locate the identifiesrs strinstr etc in > any of the include files. > > Can some one guide me for a way out. > > Regards, > Ravi > > > > Do You Yahoo!? > Get your free @yahoo.co.uk address at > http://mail.yahoo.co.uk > or your free @yahoo.ie address at > http://mail.yahoo.ie > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > _ > Chat with your friends as soon as they come online. > Get Rediff Bol at > http://bol.rediff.com > > > > Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: My Sql C_API(Urgent)
Hi, Instead of working with the strmov function use pointers to work on it, like I had to Ex: char myQuery[1024]=""; CurrentAddress = myQuery; CurrentAddress+= mysql_real_escape_string( &MysqlStruct,CurrentAddress, string, strlen(string) ); Best of Luck, S.K. Singh. - Original Message -- =?iso-8859-1?q?VVM=20Ravikumar=20Sarma=20Chengalvala?= <[EMAIL PROTECTED]> wrote: To:[EMAIL PROTECTED] From:=?iso-8859-1?q?VVM=20Ravikumar=20Sarma=20Chengalvala?= <[EMAIL PROTECTED]> Date:Fri, 11 May 2001 16:35:21 +0100 (BST) Subject: My Sql C_API(Urgent) Hi, I am using my_sql_real_escape_string and in that the strmov function of mysqlclient library. I am getting the following errors while compiling: d:\program files\mysql\include\m_string.h(143) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(146) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(147) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(149) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(151) : error C2061: syntax error : identifier 'pchar' d:\program files\mysql\include\m_string.h(154) : error C2061: syntax error : identifier 'my_string' d:\program files\mysql\include\m_string.h(155) : error C2146: syntax error : missing ';' before identifier 'strinstr' d:\program files\mysql\include\m_string.h(155) : fatal error C1004: unexpected end of file found Error executing cl.exe. I could not locate the identifiesrs strinstr etc in any of the include files. Can some one guide me for a way out. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
My Sql C_API(Urgent)
Hi, I am using my_sql_real_escape_string and in that the strmov function of mysqlclient library. I am getting the following errors while compiling: d:\program files\mysql\include\m_string.h(143) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(146) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(147) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(149) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(151) : error C2061: syntax error : identifier 'pchar' d:\program files\mysql\include\m_string.h(154) : error C2061: syntax error : identifier 'my_string' d:\program files\mysql\include\m_string.h(155) : error C2146: syntax error : missing ';' before identifier 'strinstr' d:\program files\mysql\include\m_string.h(155) : fatal error C1004: unexpected end of file found Error executing cl.exe. I could not locate the identifiesrs strinstr etc in any of the include files. Can some one guide me for a way out. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: My SQL C_API(urgent)
Try mysql_real_query(). This function takes three parameters, the first two are the same as mysql_query(). The third is the length of the query string. Regards. Alec At 06:51 PM 5/7/01, VVM Ravikumar Sarma Chengalvala wrote: >Hi, >I am having a peculiar problem with C_API.How to >execute a query string with its length more than 255 >characters using mysql_query() function.My sql query >is >more than 255 characters long and is getting >truncated. > >Regards, >Ravi > > >Do You Yahoo!? >Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk >or your free @yahoo.ie address at http://mail.yahoo.ie > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: My SQL C_API(urgent)
On Tue, May 08, 2001 at 12:51:02AM +0100, VVM Ravikumar Sarma Chengalvala wrote: > Hi, > I am having a peculiar problem with C_API.How to > execute a query string with its length more than 255 > characters using mysql_query() function.My sql query > is > more than 255 characters long and is getting > truncated. > > Regards, > Ravi mysql_query() doesn't have any length limitation like that. How big is the buffer in which you're storing your query? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
My SQL C_API(urgent)
Hi, I am having a peculiar problem with C_API.How to execute a query string with its length more than 255 characters using mysql_query() function.My sql query is more than 255 characters long and is getting truncated. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: In need of urgent Advise, please
I don't think I can answer all your questions as I use Linux. Are you sure it was the DB that went down or their whole system crashed? I can believe the latter more than the first. Ever since I switched from Windows to a unix based system, I have had far less troubles with the server crashing. In fact, I've only had my Linux down a couple of times... and that was for maintenance only, unlike the Windows server where it used to crash once every couple of weeks for no apparent reason. Maybe that crash will convince your customers to switch to a unix based machine. With only 3 - 5 clients, I can't imagine it seeing very heavy use. How many queries per second? 128Mb works fine on my unix server, but in the past, I've found Windows to be more resource hungry, so, if I were you, add more memory even as much as 500Mb. But again this all depends on what you are running and the amount traffic you're getting. - Original Message - From: "Lee Jenkins" <[EMAIL PROTECTED]> To: "MySQL Mail list" <[EMAIL PROTECTED]> Sent: Friday, April 20, 2001 10:24 Subject: In need of urgent Advise, please > > > Hello, > > First, sorry the lengthy post. I have a couple of questions that are very > important for me to get answered. I we moved from using MS Access to MySQL > for our Point of Sale app. We do the transaction rollbacks, commits in the > application layer so the fact that MySQL lacks this functionality is no > problem especially when compared to the speed that we get from the DB. > > We would very much like to run MySQL on a Linux box, but when our customers > (many lack even basic Windows skills) hear the word Linux, they run for > cover. They obviosly don't know how stable it is, only that Windows gives > them a nice fuzzy warm feeling. So, we are deploying the Windows Version > of MySQL running on Win2K Prof or Server depending on how many POS stations > will be hitting the DB. We're using MyODBC to talk to the server with ADO > from VB60 apps running on Win98 Clients. > > Last night, I had a customer whose DB went down and got very corrupted. > It's only got 128 MB RAM on it and in addition to running the MySQL NT > service, it's spooling a lot of print jobs to remote receipt printers for > the kitchen/bar, etc and running the Credit Card Payment software too. I > warned them that I thought 128 MB RAM was not enough and that is my guess > as to why it went down (plus the server had not been rebooted in about a > week). > > At any rate, I have 2 very important questions that I really need to get > answered and am grateful for any responses. > > # 1: > Considering that we have an average of 3-5 clients hitting the database > with SELECTS, INSERTS and UPDATES sometimes pretty heavily, would 256 MB > RAM suffice on a LAN? > > # 2: > What, if any, parameters should I setup in the MySQL server for maximum > efficiency? > > # 3: > If we start the MySQL server with update logging, I see the files that it > creates each time it is started. In the case of a crash, how would I go > about restoring the database from the logs on Win2K? I've looked in the > manual, but don't quite understand the syntax to do this or even if it's > the same for Windows. Could someone please give me the Romper Room level > lowdown on doing that? > > Again, I don't look forward to having another all-nighter like last night > so I would be very, very grateful for help on these things. I like MySQL > and the support found here in the list and very much want to keep using it. > > Again, thank you in advance. > > Lee > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
In need of urgent Advise, please
Hello, First, sorry the lengthy post. I have a couple of questions that are very important for me to get answered. I we moved from using MS Access to MySQL for our Point of Sale app. We do the transaction rollbacks, commits in the application layer so the fact that MySQL lacks this functionality is no problem especially when compared to the speed that we get from the DB. We would very much like to run MySQL on a Linux box, but when our customers (many lack even basic Windows skills) hear the word Linux, they run for cover. They obviosly don't know how stable it is, only that Windows gives them a nice fuzzy warm feeling. So, we are deploying the Windows Version of MySQL running on Win2K Prof or Server depending on how many POS stations will be hitting the DB. We're using MyODBC to talk to the server with ADO from VB60 apps running on Win98 Clients. Last night, I had a customer whose DB went down and got very corrupted. It's only got 128 MB RAM on it and in addition to running the MySQL NT service, it's spooling a lot of print jobs to remote receipt printers for the kitchen/bar, etc and running the Credit Card Payment software too. I warned them that I thought 128 MB RAM was not enough and that is my guess as to why it went down (plus the server had not been rebooted in about a week). At any rate, I have 2 very important questions that I really need to get answered and am grateful for any responses. # 1: Considering that we have an average of 3-5 clients hitting the database with SELECTS, INSERTS and UPDATES sometimes pretty heavily, would 256 MB RAM suffice on a LAN? # 2: What, if any, parameters should I setup in the MySQL server for maximum efficiency? # 3: If we start the MySQL server with update logging, I see the files that it creates each time it is started. In the case of a crash, how would I go about restoring the database from the logs on Win2K? I've looked in the manual, but don't quite understand the syntax to do this or even if it's the same for Windows. Could someone please give me the Romper Room level lowdown on doing that? Again, I don't look forward to having another all-nighter like last night so I would be very, very grateful for help on these things. I like MySQL and the support found here in the list and very much want to keep using it. Again, thank you in advance. Lee
URGENT: select in (select) or Join?
Hello, Please, I use MySql, I would use INTERSECT/UNION functions and they don't work, I need help, My query is : select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From Entreprise E, Mot_Entreprise ME, Mot M, Categorie C where (E.ID=ME.ID) and (ME.CodeMot=M.CodeMot) and (M.Mot like 'word1%') and C.CategoryCode=E.SubCategoryCode order by ME.Emplacement INTERSECT select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From Entreprise E, Mot_Entreprise ME, Mot M, Categorie C where (E.ID=ME.ID) and (ME.CodeMot=M.CodeMot) and (M.Mot like 'word2%') and C.CategoryCode=E.SubCategoryCode order by ME.Emplacement Can you Help me, IS there another way to do the join or intersection function All my Thanks for you. ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: URGENT - daemon dying frequently
I know this is slightly off-topic but it's related to changing the number of file descriptors on FreeBSD: - FreeBSD by Torsten Sturm How do I check my maximum filedescriptors? Do sysctl -a and look for the value of kern.maxfilesperproc. How do I increase them? sysctl -w kern.maxfiles= sysctl -w kern.maxfilesperproc= Warning: You probably want maxfiles > maxfilesperproc if you're going to be pushing the limit. What is the upper limit? I don't think there is a formal upper limit inside the kernel. All the data structures are dynamically allocated. In practice there might be unintended metaphenomena (kernel spending too much time searching tables, for example). -- -- The site is here: http://merlin.bmk.hu/Squid/FAQ-11.html > Running mysql 3.22.32-log on Apache virtual server (FreeBSD) > > I can restart my mysql daemon with ./bin/safe_mysqld - but it > only runs for a few hours before dying. Following hints from > both the manual and the list, I've tried several things... > > I've deleted my mysql database and manually re-installed all > the tables (instead of using the mysql_install_db script which > wanted me to do a make compile) > > I've looked at the error log, and see nothing that shows why > it is dying ( though when it starts it does have two messages - > could they be related?) > > Warning: setrlimit couldn't increase number of open files to > more than 164 > Warning: Changed limits: max_connections: 30 table_cache: 62 > > I've had the logging on but see no queries that should be the > problem. > > Nothing in the cron file > > Any suggestions? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: URGENT - daemon dying frequently
Looks like you're running out of the file descriptor to handle the connection etc. I'm not really a FreeBSD person but here's what I've found on this site: http://ircache.nlanr.net/Polygraph/Tips/FreeBSD-3.3/ Try increasing max file descriptors in /sys/conf/param.c #define MAXFILES (16384) This *could* the problem try it and see how you go with it. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 10, 2001 9:55 AM > To: [EMAIL PROTECTED] > Subject: URGENT - daemon dying frequently > > > Running mysql 3.22.32-log on Apache virtual server (FreeBSD) > > I can restart my mysql daemon with ./bin/safe_mysqld - but it > only runs for a few hours before dying. Following hints from > both the manual and the list, I've tried several things... > > I've deleted my mysql database and manually re-installed all > the tables (instead of using the mysql_install_db script which > wanted me to do a make compile) > > I've looked at the error log, and see nothing that shows why > it is dying ( though when it starts it does have two messages - > could they be related?) > > Warning: setrlimit couldn't increase number of open files to > more than 164 > Warning: Changed limits: max_connections: 30 table_cache: 62 > > I've had the logging on but see no queries that should be the > problem. > > Nothing in the cron file > > Any suggestions? > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
URGENT - daemon dying frequently
Running mysql 3.22.32-log on Apache virtual server (FreeBSD) I can restart my mysql daemon with ./bin/safe_mysqld - but it only runs for a few hours before dying. Following hints from both the manual and the list, I've tried several things... I've deleted my mysql database and manually re-installed all the tables (instead of using the mysql_install_db script which wanted me to do a make compile) I've looked at the error log, and see nothing that shows why it is dying ( though when it starts it does have two messages - could they be related?) Warning: setrlimit couldn't increase number of open files to more than 164 Warning: Changed limits: max_connections: 30 table_cache: 62 I've had the logging on but see no queries that should be the problem. Nothing in the cron file Any suggestions? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgent enquiry
Dear sir, I have downloaded mm.mysql driver. it is working with Sun Java. But i don't know where i have to place in Tomcat server as per your documentation it jhas to be put in WEB-INF/lib as a jar file i tried this also but it is not taking the driver still it is showing the exception. can you please tell me a way or suggestion to access the driver. It is most urgent for me. I will be very thankfull for you if you could send the suggestion ASAP. Thanking you advance. Regards, Venkat === R.Venkatesh Toppan Management Systems(I) Pvt Ltd,. # 57,Pantheon Road,Egmore, Chennai - 600 008. India. Phone : +91-44-841 8646 E-mail :[EMAIL PROTECTED]
URGENT Help! Multiple table Fulltext Search
Hi, I have 5 tables in mysql, each of same structure. When some search word is given, I am creating 5 threads to search in 5 tables. Now i need to order the search results in the most suitable order. For example, for a search word, the results from table 3 will be more suitable, where as for another word results from table 2 could be better once. In the first case I need to show the table 3 results first, that is the result returned by thread 3 and for the second case, I should show the results from table 2 that is the thread 2. How can i find this. Kindly help. Regards, Get fast and easy Internet access through http://www.netkracker.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: URGENT: Replication problem
It's my mistake, for setting the same server-id on both servers. Lois -Original Message- From: Neo Sok Lay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 20 March, 2001 7:41 PM To: [EMAIL PROTECTED] Subject: URGENT: Replication problem Hi, I am currently exploring the replication feature in 3.23.33 and encountered this error the moment I start the slave server: 010320 18:38:13 Slave: connected to master '[EMAIL PROTECTED]:9900', replication started in log 'FIRST' at posit ion 4 010320 18:38:13 Slave: received 0 length packet from server, apparent master shutdown: (0) 010320 18:38:13 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 34 010320 18:38:14 Slave: reconnected to master '[EMAIL PROTECTED]:9900',replication resumed in log 'FIRST' at posit ion 34 010320 18:38:14 Slave: received 0 length packet from server, apparent master shutdown: (0) What could be the possible reason for the error? My Master server is started with: safe_mysqld --socket=/tmp/repldb.sock --port=9900 --datadir=/home/replic/db/ mysql/data --log-bin --server-id=1 My Slave server is started with: safe_mysqld --socket=/tmp/gmdb.sock --port=9900 --datadir=/home/replic/db/my sql/data --master-host=10.1.1.0 --master-port=9900 --master-user=replicate - -master-password=replicslave --server-id=1 Thanks for any help given. Lois - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
URGENT: Replication problem
Hi, I am currently exploring the replication feature in 3.23.33 and encountered this error the moment I start the slave server: 010320 18:38:13 Slave: connected to master '[EMAIL PROTECTED]:9900', replication started in log 'FIRST' at posit ion 4 010320 18:38:13 Slave: received 0 length packet from server, apparent master shutdown: (0) 010320 18:38:13 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 34 010320 18:38:14 Slave: reconnected to master '[EMAIL PROTECTED]:9900',replication resumed in log 'FIRST' at posit ion 34 010320 18:38:14 Slave: received 0 length packet from server, apparent master shutdown: (0) What could be the possible reason for the error? My Master server is started with: safe_mysqld --socket=/tmp/repldb.sock --port=9900 --datadir=/home/replic/db/ mysql/data --log-bin --server-id=1 My Slave server is started with: safe_mysqld --socket=/tmp/gmdb.sock --port=9900 --datadir=/home/replic/db/my sql/data --master-host=10.1.1.0 --master-port=9900 --master-user=replicate - -master-password=replicslave --server-id=1 Thanks for any help given. Lois - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on NetApp Filer - Urgent Problem
Am 17:21 16.03.2001 schrieb Jeremy D. Zawodny: >*This message was transferred with a trial version of CommuniGate(tm) Pro* >On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote: > > Am 11:22 16.03.2001 schrieben Sie: > > >*This message was transferred with a trial version of CommuniGate(tm) Pro* > > >Hi there, > > > > > >i dont want to start a thread about MySQL over NFS, i did it and it runs > > >pretty good, > > >but now there is a problem i could not solve. > > > > > >the cpu on the filer goes up and up (15% per day) and i have no idea why. > > >At the moment it hit 70% in peak time (5 min average) > > >Seems to be the database cause everything else stays the same, but not > > >more traffic on the db > > >+ if i switch the db of the cpu goes down to 1-5%. > > > > > >any ideas about this? > > > > i forgot: > > nfs ops and network traffic for the filer stayed the same > >Then it would seem to be a problem with the netapp, wouldn't it? > >Jeremy >-- >Jeremy D. Zawodny, <[EMAIL PROTECTED]> >Technical Yahoo - Yahoo Finance >Desk: (408) 328-7878Fax: (408) 530-5454 >Cell: (408) 439-9951 > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Jeremy, Finally you where right. I refused to believe it but the filer itself was the problem. it was running out of inodes. damn, sorry for bothering you Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on NetApp Filer - Urgent Problem
Am 17:21 16.03.2001 schrieb Jeremy D. Zawodny: >*This message was transferred with a trial version of CommuniGate(tm) Pro* >On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote: > > Am 11:22 16.03.2001 schrieben Sie: > > >*This message was transferred with a trial version of CommuniGate(tm) Pro* > > >Hi there, > > > > > >i dont want to start a thread about MySQL over NFS, i did it and it runs > > >pretty good, > > >but now there is a problem i could not solve. > > > > > >the cpu on the filer goes up and up (15% per day) and i have no idea why. > > >At the moment it hit 70% in peak time (5 min average) > > >Seems to be the database cause everything else stays the same, but not > > >more traffic on the db > > >+ if i switch the db of the cpu goes down to 1-5%. > > > > > >any ideas about this? > > > > i forgot: > > nfs ops and network traffic for the filer stayed the same > >Then it would seem to be a problem with the netapp, wouldn't it? > >Jeremy >-- >Jeremy D. Zawodny, <[EMAIL PROTECTED]> >Technical Yahoo - Yahoo Finance >Desk: (408) 328-7878Fax: (408) 530-5454 >Cell: (408) 439-9951 Hi, but it runs fine without the db. regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on NetApp Filer - Urgent Problem
On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote: > Am 11:22 16.03.2001 schrieben Sie: > >*This message was transferred with a trial version of CommuniGate(tm) Pro* > >Hi there, > > > >i dont want to start a thread about MySQL over NFS, i did it and it runs > >pretty good, > >but now there is a problem i could not solve. > > > >the cpu on the filer goes up and up (15% per day) and i have no idea why. > >At the moment it hit 70% in peak time (5 min average) > >Seems to be the database cause everything else stays the same, but not > >more traffic on the db > >+ if i switch the db of the cpu goes down to 1-5%. > > > >any ideas about this? > > i forgot: > nfs ops and network traffic for the filer stayed the same Then it would seem to be a problem with the netapp, wouldn't it? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on NetApp Filer - Urgent Problem
Am 11:22 16.03.2001 schrieben Sie: >*This message was transferred with a trial version of CommuniGate(tm) Pro* >Hi there, > >i dont want to start a thread about MySQL over NFS, i did it and it runs >pretty good, >but now there is a problem i could not solve. > >the cpu on the filer goes up and up (15% per day) and i have no idea why. >At the moment it hit 70% in peak time (5 min average) >Seems to be the database cause everything else stays the same, but not >more traffic on the db >+ if i switch the db of the cpu goes down to 1-5%. > >any ideas about this? > >MySQL server: FreeBSD 4-Stable > >regards > >Sven Huster >Senior Unix System Administrator >*BSD, Linux, Solaris > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php i forgot: nfs ops and network traffic for the filer stayed the same Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL on NetApp Filer - Urgent Problem
Hi there, i dont want to start a thread about MySQL over NFS, i did it and it runs pretty good, but now there is a problem i could not solve. the cpu on the filer goes up and up (15% per day) and i have no idea why. At the moment it hit 70% in peak time (5 min average) Seems to be the database cause everything else stays the same, but not more traffic on the db + if i switch the db of the cpu goes down to 1-5%. any ideas about this? MySQL server: FreeBSD 4-Stable regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
urgent reply expected!
Dear Ruby,
Thank you very much for your earlier response! We have downloaded the
mm.mysql.jdbc driver as you have specified and placed it in the lib
directory of Tomcat server!
We tried placing the same in jdk and mysql lib directories too! Still we are
not able to connect it!
We are not clear as to where or in which lib directory we have to place
these jar files!
We are getting the following exception when we run our jsp file!
The driver registration code we have used is as follows:
Class.forName("org.gjt.mm.mysql.Driver");
Connection conn =
DriverManager.getConnection("jdbc:mysql://www.homeomiracles.com:8080/homoeo"
);
Error: 500
Location: /examples/jsp/num/Submit.jsp
Internal Servlet Error:
javax.servlet.ServletException: Unable to load class org.gjt.mm.mysql.Driver
at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:459)
at
jsp.num._0002fjsp_0002fnum_0002fSubmit_0002ejspSubmit_jsp_16._jspService(_00
02fjsp_0002fnum_0002fSubmit_0002ejspSubmit_jsp_16.java:388)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:177)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
at org.apache.tomcat.core.Handler.service(Handler.java:286)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
7)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:210)
at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
at java.lang.Thread.run(Thread.java:484)
Re: help-urgent
Hello ramamurthy, rr> hi, rr> We are using mysql as back end in our server.We are getting an problem with Mysql .the problem is mysqld is going down wiht out any error messages.in the log file it has writted as mysql deamon rr> ended no other messages is thr.but we are getting problmem recently previously it was working nice.as the load increases i am getting this problem(one more thin i have all me tables in single rr> database 10 tables wiht recorde in 20,000 will this create problem) rr> I have set max connections as 150. rr> looking for your help in this regards.it will be helpful for me if you reply me ASAP Are you running MySQL over Linux, Windoze??? If it's Linux, you sould check system logs, free disk space, etc. (/var for example) If it's Windoze, God save you!!! ;-) As Gerald proposed, give more tech info about system. Good luck, -- Roberto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help-urgent
You have provided absolutely no useful information for anyone who may wish to help you. ramamurthy rajeshkumar wrote: > > hi, > > We are using mysql as back end in our server.We are getting an problem with Mysql >.the problem is mysqld is going down wiht out any error messages.in the log file it >has writted as mysql deamon ended no other messages is thr.but we are getting >problmem recently previously it was working nice.as the load increases i am getting >this problem(one more thin i have all me tables in single database 10 tables wiht >recorde in 20,000 will this create problem) > > I have set max connections as 150. > > looking for your help in this regards.it will be helpful for me if you reply me ASAP > > with regardds > Rajesh > > _ > http://cinesouth.com - The best for entertainment in South India > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help-urgent
hi, We are using mysql as back end in our server.We are getting an problem with Mysql .the problem is mysqld is going down wiht out any error messages.in the log file it has writted as mysql deamon ended no other messages is thr.but we are getting problmem recently previously it was working nice.as the load increases i am getting this problem(one more thin i have all me tables in single database 10 tables wiht recorde in 20,000 will this create problem) I have set max connections as 150. looking for your help in this regards.it will be helpful for me if you reply me ASAP with regardds Rajesh _ http://cinesouth.com - The best for entertainment in South India - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie Select Problem URGENT
Hi All I am trying to compare information in 2 different tables and return matches. The problem is that this query only returns the listings where I want it to return a row from AutoEmail when it finds a match. What am I doing wrong? SELECT * FROM AutoEmail, listings WHERE ((listings.prop_style LIKE '%AutoEmail.prop_style%') AND (listings.price <= AutoEmail.range) AND (listings.bedrooms <= AutoEmail.bedrooms) AND (listings.bathrooms <= AutoEmail.bathrooms) AND (listings.garage LIKE '%AutoEmail.garage%') AND (listings.fpropover LIKE '%AutoEmail.feature%') AND (listings.location LIKE '%AutoEmail.location%')) AND ((AutoEmail.residential = listings.residential) OR (AutoEmail.multi = listings.multi) AND (AutoEmail.farm = listings.farm) OR (AutoEmail.waterfront = listings.waterfront) OR (AutoEmail.commercial = listings.commercial) OR (AutoEmail.vacant = listings.vacant)) -- Cheers! Ken Tuck EyeCreate Inc. Net~Solutions Design - Hosting - E-Commerce [EMAIL PROTECTED] http://www.eyecreate.net/ ph: 705.755.1120 fx: 705.743.9259 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: doubt urgent
At 10:50 27/02/2001 +, gopinath rajagopal n wrote: Hi! First you need to set the privileges rights on the MySQL server for the NT machine, user and db's. Read the GRANT/REVOKE commands and How works the privileges system in the MySQL Manual. To connect you have several ways: - A telnet session from your NT machine to Unix machine. Run the mysql client on /mysql/bin directory. - If your Unix server has a ssh server and you have a ssh client like Putty for Win. Do the same procedure like telnet. - You download from our site the Win MySQL stuff. The Win stuff has a MySQL console client called mysql.exe that you can use with the connection parameters to connect with the Unix server. - You can install the ODBC driver MyODBC (you need to download if from our web site) and use any client application that support ODBC. Regards, Miguel >Hello Sir, > > I am having doubt in connecting mySQL client to server.i want > some explaination, before that i worked in Oracle.I am newly entering to mySQL. > > my mySQL server is in LINUX OS,my machine is WIN NT . now i want > to connect with the server and access the database. > > First how to install mysql client in my machine.from where will > i get the EXE? > How to configure my client to mysql server which is in LINUX server. > > Pls .. explain my doubt ASP. > >Thanks & Regards >gopi > > >Nucleus Software Exports Ltd >Shakthi Towers,6th floor >766,Anna Salai >Chennai-2 >Ph: 91-044-8510519,8510825 > > >_ >Chat with your friends as soon as they come online. Get Rediff Bol at >http://bol.rediff.com > > > > > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano <[EMAIL PROTECTED]> /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil <___/ Development Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
doubt urgent
Hello Sir, I am having doubt in connecting mySQL client to server.i want some explaination, before that i worked in Oracle.I am newly entering to mySQL. my mySQL server is in LINUX OS,my machine is WIN NT . now i want to connect with the server and access the database. First how to install mysql client in my machine.from where will i get the EXE? How to configure my client to mysql server which is in LINUX server. Pls .. explain my doubt ASP. Thanks & Regards gopi Nucleus Software Exports Ltd Shakthi Towers,6th floor 766,Anna Salai Chennai-2 Ph: 91-044-8510519,8510825 _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: please urgent
- Original Message - From: "webmaster" <[EMAIL PROTECTED]> To: "Joel Gwynn" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, February 27, 2001 6:13 Subject: please urgent > I have downloaded the leatest ver of php, php 4.04pl1, I am runing winnt > 4.0, acording to the info for this ver of php this ver has all the odbc > connetciones incluided, 1. Are you sure of this? I had to compile php4 with mysql support but that's on Linux 2. This is a mysql list. Your questions have nothing to do with mysql. Please go to www.php.net or find an Oracle support list, if one exists, and ask your question there. the ver 3.0 has a library called php3_oci80.dll > wich is used for conections to oracle 8, where can I find all the > librarys requiered for php4 data base conections? until now I have not > had any lucky getting database conections how do I stablish a dagta > base conetiion oracle 8i, php4. is tyhere any graphical tool for > developing forms ? what should I download to have all the files needed > for data base conectivity? cheers > > On Mon, 26 Feb 2001, Joel Gwynn wrote: > > > Date: Mon, 26 Feb 2001 15:04:19 -0500 > > From: Joel Gwynn <[EMAIL PROTECTED]> > > To: [EMAIL PROTECTED] > > Subject: Re: mysql.server ignoring my.cnf? > > > > I tried /etc/my.cnf and got the same results. As far as $DATADIR or $HOME > > are concerned, I don't see them when I do 'printenv'. Is there another way > > to find out if those may be set, and by what? > > > > thanks. > > > > At 02:33 PM 2/26/01 -0500, Kent Hoover wrote: > > >Sorry. Sent the last message before I was done > > > > > >If you have a stray $DATADIR/my.cnf or a $HOME/.my.cnf, their > > >contents will override what you have set in /etc/my.cnf. > > > > > >Cheers, > > > > > >Kent > > > > > > > > >- > > >Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > > >To unsubscribe, e-mail > > ><[EMAIL PROTECTED]> > > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - > > Joel Gwynn Designers' CADD Company, Inc. > > A bus station is where a bus stops. > > A train station is where a train stops. > > So now you know why they call this a workstation... > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
please urgent
I have downloaded the leatest ver of php, php 4.04pl1, I am runing winnt 4.0, acording to the info for this ver of php this ver has all the odbc connetciones incluided, the ver 3.0 has a library called php3_oci80.dll wich is used for conections to oracle 8, where can I find all the librarys requiered for php4 data base conections? until now I have not had any lucky getting database conections how do I stablish a dagta base conetiion oracle 8i, php4. is tyhere any graphical tool for developing forms ? what should I download to have all the files needed for data base conectivity? cheers On Mon, 26 Feb 2001, Joel Gwynn wrote: > Date: Mon, 26 Feb 2001 15:04:19 -0500 > From: Joel Gwynn <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Re: mysql.server ignoring my.cnf? > > I tried /etc/my.cnf and got the same results. As far as $DATADIR or $HOME > are concerned, I don't see them when I do 'printenv'. Is there another way > to find out if those may be set, and by what? > > thanks. > > At 02:33 PM 2/26/01 -0500, Kent Hoover wrote: > >Sorry. Sent the last message before I was done > > > >If you have a stray $DATADIR/my.cnf or a $HOME/.my.cnf, their > >contents will override what you have set in /etc/my.cnf. > > > >Cheers, > > > >Kent > > > > > >- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail > ><[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - > Joel GwynnDesigners' CADD Company, Inc. > A bus station is where a bus stops. > A train station is where a train stops. > So now you know why they call this a workstation... > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Regarding Downloads -very urgent
Sir, i Like to work on Mysql, in Windows 95 or Windows Nt, i saw ur site, it is nice, what should i download from the net , because lot of softwares are there and also i like to work in Php - server side on Pws or iis as web server . is there is any dll or api for this . are u providing etc download. Please mail this very urgent and the exact links to download Thanks for ur early reply __ Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: urgent
Thanks Vinay Talwar [EMAIL PROTECTED] [EMAIL PROTECTED] Mohamad Ilhami <[EMAIL PROTECTED]To: [EMAIL PROTECTED] itb.ac.id> cc: [EMAIL PROTECTED] Subject: Re: urgent 02/24/01 02:37 PM MySQL version is currently 3.23.33 and always available at www.mysql.com regards -ilham- On Fri, 23 Feb 2001 [EMAIL PROTECTED] wrote: > Hai, > Pls let me know at the earliest where I can download SQL 7 > Thanks in advance > > Vinay Talwar > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: urgent
MySQL version is currently 3.23.33 and always available at www.mysql.com regards -ilham- On Fri, 23 Feb 2001 [EMAIL PROTECTED] wrote: > Hai, > Pls let me know at the earliest where I can download SQL 7 > Thanks in advance > > Vinay Talwar > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
urgent
Hai, Pls let me know at the earliest where I can download SQL 7 Thanks in advance Vinay Talwar [EMAIL PROTECTED] [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I NEED YOUR URGENT HELP!
I have big problem, i have installed 3.22.23-1 for linux (cobalt server) mysql works, mysqladmin works but i have a meassage in IE: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/sites/site2/web/tepekoy.php on line 28 then checked mysqladmin and i get: UNIX SOCKET: /var/lib/mysql/mysql.sock then i wanted to change mysql.sock address as: ./configure --with-unix-socket-path=/var/lib/mysql/mysql.sock then i get NO such FILE or directory but in directory /var/lib/mysql/, PWD says it is there! WHAT I HAVE TO DO --- i checked below commands at least 10 times--- please i need urgent help!!! cem --- The Fastest Browser on Earth now for FREE!! Download Opera 5 for Windows now! Get it at http://www.opera.com/download/ --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgent Call for Participation
NuSphere has been asked to chair the MySQL track for the upcoming O'Reilly Open Source Conference (July 23-27 in San Diego, CA) and the deadline is virtually here -- decisions must be made by next Tuesday, Feb. 20. This is very short notice but we need your input by end of day tomorrow, Feb. 16. The original call for participation issued by O'Reilly closed on February 1 and some of you may well have submitted presentation and/or tutorial ideas through that avenue. If so, please resubmit those suggestions to me for review. If you hadn't yet submitted a proposal, we urge you to do so now. The information we need is the same as that outlined at O'Reilly's site at: http://conferences.oreilly.com/oscon2001/call.html but instead of sending the submission to them, you'll need to send it directly to me at [EMAIL PROTECTED] And remember, we're solicting specifically for MySQL-related talks and tutorials. Please note - travel and expenses are *not* being covered. Individual presenters are responsible for their own expenses. There is, however, a small stipend for the half-day tutorial. If you have any questions, please feel free to contact me at the number below, or via email. We recognize that this is a very tight timeframe but we're confident that there's plenty of great material out there in the MySQL developer community and that we can indeed present a great lineup. Thanks in advance for your prompt response. Judy -- ___ Judy Mintz Sr. Product Marketing Manager NuSphere Corporation Direct dial: 781-280-4768 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: CSETI Announcement - Urgent Disclosure Project Update
Please read and forward. -Original Message- From: James [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 21:39 To: Young, Stuart; Raf; Nicky Gosney; Nick; [EMAIL PROTECTED]; John Boddy; Iain; Green, Karen; Darren S; Andy; [EMAIL PROTECTED] Subject: FW: CSETI Announcement - Urgent Disclosure Project Update -Original Message- From: Tony Craddock [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 05:35 To: [EMAIL PROTECTED] Subject: CSETI Announcement - Urgent Disclosure Project Update Please Post and Distribute As Desired Since August of 2000, the CSETI Disclosure Project has recorded the testimony of over 100 military, government and related witnesses to UFO events and projects from around the world. The testimony of these courageous witnesses creates a permanent archive with the most profound implications as it constitutes dozens of first-hand, often top-secret witnesses to UFO events, internal UFO -related government projects and covert government activities related to UFOs, Extraterrestrial Intelligence and exotic energy and propulsion system projects. These 100 witnesses constitute the tip of a larger pool of over 400 prospective witnesses, many of whom would prefer coming forward first in formal Congressional hearings --which we hope will follow the upcoming planned disclosure event. This testimony is on broadcast quality digital videotape and audio tape. Printed transcriptions of the testimony are currently being created. We are requesting that any further military, government, government- contractor or related witnesses to UFO events and projects contact CSETI Director Dr. Steven Greer immediately for inclusion in the briefing materials and the upcoming disclosure event. Such witnesses may contact Dr. Greer via the CSETI website at www.cseti.org <http://www.cseti.org/> or at 540 456 8302 (government witnesses only should use this number, please). Additionally, any other substantial, supporting evidence, such as government documents, high quality UFO photographs and videotaped images, hard evidence etc. should similarly be referred to the project for inclusion in the final briefing materials and disclosure Press Conference. The date for the Disclosure Press Conference and related activities in Washington DC has been set and will occur in the Spring of this year (2001). Prior to the Disclosure Press Conference we will be conducting private briefings for key leaders in society, government and related institutions (for example, members of the US Congress, White House staff, scientific and religious leaders etc). If you have good access to such leaders and can assist with arranging a briefing please contact Dr. Greer as soon as possible. This body of testimony is being edited and the over 100 hours of testimony will be condensed into a 2 hour briefing video. Additionally, a written briefing document consisting of witness testimony transcripts, government documents and important case material and policy papers is being prepared for use in the briefings and in the Disclosure Press Conference in Washington. The Disclosure Press Conference will present many of the government witnesses in person, and the other evidence and briefing materials will be available to the media at that time. People with excellent national and international media contacts who can assist pro bono with media coordination are invited to contact Dr. Greer also. Unfortunately, a documentary containing this witness testimony will not be available as there are insufficient funds to complete such a project. We would like to thank all of the supporters and contributors to this historic effort and especially the witnesses who have come together to let the world know the truth about this very important matter. Anyone who would like to help support this effort is invited to make a tax-deductible contribution to : The Disclosure Project, PO Box 265, Crozet Va 22932. Further updates will be issued as the date for the event approaches. Again, we would like to thank our many supporters for their assistance in and dedication to disclosing the truth. The Disclosure Project CSETI 11 February 2001
Urgent-UDF problem
Hello Sinisa and everybody else,
sorry that I contact you directly! But I tried all suggestions and it
still doesn't work! The UDF return string has always 256 characters!
I've used my_malloc and my_free! Also I allocated the necessary memory
in xxx_init()! But it doesn't work! What can I do? Who is the mysql
developer who is specialized in UDF programming! It's very important! To
change the initid->max_length has no effect. If I set this value on 12
or so, I will furthermore get 256 characters, why? Is it a bug?
Thank you for your help and support!
Greetings Tom
Some code:
// init function
my_bool IHistogram_init(UDF_INIT *initid, UDF_ARGS *args, char
*message){
// Parameter: ID, filepointer, data
if (args->arg_count != 3)
{
strcpy(message,"Usage: ID, filepointer and data field.");
return 1;
}
initid->ptr = (char*) my_malloc (65535 * sizeof(char), MY_ZEROFILL);
// Set types
args->arg_type[0] = STRING_RESULT;
args->arg_type[1] = STRING_RESULT;
args->arg_type[2] = STRING_RESULT;
return 0;
}
void IHistogram_deinit(UDF_INIT *initid)
{
my_free(initid->ptr, MY_ZEROFILL);
}
char* IHistogram(UDF_INIT *initid, UDF_ARGS *args, char *result,
unsigned long length, char *is_null, char *error){
char* res;
// Calc histogram, result: histogram-string
res = checkIHist(args->args[0], args->args[1], args->args[2],
args->lengths[1], args->lengths[2]);
// Error occured
if (strcmp(res, "ERROR") == 0){
*error = 1;
return 0;
}
else{
initid->ptr = res;
return initid->ptr;
}
}
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help on mysql and cold fusion setup (urgent)
hi i have setup a mysql database foo_db and when i goto admininstrator of coldfusion to setup the odbc, the databsourse is foo_db and i select merant mysql drive, then click add. the verify is fail can anyone tell me what am i does wrong ? i using linux 6.2, coldfusion pro 4.5 thanks Wong - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication problems URGENT
Ok, we've been having these troubles: the slave is not connecting to the master. A simple SHOW PROCESSLIST shows a message with: trying to reconnect after a failed read Sometimes the slave just won't connect. Does anyone knows what could be wrong? -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Hello. On Sat, Feb 03, 2001 at 01:54:14AM +0200, [EMAIL PROTECTED] wrote: > Dear Benjamin. > I firstly very very thanks for your interest. > This is my 3'rd mail with same question and you 're the first one who > reply. Well, it might be due to the fact that you have a rather unusual use pattern. [...] > > > > Description: > > > > I am connecting from Visual Basic 6 to Mysql via > > > > ODBC DSN. When i made 94 sleeped connection after 94 can't connect to > a > > > > server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on > > > 192.9.200.2 > > > > (10055) > > > Is it fault of myodbc or mysql server? > > > > Is it normal. If there a maximum connection limit for process ? > > > > No. Your process is only limited by your OS. E.g. Linux defaults to a > > limit of 256 sockets per process. I don't know about Windows. > I know but i tried it on 1 GB RAM and dual processor PIII 700 MHZ on winnt 4 > with service pack 6 a. Well, your resources (e.g. memory) normally don't influence the default configuration automatically. That means, you should consult the usual Window NT resources (web pages, mailing lists?) how to change the process limit. [...] > > > > I think it is abnormal cause everyone is talking about > > > > 10.000 Web Hit. > > > > Sorry? You can handle 10.000 web hits with only one connection. > i am not interested about web. it works. no problem. Well, it was your example. ;-) [...] > Think a scenario : > You connect via ODBC or Data Environment from VB > then you get a recordset. > You will show this recordset on a grid. (excel style spreadsheet.) > if you use additem method , you can loop recordset and > manually add rows into grid then close recordset no problem. > > but if you bound grid into that dao object then until program or form close > it run as a sleep process. Well, that's the problem. It is usually (not only with MySQL) a good idea to block resources as short as possible. The suggested program doesn't do that. Even if the connection is idle, it blocks a connection. > and if you even use 3 connection for program , if max sleep process > is limited to 90 (due to your hardware configuration , but even if > you use 1 gb ram it is limited to max 120) that means maximum 30 > user will be execute your program. I assume that is only a parameter you have to change within NT. [...] > i have a critical product(which is written in vb for end users) > that needs at least 150 concurrent sleeped process to run. Well, but 150 concurrent connections may not be a problem even for NT *eg*. So, as said above, I suggest you check out the appropriate NT resources how to change the process limit (in hope that this is really the wall you hit, but it sounds so). Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))
- Original Message - From: Yusuf Incekara <[EMAIL PROTECTED]> To: Benjamin Pflugmann <[EMAIL PROTECTED]> Cc: Mysql Mailing list <[EMAIL PROTECTED]> Sent: Saturday, February 03, 2001 1:54 AM Subject: Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055)) > Dear Benjamin. > I firstly very very thanks for your interest. > This is my 3'rd mail with same question and you 're the first one who > reply. > > - Original Message - > From: Benjamin Pflugmann <[EMAIL PROTECTED]> > To: Yusuf Incekara <[EMAIL PROTECTED]> > Cc: Mysql Mailing list <[EMAIL PROTECTED]> > Sent: Friday, February 02, 2001 2:52 AM > Subject: Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server > on 192.9.200.2 (10055)) > > > > Hi. > > > > On Thu, Feb 01, 2001 at 08:18:45PM +0200, [EMAIL PROTECTED] wrote: > > > Would you please offer me something please ? > > > > > > > From: [EMAIL PROTECTED] > > > > To: [EMAIL PROTECTED] > > > > Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 > > > (10055)) > > > > > > > > > > > > Description: > > > > I am connecting from Visual Basic 6 to Mysql via > > > > ODBC DSN. When i made 94 sleeped connection after 94 can't connect to > a > > > > server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on > > > 192.9.200.2 > > > > (10055) > > > Is it fault of myodbc or mysql server? > > > > Is it normal. If there a maximum connection limit for process ? > > > > No. Your process is only limited by your OS. E.g. Linux defaults to a > > limit of 256 sockets per process. I don't know about Windows. > I know but i tried it on 1 GB RAM and dual processor PIII 700 MHZ on winnt 4 > with service pack 6 a. > There is a concurrent sleeped process limit. Same on linux too also. > > > > > > > I think it is abnormal cause everyone is talking about > > > > 10.000 Web Hit. > > > > Sorry? You can handle 10.000 web hits with only one connection. > i am not interested about web. it works. no problem. > if you just create a server object on asp. loop the recordset. then close. > no problem. cause you only open 1 process then close. and it take 1 secs. > example. > > Think a scenario : > You connect via ODBC or Data Environment from VB > then you get a recordset. > You will show this recordset on a grid. (excel style spreadsheet.) > if you use additem method , you can loop recordset and > manually add rows into grid then close recordset no problem. > > but if you bound grid into that dao object then until program or form close > it run as a sleep process. > > and if you even use 3 connection for program , > if max sleep process is limited to 90 (due to your hardware configuration , > but even if you use 1 gb ram > it is limited to max 120) that means maximum 30 user will be execute your > program. > > and it is not satify us. > > > > > > Is it cause from sleeped process list ? > > > > Quite probably. Why do you need so much sleeping processes? Maybe > > there is a misconception about the need of them? > mentioned above > > > > > I increased maximum connection to 200 but it not works. I think > > > > it is not related with maximum connection. It is related with > > > > maximum process number. > > > > Why do you get so much processes? Do you really get so much hits? If > > so, maybe someone else can help (I have no clue about tuning Windows > > systems). > yes i really need this. as i mentioned above every executed compiled > software > will be needed at least 3 connection till to unloaded. > > > > > > > How-To-Repeat: > > > > Run this code on Microsoft Visual Basic 6 ENT Edition. > > > > > > > > For i = 1 To 200 > > > > Set Temp_Bag(i) = New ADODB.Connection > > > > Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro" > > > > Next i > > > > It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE. > > > > Well, do you have a production situation that hits the wall? If not, I > > wouldn't care about it. One of my servers delivers about 5.000.000 > > queries (300.000 web hits) a day with only 10-20 concurrent > > connections. (Not, that there is no need for hundreds of connections > > in some applications, but most time you don't need so much). > > i have a critical product(
Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Dear Benjamin. I firstly very very thanks for your interest. This is my 3'rd mail with same question and you 're the first one who reply. - Original Message - From: Benjamin Pflugmann <[EMAIL PROTECTED]> To: Yusuf Incekara <[EMAIL PROTECTED]> Cc: Mysql Mailing list <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 2:52 AM Subject: Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055)) > Hi. > > On Thu, Feb 01, 2001 at 08:18:45PM +0200, [EMAIL PROTECTED] wrote: > > Would you please offer me something please ? > > > > > From: [EMAIL PROTECTED] > > > To: [EMAIL PROTECTED] > > > Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 > > (10055)) > > > > > > > > > Description: > > > I am connecting from Visual Basic 6 to Mysql via > > > ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a > > > server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on > > 192.9.200.2 > > > (10055) > > Is it fault of myodbc or mysql server? > > > Is it normal. If there a maximum connection limit for process ? > > No. Your process is only limited by your OS. E.g. Linux defaults to a > limit of 256 sockets per process. I don't know about Windows. I know but i tried it on 1 GB RAM and dual processor PIII 700 MHZ on winnt 4 with service pack 6 a. There is a concurrent sleeped process limit. Same on linux too also. > > > > I think it is abnormal cause everyone is talking about > > > 10.000 Web Hit. > > Sorry? You can handle 10.000 web hits with only one connection. i am not interested about web. it works. no problem. if you just create a server object on asp. loop the recordset. then close. no problem. cause you only open 1 process then close. and it take 1 secs. example. Think a scenario : You connect via ODBC or Data Environment from VB then you get a recordset. You will show this recordset on a grid. (excel style spreadsheet.) if you use additem method , you can loop recordset and manually add rows into grid then close recordset no problem. but if you bound grid into that dao object then until program or form close it run as a sleep process. and if you even use 3 connection for program , if max sleep process is limited to 90 (due to your hardware configuration , but even if you use 1 gb ram it is limited to max 120) that means maximum 30 user will be execute your program. and it is not satify us. > > > Is it cause from sleeped process list ? > > Quite probably. Why do you need so much sleeping processes? Maybe > there is a misconception about the need of them? mentioned above > > > I increased maximum connection to 200 but it not works. I think > > > it is not related with maximum connection. It is related with > > > maximum process number. > > Why do you get so much processes? Do you really get so much hits? If > so, maybe someone else can help (I have no clue about tuning Windows > systems). yes i really need this. as i mentioned above every executed compiled software will be needed at least 3 connection till to unloaded. > > > > How-To-Repeat: > > > Run this code on Microsoft Visual Basic 6 ENT Edition. > > > > > > For i = 1 To 200 > > > Set Temp_Bag(i) = New ADODB.Connection > > > Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro" > > > Next i > > > It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE. > > Well, do you have a production situation that hits the wall? If not, I > wouldn't care about it. One of my servers delivers about 5.000.000 > queries (300.000 web hits) a day with only 10-20 concurrent > connections. (Not, that there is no need for hundreds of connections > in some applications, but most time you don't need so much). i have a critical product(which is written in vb for end users) that needs at least 150 concurrent sleeped process to run. > > [...] > > > Release: mysql-3.23.26-beta > > > > > > Exectutable: mysqld-nt and mysqld-opt > > > Environment: PIII 700 MHZ Intel,256 MB RAM with WinNT4 , > > > Same Problem on PIII MHZ Intel with 128 MB Ram > > > System:WinNT4 with Service Pack 6a, Internet Explorer 5 > > > Same problem on Windows 95 Osr 2 > > > Same Problem on Windows 98 SE > [...] > > Bye, > > Benjamin. > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Hi. On Thu, Feb 01, 2001 at 08:18:45PM +0200, [EMAIL PROTECTED] wrote: > Would you please offer me something please ? > > > From: [EMAIL PROTECTED] > > To: [EMAIL PROTECTED] > > Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 > (10055)) > > > > > > Description: > > I am connecting from Visual Basic 6 to Mysql via > > ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a > > server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on > 192.9.200.2 > > (10055) > Is it fault of myodbc or mysql server? > > Is it normal. If there a maximum connection limit for process ? No. Your process is only limited by your OS. E.g. Linux defaults to a limit of 256 sockets per process. I don't know about Windows. > > I think it is abnormal cause everyone is talking about > > 10.000 Web Hit. Sorry? You can handle 10.000 web hits with only one connection. > Is it cause from sleeped process list ? Quite probably. Why do you need so much sleeping processes? Maybe there is a misconception about the need of them? > > I increased maximum connection to 200 but it not works. I think > > it is not related with maximum connection. It is related with > > maximum process number. Why do you get so much processes? Do you really get so much hits? If so, maybe someone else can help (I have no clue about tuning Windows systems). > > How-To-Repeat: > > Run this code on Microsoft Visual Basic 6 ENT Edition. > > > > For i = 1 To 200 > > Set Temp_Bag(i) = New ADODB.Connection > > Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro" > > Next i > > It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE. Well, do you have a production situation that hits the wall? If not, I wouldn't care about it. One of my servers delivers about 5.000.000 queries (300.000 web hits) a day with only 10-20 concurrent connections. (Not, that there is no need for hundreds of connections in some applications, but most time you don't need so much). [...] > > Release: mysql-3.23.26-beta > > > > Exectutable: mysqld-nt and mysqld-opt > > Environment: PIII 700 MHZ Intel,256 MB RAM with WinNT4 , > > Same Problem on PIII MHZ Intel with 128 MB Ram > > System:WinNT4 with Service Pack 6a, Internet Explorer 5 > > Same problem on Windows 95 Osr 2 > > Same Problem on Windows 98 SE [...] Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Would you please offer me something please ? > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 (10055)) > > > Description: > I am connecting from Visual Basic 6 to Mysql via > ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a > server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on 192.9.200.2 > (10055) Is it fault of myodbc or mysql server? > Is it normal. If there a maximum connection limit for process ? > I think it is abnormal cause everyone is talking about > 10.000 Web Hit. Is it cause from sleeped process list ? > I increased maximum connection to 200 but it not works. > I think it is not related with maximum connection . It is related with > maximum process number. > > > How-To-Repeat: > Run this code on Microsoft Visual Basic 6 ENT Edition. > > For i = 1 To 200 > Set Temp_Bag(i) = New ADODB.Connection > Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro" > Next i > It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE. > > > Fix: > Any offer? What means 10055 ? I check-out documents. Can't see any > recomend or definition for this error number. > > Additional Information : > Host: 3.23.30-gamma > ClientInfo: 3.23.6-alpha > HostInfo: 192.9.200.2 via TCP/IP > ProtoInfo: 10 > > I stopped on 93 process and got process list. It is attached. > > > Synopsis: > Submitter-Id: Yusuf Incekara > Originator: Yusuf Incekara > Organization: Avukatpro Limited Sirketi > MySQL support: None > Severity: Critical > Priority: High > Category: mysqld, ODBC > Class: sw-bug,ODBC-bug > Release: mysql-3.23.26-beta > > Exectutable: mysqld-nt and mysqld-opt > Environment: PIII 700 MHZ Intel,256 MB RAM with WinNT4 , > Same Problem on PIII MHZ Intel with 128 MB Ram > System:WinNT4 with Service Pack 6a, Internet Explorer 5 > Same problem on Windows 95 Osr 2 > Same Problem on Windows 98 SE > Compiler: ? > Architecture: i686 > > +-+---+---+---+-+--+---+--+ | Id | User | Host | db| Command | Time | State | Info | +-+---+---+---+-+--+---+--+ | 1 | root | INCEKARA2 | mysql | Sleep | 1114 | | | | 189 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 190 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 191 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 192 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 193 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 194 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 195 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 196 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 197 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 198 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 199 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 200 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 201 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 202 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 203 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 204 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 205 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 206 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 207 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 208 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 209 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 210 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 211 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 212 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 213 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 214 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 215 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 216 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 217 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 218 | avukatpro | INCEKARA2 | avukatpr
Re: Very Urgent
1. Start the mysqld. 2. Make sure it is opening the socket in /var/lin/mysql 3. Make sure /var/lin/mysql is set mode 775 Balaji Nallathambi wrote: > > Iam Getting the error > "Unable to Connect to Local MySql Server through socket 'var/lin/mysql/ > mysql.sock" > my Version For MySql is 3.22.32. > What is Th solutin For this mail me asap > adieu > Balaji.N > > > Get free email and a permanent address at http://www.netaddress.com/?N=1 > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql - JSP - Please help - URGENT
>
> Connection myConn =
> DriverManager.getConnection("jdbc:mysql:///test_db1?user=Username&password=pas
> sword");
>
Try with:
Connection myConn =
DriverManager.getConnection("jdbc:mysql://localhost/test_db1,"user","passwor
d");
===
Saludos,
Enric Badia
SONRIE,
LAS COSAS NO OCURREN POR CASUALIDAD.
-
S O N R I Eweb : http://www.sonrie.com
Pompeyo, 4e-mail: [EMAIL PROTECTED]
25006 Lleida Tel : +34 973 725 093
Spain Fax : +34 973 725 281
-
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql - JSP - Please help - URGENT
Marko Sarunac wrote:
>
> I am running mySql 3.23.32 on Redhat 7, with Apaache and Tomcat Jakarta 3.2.1
> and for database connection i use mm.mysql.jdbc-1.2c
> Here is my problem
>
> I have got MySql to run fine but when i try to interfaec it over the web i get
> te follwoing error
>
> error 500
> javax.servlet.ServletException: Server configuration denies access to data
> source
>
> The jsp page it self has code that is as follows
>
> <%@ page language="java" import="java.sql.*" %>
>
> <%
> Class.forName("org.gjt.mm.mysql.Driver");
>
> Connection myConn =
>
>DriverManager.getConnection("jdbc:mysql:///test_db1?user=Username&password=password");
>
> Statement stmt = myConn.createStatement();
> ResultSet myResultSet = stmt.executeQuery("select * from test_tb1");
>
> Is the a problem with mySql user permissions, or tomcat, or JDBC driver or what
> else.
>
> All help is greatelly appreciated!
Your connection string my require an address
jdbc:mysql://localhost/test_db1
for example... make sure that mysql user permission allow access from the
tomcat machine or whatever address it is trying to use.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Very Urgent
Iam Getting the error "Unable to Connect to Local MySql Server through socket 'var/lin/mysql/ mysql.sock" my Version For MySql is 3.22.32. What is Th solutin For this mail me asap adieu Balaji.N Get free email and a permanent address at http://www.netaddress.com/?N=1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySql - JSP - Please help - URGENT
I am running mySql 3.23.32 on Redhat 7, with Apaache and Tomcat Jakarta 3.2.1
and for database connection i use mm.mysql.jdbc-1.2c
Here is my problem
I have got MySql to run fine but when i try to interfaec it over the web i get
te follwoing error
error 500
javax.servlet.ServletException: Server configuration denies access to data
source
The jsp page it self has code that is as follows
<%@ page language="java" import="java.sql.*" %>
<%
Class.forName("org.gjt.mm.mysql.Driver");
Connection myConn =
DriverManager.getConnection("jdbc:mysql:///test_db1?user=Username&password=password");
Statement stmt = myConn.createStatement();
ResultSet myResultSet = stmt.executeQuery("select * from test_tb1");
Is the a problem with mySql user permissions, or tomcat, or JDBC driver or what
else.
All help is greatelly appreciated!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: urgent question
Surely this is a PHP question, not a MySQL Question > -Original Message- > From: Ryan Hagan [SMTP:[EMAIL PROTECTED]] > Sent: Friday, January 12, 2001 1:14 PM > To: [EMAIL PROTECTED] > Subject: urgent question > > Greetings, > > I have just subscribed to this list, so I am really sorry if I'm asking a > question that has been asked already, but I wasn't having any luck plowing > > through the archives, so I thought I'd try my luck with the list. > > I'm using MySQL 3.23.29 with PHP4 and apache 1.3.14 on a FreeBSD 4.2 > machine. When do a standard query statement from a PHP page, it seems to > get the data, but I can't get it to display? Basically, if I have a > table, > Users, which consists of id, name and job with the following data: > > 1, ryan, ditch digger > 2, bob, programmer > 3, james, window washer > > When I run the query, "SELECT * FROM Users," and print it out, I get a > table that looks like this: > > | id | name | job | > - > | | | | > - > | | | | > - > | | | | > - > > In other words, it fetches 3 rows, but there's no data. However, it works > > as expected when I telnet into the machine and use the mysql command line > tool. Any idea what's going on? > > The same code worked perfectly with the same setup when I was running > Mandrake 7.1 and MySQL 3.22. Thanks for your time. > > --- > Ryan Hagan > President, IncaGold USA, Ltd. > [EMAIL PROTECTED] > http://www.incagold.com/ > ICQ: 161019 > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
urgent question
Greetings, I have just subscribed to this list, so I am really sorry if I'm asking a question that has been asked already, but I wasn't having any luck plowing through the archives, so I thought I'd try my luck with the list. I'm using MySQL 3.23.29 with PHP4 and apache 1.3.14 on a FreeBSD 4.2 machine. When do a standard query statement from a PHP page, it seems to get the data, but I can't get it to display? Basically, if I have a table, Users, which consists of id, name and job with the following data: 1, ryan, ditch digger 2, bob, programmer 3, james, window washer When I run the query, "SELECT * FROM Users," and print it out, I get a table that looks like this: | id | name | job | - | | | | - | | | | - | | | | - In other words, it fetches 3 rows, but there's no data. However, it works as expected when I telnet into the machine and use the mysql command line tool. Any idea what's going on? The same code worked perfectly with the same setup when I was running Mandrake 7.1 and MySQL 3.22. Thanks for your time. --- Ryan Hagan President, IncaGold USA, Ltd. [EMAIL PROTECTED] http://www.incagold.com/ ICQ: 161019 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
