3.4.5 > 3.4.6 produces SQL error regarding ucm_history table

Need help upgrading your Joomla! website or converting to Joomla! 3.x?

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.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
darengr
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Sat Oct 04, 2008 10:20 pm

3.4.5 > 3.4.6 produces SQL error regarding ucm_history table

Post by darengr » Mon Dec 14, 2015 7:18 pm

hello,
just upgraded from 3.4.5 to 3.4.6 sucessfully (?).

Whenever I try to enter a new or update an existing article or article category, I am getting the following SQL error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `sha1_hash` = 'ab03ad8c2a69e6e0cdcebedf824ef95b8417f504' LIMIT 0, 1' at line 3

SELECT * FROM `vv_ucm_history`
WHERE `ucm_item_id` = 33
AND `ucm_type_id` =
AND `sha1_hash` = 'ab03ad8c2a69e6e0cdcebedf824ef95b8417f504' LIMIT 0, 1

it is obvious that something is missing for the `ucm_type_id` ???
any thoughts please?

thanks

System Information
Setting Value

PHP Built On Linux static.nnn.nnn.nnn.nnn 3.10.0-123.9.3.el7.x86_64 #1 SMP Thu Nov 6 15:06:03 UTC 2014 x86_64
Database Version 5.5.43-MariaDB
Database Collation utf8_general_ci
PHP Version 5.6.15
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.4.6 Stable [ Ember ] 15-December-2015 11:11 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.80 Safari/537.36
Last edited by darengr on Mon Dec 21, 2015 1:16 pm, edited 1 time in total.

harperlala
Joomla! Guru
Joomla! Guru
Posts: 697
Joined: Mon Aug 24, 2015 5:55 pm

Re: 3.4.5 > 3.4.6 produces SQL error regarding ucm_history t

Post by harperlala » Tue Dec 15, 2015 3:11 am

Go to:
1) Extensions
2) Extension Manager
3) Database
4) Fix

if not solve, you can disable it from com_content option:
http://joomlart.s3.amazonaws.com/images ... ersion.jpg

darengr
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Sat Oct 04, 2008 10:20 pm

Re: 3.4.5 > 3.4.6 produces SQL error regarding ucm_history t

Post by darengr » Tue Dec 15, 2015 10:34 am

thanks a lot,
I already tried the database fix yesterday, no luck.
So I will disable it, as you suggested.
Should I report it somewhere so it gets fixed?


Locked

Return to “Migrating and Upgrading to Joomla! 3.x”