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
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 |
// 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 |