Joomla Templates Club 406,261 posts

[clrmedia Friend clrmediaJoin date: October 2007Posts: 102Downloads:18Uploads:8 Thanks: 17 Thanked: 11 times in 1 posts]

#204806

When I try to create a new Banner or Banner Category, I get the following error. Any assistance with a solution will be appreciated.

Error
Save failed with the following error: 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 ‘AND `sha1_hash` = ’16ac62ba73a64919fa16f9974203abec8118c441′ LIMIT 0, 1′ at line 3 SQL=SELECT * FROM `cityfurn_ucm_history` WHERE `ucm_item_id` = 1 AND `ucm_type_id` = AND `sha1_hash` = ’16ac62ba73a64919fa16f9974203abec8118c441’ LIMIT 0, 1

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#563668

Hi there
<blockquote> AND `ucm_type_id` =</blockquote>
Look like you missed to choose type ?

Thank you,
Viet Vu

[clrmedia Friend clrmediaJoin date: October 2007Posts: 102Downloads:18Uploads:8 Thanks: 17 Thanked: 11 times in 1 posts]

#563672

I tried both image and custom. This screen shot is image –

---

Attachments:

1. 

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#563674

Hi there
Please provide your site backend & CPanel access. I’ll help you check it.
I think type filed missed records

Thank you,
Viet Vu

[clrmedia Friend clrmediaJoin date: October 2007Posts: 102Downloads:18Uploads:8 Thanks: 17 Thanked: 11 times in 1 posts]

#563677

PM has been sent.

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#563852

Hi there
Sorry delayed of reply. I’m considering it’s Joomla! issue.

http://stackoverflow.com/questions/22554827/editing-article-in-joomla-3-2-sql-error

http://forum.joomla.org/viewtopic.php?f=708&t=826240
Please try to work with joomla.org community.

Thank you,
Viet Vu

1 user says Thank You to jooservices for this useful post

1. clrmedia

[clrmedia Friend clrmediaJoin date: October 2007Posts: 102Downloads:18Uploads:8 Thanks: 17 Thanked: 11 times in 1 posts]

#563855

Thank you! The stackoverflow article pointed me in the right direction. I set “Save History” to No for Banners and the SQL error disappeared.

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#563856

Glad to hear that

Thank you,
Viet Vu

[Author]

Posts