Bugs item #811222, was opened at 2003-09-23 11:26
Message generated for change (Settings changed) made by lem9
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=811222&group_id=23067
Category: PHP errors
Group: 2.5.3
Status: Open
Resolution: None
Priority: 5
Submitted By: Ryan Schmidt (ryandesign)
>Assigned to: Marc Delisle (lem9)
Summary: Undefined index sql.php 424 using field name alias
Initial Comment:
I executed this statement in my database:
SELECT product_id, partnum AS part_number,
erp_description, erp_notes, cf_description
FROM `import`
No problem. Then I click the "Export" link at the bottom to
generate SQL INSERT statements from the result set. After
specifying my export options, I get output starting like this:
# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Host: monolith
# Generation Time: Sep 23, 2003 at 05:14 PM
# Server version: 4.0.14
# PHP Version: 4.3.3
#
# Database : `dev_h`
#
#
# Dumping data for table `import`
#
Notice: Undefined index: `part_number` in /Library/
WebServer/phpMyAdmin-2.5.3/libraries/export/sql.php on
line 424
INSERT INTO `import` (`product_id`, `part_number`,
`erp_description`, `erp_notes`, `cf_description`) VALUES
(280, 'XY123', 'Multi-Purpose Cable, 25\'', '6 pin connector
both ends.', 'Multi-Purpose Cable, 25\'. 6 pin connector both
ends.');
The part_number field is filled in correctly in the dump, and
all the rows appear to be there and correct. Just, there's this
"undefined index" error referencing the one alias I used in
the SQL statement.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=811222&group_id=23067
|
