RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

Hi thanks for replying. I can't immediately see the difference between your sample and mine, except the single quotes are missing, is that it? Thanks in advance. -Original Message- From: tere [mailto:[EMAIL PROTECTED] Sent: Monday, 22 January 2007 9:12 PM To: mysql@lists.mysql.com Subjec

RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

I'm simply executing a SELECT query that used to work before, same database, everything the same except a higher version of the MySQL server. -Original Message- From: Nuno Oliveira [mailto:[EMAIL PROTECTED] Sent: Monday, 22 January 2007 7:33 PM To: mysql@lists.mysql.com Subject: Re: Cann

Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

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 '-00-00 00:00:00' from column 4 to TIMESTAMP. The error occurred on line 8. MySQL version is: 5.0.27 Thanks in ad

FOUND_ROWS() returns wrong result

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 SELECT

RE: Full-Text problems

Is there any way to override this functionality? It becomes a real pain, I have to start doing weird stuff to overcome this limitation, if it would just return the results whether its more than 50% or not, I would be fine. Is there no way to do this? Thanks. Kind regards, Taco Fleur Free

More fulltext problems

M db_com_pacificmomentum.tbl_index where MATCH (content) AGAINST ('gallery' in boolean mode); It works fine. Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox <http://www.pacificfox.com.au/> http://www.pacificfox.com.au an

RE: Full-Text problems

Is there any way to test this? I doubt it is 50%, some of these words only appear once or twice within the content. Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994

Full-Text problems

I INNER JOIN tbl_webpage W ON I.webpageIdentity = W.webpageIdentity WHEREMATCH ( I.content ) AGAINST ( '#form.searchString#' ) ORDER BY score DESC; The content is text I gathered from our webpages, I am basically trying to create a site search. Any help is much appreciat

MATCH and return some text

Hi all, is it possible to do a MATCH AGAINST and return some of the text, for example the first paragraph that contains the matching words? Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox <http://www.pacificfox.com.au/> http://www.pacificfox.com

RE: Fulltext 3 letter words

Hi James, Yes I have verified whether the variable has changed with show variables, and it has not changed as per my first email. I have not gotten to rebuilding as the variable just will not change ;-) Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox http

RE: Fulltext 3 letter words

Hi Prasad, I have no my.cfn, I have a my.ini which is located at in the same directory as the my-innodb-heavy-4G.ini C:\Program Files\MySQL\MySQL Server 5.0 Kind regards, Taco Fleur (Mobile 0421 851 786) Commerce Engine Pty Ltd - Australia's leading online Payment Gateway . Local Call

RE: Fulltext 3 letter words

In "my-innodb-heavy-4G.ini" I modified the following line ft_min_word_len = 3 There are a couple of .ini files in the same directory I just modified the one that actually had the occurrence of "ft_min_word_len" in it. Kind regards, Taco Fleur Commerce Engine Pty Ltd -

RE: Fulltext 3 letter words

Hi, that would be version 5.0.18 - thanks Kind regards, Taco Fleur (Mobile 0421 851 786) Commerce Engine Pty Ltd - Australia's leading online Payment Gateway . Local Call 1300 859 179 Postal Address: PO Box 15118, City East Brisbane, Queensland, 4002, Australia Head office: 31 Valencia

Fulltext 3 letter words

Kind regards, Taco Fleur (Mobile 0421 851 786) Commerce Engine Pty Ltd - Australia's leading online Payment Gateway . Local Call 1300 859 179 Postal Address: PO Box 15118, City East Brisbane, Queensland, 4002, Australia Head office: 31 Valencia Court, Eatons Hill, Queensland, 4037, Australia

Question about MATCH Score

OUTER JOIN db_au_com_exclaimit.tbl_entity_note EN ON N.noteIdentity = EN.noteIdentity LEFT OUTER JOIN db_au_com_exclaimit.tbl_job_note JN ON N.noteIdentity = JN.noteIdentity WHERE MATCH (N.note) AGAINST ('' IN BOOLEAN MODE ) ORDER BY score DESC; Kind regards, Ta

RE: fulltext wildcards

thank you. Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox <http://www.pacificfox.com.au/> http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . * Web Design and Development *

fulltext wildcards

Hi all, I am trying to find a list that shows what wildcards I can use in fulltext searches, I searched the docs but no luck, does anyone happen to have a link to a list? thanks in advance. Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox <h

RE: WITH TIES

I don't see how that would work? I could do a join on the total sales price once I have the top 5, but I was hoping there was something as easy as WITH TIES. Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox http://www.pacificfox.com.au an industry l

RE: WITH TIES

rds, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . * Web Design and Development * SMS Solutions, including developer API * Dom

WITH TIES

Hi all, is there a WITH TIES function to use with the LIMIT keyword? Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox <http://www.pacificfox.com.au/> http://www.pacificfox.com.au an industry leader with commercial IT experience sinc

RE: customized variations on words with fulltext

Yes I have been thinking about the same, and already started collecting search words, but its not really the direction I want to go in if I can avoid it. Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox http://www.pacificfox.com.au an industry leader with

RE: Fulltext and reserved words

Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . * Web Design and Development * SMS Solutions, including developer API * D

customized variations on words with fulltext

isual Basic - VisualBasic Is this possible, if so how? Thanks in advance for any help. Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox <http://www.pacificfox.com.au/> http://www.pacificfox.com.au an industry leader with commercial IT experience

RE: Fulltext and reserved words

through the documentation but just can't find anything specific. Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . * Web Design and Develo

Fulltext and reserved words

I am in need to search for sql reserved words with MATCH AGAINST it turns it doesn't return anything when I feed it a reserved word like 'sql' is there anything I can do about that? Thanks in advance Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pac

RE: Full text score

t does not display a score, any ideas anyone? Thanks in advance. SELECT MATCH (resumeAsText) AGAINST ('coldfusion javascript') FROM db_au_com_exclaimit.tbl_resume WHERE MATCH (resumeAsText) AGAINST ('coldfusion javascript' in boolean mode) Kind regards, Taco Fleur Free Ca

Full text score

Hi all, is there such a thing as a score for full-text searches? thanks in advance. Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox <http://www.pacificfox.com.au/> http://www.pacificfox.com.au an industry leader with commercial IT experience

RE: counting keywords

omething like that as well, and included an extra field for the metaphone version of the word, to match approximate spellings. If the text fields were all in plain text, you could even include character positions like Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pac

RE: counting keywords

Thanks Steve, Much appreciated, I was hoping there was something a little simpler, but I will have a go at it. Anyway of doing this with RegEx, would that simplify things? Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox http://www.pacificfox.com.au an

counting keywords

ySQL could search the résumé's when stored as binary data, but I was wrong, so I now have the CV's converted to HTML and then store them in the DB as VARCHAR Any help would be much appreciated, I am having a hard time coming from a MS SQL background ;-) Kind regards, Taco Fleur

foreign key creation on MyISAM storage engine

eciated. Kind regards, Taco Fleur - CEO Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox <http://www.pacificfox.com.au/> http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . * Web Design and Development * SMS