eGroupware 1.8

ngegw 2010-09-22 14:50:14 UTC #1

eGW 1.8 has been released.
Anyone using pERP trunk have any problems with it vs eGW trunk? Anyone try?

This release contains features needed for a release of pERP, so if
there are no (new) issues discovered, there should be a new projectERP
release shortly.

Nathan

Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

Stefan_Roder 2010-09-22 15:11:31 UTC #2

Hi Nathan,
we are on trunk with egw and do use perp in a very rudimental way. As far as I can see for now, there are no further problems since the update to 1.9.
But please be aware, that our installation of perp isn’t configured completely, so there might be some aspects I cannot report of.
Let me tell you after all, that you did a great job with this piece of software. I think I haven’t understood half of the possible functions of perp, but even for now, it seems to be a very mighty masterpiece.
Thanks for that and best whishes from Hamburg
Stefan

Alexandre 2010-09-28 14:35:57 UTC #3

Hi, Nathan.

Now that we have egw 1.8 release, and considering that pERP was so well developed during last years, I would know if since now you will develop pERP based on egw 1.8 stable or trunk still. I think would be interesting the development based on the stable 1.8 because it improve reliable on pERP, specially because o 1.8 already have several new features.

What do you think about?

ngegw 2010-09-28 15:51:03 UTC #4

Hi, Nathan.

Now that we have egw 1.8 release, and considering that pERP was so well
developed during last years, I would know if since now you will develop pERP
based on egw 1.8 stable or trunk still.

I have no plans at this time to use anything that is only in trunk.
However, because most of my development work on eGW is done in trunk,
that is what I will be most familiar with. I will try to keep things
so they work with 1.8, but there’s only one of me.

1.8 already have several new features.

I haven’t heard any reports of pERP not working with 1.8

What do you think about?

My family. Getting more sleep. Getting everything I need to done
before the snow comes. Coffee. Lunch.
The usual.

Nathan

Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

Massimo_676 2010-10-05 07:18:53 UTC #5

Hi, i have upgraded eGroupware and i have one error:

in the project manager if i select “element view” have this error:
Invalid SQL: (SELECT c.,b.link_app1 AS app3,b.link_id1 AS id3,b.link_id AS link3 FROM egw_links a
JOIN egw_links b ON a.link_id2=b.link_id1 AND a.link_app2=b.link_app1
JOIN egw_links c ON a.link_id1=c.link_id1 AND a.link_app1=c.link_app1 AND a.link_id!=c.link_id AND c.link_app2=b.link_app2 AND c.link_id2=b.link_id2 WHERE a.link_app1=‘timesheet’ AND c.link_app2=‘projectmanager’ AND c.link_id2=‘44’)
UNION
(SELECT b.link_id, b.link_app2 as app1, b.link_id2 as id1, b.link_app1 as app2, b.link_id1 as id2, b.link_remark,b.link_lastmod,b.link_owner,c.link_app1 AS app3,c.link_id1 AS id3,c.link_id AS link3 FROM egw_links a
JOIN egw_links b ON a.link_id1=b.link_id2 AND a.link_app1=b.link_app2
JOIN egw_links c ON a.link_id2=c.link_id1 AND a.link_app2=c.link_app1 AND a.link_id!=c.link_id AND c.link_app2=b.link_app1 AND c.link_id2=b.link_id1 WHERE a.link_app1=‘timesheet’ AND b.link_app1=‘projectmanager’ AND b.link_id1=‘44’)
UNION
(SELECT a.,c.link_app1 AS app3,c.link_id1 AS id3,c.link_id AS link3 FROM egw_links a
JOIN egw_links b ON a.link_id1=b.link_id2 AND a.link_app1=b.link_app2
JOIN egw_links c ON a.link_id2=c.link_id2 AND a.link_app2=c.link_app2 AND a.link_id!=c.link_id AND c.link_app1=b.link_app1 AND c.link_id1=b.link_id1 WHERE a.link_app1=‘timesheet’ AND a.link_app2=‘projectmanager’ AND a.link_id2=‘44’):
The used SELECT statements have a different number of columns

any idea?

ngegw 2010-10-05 14:56:37 UTC #6

…
Hi, i have upgraded eGroupware and i have one error:

in the project manager if i select “element view” have this error:
Invalid SQL: (SELECT c.*,b.link_app1 AS app3,b.link_id1 AS id3,b.link_id AS
…
The used SELECT statements have a different number of columns

I’m not sure this has anything to do with pERP.
Can you turn on the exception trace, and post that please?

Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

Massimo_676 2010-10-07 09:24:52 UTC #7

I also think it is not dependent on perp

how can I activate the exception trace?

ngegw 2010-10-07 14:01:41 UTC #8

I also think it is not dependent on perp

how can I activate the exception trace?

Admin -> Site configuration under Security

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

Massimo_676 2010-10-08 14:41:08 UTC #9

Thanks, the log is:

Database error

Invalid SQL: (SELECT c.,b.link_app1 AS app3,b.link_id1 AS id3,b.link_id AS link3 FROM egw_links a
JOIN egw_links b ON a.link_id2=b.link_id1 AND a.link_app2=b.link_app1
JOIN egw_links c ON a.link_id1=c.link_id1 AND a.link_app1=c.link_app1 AND a.link_id!=c.link_id AND c.link_app2=b.link_app2 AND c.link_id2=b.link_id2 WHERE a.link_app1=‘timesheet’ AND c.link_app2=‘projectmanager’ AND c.link_id2=‘1057’)
UNION
(SELECT b.link_id, b.link_app2 as app1, b.link_id2 as id1, b.link_app1 as app2, b.link_id1 as id2, b.link_remark,b.link_lastmod,b.link_owner,c.link_app1 AS app3,c.link_id1 AS id3,c.link_id AS link3 FROM egw_links a
JOIN egw_links b ON a.link_id1=b.link_id2 AND a.link_app1=b.link_app2
JOIN egw_links c ON a.link_id2=c.link_id1 AND a.link_app2=c.link_app1 AND a.link_id!=c.link_id AND c.link_app2=b.link_app1 AND c.link_id2=b.link_id1 WHERE a.link_app1=‘timesheet’ AND b.link_app1=‘projectmanager’ AND b.link_id1=‘1057’)
UNION
(SELECT a.,c.link_app1 AS app3,c.link_id1 AS id3,c.link_id AS link3 FROM egw_links a
JOIN egw_links b ON a.link_id1=b.link_id2 AND a.link_app1=b.link_app2
JOIN egw_links c ON a.link_id2=c.link_id2 AND a.link_app2=c.link_app2 AND a.link_id!=c.link_id AND c.link_app1=b.link_app1 AND c.link_id1=b.link_id1 WHERE a.link_app1=‘timesheet’ AND a.link_app2=‘projectmanager’ AND a.link_id2=‘1057’):
The used SELECT statements have a different number of columns

#0 /var/www/egroupware/phpgwapi/inc/class.egw_db.inc.php(674): egw_db->halt(‘Invalid SQL: (S…’, 403, ‘/var/www/egroup…’)
#1 /var/www/egroupware/phpgwapi/inc/class.egw_db.inc.php(2032): egw_db->query(’(SELECT c.*,b.l…’, 403, ‘/var/www/egroup…’, false, -1, false, 2)
#2 /var/www/egroupware/phpgwapi/inc/class.solink.inc.php(403): egw_db->union(Array, 403, ‘/var/www/egroup…’)
#3 /var/www/egroupware/timesheet/inc/class.timesheet_hooks.inc.php(69): solink::get_3links(‘timesheet’, ‘projectmanager’, 1057)
#4 [internal function]: timesheet_hooks::cumulate(Array)
#5 /var/www/egroupware/phpgwapi/inc/common_functions.inc.php(886): call_user_func(‘timesheet_hooks…’, Array)
#6 /var/www/egroupware/phpgwapi/inc/class.hooks.inc.php(153): ExecMethod(‘timesheet_hooks…’, Array)
#7 /var/www/egroupware/phpgwapi/inc/class.hooks.inc.php(115): hooks->single(Array, ‘timesheet’, false)
#8 /var/www/egroupware/projectmanager/inc/class.projectmanager_elements_bo.inc.php(704): hooks->process(Array)
#9 /var/www/egroupware/etemplate/inc/class.so_sql.inc.php(1347): projectmanager_elements_bo->search(Array, false, ‘pe_modified DES…’, Array, ‘’, false, ‘AND’, Array, Array, true, false)
#10 /var/www/egroupware/projectmanager/inc/class.projectmanager_elements_ui.inc.php(466): so_sql->get_rows(Array, Array, Array, true)
#11 /var/www/egroupware/etemplate/inc/class.nextmatch_widget.inc.php(548): projectmanager_elements_ui->get_rows(Array, Array, Array)
#12 /var/www/egroupware/etemplate/inc/class.nextmatch_widget.inc.php(302): nextmatch_widget::call_get_rows(Array, Array, Array)
#13 /var/www/egroupware/etemplate/inc/class.boetemplate.inc.php(516): nextmatch_widget->pre_process(‘exec[nm]’, Array, Array, Array, Array, Object(etemplate))
#14 /var/www/egroupware/etemplate/inc/class.etemplate.inc.php(1094): boetemplate->extensionPreProcess(‘nextmatch’, ‘exec[nm]’, Array, Array, Array)
#15 /var/www/egroupware/etemplate/inc/class.etemplate.inc.php(873): etemplate->show_cell(Array, Array, Array, ‘exec’, 0, 1, ‘’, ‘’, ‘/0/2A’)
#16 /var/www/egroupware/etemplate/inc/class.etemplate.inc.php(1439): etemplate->show_grid(Array, Array, Array, ‘exec’, 0, 0, ‘/0’)
#17 /var/www/egroupware/etemplate/inc/class.etemplate.inc.php(682): etemplate->show_cell(Array, Array, Array, ‘exec’, 0, 0, ‘’, NULL, ‘/0’)
#18 /var/www/egroupware/etemplate/inc/class.etemplate.inc.php(259): etemplate->show(Array, Array, Array, ‘exec’)
#19 /var/www/egroupware/projectmanager/inc/class.projectmanager_elements_ui.inc.php(678): etemplate->exec(‘projectmanager…’, Array, ‘’, NULL)
#20 /var/www/egroupware/index.php(155): projectmanager_elements_ui->index()
#21 {main}

ngegw 2010-10-08 15:19:47 UTC #10

Thanks, the log is:

Database error
…
#2 /var/www/egroupware/phpgwapi/inc/class.solink.inc.php(403):

Thank you, I was able to find and fix that error in SVN trunk.
I don’t think your upgrade to eGW 1.8 happened properly. 1.8 doesn’t
appear to have that problem.

Nathan

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

Massimo_676 2010-10-11 14:56:38 UTC #11

Thank you, now it work correctly