Solved

sql query failing for wordpress

Posted on 2011-02-16
3
1,069 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
  • 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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

759 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now