MySQL column count doesn’t match value count at row 1 [closed]

mysql_query("INSERT INTO file (id, filename, extention, filelink, filesize, filepass) VALUES('{$random}', '{$filename}', '{$extension}', '{$filelink}', '{$filesize}' '{$filepass}') ") or die(mysql_error());

You should add the missing comma after {$filesize}:

mysql_query("INSERT INTO file (id, filename, extention, filelink, filesize, filepass) VALUES(

Related Posts:

  1. Undefined function mysql_connect()
  2. Fatal error: Call to undefined function mysql_connect()
  3. MySQL “Or” Condition
  4. the_date() not working
  5. How to return number of found rows from SELECT query
  6. Transaction when using WP functions rather than vanilla SQL?
  7. Check if post of title already exists
  8. How to make WordPress plugin check for database changes and then do something?
  9. Jquery ajax to custom php file: returning blank data
  10. Add value to usermeta without removing previous values?
  11. How to sort results from a custom database table
  12. Update some database fields when post is saved
  13. How can I call a row of user specific data from a custom table added to the WP Database
  14. How to merge local and live databases?
  15. Successful or Error Message after running mysql code in functions.php
  16. sql query to put quotes around numbers in img tag
  17. Performance issues with large website [closed]
  18. Create a quick start wordpress installation [closed]
  19. theme options echoing multiple times
  20. PHP/MySQL issues when running WP on EC2 cloud [closed]
  21. WordPress 3 – how are passwords stored and how do I compare to them?
  22. WordPress get pagination on wpdb get_results
  23. How to create another version of my site based on the same database
  24. how to echo all tables that start with a prefix
  25. Strange wordpress slowness
  26. Looking for most performant way to execute several similar WP queries within shortcodes
  27. How to select WooCommerce products by post_meta and order them
  28. Setting All Drafts to ‘exclude-from-catalog’ in WooCommerce
  29. Stumped on migration
  30. PHP code inside shortcodes
  31. Show MySQL errors that occur when I excute $wpdb->insert()
  32. Is XAMPP faster than running LAMP in WSL on Windows 10? [closed]
  33. Remove one value in dismissed_wp_pointers?
  34. WordPress Site Running Extremely Slow on Dedicated Server
  35. Accessing data from a non-WP database/table within a page content
  36. Get updated query results on page after insert in database
  37. WordPress not reflecting changed of the database
  38. How can I fix WordPress installation errors?
  39. How can I save unique user data on my site? [closed]
  40. Ordering users by custom user meta
  41. How to split links generated into an xml sitemap to avoid exceeding 30 sec maximum execution time?
  42. Hacked WordPress website /Homepage redirect [closed]
  43. Refresh table data with Ajax
  44. Database query works fine outside WordPress
  45. Large Woocommerce Site (83,000 items), What Can I Do? [closed]
  46. Using custom tables for old posts
  47. Help with a $wpdb MySQL Query
  48. How i can obtain all the post meta for a specific post as an array?
  49. Multiple meta_key in one global $wpdb;
  50. WordPress member notification
  51. Can’t Query Custom Table Using $wpdb Method
  52. Moving wordpress site from localhost to live server using GoDaddy cPanel
  53. How does WP work in conjunction with a web server?
  54. $wpdb returns duplicate posts
  55. Update postmeta after theme switch
  56. Location of core code for database connection and get_header
  57. Should I use WordPress to skin a database website?
  58. Creating Database Table vs. Adding MetaData to Post & User
  59. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  60. WordPress Custom SQL Table with UserID Filter for results
  61. Most commented posts by time period (last 12h, last 24h and etc)
  62. Hide posts if user is added to it WP_query
  63. How to unserialize data from MySQL
  64. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  65. WordPress WP_Query without query GET parameters
  66. Known Issues in WordPress When Upgrading PHP to ver 7
  67. Get the id of the row from database on click of a button [closed]
  68. WPDB secure custom form
  69. Query the links Database
  70. SQL error with custom query
  71. MySQL Query Returns Array () In Shortcode
  72. Modify WooCommerce used to get all orders in dashboard
  73. Database SQL query error
  74. Display Results of SQL Query on WP site
  75. Weird fonts showing which are coming from database
  76. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  77. Inside Array – “unidentified index” error with “prepare was called incorrectly” despite not calling the prepared statement with wordpress [closed]
  78. Updated Php version from 5.4 to 7.2 and getting “PHP installation missing the MySQL extension needed by WordPress”
  79. WordPress Bad Request Error 400
  80. I am facing this error Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  81. How to display MySQL table data which is stored as an array?
  82. What is the correct way to search 3 custom fields only in WordPress?
  83. cant insert data in a custom table in phpmyadmin
  84. How to import woocommerce custom fields data into another site?
  85. autocomplete in wordpress using ajax with json-data
  86. New database entry to trigger runing PHP/SQL query through link with token, without logging into the website
  87. Query doesn’t display text data with apostrophes
  88. I want show only data for today
  89. Advanced WordPress SQL Query
  90. How to detect if a revision was made by woocommerce or wordpress?
  91. SQL Query Search page
  92. MySQL queries in WordPress
  93. Let users register weight each day and save it in DB
  94. How to pass username into form that sends data to database
  95. Submit cf7 form to cfdb as pdf/BLOB [closed]
  96. Your PHP installation appears to be missing the MySQL … After deleting and restarting from cpanel
  97. Getting invalid user ID error when creating a new user with wp_insert_user
  98. Custom form that stores data in mysql database
  99. Putting form result in my database
  100. How can I update a value of a field depending on outside source?

Leave a Comment