dotProject on MySql 5

apps

#1

I installed dotProject (http://dotproject.net) with a mysql5 db. I suspect the syntax they are using isn’t compatible with mysql5.

Has anyone else had this issue? What did you do to get it to work? Currently I’m getting line errors saying the sql statements aren’t executing properly. We can login, so the connection to the db is working, just those queries aren’t.

I’ve also got that domain set up for PHP 5 running as a CGI.

Thanks!
Angela

================================
CrimsonDryad Web Design Services
Web Design, Custom Software Development
http://www.crimsondryad.com


#2

This is almost certainly an SQL syntax issue. The JOIN syntax was updated in 5.0.12 to make MySQL more compliant with the 2003 ANSI standard. In situations like this:

FROM table1, table2 LEFT JOIN table3 ON (expr)you need to rewrite it like this:

FROM (table1, table2) LEFT JOIN table3 ON (expr)The new behavior is documented in the join syntax documentation.


Simon Jessey | Keystone Websites
Save $97 on yearly plans with promo code [color=#CC0000]SCJESSEY97[/color]


#3

Thanks, I’ll try it. Though honestly, I’ve got scripts I’ve written before with joins not using the parenthesis and they’ve worked fine. So I’m a little confused.

================================
CrimsonDryad Web Design Services
Web Design, Custom Software Development
http://www.crimsondryad.com


#4

Joins written using the earlier method may still work, but they may produce unexpected results. For example, if you wrote this:

FROM table1, table2 LEFT JOIN table3 ON (expr)it is parsed like this:

FROM table1, (table2 LEFT JOIN table3 ON (expr))instead of like this

FROM (table1, table2) LEFT JOIN table3 ON (expr)Putting the parentheses around the table names forces the query to run as expected, and it allows you to refer to columns within table1 in the expression.


Simon Jessey | Keystone Websites
Save $97 on yearly plans with promo code [color=#CC0000]SCJESSEY97[/color]


#5

I took a look at the dotProject code. It’s super abstracted. So I’ll probably just use something else. sigh I’m too lazy and/or busy to comb through a billion include files.

================================
CrimsonDryad Web Design Services
Web Design, Custom Software Development
http://www.crimsondryad.com


#6

w00t!! They just released a new version today with MySQL 5 support! Yay!!

Thanks!

================================
CrimsonDryad Web Design Services
Web Design, Custom Software Development
http://www.crimsondryad.com


#7

LOL. I guess that it is a case of “ask and you shall receive.” What an extraordinary coincidence!


Simon Jessey | Keystone Websites
Save $97 on yearly plans with promo code [color=#CC0000]SCJESSEY97[/color]