cron job issues with PEAR_Error
HiWe have had some cron jobs running to process both incomming email (from 2accounts) and outgoing mail every minute 24x7 for a few months now, and allseems to work well, except for 1 thing; the inbound jobs fail with the following error;Fatal error: Cannot use object of type PEAR_Error as array...
1 answers | 1177 bytes |
CHAR(a,t) AND LIMIT functions
Hi,Dusan, you mixedCHAR (, <) used in SQLMDEINTERNALandTCHAR (, <some string containing the definition ofdate/time-layout) used in SQLMDE RACLECHAR (timestampentry, IS) or CHAR ( DATE ( timestampentry, IS) ) inINTERNAL MDEorTCHAR (timestampentry, 'YYYY-MM-DD') in SQLMDE RACLESynt...
0 answers | 2928 bytes |
hbb"/usr/sbin/mysqld: Shutdown complete" when doing mysqldump
Hi.Using mySQL v4.1.9 on Fedora Core 2, I'm suffering a shutdown everydayaround 04:30. These are the contents of 'mysqld.log':/usr/sbin/mysqld: ready for connections.Version: '4.1.9-standard-log' socket: '/var/lib/mysql/mysql.sock'port: 3306 Source distribution...
0 answers | 1960 bytes |
WHERE (NOT) EXISTS problem
Having a very bad time with the subject sorts of queries.Here is a simple reproduction of the problem for me.Perhaps I'm blind/stupid while looking at the docs,or there's a bugmysql version 5.0.24-standardsimple schema:mysqldesc people;| Field | Type | Null | Key | Default | Extra || i...
3 answers | 2389 bytes |
Does MySQL 5.2 include support for RolesBased Access Control?
I find some code about role management in mysql5.2 's source code " \mysql-5.2.0-falcon-alpha\storage\falcon " Does MySQL 5.2 include support for roles based access control now? Does it be supported by falcon engine?...
0 answers | 240 bytes |
erro about using odbc vist mysql
hi good everyone, i use odbc visit remote mysql(mysql Ver 14.3 Distrib 5.0.0-alpha) but display this error log!error log: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 '{ call testme(1002, 104) }' at...
0 answers | 689 bytes |
Better way to query table converted from SQL to RDF format?
I have some data in a regular MySQL table called usplaces:city |state|country|latitude |longitude |population|commentsNew York |NY |USA |40.704234| -73.917927|8008278 |Big AppleChicago |IL |USA |41.840675|-87.679365 |2896016 |Windy CitySan Francisco|CA |USA |37.759881|-122.437392|776733 |City by...
0 answers | 2762 bytes |
Fulltext relevance and weighting....
Mike::) I wish! Free ham for everyone!I had already changed the min length to 2 actually - so that is not theaffecting factorIt is more of an issue to prioritizing fields for relevance, and whether itis possible to do this within a fulltext query, or whether it needs to bedone through multiple q...
0 answers | 2969 bytes |
rounding digits after decimal sign
Dimitar Vassilev asks:Hello,Can anyone point me to a section of manual or link how to reduce digitsaftera decimal sign?I have a tablemysqldesc part;| Field | Type | Null | Key | Default | Extra || kod | varchar(255) | YES | | NULL | || bulstat | double(15,5) | YES | MUL | NULL | || Land | varcha...
1 answers | 1007 bytes |
rounding digits after decimal sign
Hello,Can anyone point me to a section of manual or link how to reduce digitsaftera decimal sign?I have a tablemysqldesc part;| Field | Type | Null | Key | Default | Extra || kod | varchar(255) | YES | | NULL | || bulstat | double(15,5) | YES | MUL | NULL | || Land | varchar(3) | YES | MUL | NUL...
5 answers | 876 bytes |
Fulltext relevance and weighting....
Does anyone have any suggestions on how to solve the result weightingproblem? I have a client whose search results are becoming more and moreimportant, and the relevance demands on the results are not entirelysatisfactoryThe fields that are searched are code, name, small description and largedes...
3 answers | 1655 bytes |
CHAR(a,t) AND LIMIT functions
MaxDB 7.6.00.34 (linux 32)SQLStudio 7.6.00.27Good afternoon List,When querying my database I get unexpected results in using the CHAR andLIMIT functions.About the CHAR(a,t) function. The help explains "CHAR(a,t) is a function(conversion function<>) that converts thedate values <>, ti...
1 answers | 1256 bytes |
- cron job issues with PEAR_Error
- CHAR(a,t) AND LIMIT functions
- hbb"/usr/sbin/mysqld: Shutdown complete" when doing mysqldump
- WHERE (NOT) EXISTS problem
- Does MySQL 5.2 include support for RolesBased Access Control?
- erro about using odbc vist mysql
- Better way to query table converted from SQL to RDF format?
- Fulltext relevance and weighting....
- rounding digits after decimal sign
- Replication not working?
- Safe DB Distribution
- General MySQL Question: Ed Reed (CA, United States ofAmerica) Medium
- Safe DB Distribution
- Recover from lost log volume
- Alias a function result?
- MYODB 5.00.10
- Home- About Us- Contact- Privacy Statement- Link Exchange- Bookmark- Map.XML- Rss.Xml
- Copyright 2001-2008 by EMSDN.COM Information Technology Co.,Ltd All rights reserved
- 0.594