Urgent Plugin Help Needed!!

  • focustechnology

    (@focustechnology)


    15 years, 1 month ago

    Hi All,

    I am developing a wordpress site on version 3.1 hosted on IIS6 x64 with PHP 5.2.5 x64 with a MySQL 5.1 database.
    Wordpress works fine.
    I am trying to use 2 plugins, formbuilder 0.86, the problem is that i cannot save any changes i make to any forms i create or fields etc.
    I think the issue lies in the db structure not liking null values or something along those lines, has anyone else had this and how do i fix it as i need this working.
    The second plugin is availability calendar 0.1.3, when i go to the admin section i cannot see the dates as in the screen shots but a lot of code which would imply to me that the code is not picking up the date from wordpress, i have tried different date formats within wordpress settings but no luck.
    So, could someone please help me resolve this as i really need these two working asap.
    P.S. the developers are not being helpful despite having posted on their forums.
    Thanks in advance!

Viewing 1 replies (of 1 total)
  • Thread Starter focustechnology

    (@focustechnology)

    15 years, 1 month ago

    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.

Viewing 1 replies (of 1 total)

The topic ‘Urgent Plugin Help Needed!!’ is closed to new replies.