Solved

Joomla Poll error message when attempting to add, edit or delete poll in poll manager

Posted on 2009-07-04
2
459 Views
Last Modified: 2013-12-13
When I try to do anything in joomla poll i get the message
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 'Is this working,1246751909)' at line 2 SQL=INSERT INTO boch_ualog VALUES( NULL,'62','com_poll','publish','index.php?option=com_poll&task=edit&cid[]=17','{user} published a poll: {link}',Is this working,1246751909)

Is there a fix for this. I am running the latest version of joomla, and this poll was working until i tried to add a new poll.
0
Comment
Question by:bochaka
2 Comments
 
LVL 40

Accepted Solution

by:
RQuadling earned 500 total points
ID: 24784307
SQL=INSERT INTO boch_ualog VALUES( NULL,'62','com_poll','publish','index.php?option=com_poll&task=edit&cid[]=17','{user} published a poll: {link}',Is this working,1246751909)

The "Is this working" is not surrounded by single quotes.

Can you show the code that generated the SQL?
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

910 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

16 Experts available now in Live!

Get 1:1 Help Now