SQL Syntax error

Joomla version 1.5 is end-of-life and are no longer supported. Please use Joomla 3.x instead.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
jbelanger
Joomla! Intern
Joomla! Intern
Posts: 82
Joined: Mon Oct 20, 2008 2:42 pm
Location: Chicago,il
Contact:

SQL Syntax error

Post by jbelanger » Tue Sep 28, 2010 12:07 am

Hello,

I have noticed this problem from Joomla 1.5.15. Today I updated to Joomla 1.5.20 but I am still getting this error.

This is how I get it. When I log into the admin back end, I go to components and then contacts.
In the contact manger, I click on published x or check box and this error comes up.

Code: Select all

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 'Inquiries ,1285630768)' at line 2 SQL=INSERT INTO jos_ualog VALUES( NULL,'62','com_contact','unpublish','index.php?option=com_contact&task=edit&cid[]=1','{user} unpublished a contact: {link}',General Inquiries ,1285630768)
Here is a screen shot of it as well:
http://grab.by/6AJX


Not sure what I can do to fix this.

Thanks
Looking to learn option trading?
http://www.optionsizzle.com

User avatar
drmmr763
Joomla! Ace
Joomla! Ace
Posts: 1671
Joined: Tue Oct 23, 2007 8:51 pm
Location: Orlando, Florida
Contact:

Re: SQL Syntax error

Post by drmmr763 » Tue Sep 28, 2010 2:58 am

Huh....Just curious since it's popping up the UID 62....is the contact linked to a user? if so try unlinking and then unpublishing.
-Chad Windnagle
Please use the search feature as your question might already have been answered.

http://www.s-go.net/ ~ Website Hosting - Strategic Marketing - Website Development - Print Work

jbelanger
Joomla! Intern
Joomla! Intern
Posts: 82
Joined: Mon Oct 20, 2008 2:42 pm
Location: Chicago,il
Contact:

Re: SQL Syntax error

Post by jbelanger » Tue Sep 28, 2010 3:13 am

No just a categorie I made.
Looking to learn option trading?
http://www.optionsizzle.com

User avatar
drmmr763
Joomla! Ace
Joomla! Ace
Posts: 1671
Joined: Tue Oct 23, 2007 8:51 pm
Location: Orlando, Florida
Contact:

Re: SQL Syntax error

Post by drmmr763 » Tue Sep 28, 2010 3:26 am

Hmmm. Can you get it to do it again? As in with another contact that you try to unpublish? (Try creating one if you don't have one). really odd.
-Chad Windnagle
Please use the search feature as your question might already have been answered.

http://www.s-go.net/ ~ Website Hosting - Strategic Marketing - Website Development - Print Work

jbelanger
Joomla! Intern
Joomla! Intern
Posts: 82
Joined: Mon Oct 20, 2008 2:42 pm
Location: Chicago,il
Contact:

Re: SQL Syntax error

Post by jbelanger » Tue Sep 28, 2010 3:56 am

Yeah, It is also doing it in other places like in the banners, here is another screen shot

http://grab.by/6AW8
Looking to learn option trading?
http://www.optionsizzle.com

jbelanger
Joomla! Intern
Joomla! Intern
Posts: 82
Joined: Mon Oct 20, 2008 2:42 pm
Location: Chicago,il
Contact:

Re: SQL Syntax error

Post by jbelanger » Tue Sep 28, 2010 1:16 pm

I narrowed it down to a plugin called system folder called System - User activity log. I turned this off and no error. But what does the plug in do?
Looking to learn option trading?
http://www.optionsizzle.com


Locked

Return to “Installation 1.5”