|
 |
| Recent blog posts: | |
|
| They have birthday today: | |
|
| Forums: | | |
|
| Discuss: | |
|
| Recent forum topics: | |
|
| Recent forum comments: | |
|
| Модератор: | |
|
Tuesday, 23 January 2007
|
| MYODB 5.00.10 Mogens Lunde 11:43:18 |
| | I am so tired of all the problems with #2013 errors in 3.51.13 that I
decided to give 5.0 another shot. This time I succeeded to get a bit
longer, but when I try to link a Mysql table in MS-access I now get this
error: 1142 SELECT command denied to user 'my_username'@'my connection'
for table STATISTICS (#1142)
I am using MySQL version 4.1.21-standard on the webserver I try to
connect to.
--
Regards
Mogens
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
|
| |  5 answers | Add comment |
|
| Urgent - MySQL 5 - mysqld using a lot of memory consistently Ratheesh K J 10:15:36 |
| | Hello all,
Recently we upgraded from MySQL 4.1.11 to MySQL 5.0.22. The queries are taking a lot of time to execute in the newer version. The queries which were executing within 10 secs are now taking more than 100 secs.
Running an expalin on the queries showed that an index_merge optimization is being used which is a new concept in MySQL 5. My initial doubt was on this but now when I checked top it shows that mysqld is consistently using 59% of Memory and 25% of cpu even when there is no load.
the SHOW STATUS command in mysql shows:
Threads_created 21863
Threads_cached 1
Threads_connected 38
Connections 5784350
Running a SHOW VARIABLES shows:
thread_cache_size 8
It is evident that mysqld is creating a lots of threads... Could this be the problem?
Thanks,
Ratheesh K J |
| | 4 answer | Add comment |
|
| MYSQL reporting an error with subquery query A Blossom of Paradise 06:50:41 |
| | Hello Fellow MySqueelers!,
SELECT version()
reveals...
4.0.24-nt-max-log
I have looked at the following query a hundred times, and cannot find how MYSQL can report a syntax error to me.
query string is...
SELECT RAND() AS `RAND`, `prod`.`id`
FROM `prod` JOIN `pack` ON `prod`.`id` = `pack`.`pid`
WHERE `pack`.`did` = 3 AND
NOT ( `prod`.`id` IN (
SELECT `pack1`.`pid`
FROM `ogrp` AS `ogrp1` JOIN `oitm` AS `oitm1` ON `ogrp1`.`id` = `oitm1`.`gid`
JOIN `pack` AS `pack1` ON `oitm1`.`pid` = `pack1`.`id`
WHERE `ogrp1`.`raid` = 9 AND
`ogrp1`.`wid` = 3 AND
`ogrp1`.`rdate` > DATE_SUB( CURDATE(), INTERVAL 3 MONTH ) ) )
ORDER BY `RAND`
LIMIT 3
Error number is 1064
Error message is 'You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `pack1`.`pid` FROM `ogrp` AS `ogrp1` JOIN `oitm` AS `o'
any suggestions before i squeel?
-wh |
| | 1 answer | Add comment |
|
| Help indexing this query. Altendew 00:42:53 |
| |
--- ptsSignups --
id int(20) No
mid int(20) No 0
ptsID int(20) No 0
pps double No 0
points double No 0
loginID varchar(255) No
emailConfirm longtext No
time timestamp Yes CURRENT_TIMESTAMP
reasonForDeny longtext No
status int(1) No 1
--- index (timeframe) ---
timeframe (mid,status,time)
--- query ---
SELECT SUM(s.pps) as earned,m.id,m.username
FROM ptsSignups s
FORCE INDE timeframe)
JOIN members m
ON s.mid=m.id
AND m.status='Member'
LEFT JOIN ptsContestExclude e
ON e.cid=1
AND e.mid=m.id
WHERE
s.status='2'
AND s.time>=2004-06-08
AND s.time<2008-06-08+INTERVAL 1 DAY
AND e.mid IS NULL
GROUP BY s.mid
HAVING earned>0
ORDER BY earned DESC
--- problem ---
`ptsSignups` is a table listing everything my members have completed.
Sometimes I like to run contests to see who has earned the most. `members`
is a table that contains all my users. `ptsContestExclude` is a table of
members of whom I would like to exclude from the contest.
What I do first is group the table `ptsSignups` by member id, and calculate
a sum of how much they earned. Then I reorder that sum in Descending order
so the highest earned is on top.
This `ptsSignups` table contains 82752 rows and is 75KB big. It runs
extremely slow. I tried to create an index for it but it failed to increase
performance.
Any help is appreciated.
--
View this message in context: http://www.nabble.com/Help-indexing-this-query.-tf3059045.html#a8505554
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 4 answer | Add comment |
Monday, 22 January 2007
|
| Visual Basic 6 + MySQL Nuno Vaz Oliveira 23:12:44 |
| |
Hello!
I'm thinking to develop a database interface for our company and I thought
"great" when I discovered that Visual Basic 6 was able to interact with MySQL.
That's because VB6 is very easy and PHP (even being fast, but its hard for
me) gets slower because the source code for HTML pages needs to go from the
server to the client and big pages must carry the data and the tags, images,
css, formating, etc...
However I'm not going to start a project without knowing that VB6+ODBC Driver
is able to do all the needed operations to connect/read/write/insert/update
a database.
Additionaly I would like to know if I can manage users from VB and to backup
the DB.
If anyone can tell me something about it I appreciate. I would also "like"
(Not Mandatory) to use a secure connection (SSL) but I don't know if this
is possible using VB6/ODBC Driver.
Note: The MySQL Database will be served from our company server.
(Any links to tutorials/tips/recommendations/forums about this subject are
also welcome)
Thanks
- Nuno
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 10 answers | Add comment |
|
| Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP Taco Fleur 22:26:45 |
| |
The second major problem I am running into after the upgrade is the
following error, which did not occur on Development.
Error Executing Database Query. Cannot convert value '0000-00-00 00:00:00'
from column 4 to TIMESTAMP.
The error occurred on line 8.
MySQL version is: 5.0.27
Thanks in advance for any help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 5 answers | Add comment |
|
| Include a stored procedure ( that returns a recordset ) in another
query Daniel Kasak 21:03:59 |
| | Hi all.
I'd like to be able to define a stored procedure that returns a
recordset ( I've done this bit ), and then select from this in another
query, eg:
CREATE DEFINER=`root`@`10.146.%` PROCEDURE `sp_MyClients`( IN ACCMAN INT )
BEGIN
select * from mirror_Clients where AccMan = ACCMAN;
END
... and then:
select
C.FileNo, C.SubNo, L.AccountNo
from
( sp_MyClients ( 192 ) ) C inner join TLocations T on C.ClientID =
T.ClientID;
I've also tried adding 'call' immediately before the 'sp_MyClients' bit.
Either way, I get:
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '( 192 ) ) C inner join TLocations T on C.ClientID =
T.ClientID' at line 1
I assume it's not possible to do this then?
I realise I can skip the stored procedure in this case and just add the
where clause from the SP to the query, but in some other cases, the SP
bit will be quite complex.
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 1 answer | Add comment |
|
| VB6 + MySQL Nuno Vaz Oliveira 18:59:48 |
| |
Hello!
I'm thinking to develop a database interface for our company and I thought
"great" when I discovered that Visual Basic 6 was able to interact with MySQL.
That's because VB6 is very easy and PHP (even being fast, but its hard for
me) gets slower because the source code for HTML pages needs to go from the
server to the client and big pages must carry the data and the tags, images,
css, formating, etc...
However I'm not going to start a project without knowing that VB6+ODBC Driver
is able to do all the needed operations to connect/read/write/insert/update
a database.
Additionaly I would like to know if I can manage users from VB and to backup
the DB.
If anyone can tell me something about it I appreciate. I would also "like"
(Not Mandatory) to use a secure connection (SSL) but I don't know if this
is possible using VB6/ODBC Driver.
Note: The MySQL Database will be served from our company server.
(Any links to tutorials/tips/recommendations/forums about this subject are
also welcome)
Thanks
- Nuno
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
|
| | 3 answer | Add comment |
|
| myodbc 3.51 crash Maciej Swic 18:47:21 |
| | Hi!
I've created a referee database for use with a card-printer software. It
can read the database correctly when advancing thru records manually
using next/prev buttons in the card-printing software. However, if i
bring up a list of all records in the database thru the
card-printing-software and double-click a record from there, myodbc3.dll
crashes the card-printing-app. It is possible to browse to the
double-clicked record manually but it takes a lot of time and this needs
fixing. I am probably doing something wrong as i havent used mysql with
this card-printer before. For the record, we are using evolis software.
What could be wrong? I dont know what other info to post so plase ask
for it. I could also post all the info the windows crash-window gives.
Cheers
MS
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
|
| | 2 answer | Add comment |
|
| VS 2005 w/ mySQL 2.1.1 cannot open mysqlpp.lib Cory S Sanchez 15:27:25 |
| |
Hello everyone,
I'm running Microsoft Visual Studio 2005.net, I also have installed mySQL 5.0 and mySQL++2.1.1.
I followed the instructions in the vc read me supplied in mySQL++. I also looked at the older threads that had a similar problem that was solved by building the lib.dsw first then building the examples.
When I try to build the examples, I get the following Error:
------ Build started: Project: custom2, Configuration: Debug Win32 ------1>Compiling...1>custom2.cpp1>Compiling manifest to resources...1>Linking...1>LINK : fatal error LNK1104: cannot open file 'mysqlpp.lib'1>Build log was saved at "file://c:\mysql++-2.1.1\examples\Debug\custom2\BuildLog.htm"1>custom2 - 1 error(s), 0 warning(s) ========== Build: 0 succeeded, 1 failed, 1 up-to-date, 0 skipped ==========
So I then went to build the lib.dsw located here first:
C:\mysql++2.1.1\lib\lib.dswand oddly I got the following errors:1>coldata.cpp1>connection.cpp1>.\connection.cpp(165) : error C2065: 'ulong' : undeclared identifier1>.\connection.cpp(165) : error C2143: syntax error : missing ')' before 'constant'1>.\connection.cpp(165) : error C2059: syntax error : ')'1>datetime.cpp
They where the only 3 errors out of the build of lib.dsw.It says its in this fragment of code:#if MYSQL_VERSION_ID >= 40101
if (option_pending(opt_multi_statements, true)) {
client_flag |= CLIENT_MULTI_STATEMENTS;
}
#endif Any idea what is going on or what i'm doing incorrectly? Thank you.
|
| | 1 answer | Add comment |
|
| Query about MySQL Raman Kheterpal 14:07:23 |
| | Hi All
I got your mail id from one of the forums.
can u plz tell me tht wht is the capacity of storage of MySQL DB. acutally
we are in the process of making a project on LAMP technology, but the
databse is too large..say 17220000 records....
this much of records will remain in one table only... Can you please tell
me .
- Is mysql is able to manage this huge amount of data.
- Can we put this much of data in single table database OR keeping the
data in multiple tables is the good practice.
- What precautions I have to taking while managing this much of data in
MySQL....etc etc
kindly see the matter n reply me in this regards
Thanx in advance
raman |
| | 2 answer | Add comment |
|
| Request problem (with \\) Gabriel Linder 11:52:47 |
| | Hello list,
I am currently trying to fix a bug in a search function with a request
like this one :
select * from forum where topic like '%[...]%' ;
where [...] is a string escaped by mysql_real_escape_string (C API) and
topic is a varchar field (not null).
It works, but there is a bug if someone is searching the character
backslash only ('\'), so the request become :
select * from forum where topic like '%\\%' ;
and it returns only topics who have a '%' in them, not a '\'. It is the
same result as if I were doing :
select * from forum where topic like '%\%' ;
To get the topics with a '\' (but it returns only the topics that ends
with a '\'), I must do :
select * from forum where topic like '%\\' ;
So it seems to me that the ending % is escaped even with '\\'. Is this a
normal behaviour ? Or am I missing something ?
Here are some infos about the server version, might be useful :
version = 4.0.20-standard
version_comment = Official MySQL-standard binary
version_compile_os = linux
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 2 answer | Add comment |
|
| SQL Query Question Sulewski 10:09:36 |
| | Okay, I think I'm missing something obvious. I have two tables
Table 1 Table 2
___________ _____________
ID rdid vid
___________ _____________
ID in table 1 links to rdid in table 2. This is a one to many
relationship. Now I wish to find all the items in table 1 where
table2.rdid= table1.rdid and (table2.vid=46) and (table2.vid=554)
In other words which records from table 1 link to two records in table
2 who's vid are 46 and 554.
I hope this makes sense.
Thanks
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 63 answer | Add comment |
|
| Is there C API function to convert the MYSQL_ROW items from string to Language specified type? David 09:53:21 |
| | Hi all:
Is there a C API function to convert the MYSQL_ROW items from string
to Language specified type? I thought there should be one, but I can't find
it. Could you give me some advice?
Appreciate your help!
--
David
|
| | Add comment |
|
| FOUND_ROWS() returns wrong result Taco Fleur 09:26:25 |
| | Hi,
I've installed MySQL 5.0.27 on a LIVE environment while DEVELOPMENT runs a
lower version, yes I know wrong thing to do.
I've run into quite a few issues which are causing me lots of problems, the
main one being that FOUND_ROWS() return a wrong result.
The queries in questions are
SELECTSQL_CALC_FOUND_ROWS
PI.productInfoIdentity
, PI.productInfoTypeIdentity
, PI.productCategoryIdentity
, PI.dateStamp
, PI.documentIdentity
, PIT.productInfoTypeTitle
, PC.productCategoryTitle
, D.documentTitle
, D.documentIdentity
, D.originalExtension
, D.originalName
, D.fileSize
FROM tbl_productinfo PI
INNER JOIN tbl_productinfotype PIT
ON PI.productInfoTypeIdentity =
PIT.productInfoTypeIdentity
INNER JOIN tbl_l_productcategory PC
ON PI.productCategoryIdentity =
PC.productCategoryIdentity
INNER JOIN tbl_document D
ON PI.documentIdentity =
D.documentIdentity
INNER JOIN tbl_l_country C
ON C.countryIdentity =
PI.countryIdentity AND PI.countryIdentity = 1
ORDER BY PC.productCategoryTitle
LIMIT0, 10;
Which returns nothing
Second statement
SELECTFOUND_ROWS() AS value;
Returns 8, which is completely wrong. The numbers returned do not make any
sense either, as I have others that should return 0, but return 6 or some
other number.
Any help would be much appreciated.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | Add comment |
|
| How to convert the the string row[i] to its real type. David 06:39:37 |
| | Hi all:
I use mysql C API , and I want generate JSON object from mysql
recordset, the filed value of JSON should be real type , e.g. int, float,
ect. but the value I got using mysql_fetch_row() is strings, I can get its
type using field->type, and then convert the values. but it is not
convinient to me, How to do it in a smart way?
--
David
|
| | Add comment |
|
| changing from mysql5 to mysql4 Thibaud Hulin 00:10:00 |
| | Hello !
I need of koha, a software for libraries. It works with mysql 4, but
it's not compatible with mysql5.
How can do this changement with a Debian Etch ? Must I only remove the
one and install the other ?
Thanks for help,
Thibaud.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 2 answer | Add comment |
Sunday, 21 January 2007
|
| Query skips one set of records Miles Thompson 23:42:31 |
| |
The query displayed below performs flawlessly, except for these two records:
7364M01740 002505 10 Invoice 2006-12-13 2006-12-13 2006-12-31
7365 M01740 002506 5 Invoice2006-12-13 2006-12-13 2006-12-31
Here's the table structure:
member_id varchar(6)
member_sub_id varchar(6)
pay_method varchar(8)
monthly_cost decimal(11,0)
anniv_bill_date date
dtCreated date
fetch_date date
This query:
SELECT
member_id,
member_sub_id,
IF( ( monthly_cost = 10 ), ( SUM(( monthly_cost * 2.00 ) + 200 ) ), ( SUM(
monthly_cost * 12.00 ) ) ) AS Amount
FROM subinfo
WHERE
MONTH(anniv_bill_date) = 12 AND
MONTH(fetch_date) = 12 AND
YEAR(fetch_date) = 2006 AND
pay_method = 'Invoice'
GROUP BY member_id
Should return Amount as $280 : ( 10*2 ) + 200 for the first record plus 5 *
12 for the next one.
Instead it is returning $180.
Other records which have similar conditions are processed with no
difficulty. Is this kind of intermittency a bug in MySQL 3.23?
If anyone has any suggestions, then I would love to know it. If I execute a
test query without the SUM() function and GROUP BY, but using all of the
other WHERE conditions, these two records are flawlessly selected from the
data set. With SUM() and GROUP BY - wrong results, for only these two.
Suggestions or hints will be welcome.
I can now upgrade to MySQL 4.x, so I will do that.
Regards - Miles Thompson
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.410 / Virus Database: 268.16.14/636 - Release Date: 1/18/2007
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 6 answers | Add comment |
|
| MySQL Administrator problem Ed Reed 08:16:58 |
| | Unable to manage user accounts through MySQL Administrator 1.2.8. I've found that I'm not the only one with this problem but no one seems to have an answer for it.
The problem is that when you select a user in the user list of the prog the user's detail don't appear on the right side so that they can be edited. If I right click on the user in the list then the only enabled options are Add, Refresh and Show Hosts. If I add a user, there's nothing else I can do it. The new user shows up in the list but I can't modify it or delete it. I'm logged in a root. I don't know what else to do.
Any thoughts?
|
| | 8 answers | Add comment |
|
| odbc connectionm problem Jason Koch 00:37:16 |
| | I have mysql from godaddy.com. I have installed odbc 3.51.12 but cannot connect.
Here are my Connector/ODBC settings:
Date Source Name: shelby72
Server: mysql139.secureserver.net
Below is the sample configuration from godaddy.com if I was connecting to MySQL Database using PHP.
MySQL Server Database Connection Settings
Description:
This example describes using PHP to connect to a MySQL Database on a Linux hosting account.
<?php
//Connect To Database
$hostname="mysql139.secureserver.net";
$username="shelby72";
$password="your_password";
$dbname="shelby72";
$usertable="your_tablename";
$yourfield = "your_field";
mysql_connect($hostname,$username, $password) OR DIE ("Unable to connect to database! Please try again later.");
mysql_select_db($dbname);
$query = "SELECT * FROM $usertable";
$result = mysql_query($query);
if($result) {
while($row = mysql_fetch_array($result)){
$name = $row["$yourfield"];
echo "Name: ".$name;
}
}
?>
____________________________________________________________________________________
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
http://answers.yahoo.com/dir/?link=list&sid=396546091 |
| | Add comment |
Saturday, 20 January 2007
|
| Table update J rn Dahl-Stamnes 12:50:25 |
| | I want to update new column in a table with data from other tables.
The following query give me the data:
select t.id,min(r.starttime)
from teams as t
inner join rider_team as rt on (rt.team_id=t.id)
inner join participants as p on (p.rider_id=rt.rider_id)
inner join races as r on (r.id=p.race_id)
group by t.id;
Is it possible to write a query that do a:
update teams set created=min(r.starttime) ...
which updates all records in the teams table based on first query?
Thanks
BTW:
mysql> select version();
+----------------+
| version() |
+----------------+
| 4.1.8-standard |
+----------------+
--
J rn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 2 answer | Add comment |
|
| Log Warnings Level Kristen G. Thorson 09:43:21 |
| | The manual indicates that you can specify a specific level to control
what types of warnings are logged:
http://dev.mysql.com/doc/refman/5.0/en/server-options.html
(See section on log-warnings.)
But all I really get from this reading is 0 turns it off, 1 prints some
warnings, and 2 prints level 1 warnings plus aborted connections
warnings. I have not been able to find any additional information in my
search. Am I missing something, or is this all the documentation there
is on this?
Thanks,
Kristen G. Thorson
Programmer
(804) 553-1130, Ext. 204
www.AllegroConsultants.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 3 answer | Add comment |
|
|
