SalesWarp - Ecommerce Simplified! Sell more. Make More. Manage Less

Warning (512): SQL Error: 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 '__setError' at line 1 [APP/cakecore/cake/libs/model/datasources/dbo_source.php, line 526]

Missing Method in UsersController

Error: The action register is not defined in controller UsersController

Error: Create UsersController::register() in file: html/controllers/users_controller.php.

<?php
class UsersController extends AppController {

	var $name = 'Users';


	function register() {

	}

}
?>

Notice: If you want to customize this error message, create html/views/errors/missing_action.ctp.

(ProductBase) 38 queries took 78 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `base_suppliers`		49	49	2
2	DESCRIBE `base_supplier_maps`		20	20	1
3	DESCRIBE `base_supplier_map_rulesets`		12	12	1
4	DESCRIBE `saleswarp_fields`		10	10	1
5	DESCRIBE `base_supplier_ruletypes`		9	9	1
6	DESCRIBE `base_supplier_actiontypes`		8	8	1
7	DESCRIBE `base_product_changes`		9	9	1
8	DESCRIBE `base_products`		72	72	2
9	DESCRIBE `base_products_base_suppliers`		51	51	1
10	DESCRIBE `base_categories`		31	31	5
11	DESCRIBE `seller_actions`		31	31	1
12	DESCRIBE `sellers`		33	33	2
13	DESCRIBE `seller_profiles`		5	5	7
14	DESCRIBE `base_stores`		42	42	5
15	DESCRIBE `publishing_channels`		5	5	7
16	DESCRIBE `publishing_maps`		11	11	1
17	DESCRIBE `seller_categories`		5	5	7
18	DESCRIBE `users`		31	31	1
19	DESCRIBE `groups`		11	11	1
20	DESCRIBE `base_categories_base_products`		8	8	5
21	DESCRIBE `base_categories_base_suppliers`		7	7	1
22	DESCRIBE `base_categories_base_stores`		30	30	8
23	DESCRIBE `base_pricechecks`		15	15	1
24	DESCRIBE `base_product_images`		15	15	1
25	DESCRIBE `base_product_xsells`		6	6	1
26	DESCRIBE `base_products_base_stores`		76	76	2
27	DESCRIBE `base_product_histories`		16	16	1
28	DESCRIBE `base_products_base_supplier_locations`		12	12	1
29	DESCRIBE `base_brands`		10	10	1
30	DESCRIBE `base_brands_base_products`		5	5	1
31	DESCRIBE `base_products_product_groups`		9	9	1
32	DESCRIBE `configs`		7	7	1
33	SELECT `Config`.`id`, `Config`.`key`, `Config`.`name`, `Config`.`value`, `Config`.`options`, `Config`.`weight`, `Config`.`tab` FROM `configs` AS `Config` WHERE `Config`.`key` = 'session_timeout_warning' ORDER BY `Config`.`weight` ASC LIMIT 1		0	0	1
34	SELECT `Config`.`id`, `Config`.`key`, `Config`.`name`, `Config`.`value`, `Config`.`options`, `Config`.`weight`, `Config`.`tab` FROM `configs` AS `Config` WHERE `Config`.`key` = 'session_timeout_ping_interval' ORDER BY `Config`.`weight` ASC LIMIT 1		0	0	0
35	SELECT `Config`.`id`, `Config`.`key`, `Config`.`name`, `Config`.`value`, `Config`.`options`, `Config`.`weight`, `Config`.`tab` FROM `configs` AS `Config` WHERE `Config`.`key` = 'default_store_id' ORDER BY `Config`.`weight` ASC LIMIT 1		1	1	0
36	__setError	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 '__setError' at line 1			0
37	SELECT `BaseStore`.*, (CASE WHEN `BaseStore`.id = 11 THEN 1 ELSE 0 END) AS is_default, `BaseStore`.`id` FROM `base_stores` AS `BaseStore` LEFT JOIN `sellers` AS `Seller` ON (`BaseStore`.`seller_id` = `Seller`.`id`) LEFT JOIN `publishing_channels` AS `PublishingChannel` ON (`BaseStore`.`publishing_channel_id` = `PublishingChannel`.`id`) WHERE `BaseStore`.`base_supplier_id` IS NULL ORDER BY `is_default` DESC, `BaseStore`.`name` ASC		0	0	1
38	SELECT `Config`.`id`, `Config`.`key`, `Config`.`name`, `Config`.`value`, `Config`.`options`, `Config`.`weight`, `Config`.`tab` FROM `configs` AS `Config` WHERE `Config`.`key` = 'enable_error_popup' ORDER BY `Config`.`weight` ASC LIMIT 1		1	1	3

(ProductBase) 38 queries took 78 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `base_suppliers`

DESCRIBE `base_supplier_maps`

DESCRIBE `base_supplier_map_rulesets`

DESCRIBE `saleswarp_fields`

DESCRIBE `base_supplier_ruletypes`

DESCRIBE `base_supplier_actiontypes`

DESCRIBE `base_product_changes`

DESCRIBE `base_products`

DESCRIBE `base_products_base_suppliers`

DESCRIBE `base_categories`

DESCRIBE `seller_actions`

DESCRIBE `sellers`

DESCRIBE `seller_profiles`

DESCRIBE `base_stores`

DESCRIBE `publishing_channels`

DESCRIBE `publishing_maps`

DESCRIBE `seller_categories`

DESCRIBE `users`

DESCRIBE `groups`

DESCRIBE `base_categories_base_products`

DESCRIBE `base_categories_base_suppliers`

DESCRIBE `base_categories_base_stores`

DESCRIBE `base_pricechecks`

DESCRIBE `base_product_images`

DESCRIBE `base_product_xsells`

DESCRIBE `base_products_base_stores`

DESCRIBE `base_product_histories`

DESCRIBE `base_products_base_supplier_locations`

DESCRIBE `base_brands`

DESCRIBE `base_brands_base_products`

DESCRIBE `base_products_product_groups`

DESCRIBE `configs`

SELECT `Config`.`id`, `Config`.`key`, `Config`.`name`, `Config`.`value`, `Config`.`options`, `Config`.`weight`, `Config`.`tab` FROM `configs` AS `Config` WHERE `Config`.`key` = 'session_timeout_warning' ORDER BY `Config`.`weight` ASC LIMIT 1

SELECT `Config`.`id`, `Config`.`key`, `Config`.`name`, `Config`.`value`, `Config`.`options`, `Config`.`weight`, `Config`.`tab` FROM `configs` AS `Config` WHERE `Config`.`key` = 'default_store_id' ORDER BY `Config`.`weight` ASC LIMIT 1

__setError

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 '__setError' at line 1

SELECT `BaseStore`.*, (CASE WHEN `BaseStore`.id = 11 THEN 1 ELSE 0 END) AS is_default, `BaseStore`.`id` FROM `base_stores` AS `BaseStore` LEFT JOIN `sellers` AS `Seller` ON (`BaseStore`.`seller_id` = `Seller`.`id`) LEFT JOIN `publishing_channels` AS `PublishingChannel` ON (`BaseStore`.`publishing_channel_id` = `PublishingChannel`.`id`) WHERE `BaseStore`.`base_supplier_id` IS NULL ORDER BY `is_default` DESC, `BaseStore`.`name` ASC

SELECT `Config`.`id`, `Config`.`key`, `Config`.`name`, `Config`.`value`, `Config`.`options`, `Config`.`weight`, `Config`.`tab` FROM `configs` AS `Config` WHERE `Config`.`key` = 'enable_error_popup' ORDER BY `Config`.`weight` ASC LIMIT 1

(default) 74 queries took 125 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `base_supplier_addresses`	12	12	4
2	DESCRIBE `base_order_flows`	4	4	1
3	DESCRIBE `base_order_checks`	5	5	1
4	DESCRIBE `base_order_checks_base_order_flows`	8	8	2
5	DESCRIBE `base_store_lookups`	6	6	1
6	DESCRIBE `base_option_sets`	5	5	1
7	DESCRIBE `base_option_sets_base_groups`	5	5	1
8	DESCRIBE `base_groups`	6	6	1
9	DESCRIBE `base_options_base_groups`	7	7	3
10	DESCRIBE `base_options`	17	17	1
11	DESCRIBE `base_attribute_values`	7	7	1
12	DESCRIBE `vendors`	18	18	2
13	DESCRIBE `purchase_orders`	49	49	2
14	DESCRIBE `addresses`	14	14	1
15	DESCRIBE `customers`	3	3	1
16	DESCRIBE `base_supplier_contacts`	8	8	4
17	DESCRIBE `shipping_methods`	2	2	1
18	DESCRIBE `purchase_order_steps`	5	5	1
19	DESCRIBE `payment_terms`	2	2	1
20	DESCRIBE `freight_terms`	2	2	1
21	DESCRIBE `purchase_order_line_items`	15	15	2
22	DESCRIBE `purchase_order_receipts`	11	11	1
23	DESCRIBE `purchase_order_receipt_lineitems`	10	10	1
24	DESCRIBE `purchase_order_payments`	9	9	1
25	DESCRIBE `purchase_order_vendor_logs`	14	14	1
26	DESCRIBE `purchase_order_notes`	5	5	2
27	DESCRIBE `vendor_payments`	13	13	10
28	DESCRIBE `vendor_invoices`	23	23	1
29	DESCRIBE `base_customers`	26	26	1
30	DESCRIBE `base_customer_lookups`	6	6	1
31	DESCRIBE `base_customer_text_lookups`	6	6	1
32	DESCRIBE `return_orders`	37	37	1
33	DESCRIBE `return_order_line_items`	13	13	1
34	DESCRIBE `base_orders`	83	83	2
35	DESCRIBE `base_order_steps`	6	6	1
36	DESCRIBE `base_order_addresses`	19	19	1
37	DESCRIBE `base_order_lineitems`	46	46	1
38	DESCRIBE `base_order_lineitem_suppliers`	16	16	1
39	DESCRIBE `base_order_lookups`	6	6	1
40	DESCRIBE `base_order_notes`	7	7	1
41	DESCRIBE `base_order_note_grids`	6	6	1
42	DESCRIBE `base_order_approvals`	7	7	1
43	DESCRIBE `base_order_approval_steps`	3	3	1
44	DESCRIBE `base_order_shipment_options`	11	11	1
45	DESCRIBE `order_ship_carriers`	8	8	1
46	DESCRIBE `order_ship_carrier_attributes`	7	7	1
47	DESCRIBE `order_ship_carrier_methods`	3	3	1
48	DESCRIBE `order_ship_carrier_countries`	8	8	1
49	DESCRIBE `order_ship_carrier_country_regions`	7	7	1
50	DESCRIBE `order_ship_signature_types`	4	4	1
51	DESCRIBE `order_ship_carrier_areas`	4	4	1
52	DESCRIBE `order_ship_package_types`	5	5	1
53	DESCRIBE `box_trackings`	11	11	1
54	DESCRIBE `base_order_payments`	10	10	1
55	DESCRIBE `ship_labels`	25	25	1
56	DESCRIBE `ship_label_lookups`	7	7	1
57	DESCRIBE `return_labels`	18	18	1
58	DESCRIBE `invoice_logs`	5	5	1
59	DESCRIBE `base_customers_base_orders`	5	5	1
60	DESCRIBE `base_product_lookups`	6	6	1
61	DESCRIBE `base_product_text_lookups`	6	6	6
62	DESCRIBE `base_products_bin_locations`	7	7	1
63	DESCRIBE `bin_locations`	7	7	1
64	DESCRIBE `base_products_rfid_bin_locations`	7	7	11
65	DESCRIBE `rfid_bin_locations`	4	4	1
66	DESCRIBE `product_price_logs`	107	107	2
67	DESCRIBE `store_publishing_products`	7	7	1
68	DESCRIBE `base_products_barcodes`	7	7	1
69	DESCRIBE `product_groups`	51	51	2
70	DESCRIBE `group_rules`	8	8	1
71	DESCRIBE `base_stores_group_rules`	5	5	1
72	DESCRIBE `vendor_products`	17	17	8
73	DESCRIBE `base_products_vendor_products`	5	5	5
74	DESCRIBE `logs`	7	7	1

(default) 74 queries took 125 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `base_supplier_addresses`

DESCRIBE `base_order_flows`

DESCRIBE `base_order_checks`

DESCRIBE `base_order_checks_base_order_flows`

DESCRIBE `base_store_lookups`

DESCRIBE `base_option_sets`

DESCRIBE `base_option_sets_base_groups`

DESCRIBE `base_groups`

DESCRIBE `base_options_base_groups`

DESCRIBE `base_options`

DESCRIBE `base_attribute_values`

DESCRIBE `vendors`

DESCRIBE `purchase_orders`

DESCRIBE `addresses`

DESCRIBE `customers`

DESCRIBE `base_supplier_contacts`

DESCRIBE `shipping_methods`

DESCRIBE `purchase_order_steps`

DESCRIBE `payment_terms`

DESCRIBE `freight_terms`

DESCRIBE `purchase_order_line_items`

DESCRIBE `purchase_order_receipts`

DESCRIBE `purchase_order_receipt_lineitems`

DESCRIBE `purchase_order_payments`

DESCRIBE `purchase_order_vendor_logs`

DESCRIBE `purchase_order_notes`

DESCRIBE `vendor_payments`

DESCRIBE `vendor_invoices`

DESCRIBE `base_customers`

DESCRIBE `base_customer_lookups`

DESCRIBE `base_customer_text_lookups`

DESCRIBE `return_orders`

DESCRIBE `return_order_line_items`

DESCRIBE `base_orders`

DESCRIBE `base_order_steps`

DESCRIBE `base_order_addresses`

DESCRIBE `base_order_lineitems`

DESCRIBE `base_order_lineitem_suppliers`

DESCRIBE `base_order_lookups`

DESCRIBE `base_order_notes`

DESCRIBE `base_order_note_grids`

DESCRIBE `base_order_approvals`

DESCRIBE `base_order_approval_steps`

DESCRIBE `base_order_shipment_options`

DESCRIBE `order_ship_carriers`

DESCRIBE `order_ship_carrier_attributes`

DESCRIBE `order_ship_carrier_methods`

DESCRIBE `order_ship_carrier_countries`

DESCRIBE `order_ship_carrier_country_regions`

DESCRIBE `order_ship_signature_types`

DESCRIBE `order_ship_carrier_areas`

DESCRIBE `order_ship_package_types`

DESCRIBE `box_trackings`

DESCRIBE `base_order_payments`

DESCRIBE `ship_labels`

DESCRIBE `ship_label_lookups`

DESCRIBE `return_labels`

DESCRIBE `invoice_logs`

DESCRIBE `base_customers_base_orders`

DESCRIBE `base_product_lookups`

DESCRIBE `base_product_text_lookups`

DESCRIBE `base_products_bin_locations`

DESCRIBE `bin_locations`

DESCRIBE `base_products_rfid_bin_locations`

DESCRIBE `rfid_bin_locations`

DESCRIBE `product_price_logs`

107

DESCRIBE `store_publishing_products`

DESCRIBE `base_products_barcodes`

DESCRIBE `product_groups`

DESCRIBE `group_rules`

DESCRIBE `base_stores_group_rules`

DESCRIBE `vendor_products`

DESCRIBE `base_products_vendor_products`

DESCRIBE `logs`