Hi all...
I am having a problem with unique key violations in one of my tables.
This is the table structure:
CREATE TABLE `optionaldata` (
`ForeignID` int(10) unsigned NOT NULL default '0',
`FieldID` int(10) unsigned NOT NULL default '0',
`Value` char(200) default NULL,
UNIQUE KEY `Citiz
he original PASSWORD() function was irreversible.
Therefore I am left with no choice but to use a deprecated function...
which I really don't want to do...
What do you suggest?
Regards,
Matt Parlane
Modus Consulting
sql,query
---
>Description:
The password function does not work as intended with latest 4.1 tree
(today's). It returns a string of LENGTH() = 45 starting with a *
(asterisk) and 44 alphanumeric characters /[a-z0-9]/
>How-To-Repeat:
Using latest 4.1 BK tree, SELECT PASSWORD('something');
>Fix:
Not kno
o log sequence number 0 43922
020903 10:17:28 InnoDB: Flushing modified pages from the buffer pool...
020903 10:17:28 InnoDB: Started
/usr/local/mysql/bin/mysqld: ready for connections
~~
If you need any more info, please get back to me.
Thanks,
Matt Parlane
__
