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: | Bryan Alsdorf (bry...@mysql.com) |
| Date: | 10/25/2005 07:40:50 AM |
| List: | com.mysql.lists.eventum-users |
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