Re: Problem with MySQL 5.0 and eventum 1.6.1 - Lorna Mitchell - com.mysql.lists.eventum-users

7 messages in com.mysql.lists.eventum-usersRe: Problem with MySQL 5.0 and eventu...

From	Sent On	Attachments
Frank	25 Oct 2005 07:10
Bryan Alsdorf	25 Oct 2005 07:40
stre...@tiscali.it	25 Oct 2005 08:17
Lorna Mitchell	25 Oct 2005 08:50
Joao Prado Maia	25 Oct 2005 09:50
Lorna Mitchell	25 Oct 2005 11:03
Bryan Alsdorf	03 Nov 2005 20:08

Subject:	Re: Problem with MySQL 5.0 and eventum 1.6.1
From:	Lorna Mitchell (even...@lornajane.net)
Date:	10/25/2005 08:50:21 AM
List:	com.mysql.lists.eventum-users

Could I suggest an alternative syntax alteration? The mix of join types causes problems in many different database platforms which aren't as tolerant as MySQL. I know there are no plans to implement database abstraction for Eventum but I performed a successful SQL Server port of version 1.5.4 earlier in the year. One of the biggest hurdles was that SQL Server does not support the combination of join types, I altered my syntax as follows:

this: " . APP_TABLE_PREFIX . "issue " " . APP_TABLE_PREFIX . "issue_user, " . APP_TABLE_PREFIX . "user"; [followed by other joins]

becomes: " . APP_TABLE_PREFIX . "issue INNER JOIN " . APP_TABLE_PREFIX . "issue_user ON iss_id = isu_iss_id INNER JOIN " . APP_TABLE_PREFIX . "user ON isu_usr_id=usr_id "; [followed again by the other joins]

This change had to be made throughout and although it doesn't represent a large body of work, does make our upgrade path much harder than it needed to be. I am happy to assist in making these changes to enable Eventum to be used with MySQL5 if that would be of use.

Could I also thank the team for this great product, each new feature I try I love!

Lorna

PS SQL Server as a database isn't a platform of my own choosing, its a crazy corporate requirement - but Eventum runs quite sweetly on it with a few mods.

Hi Bryan, Thanks for the info. Here are some other queries to be modifyed that I found: class.report.php -> at row 140 and 77 class.issue.php -> at row 2623 class.impact_analysis.php -> at row 105

Hope this helps, Frank

-- Messaggio Originale -- Date: Tue, 25 Oct 2005 09:41:12 -0500 From: Bryan Alsdorf <bry...@mysql.com> To: Frank <stre...@tiscali.it> CC: even...@lists.mysql.com Subject: Re: Problem with MySQL 5.0 and eventum 1.6.1 Hi Frank, Frank wrote:

Hi, I upgraded from MySQL 4.1 to 5.0 on my localhost where I installed eventum 1.6.1. To move the eventum db I made a mysqldump and then used the 'source' command to load the dump file as I do usually. Eventum seemed to work correctly apart from the issue lists, where I couldn't see any issues (there were more than 100 issue) The error log gives this error: [Tue Oct 25 15:40:27 2005] An error was found on line '67' of script 'D:\servers\http\eventum\include\class.pager.php'. The error message passed to us was: 'DB Error: no such field'

This is due to a change in MySQL 5.0 to be more standards compliant. Unfortunately it had the negative affect of breaking some Eventum queries. We should have a fix out in the near future, but for the time being you

can correct the query yourself. You will need to but all the tables before the left join in parentheses like I do below. SELECT COUNT(iss_id) AS total_rows FROM ( eventum.eventum_issue, eventum.eventum_user ) LEFT JOIN eventum.`eventum_group` ON iss_grp_id=grp_id LEFT JOIN eventum.eventum_project_category ON iss_prc_id=prc_id... There probably all some other queries that need this as well. If you find any, please let us know so we can correct them as well. Best Regards, /bryan MySQL AB

__________________________________________________________________ TISCALI ADSL Solo con Tiscali Adsl navighi senza limiti e telefoni senza canone Telecom a partire da 19,95 Euro/mese. Attivala subito, I PRIMI DUE MESI SONO GRATIS! CLICCA QUI: http://abbonati.tiscali.it/adsl/sa/1e25flat_tc/