Using PHP PDO to manage data in MySQL
Details about how to use the PHP PDO library for data manipulation
...SQLSTATE[42000]: Syntax error or access violation: 1064 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 ')) AND (cpotv.manage_stock = 1)' at line 1, query was: SELECT DISTINCT `cpotv`.`option_id` FROM `catalog_product_option_type_value` AS `cpotv` WHERE (option_id IN ()) AND (cpotv.manage_stock = 1) Exception #1 (PDOException): SQLSTATE[42000]: Syntax error or access violation: 1064 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 ')) AND (cpotv.manage_stock = 1)' at line 1 Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an er...
I am looking for an experienced Drupal developer who can troubleshoot an issue with the "Drupal cron maintenance task" failure due to a PDOException error regarding a custom PHP code in Rules. Troubleshooting session will be "live" over an MS Teams call as administrator account information cannot be handed over. Ideal skills and experience for this job include: - Strong experience with Drupal 7 and PHP - Expertise in troubleshooting PDOException errors - Understanding of MySql database - Familiarity with Drupal Rules The successful candidate will be able to quickly identify the root cause of the cron task failure and implement a solution to prevent it from happening in the future. The ability to work efficiently and communicate effectively is essential...
need help to fix 2 website with similare issue PDOException: SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown storage engine 'InnoDB': SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /home/*****/public_html/includes/).
I'm looking for someone who has succesfully installed this driver, I have followed the steps on github When I tested I have got this error: [php:error] [pid 901] [client ] PHP Fatal error: Uncaught PDOException: could not find driver in /var/www/html/nStack trace:n#0 /var/www/html/(23): PDO->__construct()n#1 {main}n thrown in /var/www/html/ on line 23
PDOException: SQLSTATE[HY000] [1040] Too many connections in lock_may_be_available()
I need someone to tell me how to create the appropriate user to be able to connect to mysql. I have a file called which is located in the includes directory/folder. <?php $dbuser = "user1"; $dbpwd = "password"; try { $dbh = new PDO('mysql:host=;dbname=domain', $dbuser, $dbpwd); } catch( PDOException $Exception) { $exccode = $Exception->getCode(); $excmsg = $Exception->getMessage(); } if (!empty($exccode)) { die($exccode." - ".$excmsg."<br>n"); } ?> I have also run the following SQL command: # mysql mysql> CREATE USER 'user1'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'user1'...
A website we use for freight management has slowness and often an unexpected error appears (see attached image). The freelancer will fix the issue of the error showing when using the website. The website is hosted on AWS lightsail linux machine
...some problems to me. You can see that form on attached file rte1.png. I add there red letters (A) (B)... like on the list below. Changes I want you to do: 1. On section "Pozycja" (A) it should be selected by default "Artykuły", so I do not have to click it. 2. On section "nazwa:" (B) there is a problem with allowable number of characters. There is an error: "Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'name' at row 1'..." I want to increase that limit to 100 characters 3. On section "Treść::" (D) there is problem with images. On actual version of editor, when I upload new images the location of the file i...
help with error: Fatal error: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number in C:inetpubvhostshttpdocs Stack trace: #0 C:inetpubvhostshttpdocs(13): PDOStatement->execute() #1 {main} thrown in C:inetpubvhostshttpdocs on line 13 (SEE ATTACHED SCREENSHOT OF CODE)
We need someone to look at and fix this error we encountered after creating a Drupal site copy (for testing/development purposes): PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '' doesn't exist: SELECT name, value FROM {variable}; Array ( ) in variable_initialize() (line 1202 of /home/beldenu/). *********** I will share site details once bid is accepted.
my website works on API whenever a user places an order the order automatically place through API on another website but now i facing a problem that some of the order are not entering in my database but that orders place to another website from where API is connect
PDOException: SQLSTATE[HY000] [2002] Connection refused
Hello, I have a Microsoft Server, and I want to build a PHP7 web app, using MS SQL database. But, I am having trouble creating the connection using php mssql_connect function: "Fatal error: Uncaught Error: Call to undefined function mssql_connect() in C:clntswww" I have also tried with sqlsrv function: "Fatal error: Uncaught PDOException: could not find driver in C:...... Stack trace: #0 C:......(6): PDO->__construct() #1 {main} thrown in C:...... on line 6" I need you to: - Install/configure/enable PHP's MSSQL extensions (or equivalent) on the server - Create a example connection script with PHP where you connect to database, and display rows form a table The server has a Virtual Deskop/Remote Connection, no control panel. Please only repl...
Hi, since yesterday I have an e...error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?))' at line 2, query was: SELECT `e`.`entity_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.parent_id WHERE (l.product_id IN(?)) at /home/myshop/public_html/vendor/magento/framework/DB/Statement/Pdo/, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 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 '?))' at line 2 at /home/myshop/public_html/vendor/magento/framework/DB/Statement/Pdo/)"} [] I'm looking for someone to fix t...
I run Magento 2.4.2-1p. We are not able to add Cart Price Rules. If we try, we get "Something went wrong while saving the rule data. Please review the error log."....`apply_to_shipping`, `is_rss`, `coupon_type`, `use_auto_generation`, `uses_per_coupon`, `simple_free_shipping`, `action_details_serialized`, `discount_order_type`, `actions_hint_label`, `promo_block_title_in_product`, `promo_block_set_name`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NULL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) at /var/www/xxx/vendor/magento/framework/DB/Statement/Pdo/, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'actions_hint_label' cannot be null at /var/www/xxx/vendor/magento/framework/DB/Statement/Pdo/)"} [] Need help urgent...
Hello getting this error PDOException: SQLSTATE[08004] [1040] Too many connections in lock_may_be_available() (line 167 of /home/website/public_html/includes/).
i was facing a lot of dddos attacks during the last a few days so i decided to move to another server after moving to new vps i faced a lot of problems the old server php version was 7.2 the new server php version is php 8.0.5 [ both of them running vestacp ] pdo errors Fatal error : Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in /home/admin/web/xxx/public_html/seller/ Stack trace: i have this PDO error in all my vendor panel sections 2st error datatable error i have this problem in 2 sections always comes code 500 and not loading the data from my db DataTables warning: table id=file_data - Ajax error. For more information about this error, please see
... Below is the code that I use to list customers: <?php $pdo = Conexao::getInstance(); $pagina = 1; if(isset($_REQUEST['pagina'])){ $pagina = $_REQUEST['pagina']; } try{ $sql = $pdo->prepare("SELECT * FROM tbl_bb ORDER BY ID DESC"); $executar = $sql->execute(); $resultado = $sql->fetchAll(PDO::FETCH_OBJ); $total = count($resultado); } catch(PDOException $e){ echo $e->getMessage(); } $totalPaginas = ceil($total/10); if($totalPaginas <= 0){ $total ?> But I want to separate this page. I will create another page with the customers of lower balance, and I want this page with the customers of larger balance, so we can send a message indicating products to exchan...
Have not updated website in a while and am getting an error when trying to add new pages "PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table" Assigned to a Freelancer. He has now advised he is unable to complete. Google now reports the site as hacked and it is redirecting. Require someone to resolve all issues and prevent further SQL injections.
Have not updated website in a while and am getting an error when trying to add new pages "PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table"
We need PDOException logging added to our database class which sends the message to SQL table for review. Looking to kindly have job complete quickly and efficiently. Will provide class.
Hello, We need to correct the bellow error that appeared after moving products from our live site to the staging. [2020-10-20 06:31:51] : SQLSTATE[42S22]: Column not found: 1054 Unknown c...option_value.store_id = 0 LEFT JOIN `eav_attribute_option_value` AS `default_option_value` ON default_option_value.option_id = AND default_option_value.store_id = 0 WHERE (super_attribute.product_id = 13023) AND (attribute.attribute_id = '') ORDER BY `attribute_option`.`sort_order` ASC at /home//public_html/staging/vendor/magento/framework/DB/Statement/Pdo/, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'field list' at /public_html/staging/vendor/magento/framework/DB/Statement/Pdo/)"} []
I have migrated the site to a new VPS server where the Mysql is higher version from the previous. Now showing the following fatal error. Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[01000]: Warning: 1265 Data truncated for column 'proDiscount' at row 1' in /home/yesbusin/public_html/includes/ Stack trace: #0 /home/yesbusin/public_html/includes/(401): PDOStatement->execute(Array) #1 /home/yesbusin/public_html/(330): user_module->addBookerDetail_new(Array) #2 {main} thrown in /home/yesbusin/public_html/includes/ on line 401
We transferred website files for a drupal website but the website is not showing. Receive error message stating: The website encountered an unexpected error. Please try again later. PDOException: SQLSTATE[28000] [1045] Access denied for user 'Sentius'@'localhost' (using password: YES) in lock_may_be_available() (line 167 of /home/msglassc/public_html/includes/). Need site up as soon as possible
After restarting the server, my magento application shows the following error: Exception # 0 (Zend_Db_Adapter_Exception): SQLSTATE [HY000] [2002] No such file or directory Exception # 1 (PDOException): SQLSTATE [HY000] [2002] No such file or directory When I check the status of the service, it is stopped. Running sudo systemctl stop mariadb reactivates it, but within minutes it stops again.
Hosted by Digital Ocean My website is not coming up. I am getting an error ========== PDOException in line 55: SQLSTATE[HY000] [1045] Access denied for user 'root '@'localhost' (using password: YES) ========== I am using the software Gentask (LAMP stack, Laravel) Also this requires node.js to be installed on Digital Ocean. This is so the 'chat' can work. I thought I had it working at one time but it does not now I can give credentials for both DO and the files (I use Filezilla) ========= Please note, I haven't messed with this program for about a month. It worked last I worked on it and went to the website. So something has changed.
Hi Miracles Group, I noticed your profile. I have a Magento 2.3.4 site with this error: "(Zend_Db_Adapter_Exception): SQLSTATE[42000] [1226] User 'globalt6_mage340' has exceeded the 'max_user_connections' resource (current value: 30) Exception #1 (PDOException): SQLSTATE[42000] [1226] User 'globapt6_mage340' has exceeded the 'max_user_connections' resource (current value: 30)" Some connections not finishing. Webhost restart DB, error goes but comes back. Please quote me to fix. Thanks
Hi Bui H., I see your profile. Magento 2.3.4 site with this error (Zend_Db_Adapter_Exception): SQLSTATE[42000] [1226] User 'globalt6_mage340' has exceeded the 'max_user_connections' resource (current value: 30) Exception #1 (PDOException): SQLSTATE[42000] [1226] User 'globalt6_mage340' has exceeded the 'max_user_connections' resource (current value: 30) Some connections not finishing. Webhost is restarts DB and error goes but comes back Please quote price to fix. Thanks
Hi, our webshop is using Centos 7, Apache & Magento 1.8 we're getting this error and our webshop is down: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[08004] [1040] Too many connections' in /var/www/html/includes/src/ Stack trace: #0 /var/www/html/includes/src/(54452): PDO->__construct('mysql:host=loca...', 'carrousel_kids', 'ckDBkidword', Array) #1 /var/www/html/includes/src/(54818): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /var/www/html/includes/src/(55301): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /var/www/html/includes/src/(53505): Varien_Db_Adapter_Pdo_Mysql->_connect() #4 /var/www/html/includes/src/(54561): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array...
After restarting the server, my magento application shows the following error: Exception # 0 (Zend_Db_Adapter_Exception): SQLSTATE [HY000] [2002] No such file or directory Exception # 1 (PDOException): SQLSTATE [HY000] [2002] No such file or directory When I check the status of the service, it is stopped. Running sudo systemctl stop mariadb reactivates it, but within minutes it stops again.
...17.0.17 to 17.8.11. You can see the error showed below this lines. Please contact for further information. Regards, Xab ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory Additionally, an exception has occurred while trying to report this error: Zend_Exception No entry is registered for key 'translate' () ERROR: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No such file or directory' in /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/ Stack trace: #0 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/(129): PDO->__construct('mysql:dbname=ps...', 'admin', '$AES-128-CBC$fP...', Array) #1 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/(111): Zend_Db_Adapter_Pdo_Abs...
...17.0.17 to 17.8.11. You can see the error showed below this lines. Please contact for further information. Regards, Xab ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory Additionally, an exception has occurred while trying to report this error: Zend_Exception No entry is registered for key 'translate' () ERROR: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No such file or directory' in /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/ Stack trace: #0 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/(129): PDO->__construct('mysql:dbname=ps...', 'admin', '$AES-128-CBC$fP...', Array) #1 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/(111): Zend_Db_Adapter_Pdo_Abs...
I have changed my dedicated server, using xampp as web interface and MSSQL database, my website getting errors: Its not wrong user/password , its somekind of configuration i probably did wrong and i dont know exactly what Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[28000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Login failed for user 'sa'.' in C:xampphtdocswebconfigs Stack trace: #0 C:xampphtdocswebconfigs(227): PDO->__construct('sqlsrv:server=l...', 'sa', '********', Array) #1 C:xampphtdocswebconfigs(55): MedooMedoo->__construct(Array) #2 C:xampphtdocsweb(12): Model->__construct() #3 {main} thrown in C:xampphtdocswebconfigs on line 227
having a few issues with our magento website, crashes daily and right now says Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] Connection refused in /home/audioconnect/public_html/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/ Stack trace: #0
having a few issues with our magento website, crashes daily and right now says Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] Connection refused in /home/audioconnect/public_html/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/ Stack trace: #0
Hello, We are receiving the following error when submitting from our webform: PDOException: SQLSTATE[HY000]: General error: 1364 Field 'serial' doesn't have a default value: INSERT INTO {webform_submissions} (nid, uid, is_draft, submitted, remote_addr) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array ( [:db_insert_placeholder_0] => 108 [:db_insert_placeholder_1] => 14 [:db_insert_placeholder_2] => 0 [:db_insert_placeholder_3] => 1568136848 [:db_insert_placeholder_4] => ) in drupal_write_record() (line 7401 of /home/anaadmin/public_html/includes/). We need someone to fix this issue.
I've a problem with Mysql tmp dir, after few hour the tmp dir table full my hard d...Zend_Db_Statement_Exception(code: 0): SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/#' (Errcode: 122 - Internal (unspecified) error in handler), query was: CREATE TEMPORARY TABLE IF NOT EXISTS `catalog_product_index_price_temp` LIKE `catalog_product_index_price_tmp` at /home/raizer96/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement/, PDOException(code: HY000): SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/#' (Errcode: 122 - Internal (unspecified) error in handler) at /home/raizer96/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement/)"} [] if i restart mysql service all return ok for few hour
We are getting an error: PDOException: could not find driver after we upgraded to EasyApache 4 from 3. Can someone fix the module that is no longer working now?
Hi, I have an issue with catalog flat indexing. Product Flat Data index process unknown error: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-d4a_b2d' Even after truncation of the table catalog_product_flat_1 and start new indexation there is an error for duplicated key. I tried do disable Catalog Product Flat and truncate catalog_product_flat_1 table and then enable again to create a new table but again I have an error. I will grant you access with teamviewer to SSH or you can send me instructions how to fix this. Thank you
.../home/mrmail/public_html/portal/admin/(15): FrontController::init() #8 {main} Uh oh! Something went wrong ... PHP [Error]: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'id' at row 1' in /home/mrmail/public_html/portal/hbf/components/hbdebug/ Stack trace: #0 /home/mrmail/public_html/portal/hbf/components/hbdebug/(31): PDOStatement->execute() #1 /home/mrmail/public_html/portal/hbf/core/(85): HBErrorLog->createEntry() #2 [internal function]: HBException::php_exception_handler(Object(PDOException)) #3 {main} thrown IN hbf/components/hbdebug/(31) the problem might be in php / mysql configuration on the server or in the code Probably
Need to fix the following error: PDOException: SQLSTATE[HY000]: General error: 1033 Incorrect information in file: './qbslzdds_drupal/': SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /home/qbslzdds/public_html/includes/) When bidding, make sure you add #XYZ# to your comments so that I know you've read this project outline.
resolve an issue in a yiiframework website Database Exception – yiidbException SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'order clause' The SQL being executed was: SELECT * FROM `auction` WHERE `auction`.`status`=1 ORDER BY `id` DESC LIMIT 9 Error Info: Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'id' in 'order clause' ) ↵ Caused by: PDOException SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'order clause'
...displays the following error: Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'dva_pet_strayed' in 'field list' in /home/zzxukdgt5qik/public_html/tracker/admin/ Stack trace: #0 /home/zzxukdgt5qik/public_html/tracker/admin/(123): PDOStatement->execute(Array) #1 /home/zzxukdgt5qik/public_html/tracker/admin/(576): crud->update(Array, 'maindb', '7') #2 /home/zzxukdgt5qik/public_html/tracker/admin/(152): updateDataIntoTable('maindb', Array, '7') #3 /home/zzxukdgt5qik/public_html/tracker/admin/(27): include_once('/home/zzxukdgt5...') #4 {main} thrown in /home/zzxukdgt5qik/public_html/tracker/admin/ on line 123 Fatal error: Uncaught PDOException: SQLSTATE[42S22]...
Hello, I am looking for a mysql expert. I have a problem with a LAMP server hosting a drupal website. The mysql service often freezes and the website displays an error connecting to the database: PDOException: SQLSTATE[08004] [1040] Too many connections in lock_may_be_available() When trying to restart mysql with "systemctrl restart ", the service will not stop and I have to kill it with "kill -9 <pid>". I am looking for someone to adjust the mysql configuration to stop this from happening. Can you give me a quote please?
...mssql_connect). I followed this article with errors and feel like I almost completed the process, but need someone with more knowledge to get it working. It's not necessary to follow this article, please do it your own way if necessary. When I try to construct PDO and connect I received the error: " PDOException: could not find driver ". I know my code is not the issue as it's worked reliably using sqlsrv on Windows and dblib on Ubuntu. The deliverable on this will be: step by step instructions on how to get it working on a fresh install of Ubuntu 16.04 LTS, using only minimal amount of installed software (e.g. apache, php 7.0, necessary drivers). So that I can use the same instructions
..." and "/var/www/html/miner/Files/core/app/Http/Demo_Controllers/", the first will be used. > IlluminateFoundationComposerScripts::postAutoloadDump > @php artisan package:discover [IlluminateDatabaseQueryException] SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using passwor d: NO) (SQL: select * from `basic_settings` limit 1) [PDOException] SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using passwor d: NO) Script @php artisan package:discover handling the post-autoload-dump event returned with error code 1 [root@socialminersl core]# vi [root@socialminersl core]# ls app resources tests artisan config routes vendor bootstra...
...the bindings with SQL, which will make this exception a 662| // lot more helpful to the developer instead of just the database's errors. 663| catch (Exception $e) { > 664| throw new QueryException( 665| $query, $this->prepareBindings($bindings), $e 666| ); 667| } 668| Exception trace: 1 PDOException::("SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)") /Users/MediaEdgeAgency/Desktop/Projects/laravel20.0/vendor/laravel/framework/src/Illuminate/Database/Connectors/ : 68 2 PDO::__construct("mysql:host=;port=3306;dbname=laravel20.0", "root", "", []) ...
I am facing an issue when I tried hosting the Drupal7 website at Godaddy. My account is Economy Windows Hosting with Plesk. Initially, I uploaded the files to the root folder, that is, the httpdocs, but an error was returned PDOException: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it. in lock_may_be_available() (line 167 of G:PleskVhostshttpdocsincludes). The database information I have given is correct, as I checked it several times. Then I tried uploading it as a subfolder and this time an Internal server error was returned. Can you please someone to help me to fix this issue??
Pimcore 4.6.3 (DAM) I get an error when uploading a folder. Right now I want to delete the folder also gives an error. Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 in /var/www/html/pimcore/vendor/zendframework/zendframework1/library/Zend/Db/Statement/ Stack trace: #0 /var/www/html/pimcore/vendor/zendframework/zendframework1/library/Zend/Db/Statement/(228): PDOStatement->execute(Array) #1 /var/www/html/pimcore/vendor/zendframework/zendframework1/library/Zend/Db/(303): Zend_Db_Statement_Pdo->_execute(Array) #2 /var/www/html/pimcore/vendor/zendframework/zendframewor
Pimcore 4.6.3 (DAM) I get an error when uploading a folder. Right now I want to delete the folder also gives an error. Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 in /var/www/html/pimcore/vendor/zendframework/zendframework1/library/Zend/Db/Statement/ Stack trace: #0 /var/www/html/pimcore/vendor/zendframework/zendframework1/library/Zend/Db/Statement/(228): PDOStatement->execute(Array) #1 /var/www/html/pimcore/vendor/zendframework/zendframework1/library/Zend/Db/(303): Zend_Db_Statement_Pdo->_execute(Array) #2 /var/www/html/pimcore/vendor/zendframework/zendframewor
Details about how to use the PHP PDO library for data manipulation