Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

sql query failing for wordpress

Posted on 2011-02-16
3
Medium Priority
?
1,249 Views
Last Modified: 2012-08-14
Hi All,

Wordpress latest version with formbuilder 0.86 on MySQL, cannot edit forms with error: your form failed to save.
I have captured the SQL query being passed which is...

SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
UPDATE `wp_options` SET `option_value` = '1297858071' WHERE `option_name` = '_transient_doing_cron'
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category')  ORDER BY t.name ASC
SELECT * FROM wp_posts  WHERE (post_type = 'page' AND post_status = 'publish')     ORDER BY post_title ASC
SELECT * FROM wp_users WHERE user_login = 'washhouseadmin'
SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1)
SELECT option_value FROM wp_options WHERE option_name = 'db_upgraded' LIMIT 1
SELECT comment_approved, COUNT( * ) AS num_comments FROM wp_comments  GROUP BY comment_approved
SELECT option_value FROM wp_options WHERE option_name = 'dismissed_update_core' LIMIT 1
SELECT option_value FROM wp_options WHERE option_name = 'menu_items' LIMIT 1
UPDATE `wp_formbuilder_forms` SET `name` = 'A New Contact Form', `subject` = 'Enquiry From Wash House Web Site', `recipient` = 'username@domain.com, `method` = 'POST', `action` = '', `thankyoutext` = '', `autoresponse` = '' WHERE `id` = '1'
SELECT * FROM wp_formbuilder_forms WHERE id = '1'
SELECT * FROM wp_formbuilder_responses
SELECT * FROM wp_formbuilder_fields WHERE form_id = 1 ORDER BY display_order ASC

The error message is...

Error Code: 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 'UPDATE `wp_options` SET `option_value` = '1297858071' WHERE `option_name` = '_tr' at line 2

The error seems to show a truncated option name at the end '_tr' rather than the full name in the query, the option name does exist.
If i run the query without the Select statement above it works.

This is holding up some web development so i really need the help!
Many Thanks in anticipation!
0
Comment
Question by:sparky1977
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 1

Expert Comment

by:stezeb
ID: 34915526
Hello

I'm not very familiar with Wordpress, but these queries looks fine to me. The error seems like a missing delimiter issue.
The queries are stored in some file exactly as you posted them and they are executed at once? If yes, there should a delimiter at the end of each command.
0
 
LVL 1

Accepted Solution

by:
sparky1977 earned 0 total points
ID: 35254705
Never resolved this problem, passed it back to the plugin developers who never replied.
0
 
LVL 1

Author Closing Comment

by:sparky1977
ID: 35312531
No other acceptable solution proposed.
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question