Ошибка SQL

[vitkom 0]

MYSQL ERROR REPORT
- 08/10/2014 11:10:07
---------------------------------------
1054 - Unknown column 'edit_orders' in 'field list'

select `edit_orders` from admin_access where customers_id = '1'
---------------------------------------
Server Name : www.XXXX.XX
Remote Address: XX.XX.XX.XX
Referer : http://www.XXX.XX/admin/orders.php?oID=433&action=edit
Requested : /admin/edit_orders.php?oID=433&cID=0
Trace Back : admin/edit_orders.php:28(requirearray(1) {; [0]=>; string(48) "admin/includes/application_top.php"; }; ) => admin/includes/application_top.php:526(vam_check_permissionarray(1) {; [0]=>; &string(11) "edit_orders"; }; ) => admin/includes/functions/general.php:113(vam_db_queryarray(1) {; [0]=>; &string(63) "select `edit_orders` from admin_access where customers_id = '1'"; }; ) => inc/vam_db_query.inc.php:34(vam_db_errorarray(3) {; [0]=>; &string(63) "select `edit_orders` from admin_access where customers_id = '1'"; [1]=>; &int(1054); [2]=>; &string(44) "Unknown column 'edit_orders' in 'field list'"; }; )

 

 

и еще вопрос как установить карту по IP

 

Спасибо

[support 447]

Вы патчами свой магазин обновляли?

Видимо, sql файл из патчей не загружали в базу данных.

 

Насчёт карты не знаю, подобные сервиы обычно предоставляют готовый html-код, который Вы к себе на сайт вставляете.

[vitkom 0]

когда а переставлял ubuntu, я установил v.173 , потом поверх неё просто перекопировал файлы и после этого поднял бэкап.

 

А теперь, что теперь делать ?

Не подскажите ?

 

 

Спасибо

[support 447]

admin_access таблица на месте?!

 

В ней должна быть колонка edit_orders

[vitkom 0]

хотел обновить статус покупателя

 

MYSQL ERROR REPORT
- 08/10/2014 15:10:58
---------------------------------------
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and ot.class = 'ot_total' and ( o.orders_status = 4)' at line 1

select sum(ot.value) as total from orders_total as ot, orders as o where ot.orders_id = o.orders_id and o.customers_id = and ot.class = 'ot_total' and ( o.orders_status = 4);
---------------------------------------
Server Name :
Remote Address: 62.205.214.123
Referer :
Requested : /admin/orders.php
Trace Back : admin/orders.php:183(vam_db_queryarray(1) {; [0]=>; &string(175) "select sum(ot.value) as total from orders_total as ot, orders as o where ot.orders_id = o.orders_id and o.customers_id = and ot.class = 'ot_total' and ( o.orders_status = 4);"; }; ) => inc/vam_db_query.inc.php:34(vam_db_errorarray(3) {; [0]=>; &string(175) "select sum(ot.value) as total from orders_total as ot, orders as o where ot.orders_id = o.orders_id and o.customers_id = and ot.class = 'ot_total' and ( o.orders_status = 4);"; [1]=>; &int(1064); [2]=>; &string(198) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and ot.class = 'ot_total' and ( o.orders_status = 4)' at line 1"; }; )

[vitkom 0]

admin_access -> столбцы

 

 

edit_orders вроде нет

[support 447]

В phpMyAdmin, в закладке SQL выполните код:

 

DROP TABLE IF EXISTS admin_access;

CREATE TABLE `admin_access` (

  `customers_id` varchar(255) NOT NULL default '0',

  `configuration` int(1) NOT NULL default '0',

  `modules` int(1) NOT NULL default '0',

  `countries` int(1) NOT NULL default '0',

  `currencies` int(1) NOT NULL default '0',

  `zones` int(1) NOT NULL default '0',

  `geo_zones` int(1) NOT NULL default '0',

  `tax_classes` int(1) NOT NULL default '0',

  `tax_rates` int(1) NOT NULL default '0',

  `accounting` int(1) NOT NULL default '0',

  `backup` int(1) NOT NULL default '0',

  `cache` int(1) NOT NULL default '0',

  `server_info` int(1) NOT NULL default '0',

  `whos_online` int(1) NOT NULL default '0',

  `languages` int(1) NOT NULL default '0',

  `define_language` int(1) NOT NULL default '0',

  `orders_status` int(1) NOT NULL default '0',

  `shipping_status` int(1) NOT NULL default '0',

  `module_export` int(1) NOT NULL default '0',

  `customers` int(1) NOT NULL default '0',

  `create_account` int(1) NOT NULL default '0',

  `customers_status` int(1) NOT NULL default '0',

  `orders` int(1) NOT NULL default '0',

  `campaigns` int(1) NOT NULL default '0',

  `print_packingslip` int(1) NOT NULL default '0',

  `print_order` int(1) NOT NULL default '0',

  `popup_memo` int(1) NOT NULL default '0',

  `coupon_admin` int(1) NOT NULL default '0',

  `listcategories` int(1) NOT NULL default '0',

  `gv_queue` int(1) NOT NULL default '0',

  `gv_mail` int(1) NOT NULL default '0',

  `gv_sent` int(1) NOT NULL default '0',

  `validproducts` int(1) NOT NULL default '0',

  `validcategories` int(1) NOT NULL default '0',

  `mail` int(1) NOT NULL default '0',

  `categories` int(1) NOT NULL default '0',

  `new_attributes` int(1) NOT NULL default '0',

  `products_attributes` int(1) NOT NULL default '0',

  `manufacturers` int(1) NOT NULL default '0',

  `reviews` int(1) NOT NULL default '0',

  `specials` int(1) NOT NULL default '0',

  `stats_products_expected` int(1) NOT NULL default '0',

  `stats_products_viewed` int(1) NOT NULL default '0',

  `stats_products_purchased` int(1) NOT NULL default '0',

  `stats_customers` int(1) NOT NULL default '0',

  `stats_sales_report` int(1) NOT NULL default '0',

  `stats_campaigns` int(1) NOT NULL default '0',

  `banner_manager` int(1) NOT NULL default '0',

  `banner_statistics` int(1) NOT NULL default '0',

  `module_newsletter` int(1) NOT NULL default '0',

  `start` int(1) NOT NULL default '0',

  `content_manager` int(1) NOT NULL default '0',

  `content_preview` int(1) NOT NULL default '0',

  `credits` int(1) NOT NULL default '0',

  `blacklist` int(1) NOT NULL default '0',

  `orders_edit` int(1) NOT NULL default '0',

  `popup_image` int(1) NOT NULL default '0',

  `csv_backend` int(1) NOT NULL default '0',

  `products_vpe` int(1) NOT NULL default '0',

  `cross_sell_groups` int(1) NOT NULL default '0',

  `fck_wrapper` int(1) NOT NULL default '0',

  `easypopulate` int(1) NOT NULL default '0',

  `quick_updates` int(1) NOT NULL default '0',

  `latest_news` int(1) NOT NULL default '0',

  `recover_cart_sales` int(1) NOT NULL default '0',

  `featured` int(1) NOT NULL default '0',

  `cip_manager` int(1) NOT NULL default '0',

  `authors` int(1) NOT NULL default '0',

  `articles` int(1) NOT NULL default '0',

  `articles_config` int(1) NOT NULL default '0',

  `stats_sales_report2` int(1) NOT NULL default '0',

  `chart_data` int(1) NOT NULL default '0',

  `articles_xsell` int(1) NOT NULL default '0',

  `email_manager` int(1) NOT NULL default '0',

  `category_specials` int(1) NOT NULL default '0',

  `products_options` int(1) NOT NULL default '0',

  `product_extra_fields` int(1) NOT NULL default '0',

  `ship2pay` int(1) NOT NULL default '0',

  `faq` int(1) NOT NULL default '0',

  `affiliate_affiliates` int(1) NOT NULL default '0',

  `affiliate_banners` int(1) NOT NULL default '0',

  `affiliate_clicks` int(1) NOT NULL default '0',

  `affiliate_contact` int(1) NOT NULL default '0',

  `affiliate_invoice` int(1) NOT NULL default '0',

  `affiliate_payment` int(1) NOT NULL default '0',

  `affiliate_popup_image` int(1) NOT NULL default '0',

  `affiliate_sales` int(1) NOT NULL default '0',

  `affiliate_statistics` int(1) NOT NULL default '0',

  `affiliate_summary` int(1) NOT NULL default '0',

  `customer_extra_fields` int(1) NOT NULL default '0',

  `select_featured` int(1) NOT NULL default '0',

  `select_special` int(1) NOT NULL default '0',

  `yml_import` int(1) NOT NULL default '0',

  `customer_export` int(1) NOT NULL default '0',

  `exportorders` int(1) NOT NULL default '0',

  `pin_loader` int(1) NOT NULL default '0',

  `edit_orders` int(1) NOT NULL default '0',

  `edit_orders_add_product` int(1) NOT NULL default '0',

  `edit_orders_ajax` int(1) NOT NULL default '0',

  `products_specifications` int(1) NOT NULL default '0',

  `attributeManager` int(1) NOT NULL default '0',

  `answer_templates` int(1) NOT NULL default '0',

  PRIMARY KEY  (`customers_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;

 

INSERT  INTO admin_access VALUES ( 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);

INSERT  INTO admin_access VALUES ( 'groups', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 3, 3, 3, 3, 3, 3, 3, 4, 4, 4, 4, 2, 4, 2, 2, 2, 2, 5, 5, 5, 5, 5, 5, 5, 5, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);

[vitkom 0]

Появилась, спасибо

[support 447]

Не за что, хотя такой ошибки по умолчанию быть не должно.