Author: n.kaiser
Description:
Hello,
I have updated my Mediawiki from Version 1.8.4 to 1.11.0(German-language). My PostgreSQL Version is 8.2 (Windows-Version).
Now don't work some functions.
- Upload - Function concat und function If do not exists in pg/plSQL
"Function: LocalFileDeleteBatch::doDBInserts Error: 1 ERROR: function concat(text, "unknown") does not exist LINE 1: ..._timestamp) SELECT 'deleted',IF(img_sha1='', '', CONCAT(img... ^ HINT: No function matches the given name and argument types. You may need to add explicit type casts. "
I wrote and install this function. now ist works for me
- Compare Versions
"A database error has occurred Query: SELECT * FROM recentchanges WHERE rc_timestamp = '20070912111612' AND rc_this_oldid = '1693' AND rc_last_oldid = '1692' AND rc_patrolled = '0' Function: DifferenceEngine::showDiffPage Error: 1 ERROR: invalid input syntax for type timestamp with time zone: "20070912111612"
Backtrace:
#0 C:\Programme\Apache Group\Apache2\htdocs\wiki\includes\Database.php(779): DatabasePostgres->reportQueryError('ERROR: invalid...', 1, 'SELECT * FROM...', 'DifferenceEngin...', false)
#1 C:\Programme\Apache Group\Apache2\htdocs\wiki\includes\Database.php(1224): Database->query('SELECT * FROM...', 'DifferenceEngin...')
#2 C:\Programme\Apache Group\Apache2\htdocs\wiki\includes\RecentChange.php(100): Database->select('recentchanges', '*', Array, 'DifferenceEngin...')"
What can I do?
Thanks
Norbert
Version: 1.11.x
Severity: major
OS: Windows Server 2003
Platform: PC