初投稿です。よろしくお願いいたします。

題名の通りです。

過去ログを参考に

----------------------------------
order_id as "オーダー番号",
update_date as "受注日",
concat(order_name01,order_name02) as "注文者名",
product_name as "商品名",
price as "価格",
payment_method as "決済方法",
concat(deliv_name01, deliv_name02) as "宛名",
concat(deliv_kana01,deliv_kana02) as "宛名フリガナ",
concat(deliv_tel01,deliv_tel02,deliv_tel03) as "電話番号",
concat(deliv_zip01,deliv_zip02) as "配送先郵便番号",
concat(mtb_pref.pref_name,deliv_addr01,deliv_addr02) as "配送先住所",
deliv_date as "配送日",
deliv_time as "配送時間",
note as "メモ欄"
FROM
mtb_pref , dtb_order join dtb_order_detail using(order_id)
WHERE
dtb_order.deliv_pref=mtb_pref.pref_id AND dtb_order.status = 6
-------------------------------

のように、
高度な設定の欄に入力して、
登録してもエラーが出力されます。

deliv_name01などがdbの方にないというエラーだと思います。

↓エラー
-----------------------------------
MDB2 Error: no such field
_doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3050f059eb9e89bbd7ea0dbc5d45a98f02cfb1a8d FROM 'SELECT order_id as \"オーダー番号\", update_date as \"受注日\", concat(order_name01,order_name02) as \"注文者名\", product_name as \"商品名\", price as \"価格\", payment_method as \"決済方法\", concat(deliv_name01, deliv_name02) as \"宛名\", concat(deliv_kana01,deliv_kana02) as \"宛名フリガナ\", concat(deliv_tel01,deliv_tel02,deliv_tel03) as \"電話番号\", concat(deliv_zip01,deliv_zip02) as \"配送先郵便番号\", concat(mtb_pref.pref_name,deliv_addr01,deliv_addr02) as \"配送先住所\", deliv_date as \"配送日\", deliv_time as \"配送時間\", note as \"メモ欄\" FROM mtb_pref , dtb_order join dtb_order_detail using(order_id) WHERE dtb_order.deliv_pref=mtb_pref.pref_id AND dtb_order.status = 6 ']
[Native code: 1054]
[Native message: Unknown column 'deliv_name01' in 'field list']
-----------------------------------


おそらくバージョンの違いからによるものだと思いますが、
下記環境でやっております。


2.11.1
PHPバージョン PHP 5.2.14
DBバージョン MySQL 5.0.90-log



phpmyadminはログインできます。
dbがあまり詳しくなく、ご教授いただければ幸いです。