Unhandled Error!

MySQL error executing query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

Hint

This problem could be caused by the LemonStand MySQL connection configuration errors. Please log into the LemonStand Configuration Tool and update the database connection parameters. Also please make sure that MySQL server is running.

Document /phproad/modules/db/classes/db_mysqlidriver.php
Document type PHP document
Line 101
Exception class Phpr_DatabaseException

Code Highlight

 
		// execute the statement
		$handle = mysqli_query(Db::$connection, $sql);
 
		// If error, generate exception
		if ($err = mysqli_errno(Db::$connection) != 0) {
			$exception               = new Phpr_DatabaseException('MySQL error executing query: ' . mysqli_error(Db::$connection));
			$exception->hint_message = 'This problem could be caused by the LemonStand MySQL connection configuration errors. Please log into the LemonStand Configuration Tool and update the database connection parameters. Also please make sure that MySQL server is running.';
			throw $exception;
		}
 
		return $handle;
	}
# Call Stack Code Document Line
36 Db_MySQLiDriver->execute('insert into shop_product_cached_details (sku, property, value, updated_at) values ') /phproad/modules/db/classes/db_sqlbase.php 604
35 Db_SqlBase->execute('insert into shop_product_cached_details (sku, property, value, updated_at) values ') /phproad/modules/db/classes/db_sqlbase.php 437
34 Db_SqlBase->query('insert into shop_product_cached_details (sku, property, value, updated_at) values ') /phproad/modules/db/classes/db_dbhelper.php 56
33 Db_DbHelper::query('insert into shop_product_cached_details (sku, property, value, updated_at) values ', array(0)) /modules/shopproductbooking/controllers/booking.php 150
32 ProductBookingController::getRemoteProductDetails(array(1) [0 => 'brc45/45c']) /modules/shopproductbooking/controllers/booking.php 44
31 ProductBookingController::getProductDetails(array(1) [0 => 'brc45/45c']) /modules/shopproductbooking/classes/shopproductbooking_module.php 58
30 ShopProductBooking_Module->after_product_fetch(object(Shop_Product))
29 call_user_func_array(array(2) [0 => object(ShopProductBooking_Module), 1 => 'after_product_fetch'], array(1) [0 => object(Shop_Product)]) /phproad/system/class_functions.php 18
28 callFunction(array(2) [0 => object(ShopProductBooking_Module), 1 => 'after_product_fetch'], array(1) [0 => object(Shop_Product)]) /phproad/modules/phpr/classes/phpr_events.php 77
27 Phpr_Events->fire_event(array(1) [name => 'shop:onAfterProductRecordFetch'], object(Shop_Product))
26 call_user_func_array(array(2) [0 => object(Phpr_Events), 1 => 'fire_event'], array(2) [0 => array(1), 1 => object(Shop_Product)]) /phproad/system/class_functions.php 18
25 callFunction(array(2) [0 => object(Phpr_Events), 1 => 'fire_event'], array(2) [0 => array(1), 1 => object(Shop_Product)]) /phproad/modules/phpr/classes/phpr_events.php 143
24 Phpr_Events->fireEvent('shop:onAfterProductRecordFetch', object(Shop_Product))
23 call_user_func_array(array(2) [0 => object(Phpr_Events), 1 => 'fireEvent'], array(2) [0 => 'shop:onAfterProductRecordFetch', 1 => object(Shop_Product)]) /phproad/modules/phpr/classes/phpr_extensible.php 159
22 Phpr_Extensible->__call('fireEvent', array(2) [0 => 'shop:onAfterProductRecordFetch', 1 => object(Shop_Product)]) /modules/shop/models/shop_product.php 1861
21 Backend_Events->fireEvent('shop:onAfterProductRecordFetch', object(Shop_Product)) /modules/shop/models/shop_product.php 1861
20 Shop_Product->after_fetch(()) /phproad/modules/db/classes/db_activerecord.php 439
19 Db_ActiveRecord->_find_fill(array(1) [0 => array(92)], null) /phproad/modules/db/classes/db_activerecord.php 513
18 Db_ActiveRecord->find_all_internal(null, array(0)) /phproad/modules/db/classes/db_activerecord.php 599
17 Db_ActiveRecord->find_all_by('url_name', 'karcher-upright-commercial-carpet-cleaner-hire', array(0)) /phproad/modules/db/classes/db_activerecord.php 593
16 Db_ActiveRecord->find_by('url_name', 'karcher-upright-commercial-carpet-cleaner-hire')
15 call_user_func_array(array(2) [0 => object(Shop_Product), 1 => 'find_by'], array(2) [0 => 'url_name', 1 => 'karcher-upright-commercial-carpet-cleaner-hire']) /phproad/modules/db/classes/db_activerecord.php 1594
14 Db_ActiveRecord->__call('find_by_url_name', array(1) [0 => 'karcher-upright-commercial-carpet-cleaner-hire']) /modules/shop/classes/shop_actions.php 110
13 Shop_Product->find_by_url_name('karcher-upright-commercial-carpet-cleaner-hire') /modules/shop/classes/shop_actions.php 110
12 Shop_Actions->product(()) /modules/cms/classes/cms_actionmanager.php 72
11 Cms_ActionManager::execAction('shop:product', object(Cms_Controller)) /modules/cms/classes/cms_controller.php 580
10 Cms_Controller->eval_page_content(()) /modules/cms/classes/cms_controller.php 198
9 Cms_Controller->open(object(Cms_Page), array(1) [0 => 'karcher-upright-commercial-carpet-cleaner-hire']) /controllers/application.php 72
8 Application->On404(())
7 call_user_func_array(array(2) [0 => object(Application), 1 => 'On404'], array(0)) /phproad/modules/phpr/classes/phpr_controller.php 170
6 Phpr_Controller->executeAction('On404', array(0)) /phproad/modules/phpr/classes/phpr_controller.php 84
5 Phpr_Controller->_run('On404', array(0)) /phproad/modules/phpr/classes/phpr_response.php 64
4 Phpr_Response->open404(()) /phproad/modules/phpr/classes/phpr_response.php 37
3 Phpr_Response->open('/product/karcher-upright-commercial-carpet-cleaner-hire') /phproad/system/phproad.php 31
2 include('/var/www/vhosts/carpetcleaner-hire.co.uk/httpdocs/phproad/system/phproad.php') /boot.php 114
1 require_once('/var/www/vhosts/carpetcleaner-hire.co.uk/httpdocs/boot.php') /index.php 3