From: Alexandru Gari-N. <ale...@ya...> - 2007-08-02 17:24:40
|
I have also tried to run example.php which comes with rlib installation pac= kage (b/m is reffering to the example from the pdf user's manual).=0Ait loo= ks like the data is coming from MySQL but still there are some errors:=0A= =0A[root@csct-local ~]# mysql -u rlib -p=0AEnter password:=0AWelcome to the= MySQL monitor. Commands end with ; or \g.=0AYour MySQL connection id is 6= =0AServer version: 5.2.3-falcon-alpha-log MySQL Community Server (GPL)=0A= =0AType 'help;' or '\h' for help. Type '\c' to clear the buffer.=0A=0Amysql= > use rlib=0ADatabase changed=0Amysql> select * from products;=0A+----+----= ---------+--------------------+------+----------+=0A| rn | plunum | na= me | type | category |=0A+----+-------------+----------------= ----+------+----------+=0A| 1 | 10000000006 | NRS | 9999 | = 0 |=0A| 2 | 10000000008 | food sales | 9999 | 0 |=0A= | 3 | 10000000005 | overring | 9999 | 0 |=0A| 4 | 100000= 00007 | refund | 9999 | 0 |=0A| 5 | 10000000010 | gift = cert sales | 9999 | 0 |=0A| 6 | 10000000011 | other sales = | 9999 | 0 |=0A| 7 | 10000000001 | EI Sales | 9999 | = 0 |=0A| 8 | 10000000002 | TO Sales | 9999 | 0 |=0A| = 9 | 10000000003 | DT Sales | 9999 | 0 |=0A| 10 | 100000000= 09 | nonfood sales | 9999 | 0 |=0A| 11 | 10000000013 | credits = issued | 9999 | 0 |=0A| 12 | 10000000014 | promo sales | = 9999 | 0 |=0A| 13 | 10000000015 | gift cert redeemed | 9999 | = 0 |=0A| 14 | 10000000060 | reserved | 9999 | 0 |=0A+----+= -------------+--------------------+------+----------+=0A14 rows in set (0.0= 0 sec)=0A=0A=0Atrying to open example.php in the browser brings the followi= ng error (data from products table is clearly within the error body):=0A=0A= Warning: Header may not contain more than a single header, new line detect= ed. in /var/www/html/rlib/example.php on line 13=0A=0A%PDF-1.3=0A1 0 obj=0A= <<=0A/Type /Pages=0A/Count 1=0A/Kids [ 6 0 R ]=0A>>=0Aendobj=0A2 0 obj=0A<<= =0A/Type /Font=0A/Subtype /Type1=0A/Name /Frpdf0=0A/BaseFont /Courier=0A/En= coding /WinAnsiEncoding=0A>>=0Aendobj=0A3 0 obj=0A<<=0A/Type /Outlines=0A/C= ount 0=0A>>=0Aendobj=0A4 0 obj=0A[/PDF /Text ]=0Aendobj=0A5 0 obj=0A<>=0Ast= ream=0A1.0000 0.0000 0.0000 1.0000 0.0000 792.0000 cm=0A0.0000 -1.0000 1.00= 00 0.0000 0.0 0.0 cm=0ABT=0A/Frpdf0 9.000 Tf=0A1.0000 0.0000 -0.0000 1.0000= 14.4000 16.5600 Tm=0A(Page: 1) Tj=0A/Frpdf0 12.000 Tf=0A1.0000 0.0000 -0= .0000 1.0000 14.4000 579.4800 Tm=0A(Products Report) Tj=0A/Frpdf0 9.000 Tf= =0A0.0000 0.0000 0.0000 rg=0A0.0000 0.0000 0.0000 RG=0AET=0A14.400 561.600 = 763.200 1.856 re=0Af=0ABT=0A/Frpdf0 11.000 Tf=0A1.0000 0.0000 -0.0000 1.000= 0 14.4000 549.2400 Tm=0A(Products Report \(Page Header\)) Tj=0A/Frpdf0 9.00= 0 Tf=0AET=0A14.400 541.600 763.200 0.856 re=0Af=0A0.8980 0.8980 0.8980 rg= =0A0.8980 0.8980 0.8980 RG=0A14.400 532.600 313.200 8.856 re=0Af=0A0.0000 0= .0000 0.0000 rg=0A0.0000 0.0000 0.0000 RG=0ABT=0A1.0000 0.0000 -0.0000 1.00= 00 14.4000 534.7600 Tm=0A(Number Name Type C= ategory ) Tj=0AET=0A14.400 531.600 763.200 0.856 re=0Af=0ABT=0A1.0000 0.00= 00 -0.0000 1.0000 14.4000 520.7600 Tm=0A(10000000006 NRS = 9999 0 ) Tj=0A0.8980 0.8980 0.8980 rg=0A0.8980 0.8980 0.89= 80 RG=0AET=0A14.400 509.600 313.200 8.856 re=0Af=0A0.0000 0.0000 0.0000 rg= =0A0.0000 0.0000 0.0000 RG=0ABT=0A1.0000 0.0000 -0.0000 1.0000 14.4000 511.= 7600 Tm=0A(10000000008 food sales 9999 0 ) Tj= =0A1.0000 0.0000 -0.0000 1.0000 14.4000 502.7600 Tm=0A(10000000005 over= ring 9999 0 ) Tj=0A0.8980 0.8980 0.8980 rg=0A0.89= 80 0.8980 0.8980 RG=0AET=0A14.400 491.600 313.200 8.856 re=0Af=0A0.0000 0.0= 000 0.0000 rg=0A0.0000 0.0000 0.0000 RG=0ABT=0A1.0000 0.0000 -0.0000 1.0000= 14.4000 493.7600 Tm=0A(10000000007 refund 9999 0 = ) Tj=0A1.0000 0.0000 -0.0000 1.0000 14.4000 484.7600 Tm=0A(100000000= 10 gift cert sales 9999 0 ) Tj=0A0.8980 0.8980 0.898= 0 rg=0A0.8980 0.8980 0.8980 RG=0AET=0A14.400 473.600 313.200 8.856 re=0Af= =0A0.0000 0.0000 0.0000 rg=0A0.0000 0.0000 0.0000 RG=0ABT=0A1.0000 0.0000 -= 0.0000 1.0000 14.4000 475.7600 Tm=0A(10000000011 other sales 9= 999 0 ) Tj=0A1.0000 0.0000 -0.0000 1.0000 14.4000 466.7600 Tm= =0A(10000000001 EI Sales 9999 0 ) Tj=0A0.8980= 0.8980 0.8980 rg=0A0.8980 0.8980 0.8980 RG=0AET=0A14.400 455.600 313.200 8= .856 re=0Af=0A0.0000 0.0000 0.0000 rg=0A0.0000 0.0000 0.0000 RG=0ABT=0A1.00= 00 0.0000 -0.0000 1.0000 14.4000 457.7600 Tm=0A(10000000002 TO Sales = 9999 0 ) Tj=0A1.0000 0.0000 -0.0000 1.0000 14.4000 = 448.7600 Tm=0A(10000000003 DT Sales 9999 0 ) = Tj=0A0.8980 0.8980 0.8980 rg=0A0.8980 0.8980 0.8980 RG=0AET=0A14.400 437.60= 0 313.200 8.856 re=0Af=0A0.0000 0.0000 0.0000 rg=0A0.0000 0.0000 0.0000 RG= =0ABT=0A1.0000 0.0000 -0.0000 1.0000 14.4000 439.7600 Tm=0A(10000000009 = nonfood sales 9999 0 ) Tj=0A1.0000 0.0000 -0.0000 1.0= 000 14.4000 430.7600 Tm=0A(10000000013 credits issued 9999 = 0 ) Tj=0A0.8980 0.8980 0.8980 rg=0A0.8980 0.8980 0.8980 RG=0AET=0A1= 4.400 419.600 313.200 8.856 re=0Af=0A0.0000 0.0000 0.0000 rg=0A0.0000 0.000= 0 0.0000 RG=0ABT=0A1.0000 0.0000 -0.0000 1.0000 14.4000 421.7600 Tm=0A(1000= 0000014 promo sales 9999 0 ) Tj=0A1.0000 0.0000 = -0.0000 1.0000 14.4000 412.7600 Tm=0A(10000000015 gift cert redeemed = 9999 0 ) Tj=0A0.8980 0.8980 0.8980 rg=0A0.8980 0.8980 0.8980 = RG=0AET=0A14.400 401.600 313.200 8.856 re=0Af=0A0.0000 0.0000 0.0000 rg=0A0= .0000 0.0000 0.0000 RG=0ABT=0A1.0000 0.0000 -0.0000 1.0000 14.4000 403.7600= Tm=0A(10000000060 reserved 9999 0 ) Tj=0AET= =0A=0Aendstream=0Aendobj=0A6 0 obj=0A<<=0A/Type /Page=0A/Parent 1 0 R=0A/Re= sources <<=0A/Font <<=0A/Frpdf0 2 0 R=0A>>=0A/ProcSet 4 0 R >>=0A/MediaBox = [0 0 612 792]=0A/CropBox [0 0 612 792]=0A/Rotate 270=0A/Contents 5 0 R=0A>>= =0Aendobj=0A7 0 obj=0A<<=0A/Creator (RPDF By SICOM Systems)=0A/CreationDate= (D:20070728052005)=0A/Producer (RPDF 1.0)=0A/Author (RPDF)=0A/Title (RLIB = Report)=0A/Subject (None)=0A/Keywords (RPDF)=0A>>=0Aendobj=0A8 0 obj=0A<<= =0A/Type /Catalog=0A/Pages 1 0 R=0A/Outlines 3 0 R=0A>>=0Aendobj=0Axref=0A0= 9=0A0000000000 65535 f =0A0000000009 00000 n =0A0000000068 00000 n =0A0000= 000177 00000 n =0A0000000223 00000 n =0A0000000252 00000 n =0A0000003646 00= 000 n =0A0000003826 00000 n =0A0000004003 00000 n =0Atrailer=0A<<=0A/Size 9= =0A/Root 8 0 R=0A/Info 7 0 R=0A>>=0Astartxref=0A4068=0A%%EOF=0A=0A=0Aagain = appreciate if anyone can help me,=0AAlex=0A=0A----- Original Message ----= =0AFrom: Alexandru Gari-Negut <ale...@ya...>=0ATo: rlib-users@lists.s= ourceforge.net=0ACc: rli...@li...=0ASent: Thursday, August 2, 20= 07 7:43:38 PM=0ASubject: Re: post-install problems with RLIB=0A=0AHello,=0A= I finally installed RLIB 1.3.7 after solving glib-2.0 dependency problem on= a Fedora Core 6 running Apache, PHP & MySQL.=0AWhile trying to run the exa= mple.php as per the PDF manual available on http://rlib.sicompos.com/ I had= encountered the following error messages:=0A=0A=0A=0AWarning: rlib_execut= e() [function.rlib-execute]: report.xml:6: parser error : Input is not prop= er UTF-8, indicate encoding !=0ABytes: 0x92 0x6C 0x6F 0x67 in /var/www/html= /rlib.php on line 12=0A=0A=0A=0AWarning: rlib_execute() [function.rlib-exe= cute]: <Image value=3D"=A2logo.jpg=A2" type=3D"=A2jpeg=A2" width=3D"50" hei= ght=3D"50"/> in /var/www/html/rlib.php on line 12=0A=0A=0A=0AWarning: rlib= _execute() [function.rlib-execute]: ^ in /var/www/html/rlib.p= hp on line 12=0A=0A=0A=0AWarning: Cannot modify header information - heade= rs already sent by (output started at /var/www/html/rlib.php:12) in /var/ww= w/html/rlib.php on line 13=0A=0A=0ACan anyone try to help me figuring out w= hat is missing so I can run the sample report against the MySQL database?= =0A=0AThanks in advance,=0AAlex=0A=0A=0A=0A=0A=0A=0A _________________= ___________________________________________________________________=0AShape= Yahoo! in your own image. Join our Network Research Panel today! http:/= /surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=3D7 =0A=0A=0A=0A=0A=0A= =0A=0A =0A___________________________________________________________= _________________________=0AMoody friends. Drama queens. Your life? Nope! -= their life, your story. Play Sims Stories at Yahoo! Games.=0Ahttp://sims.y= ahoo.com/ |