headers
joe blair | 1 Feb 2007 07:31
Favicon

Help with an error in the make of dbdimp.c

Hello,

I can not determine why I am receiving this error on the compile of  
dbimp.c during the install of DBD::MYSQL

blairmac02:~/Desktop/samplecode/DBD-mysql-4.001 joeblair$ sudo make
gcc -c  -I/usr/local/ActivePerl-5.8/site/lib/auto/DBI -I/usr/local/ 
mysql/include -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -fno-common - 
DPERL_DARWIN -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -fno-strict-aliasing - 
pipe -Wdeclaration-after-statement -O3   -DVERSION=\"4.001\" - 
DXS_VERSION=\"4.001\"  "-I/usr/local/ActivePerl-5.8/lib/CORE"   dbdimp.c
dbdimp.c: In function 'mysql_dr_connect':
dbdimp.c:1677: error: 'ulong' undeclared (first use in this function)
dbdimp.c:1677: error: (Each undeclared identifier is reported only once
dbdimp.c:1677: error: for each function it appears in.)
dbdimp.c:1677: error: parse error before numeric constant
make: *** [dbdimp.o] Error 1

I have searched for 'ulong', but have not been able to find it nor  
declare it.

Please let me know what I should do to correct the problem.

Thanks so much!
joe

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
(Continue reading)

Permalink | Reply | 1 comment |
headers
Christian Hoermann | 3 Feb 2007 06:18
Picon

Re: Help with an error in the make of dbdimp.c

This has been discussed frequently on this list. See the archives for
January, here:
http://lists.mysql.com/perl?thread=2007-01

On 2/1/07, joe blair <joeblair <at> mtco.com> wrote:
> Hello,
>
> I can not determine why I am receiving this error on the compile of
> dbimp.c during the install of DBD::MYSQL
>
> blairmac02:~/Desktop/samplecode/DBD-mysql-4.001 joeblair$ sudo make
> gcc -c  -I/usr/local/ActivePerl-5.8/site/lib/auto/DBI -I/usr/local/
> mysql/include -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -fno-common -
> DPERL_DARWIN -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -fno-strict-aliasing -
> pipe -Wdeclaration-after-statement -O3   -DVERSION=\"4.001\" -
> DXS_VERSION=\"4.001\"  "-I/usr/local/ActivePerl-5.8/lib/CORE"   dbdimp.c
> dbdimp.c: In function 'mysql_dr_connect':
> dbdimp.c:1677: error: 'ulong' undeclared (first use in this function)
> dbdimp.c:1677: error: (Each undeclared identifier is reported only once
> dbdimp.c:1677: error: for each function it appears in.)
> dbdimp.c:1677: error: parse error before numeric constant
> make: *** [dbdimp.o] Error 1
>
> I have searched for 'ulong', but have not been able to find it nor
> declare it.
>
> Please let me know what I should do to correct the problem.
>
> Thanks so much!
> joe
(Continue reading)

Permalink | Reply | 0 comments |
headers
Sven Neuhaus | 8 Feb 2007 12:33
Picon
Favicon

UTF8-bit not set for columns with "utf8_bin" collation

Hello folks,

I'm using the latest and greatest DBD::mysql 4.001 and connect to the
database with the "mysql_enable_utf8" flag set.

I noticed that the UTF-8-bit in perl is set correctly for data fetched from
columns with the collations utf8_general_ci and utf8_unicode_ci, but not for
the collation utf8_bin (which is currently the only case-sensitive collation
for UTF-8).

I opened a bug for this issue at
http://rt.cpan.org/Public/Bug/Display.html?id=24738
but didn't get a reaction yet so I thought I'd bring it up here, too.

I looked at the source code, but it merely seems to call
sv_utf8_decode() in dbdimp.c line 3559.
I'm not sure why this fails with utf8_bin collation. Perhaps
the data isn't even of type MYSQL_TYPE_STRING with this collation?

Regards,
-Sven Neuhaus

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Permalink | Reply | 0 comments |
headers
Frederic TYNDIUK | 14 Feb 2007 18:20

DBD-mysql-4.001


	I've found bug, when I use setlocale( LC_ALL, 'fr_FR' ).
In french dot under number are ',' and not '.' that why theme are a bug
like this:

install_driver(mysql) failed: DBD::mysql object version 4.001 does not
match bootstrap parameter 4,001 at
/usr/lib/perl5/5.8.4/i486-linux/DynaLoader.pm line 253.
Compilation failed in require at (eval 28) line 3.

	Could you had correct into next version...

	Thanks...

		Frederic

-- 
Frederic TYNDIUK         Developpeur / Admin Systeme WEBFUTUR
f.t <at> webfutur.com         http://www.webfutur.com/
Tel: +33 5.56.12.61.10 / Fax: +33 5.56.12.61.19
skype:webfutur_tech_frederic

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Permalink | Reply | 2 comments |
headers
Sven Neuhaus | 15 Feb 2007 09:10
Picon
Favicon

Re: DBD-mysql-4.001

Frederic TYNDIUK wrote:
> 	I've found bug, when I use setlocale( LC_ALL, 'fr_FR' ).
> In french dot under number are ',' and not '.' that why theme are a bug
> like this:
> 
> install_driver(mysql) failed: DBD::mysql object version 4.001 does not
> match bootstrap parameter 4,001 at
> /usr/lib/perl5/5.8.4/i486-linux/DynaLoader.pm line 253.
> Compilation failed in require at (eval 28) line 3.
> 
> 	Could you had correct into next version...

We stumbled upon the same bug. It seems the version numbers used to be a
string, now it's an integer so the decimal point is changed into a comma for
some locales.

-Sven

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Permalink | Reply | 1 comment |
headers
Patrick Galbraith | 15 Feb 2007 13:40

Re: DBD-mysql-4.001

Sven Neuhaus wrote:

>Frederic TYNDIUK wrote:
>  
>
>>	I've found bug, when I use setlocale( LC_ALL, 'fr_FR' ).
>>In french dot under number are ',' and not '.' that why theme are a bug
>>like this:
>>
>>install_driver(mysql) failed: DBD::mysql object version 4.001 does not
>>match bootstrap parameter 4,001 at
>>/usr/lib/perl5/5.8.4/i486-linux/DynaLoader.pm line 253.
>>Compilation failed in require at (eval 28) line 3.
>>
>>	Could you had correct into next version...
>>    
>>
>
>We stumbled upon the same bug. It seems the version numbers used to be a
>string, now it's an integer so the decimal point is changed into a comma for
>some locales.
>
>-Sven
>  
>
Frederic and Sven,

I'll take a look into this - seems that it needs to be a string to avoid 
this sort of problem.
(Continue reading)

Permalink | Reply | 0 comments |
headers
Kiran Annaiah | 18 Feb 2007 01:25
Picon
Favicon

date insert into mysql

I am having trouble inserting date into mysql from my perl DBI script.

my date format is in mon/day/yyyy format.

Should i split it and rearrange it to look like yyyy-mm-dd before inserting?

i am using mysql 5.0

_________________________________________________________________
Refi Now: Rates near 39yr lows!  $430,000 Mortgage for $1,399/mo - Calculate 
new payment 
http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-17727&moid=7581

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Permalink | Reply | 2 comments |
headers
Daniel Kasak | 18 Feb 2007 02:01
Picon

Re: date insert into mysql

Kiran Annaiah wrote:

> I am having trouble inserting date into mysql from my perl DBI script.
>
> my date format is in mon/day/yyyy format.
>
> Should i split it and rearrange it to look like yyyy-mm-dd before
> inserting?

That's right.

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Permalink | Reply | 0 comments |
headers
Marius Feraru | 18 Feb 2007 02:30
Favicon
Gravatar

Re: date insert into mysql


Kiran Annaiah wrote:
> I am having trouble inserting date into mysql from my perl DBI script.
> 
> my date format is in mon/day/yyyy format.
> 
> Should i split it and rearrange it to look like yyyy-mm-dd before 
> inserting?
> 
> i am using mysql 5.0

or use "STR_TO_DATE". e.g.: str_to_date('2/18/2007', '%m/%d/%Y')

RTFM: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

--
Marius Feraru
Permalink | Reply | 0 comments |
headers
Michael Janis | 22 Feb 2007 01:52

DBD::mysql install problem cygwin

Hi,

I am experiencing problems installing DBD-mysql with cygwin.  I closely
followed the instructions
(http://search.cpan.org/dist/DBD-mysql/lib/DBD/mysql/INSTALL.pod#Windows%2FC
ygWin) for installation via cygwin.  During the build MySQL clients under
Cygwin process I had to use make -j1 in order to avoid fork errors (this is
a dual core system, see below).

The output of build DBD::mysql:

user <at> compName ~/mysqlsource/DBD-mysql-4.001

$ cp /usr/local/mysql/bin/mysql_config . 

$ perl Makefile.PL --testhost=127.0.0.1 --testuser=xxxxx
--testpassword=xxxxx

I will use the following settings for compiling and testing:

  cflags        (mysql_config ) = -I/usr/local/mysql/include/mysql

  embedded      (mysql_config ) = 

  libs          (mysql_config ) = -L/usr/local/mysql/lib/mysql -lmysqlclient
-lz -lcrypt -lm

  mysql_config  (guessed      ) = mysql_config

  nocatchstderr (default      ) = 0
(Continue reading)

Permalink | Reply | 0 comments |

Gmane