On Mon, Oct 19, 2009 at 01:54:31PM +0900, Stephane LAPIE wrote: > Could any of the maintainers provide a proper 0.8.4 postgres file ? This > is really annoying, and I am currently creating my "own" file by using > the 0.8.3 one and checking the differences with the mysql file for any > missing data. Attached is the jffnms 0.8.5 database schema. The bad news is mysqldump has changed and doesn't like the flags jffnms had.
The good news is mysqldump has a postgresql compatibility mode which I used to generate the attached file. If you can import this I'll know it works ok. This would be a *much* better way of generating the postgresql files as it directly takes the schema and is not converted by a third-party script which breaks. > Also, "engine/consolidate/logfiles.php" and "engine/logfiles.php" refer > to an "offset" field in a table that did not exist in 0.8.3. This is > problematic for two reasons, since there is no postgres schema > instruction for this table, but also because "offset" is a postgres > keyword and can't be used as a table column name. This was mentioned previously, comment out the two lines that mention logfiles in engine/consolidate.php - Craig -- Craig Small GnuPG:1C1B D893 1418 2AF4 45EE 95CB C76C E5AC 12CA DFA5 http://www.enc.com.au/ csmall at : enc.com.au http://www.debian.org/ Debian GNU/Linux, software should be Free ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users
