Re: [Phpgroupware-users] Intermittent database select errors --Still...

[Chris Weiss]

using hte new version of pg?  pg changed the way several things worked, 
including
the LIMIT command, so yeah it could be a compatability issue in the API.

Izzy Blacklock (address@hidden) wrote:
>
>Well, I'm happy to say I have almost everything working now.  One problem I
>still have is the database select error I'm getting.  Originally it was
>
>Fatal Error: It appears that you have not created the database tables for
>phpGroupWare. Click here to run setup.
>
>I found the source file that was displaying the error and turned on the
>halt_on_errors.  ie, I changed no to yes in the following line found before
>the database query.
>
>$GLOBALS['phpgw']->db->Halt_On_Error = 'no';
>
>Now I'm getting this error.
>
>Database error: Invalid SQL: select version()
>PostgreSQL Error: 1 (ERROR: current transaction is aborted, queries ignored
>until end of transaction block )
>
>File:
>/mnt/hda7/www/phpgroupware-0.9.14.002/phpgwapi/inc/class.db_pgsql.inc.php
>Line: 98
>
>Session halted.
>
>I seem to always get this error when the user first logs in.  After that, I
>haven't noticed it lately.  Simply reloading the current page from the
>browser clears it up.
>
>I was also getting it a lot when I was trying to setup the forced and default
>preferences.  Is it possible this is a bug in the API?
>
>...Izzy
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>