2. PHPRunner General questions
  3. [SOLVED]  <<< Record was NOT edited >>>
This topic is locked
[SOLVED]

 <<< Record was NOT edited >>>

 		5/22/2007 2:11:10 PM
PHPRunner General questions
S
 spoilar author

Using PHPR 3.1 Build 218
Whenever I try to edit a record 'retdate', I get this error
<<< Record was NOT edited >>>
Unknown column 'ord.orders_id' in 'where clause'[/b]
Here is my table structure
--

-- Table structure for table `orders`

--
CREATE TABLE `orders` (

`orders_id` int(10) unsigned NOT NULL auto_increment,

`custno` mediumint(8) unsigned NOT NULL default '0',

`terr` char(1) NOT NULL default '',

`sono` mediumint(8) unsigned NOT NULL default '0',

`lineno` mediumint(8) unsigned NOT NULL default '0',

`ordate` date default NULL,

`retdate` date default NULL,

`ponum` varchar(20) NOT NULL default '',

`item` varchar(20) NOT NULL default '',

`descrip` varchar(50) default NULL,

`aloc_qty` mediumint(9) default NULL,

`bo_qty` mediumint(9) default NULL,

`ord_qty` mediumint(9) default NULL,

`customer` varchar(35) default NULL,

`addr1` varchar(30) default NULL,

`addr2` varchar(30) default NULL,

`addr3` varchar(30) default NULL,

`linestat` varchar(20) default NULL,

PRIMARY KEY (`orders_id`),

UNIQUE KEY `main` (`ponum`,`sono`,`lineno`)

) ENGINE=MyISAM AUTO_INCREMENT=2777 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2777 ;
anyone familiar with this error?
Sergey Kornilov admin 5/22/2007

It looks like you trying to edit a field that belongs to another table.

Make sure you don't Edit joined or calculated fields.
You can post your SQL query as it appears on "Edit SQL query" tab.
S
 		spoilar author 5/22/2007

I fixed it. It looks like it was a problem with a table alias.
original Edit Sql
[codebox]SELECT

`ord`.`orders_id`,

`ord`.`custno`,

`ord`.`terr`,

`bcno`.`lineno`,

IFNULL(`ship`.`shiptype`,`ord`.`linestat`) AS `stat`,

`ord`.`ponum`,

`ord`.`sono` AS `ordsono`,

`ship`.`invno`,

`ord`.`ordate`,

`ship`.`dateship`,

`ord`.`retdate`,

`ord`.`item`,

`ord`.`descrip`,

`bcno`.`bcn`,

`bcno`.`serialno`,

`ord`.`customer`,

CONCAT_WS('\r',`ord`.`addr1`,`ord`.`addr3`) AS `address`,

`ship`.`trackno`,

`ship`.`carrier`,

`ord`.`ord_qty`,

`ship`.`qtyship`,

`ship`.`sono` AS `shipsono`,

`bcno`.`sono` AS `bcnsono`

FROM

`orders` AS `ord`

Left Join `shipments` AS `ship` ON `ord`.`sono` = `ship`.`sono`

Left Join `bcn` AS `bcno` ON `ship`.`sono` = `bcno`.`sono`[/codebox]
fixed Edit Sql
[codebox]SELECT

`orders`.`orders_id`,

`orders`.`custno`,

`orders`.`terr`,

`bcno`.`lineno`,

IFNULL(`ship`.`shiptype`,`orders`.`linestat`) AS `stat`,

`orders`.`ponum`,

`orders`.`sono` AS `ordsono`,

`ship`.`invno`,

`orders`.`ordate`,

`ship`.`dateship`,

`orders`.`retdate`,

`orders`.`item`,

`orders`.`descrip`,

`bcno`.`bcn`,

`bcno`.`serialno`,

`orders`.`customer`,

CONCAT_WS('\r',`orders`.`addr1`,`orders`.`addr3`) AS `address`,

`ship`.`trackno`,

`ship`.`carrier`,

`orders`.`ord_qty`,

`ship`.`qtyship`,

`ship`.`sono` AS `shipsono`,

`bcno`.`sono` AS `bcnsono`

FROM

`orders`

Left Join `shipments` AS `ship` ON `orders`.`sono` = `ship`.`sono`

Left Join `bcn` AS `bcno` ON `ship`.`sono` = `bcno`.`sono`[/codebox]