Re: [Phpgroupware-users] Can someone tell me what I'm smoking?

[Travis Tabbal]

Yes, in /setup exerything is fine and I can talk to the DB. In "Simple
Application Managment" it says the tables are fine. In Advanced, I get some
errors.

For example, installing "timetrack" I get this:

-----
App install/remove/upgrade:
Database error: Invalid SQL: CREATE SEQUENCE seq_phpgw_ttrack_customers
PostgreSQL Error: 1 (ERROR: Relation 'seq_phpgw_ttrack_customers' already
exists )

Fatal error: Call to a member function on a non-object in
/var/www/phpgroupware/phpgwapi/inc/class.db_pgsql.inc.php on line 545
-----

In "tts" it shows that the tables loaded in just fine. But when I attempt to
run it I get this:

-----
Database error: Invalid SQL: SELECT * from phpgw_categories WHERE
(cat_appname='tts' AND (cat_owner='3' OR cat_access='public' AND cat_owner
in(3,-1)) ) ORDER BY cat_main, cat_level, cat_name ASC
PostgreSQL Error: 1 (ERROR: parser: parse error at or near "-" )

File: /var/www/phpgroupware/phpgwapi/inc/class.categories.inc.php
Line: 176

Session halted.
Fatal error: Call to undefined function: parse_navbar_end() in
/var/www/phpgroupware/phpgwapi/inc/footer.inc.php on line 62
-----

Most of the apps that make it past installation that fail do so in similiar
fashion. This is .9.14RC1 on PostgreSQL.

Now that I look again at the version number in dselect I may well have an
old version. I'll go download the latest from postgresql.org and try again.
I could have sworn I had a 7.x version.. MySQL is 3.22.32 and doesn't work.
It fails in different places though.

Travis


> should work in just about any version.  Have you into /setup/ and
> manage application to make sure everything is ok?  If it is all ok,
> what are the errors you are getting?
>
> Travis Tabbal (address@hidden) wrote*:
>>
>>Okay. I have tried .9.12 and .9.14RC1.
>>
>>In both I get tons of Invalid SQL errors under both PostgreSQL and
>>MySQL. So, I am wondering what database DOES work. I have a devel copy
>>of Oracle 8i, would that work? In some modules, PGSQL works, in others,
>>MySQL works. I've tried everything I can think of but I can't seem to
>>get it to stabilize. Some of the apps can't even generate thier tables
>>properly. Is there a recomended configuration some of the developers
>>are using that I can try? The only things that seem to work all the
>>time are Email, Admin, and Preferences.
>>
>>My config is PHP4.1.1, Apache 1.3.19, Debian slink, and postgresql or
>>mysql from apt-get. I can download and compile a specific version if
>>that is what I need.
>>
>>I can get the DB connection to work, and the basic tables seem to load
>>fine. It's the various apps I can't get to work. I want notes, forums,
>>trouble tickets, email, admin, preferences, and maybe chat at a
>>minimum. The problems all seem to be related to SQL errors. So the code
>>could be fine, except the queries. Any info would be helpfull.
>>
>>Travis
>>
>>
>>
>>_______________________________________________
>>Phpgroupware-users mailing list
>>address@hidden
>>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>
>
>
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users