SOLVED Problem exporting queryresult to Excel (or csv-file)

Problems with the Linux version of XAMPP, questions, comments, and anything related.

SOLVED Problem exporting queryresult to Excel (or csv-file)

Postby Bauke » 13. October 2006 18:49

Hello,

I'm trying to export a fine running query to Excel.

I getting a file with:

Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/phpmyadmin/export.php:126) in /opt/lampp/phpmyadmin/libraries/ob.lib.php on line 61
Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/phpmyadmin/export.php:126) in /opt/lampp/phpmyadmin/libraries/header_http.inc.php on line 13
Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/phpmyadmin/export.php:126) in /opt/lampp/phpmyadmin/libraries/header_http.inc.php on line 14
Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/phpmyadmin/export.php:126) in /opt/lampp/phpmyadmin/libraries/header_http.inc.php on line 15
Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/phpmyadmin/export.php:126) in /opt/lampp/phpmyadmin/libraries/header_http.inc.php on line 16
Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/phpmyadmin/export.php:126) in /opt/lampp/phpmyadmin/libraries/header_http.inc.php on line 19
<?xml version="1.0" encoding="utf-8"?>
Server: localhost Database: biljart Tabel: wedstrijden
Fout
SQL-query:
SELECT DATE_FORMAT( w_datum, '%d-%m-%y' ) AS Datum, w_ronde AS Ronde, w_wnr AS "Wedstr. nr", w_brtn AS Beurten, speler AS Speler, l_naam AS Naam, temaken AS "Te maken", car AS "Caramb.", perc AS "Perc.", berpunten AS Punten, Afwgem AS "Afw. gem."
FROM (
SELECT w_seizoen, w_datum, w_ronde, w_wnr, w_brtn, w_speler1 AS speler, w_s1_temaken AS temaken, w_s1_car AS car, ROUND( w_s1_car / w_s1_temaken *100, 3 ) AS perc, IF( ROUND( w_s1_car / w_s1_temaken *100, 3 ) >=100
AND ROUND( w_s2_car / w_s2_temaken *100, 3 ) >=100, 1, IF( ROUND( w_s1_car / w_s1_temaken *100, 3 ) = ROUND( w_s2_car / w_s2_temaken *100, 3 ) , 1, IF( ROUND( w_s1_car / w_s1_temaken *100, 3 ) > ROUND( w_s2_car / w_s2_temaken *100, 3 )
AND ROUND( w_s1_car / w_s1_temaken *100, 3 ) >=100, 3, IF( ROUND( w_s1_car / w_s1_temaken *100, 3 ) > ROUND( w_s2_car / w_s2_temaken *100, 3 )
AND ROUND( w_s1_car / w_s1_temaken *100, 3 ) <100, 2, 0 ) ) ) ) AS berpunten, ROUND( w_s1_car / w_brtn, 4 ) - ROUND( w_s1_temaken /25, 4 ) AS Afwgem
FROM wedstrijden
WHERE w_seizoen = "2006/07"
UNION ALL SELECT w_seizoen, w_datum, w_ronde, w_wnr, w_brtn, w_speler2 AS speler, w_s2_temaken AS temaken, w_s2_car AS car, ROUND( w_s2_car / w_s2_temaken *100, 3 ) AS perc, IF( ROUND( w_s2_car / w_s2_temaken *100, 3 ) >=100
AND ROUND( w_s1_car / w_s1_temaken *100, 3 ) >=100, 1, IF( ROUND( w_s2_car / w_s2_temaken *100, 3 ) = ROUND( w_s1_car / w_s1_temaken *100, 3 ) , 1, IF( ROUND( w_s2_car / w_s2_temaken *100, 3 ) > ROUND( w_s1_car / w_s1_temaken *100, 3 )
AND ROUND( w_s2_car / w_s2_temaken *100, 3 ) >=100, 3, IF( ROUND( w_s2_car / w_s2_temaken *100, 3 ) > ROUND( w_s1_car / w_s1_temaken *100, 3 )
AND ROUND( w_s2_car / w_s2_temaken *100, 3 ) <100, 2, 0 ) ) ) ) AS berpunten, ROUND( w_s2_car / w_brtn, 4 ) - ROUND( w_s2_temaken /25, 4 ) AS Afwgem
FROM wedstrijden
WHERE w_seizoen = "2006/07") AS d
INNER JOIN leden ON l_id = d.speler
ORDER BY w_wnr DESC , punten DESC
LIMIT 36
MySQL retourneerde:
#1305 - FUNCTION biljart.ROUND does not exist

Does anyone knows what is wrong?
Yesterday this went oke. I had to re-install XAMPP and I have no idea of what might be different.

Thanks in advance from a Dutch newbie.

Bauke
Last edited by Bauke on 16. October 2006 09:08, edited 1 time in total.
Bauke
 
Posts: 2
Joined: 13. October 2006 15:30

Postby Bauke » 16. October 2006 09:07

SOLVED!

I had (don't know how) a couple of trailing spaces on the lasr row of my config file. Removed them and everything goes fine now!

Bauke
Bauke
 
Posts: 2
Joined: 13. October 2006 15:30


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 16 guests