error creating table

error creating table

am 04.10.2009 20:17:54 von Sharique uddin Ahmed Farooqui

Hi,
I'm trying to create a table with 2 columns both are primary key
(combined) and both are foreign key as well. I'm getting error cannot
create table. Here is the sql

CREATE TABLE `userroles` (
`roleid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`userid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`roleid`, `userid`),
INDEX `FK1_user` (`userid`),
CONSTRAINT `fk_userid` FOREIGN KEY (`userid`) REFERENCES `users`
(`userid`) ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT `fk_roleid` FOREIGN KEY (`roleid`) REFERENCES `roles`
(`roleid`) ON UPDATE CASCADE ON DELETE CASCADE
)
COLLATE=utf8_general_ci
ENGINE=InnoDB
ROW_FORMAT=COMPACT
AVG_ROW_LENGTH=0

--
Sharique uddin Ahmed Farooqui
(C++/C# Developer, IT Consultant)
http://safknw.blogspot.com/
"Peace" is the Ultimate thing we want.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: error creating table

am 05.10.2009 00:14:19 von John

What is the exact error you are getting?



John Daisley
MySQL & Cognos Contractor

Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer (CMDEV)
IBM Cognos BI Developer

Telephone +44 (0)7812 451238
Email john@butterflysystems.co.uk

-----Original Message-----
From: Sharique uddin Ahmed Farooqui [mailto:safknw@gmail.com]=20
Sent: 04 October 2009 19:18
To: mysql
Subject: error creating table

Hi,
I'm trying to create a table with 2 columns both are primary key
(combined) and both are foreign key as well. I'm getting error cannot
create table. Here is the sql

CREATE TABLE `userroles` (
`roleid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`userid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`roleid`, `userid`),
INDEX `FK1_user` (`userid`),
CONSTRAINT `fk_userid` FOREIGN KEY (`userid`) REFERENCES `users`
(`userid`) ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT `fk_roleid` FOREIGN KEY (`roleid`) REFERENCES `roles`
(`roleid`) ON UPDATE CASCADE ON DELETE CASCADE
)
COLLATE=3Dutf8_general_ci
ENGINE=3DInnoDB
ROW_FORMAT=3DCOMPACT
AVG_ROW_LENGTH=3D0

--=20
Sharique uddin Ahmed Farooqui
(C++/C# Developer, IT Consultant)
http://safknw.blogspot.com/
"Peace" is the Ultimate thing we want.

--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Djohn.daisley@butterflys ystems.co.uk

No virus found in this incoming message.
Checked by AVG - www.avg.com=20
Version: 8.5.409 / Virus Database: 270.14.3/2413 - Release Date: =
10/04/09 06:20:00


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: error creating table

am 05.10.2009 04:03:05 von LIU YAN

--_b21fce35-605e-43ca-9aa6-1855fac4959b_
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit


hi,



I run your code , but worked propertly. I suggested to check the table USERS , ROLES, is the column userid / roleid same data type (INT(10) UNSIGNED ) with your userroles table ?



======================================================

mysql> create table users (userid INT(10) UNSIGNED primary key);
Query OK, 0 rows affected (0.06 sec)

mysql> create table roles (roleid INT(10) UNSIGNED primary key);
Query OK, 0 rows affected (0.06 sec)

mysql> CREATE TABLE `userroles` (
-> `roleid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
-> `userid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
-> PRIMARY KEY (`roleid`, `userid`),
-> INDEX `FK1_user` (`userid`),
-> CONSTRAINT `fk_userid` FOREIGN KEY (`userid`) REFERENCES `users`
-> (`userid`) ON UPDATE CASCADE ON DELETE CASCADE,
-> CONSTRAINT `fk_roleid` FOREIGN KEY (`roleid`) REFERENCES `roles`
-> (`roleid`) ON UPDATE CASCADE ON DELETE CASCADE
-> )
-> COLLATE=utf8_general_ci
-> ENGINE=InnoDB
-> ROW_FORMAT=COMPACT
-> AVG_ROW_LENGTH=0;
Query OK, 0 rows affected (0.08 sec)

mysql>

======================================================



best regards

liuyann



> Date: Sun, 4 Oct 2009 23:47:54 +0530
> Subject: error creating table
> From: safknw@gmail.com
> To: mysql@lists.mysql.com
>
> Hi,
> I'm trying to create a table with 2 columns both are primary key
> (combined) and both are foreign key as well. I'm getting error cannot
> create table. Here is the sql
>
> CREATE TABLE `userroles` (
> `roleid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
> `userid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
> PRIMARY KEY (`roleid`, `userid`),
> INDEX `FK1_user` (`userid`),
> CONSTRAINT `fk_userid` FOREIGN KEY (`userid`) REFERENCES `users`
> (`userid`) ON UPDATE CASCADE ON DELETE CASCADE,
> CONSTRAINT `fk_roleid` FOREIGN KEY (`roleid`) REFERENCES `roles`
> (`roleid`) ON UPDATE CASCADE ON DELETE CASCADE
> )
> COLLATE=utf8_general_ci
> ENGINE=InnoDB
> ROW_FORMAT=COMPACT
> AVG_ROW_LENGTH=0
>
> --
> Sharique uddin Ahmed Farooqui
> (C++/C# Developer, IT Consultant)
> http://safknw.blogspot.com/
> "Peace" is the Ultimate thing we want.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=liuyann@live.com
>

____________________________________________________________ _____
Windows Live: Keep your friends up to date with what you do online.
http://www.microsoft.com/middleeast/windows/windowslive/see- it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLM TAGL:ON:WL:en-xm:SI_SB_1:092010
--_b21fce35-605e-43ca-9aa6-1855fac4959b_--

Re: error creating table

am 05.10.2009 18:49:26 von Sharique uddin Ahmed Farooqui

Thanks Liu, This type mismatch issue.


On 10/5/09, LIU YAN wrote:
>
> hi,
>
>
>
> I run your code , but worked propertly. I suggested to check the table USERS
> , ROLES, is the column userid / roleid same data type (INT(10) UNSIGNED )
> with your userroles table ?
>
>
>
> ======================================================
>
> mysql> create table users (userid INT(10) UNSIGNED primary key);
> Query OK, 0 rows affected (0.06 sec)
>
> mysql> create table roles (roleid INT(10) UNSIGNED primary key);
> Query OK, 0 rows affected (0.06 sec)
>
> mysql> CREATE TABLE `userroles` (
> -> `roleid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
> -> `userid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
> -> PRIMARY KEY (`roleid`, `userid`),
> -> INDEX `FK1_user` (`userid`),
> -> CONSTRAINT `fk_userid` FOREIGN KEY (`userid`) REFERENCES `users`
> -> (`userid`) ON UPDATE CASCADE ON DELETE CASCADE,
> -> CONSTRAINT `fk_roleid` FOREIGN KEY (`roleid`) REFERENCES `roles`
> -> (`roleid`) ON UPDATE CASCADE ON DELETE CASCADE
> -> )
> -> COLLATE=utf8_general_ci
> -> ENGINE=InnoDB
> -> ROW_FORMAT=COMPACT
> -> AVG_ROW_LENGTH=0;
> Query OK, 0 rows affected (0.08 sec)
>
> mysql>
>
> ======================================================
>
>
>
> best regards
>
> liuyann
>
>
>
>> Date: Sun, 4 Oct 2009 23:47:54 +0530
>> Subject: error creating table
>> From: safknw@gmail.com
>> To: mysql@lists.mysql.com
>>
>> Hi,
>> I'm trying to create a table with 2 columns both are primary key
>> (combined) and both are foreign key as well. I'm getting error cannot
>> create table. Here is the sql
>>
>> CREATE TABLE `userroles` (
>> `roleid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
>> `userid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
>> PRIMARY KEY (`roleid`, `userid`),
>> INDEX `FK1_user` (`userid`),
>> CONSTRAINT `fk_userid` FOREIGN KEY (`userid`) REFERENCES `users`
>> (`userid`) ON UPDATE CASCADE ON DELETE CASCADE,
>> CONSTRAINT `fk_roleid` FOREIGN KEY (`roleid`) REFERENCES `roles`
>> (`roleid`) ON UPDATE CASCADE ON DELETE CASCADE
>> )
>> COLLATE=utf8_general_ci
>> ENGINE=InnoDB
>> ROW_FORMAT=COMPACT
>> AVG_ROW_LENGTH=0
>>
>> --
>> Sharique uddin Ahmed Farooqui
>> (C++/C# Developer, IT Consultant)
>> http://safknw.blogspot.com/
>> "Peace" is the Ultimate thing we want.
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=liuyann@live.com
>>
>
> ____________________________________________________________ _____
> Windows Live: Keep your friends up to date with what you do online.
> http://www.microsoft.com/middleeast/windows/windowslive/see- it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLM TAGL:ON:WL:en-xm:SI_SB_1:092010


--
Sharique uddin Ahmed Farooqui
(C++/C# Developer, IT Consultant)
http://safknw.blogspot.com/
"Peace" is the Ultimate thing we want.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Mysql Perl DBI DBD Version Compatability for MAC OS 10.6

am 05.10.2009 20:57:42 von Hagen Finley

After installing Apple's MAC Snow Leopard OS 10.6 I haven't been able to =
get my DBD:mysql module to work. I am kind of beyond trying to fix that =
issue directly so I am requesting assistance defining a compatible =
version set which is known to work. Between various releases and 32/64 =
bit options I have to confess there are too many choices and not enough =
information on how to choose for me to trust my own judgment anymore.=20

Currently, I am running:

1. mysql Server Version 5.4.1-beta MySQL Community Server

2. perl version 5.8.9 built for Darwin 2level

3. perl DBI version 1.609

4. perl DBD:mysql 4.012

I am not positive which of the above are 32 or 64 bit but help =
discerning which 32/64 versions are required would also be appreciated. =
I am happy ;-( to uninstall and reinstall any of the above to get to a =
working configuration. Thanks in advance.

Hagen Finley
Boulder, CO


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6

am 05.10.2009 21:16:06 von Gavin Towey

TXlTUUwgU2VydmVyIGNhbiBiZSAzMiBvciA2NCBiaXQgYW5kIGl0IHNob3Vs ZG4ndCBtYWtlIGEg
ZGlmZmVyZW5jZSB0byBQRVJMLiAgSG93ZXZlciwgaWYgeW91IGNhbiBydW4g NjQgYml0LCB5b3Ug
c2hvdWxkLg0KDQpQRVJMIGFuZCBpdCdzIG1vZHVsZXMgYWxsIG5lZWQgdG8g YmUgdGhlIHNhbWUg
YXJjaGl0ZWN0dXJlLiAgSXQgZG9lc24ndCBtYXR0ZXIgaWYgdGhleSdyZSAz MiBiaXQgb3IgNjQg
Yml0LCBhcyBsb25nIGFzIGl0J3MgY29uc2lzdGVudCB3aXRoIGl0c2VsZi4N Cg0KSSBzZWUgbm8g
cmVhc29uIHdoeSB0aG9zZSB2ZXJzaW9ucyBzaG91bGQgaGF2ZSBhIHByb2Js ZW0gaW50ZXJhY3Rp
bmc7IHdoYXQgYXJlIHlvdSB0cnlpbmcsIGFuZCB3aGF0IGlzIHRoZSBlcnJv ciB5b3UgZ2V0Pw0K
DQpSZWdhcmRzDQpHYXZpbiBUb3dleQ0KDQotLS0tLU9yaWdpbmFsIE1lc3Nh Z2UtLS0tLQ0KRnJv
bTogSGFnZW4gW21haWx0bzpmaW5oYWdlbkBjb21jYXN0Lm5ldF0NClNlbnQ6 IE1vbmRheSwgT2N0
b2JlciAwNSwgMjAwOSAxMTo1OCBBTQ0KVG86IG15c3FsQGxpc3RzLm15c3Fs LmNvbQ0KQ2M6IGZp
bmhhZ2VuQGNvbWNhc3QubmV0DQpTdWJqZWN0OiBNeXNxbCBQZXJsIERCSSBE QkQgVmVyc2lvbiBD
b21wYXRhYmlsaXR5IGZvciBNQUMgT1MgMTAuNg0KDQpBZnRlciBpbnN0YWxs aW5nIEFwcGxlJ3Mg
TUFDIFNub3cgTGVvcGFyZCBPUyAxMC42IEkgaGF2ZW4ndCBiZWVuIGFibGUg dG8gZ2V0IG15IERC
RDpteXNxbCBtb2R1bGUgdG8gd29yay4gSSBhbSBraW5kIG9mIGJleW9uZCB0 cnlpbmcgdG8gZml4
IHRoYXQgaXNzdWUgZGlyZWN0bHkgc28gSSBhbSByZXF1ZXN0aW5nIGFzc2lz dGFuY2UgZGVmaW5p
bmcgYSBjb21wYXRpYmxlIHZlcnNpb24gc2V0IHdoaWNoIGlzIGtub3duIHRv IHdvcmsuIEJldHdl
ZW4gdmFyaW91cyByZWxlYXNlcyBhbmQgMzIvNjQgYml0IG9wdGlvbnMgSSBo YXZlIHRvIGNvbmZl
c3MgdGhlcmUgYXJlIHRvbyBtYW55IGNob2ljZXMgYW5kIG5vdCBlbm91Z2gg aW5mb3JtYXRpb24g
b24gaG93IHRvIGNob29zZSBmb3IgbWUgdG8gdHJ1c3QgbXkgb3duIGp1ZGdt ZW50IGFueW1vcmUu
DQoNCkN1cnJlbnRseSwgSSBhbSBydW5uaW5nOg0KDQoxLiAgICAgIG15c3Fs IFNlcnZlciBWZXJz
aW9uIDUuNC4xLWJldGEgTXlTUUwgQ29tbXVuaXR5IFNlcnZlcg0KDQoyLiAg ICAgIHBlcmwgdmVy
c2lvbiA1LjguOSBidWlsdCBmb3IgRGFyd2luIDJsZXZlbA0KDQozLiAgICAg IHBlcmwgREJJIHZl
cnNpb24gMS42MDkNCg0KNC4gICAgICBwZXJsIERCRDpteXNxbCA0LjAxMg0K DQpJIGFtIG5vdCBw
b3NpdGl2ZSB3aGljaCBvZiB0aGUgYWJvdmUgYXJlIDMyIG9yIDY0IGJpdCBi dXQgaGVscCBkaXNj
ZXJuaW5nIHdoaWNoIDMyLzY0IHZlcnNpb25zIGFyZSByZXF1aXJlZCB3b3Vs ZCBhbHNvIGJlIGFw
cHJlY2lhdGVkLiBJIGFtIGhhcHB5IDstKCB0byB1bmluc3RhbGwgYW5kIHJl aW5zdGFsbCBhbnkg
b2YgdGhlIGFib3ZlIHRvIGdldCB0byBhIHdvcmtpbmcgY29uZmlndXJhdGlv bi4gVGhhbmtzIGlu
IGFkdmFuY2UuDQoNCkhhZ2VuIEZpbmxleQ0KQm91bGRlciwgQ08NCg0KDQot LQ0KTXlTUUwgR2Vu
ZXJhbCBNYWlsaW5nIExpc3QNCkZvciBsaXN0IGFyY2hpdmVzOiBodHRwOi8v bGlzdHMubXlzcWwu
Y29tL215c3FsDQpUbyB1bnN1YnNjcmliZTogICAgaHR0cDovL2xpc3RzLm15 c3FsLmNvbS9teXNx
bD91bnN1Yj1ndG93ZXlAZmZuLmNvbQ0KDQoNClRoZSBpbmZvcm1hdGlvbiBj b250YWluZWQgaW4g
dGhpcyB0cmFuc21pc3Npb24gbWF5IGNvbnRhaW4gcHJpdmlsZWdlZCBhbmQg Y29uZmlkZW50aWFs
IGluZm9ybWF0aW9uLiBJdCBpcyBpbnRlbmRlZCBvbmx5IGZvciB0aGUgdXNl IG9mIHRoZSBwZXJz
b24ocykgbmFtZWQgYWJvdmUuIElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRl ZCByZWNpcGllbnQs
IHlvdSBhcmUgaGVyZWJ5IG5vdGlmaWVkIHRoYXQgYW55IHJldmlldywgZGlz c2VtaW5hdGlvbiwg
ZGlzdHJpYnV0aW9uIG9yIGR1cGxpY2F0aW9uIG9mIHRoaXMgY29tbXVuaWNh dGlvbiBpcyBzdHJp
Y3RseSBwcm9oaWJpdGVkLiBJZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQg cmVjaXBpZW50LCBw
bGVhc2UgY29udGFjdCB0aGUgc2VuZGVyIGJ5IHJlcGx5IGVtYWlsIGFuZCBk ZXN0cm95IGFsbCBj
b3BpZXMgb2YgdGhlIG9yaWdpbmFsIG1lc3NhZ2UuDQo=

Re: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6

am 05.10.2009 22:29:42 von Hagen Finley

Here is the error I am receiving ( I posted this issue in the recent past):

dyld: lazy symbol binding failed: Symbol not found: _mysql_init
Referenced from:
/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mys ql/mysql.bundle
Expected in: flat namespace

dyld: Symbol not found: _mysql_init
Referenced from:
/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mys ql/mysql.bundle
Expected in: flat namespace

Trace/BPT trap


Could you send me the versions of Perl, DBD & DBI you are using?

Hagen


On 10/5/09 1:16 PM, "Gavin Towey" wrote:

> MySQL Server can be 32 or 64 bit and it shouldn't make a difference to PERL.
> However, if you can run 64 bit, you should.
>
> PERL and it's modules all need to be the same architecture. It doesn't matter
> if they're 32 bit or 64 bit, as long as it's consistent with itself.
>
> I see no reason why those versions should have a problem interacting; what are
> you trying, and what is the error you get?
>
> Regards
> Gavin Towey
>
> -----Original Message-----
> From: Hagen [mailto:finhagen@comcast.net]
> Sent: Monday, October 05, 2009 11:58 AM
> To: mysql@lists.mysql.com
> Cc: finhagen@comcast.net
> Subject: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6
>
> After installing Apple's MAC Snow Leopard OS 10.6 I haven't been able to get
> my DBD:mysql module to work. I am kind of beyond trying to fix that issue
> directly so I am requesting assistance defining a compatible version set which
> is known to work. Between various releases and 32/64 bit options I have to
> confess there are too many choices and not enough information on how to choose
> for me to trust my own judgment anymore.
>
> Currently, I am running:
>
> 1. mysql Server Version 5.4.1-beta MySQL Community Server
>
> 2. perl version 5.8.9 built for Darwin 2level
>
> 3. perl DBI version 1.609
>
> 4. perl DBD:mysql 4.012
>
> I am not positive which of the above are 32 or 64 bit but help discerning
> which 32/64 versions are required would also be appreciated. I am happy ;-( to
> uninstall and reinstall any of the above to get to a working configuration.
> Thanks in advance.
>
> Hagen Finley
> Boulder, CO
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=gtowey@ffn.com
>
>
> The information contained in this transmission may contain privileged and
> confidential information. It is intended only for the use of the person(s)
> named above. If you are not the intended recipient, you are hereby notified
> that any review, dissemination, distribution or duplication of this
> communication is strictly prohibited. If you are not the intended recipient,
> please contact the sender by reply email and destroy all copies of the
> original message.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6

am 06.10.2009 01:05:53 von Gavin Towey

I'm using:
DBD::mysql 3.007
DBI 1.52
Perl 5.8.8


That output looks like missing shared library dependencies to me, but maybe=
someone else has a better idea.

Try:
Ldconfig -p | grep mysql

And see if you see something like:
libmysqlclient.so (libc6,x86-64) =3D> /usr/lib64/libmysqlclient.so

in the output. If not you may have to find it and make sure ldconfig knows=
about it.

You should also be able to use ldd to check shared lib dependencies.

Regards,
Gavin Towey

-----Original Message-----
From: Hagen Finley [mailto:finhagen@comcast.net]
Sent: Monday, October 05, 2009 1:30 PM
To: Gavin Towey
Cc: mysql@lists.mysql.com
Subject: Re: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6

Here is the error I am receiving ( I posted this issue in the recent past):

dyld: lazy symbol binding failed: Symbol not found: _mysql_init
Referenced from:
/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mys ql/mysql.bundle
Expected in: flat namespace

dyld: Symbol not found: _mysql_init
Referenced from:
/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mys ql/mysql.bundle
Expected in: flat namespace

Trace/BPT trap


Could you send me the versions of Perl, DBD & DBI you are using?

Hagen


On 10/5/09 1:16 PM, "Gavin Towey" wrote:

> MySQL Server can be 32 or 64 bit and it shouldn't make a difference to PE=
RL.
> However, if you can run 64 bit, you should.
>
> PERL and it's modules all need to be the same architecture. It doesn't m=
atter
> if they're 32 bit or 64 bit, as long as it's consistent with itself.
>
> I see no reason why those versions should have a problem interacting; wha=
t are
> you trying, and what is the error you get?
>
> Regards
> Gavin Towey
>
> -----Original Message-----
> From: Hagen [mailto:finhagen@comcast.net]
> Sent: Monday, October 05, 2009 11:58 AM
> To: mysql@lists.mysql.com
> Cc: finhagen@comcast.net
> Subject: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6
>
> After installing Apple's MAC Snow Leopard OS 10.6 I haven't been able to =
get
> my DBD:mysql module to work. I am kind of beyond trying to fix that issue
> directly so I am requesting assistance defining a compatible version set =
which
> is known to work. Between various releases and 32/64 bit options I have t=
o
> confess there are too many choices and not enough information on how to c=
hoose
> for me to trust my own judgment anymore.
>
> Currently, I am running:
>
> 1. mysql Server Version 5.4.1-beta MySQL Community Server
>
> 2. perl version 5.8.9 built for Darwin 2level
>
> 3. perl DBI version 1.609
>
> 4. perl DBD:mysql 4.012
>
> I am not positive which of the above are 32 or 64 bit but help discerning
> which 32/64 versions are required would also be appreciated. I am happy ;=
-( to
> uninstall and reinstall any of the above to get to a working configuratio=
n.
> Thanks in advance.
>
> Hagen Finley
> Boulder, CO
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgtowey@ffn.com
>
>
> The information contained in this transmission may contain privileged and
> confidential information. It is intended only for the use of the person(s=
)
> named above. If you are not the intended recipient, you are hereby notifi=
ed
> that any review, dissemination, distribution or duplication of this
> communication is strictly prohibited. If you are not the intended recipie=
nt,
> please contact the sender by reply email and destroy all copies of the
> original message.



The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e contact the sender by reply email and destroy all copies of the original =
message.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg