Solved

sql query failing for wordpress

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

863 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

26 Experts available now in Live!

Get 1:1 Help Now