savelyalex » 17 фев 2016, 10:28
Пишет буквально следующее:
root@kassir1:/usr/bin# dnc_dbupdate
trying config file: /home/kassir/.dnc/LinCash_db.conf
file not found. trying config file: /etc/dancy/LinCash_db.conf
PQresultStatus() = PGRES_FATAL_ERROR = 7
dbname = LinCash
user name = kassir
command = DROP VIEW visual_search_view;
Error : ERROR: view "visual_search_view" does not exist
PQresultStatus() = PGRES_FATAL_ERROR = 7
dbname = LinCash
user name = kassir
command = CREATE OR REPLACE VIEW visual_search_view AS SELECT w.ware_id, w.internal_id, w.longtitle, w.shortcut, NULL::unknown AS addition_code, w.price, w.quantity, wb.barcode, w.alternate_vs, w.ware_type FROM ware w LEFT JOIN ware_barcode wb ON wb.internal_id::text = w.internal_id::text WHERE (wb.addition_code IS NULL OR wb.addition_code = '') UNION SELECT w.ware_id, w.internal_id, w.longtitle || sov.set_of_value as longtitle, w.shortcut || sov.set_of_value as shortcut, a.addition_code, a.addition_price AS price, a.addition_quantity AS quantity, ab.barcode, w.alternate_vs, w.ware_type FROM ware_additions a LEFT JOIN ware w ON a.ware_id = w.ware_id LEFT JOIN ware_barcode ab ON ab.addition_code = a.addition_code LEFT JOIN additions_set_of_value sov ON sov.addition_id = a.addition_id
Error : ERROR: column w.alternate_vs does not exist
LINE 1: ...S addition_code, w.price, w.quantity, wb.barcode, w.alternat...
^
AddVisualSearchViews ------------ create view sql request error
trying config file: /home/kassir/.dnc/Trans_db.conf
file not found. trying config file: /etc/dancy/Trans_db.conf
Transaction views was dropped...
Transaction views was added
trying config file: /home/kassir/.dnc/dnc_eds.conf
file not found. trying config file: /etc/dancy/dnc_eds.conf
End of Update
root@kassir1:/usr/bin#