ljxp and postgres interaction
japester - December 18, 2006 - 00:03
| Project: | LiveJournal CrossPoster |
| Version: | 4.7.x-1.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
I installed the ljxp module and tried to add in my account details.
all I see is a lot of these errors in my logs:
Type php
Date Monday, 18 December, 2006 - 08:07
User admin
Location http://www.blaquiere.id.au/user/1
Referrer http://www.blaquiere.id.au/user/1/edit
Message query: SELECT * FROM ljxp WHERE uid = 1 in /usr/share/drupal/includes/database.pgsql.inc on line 103.
Severity error
Hostname
beats me what's actually happening ...
#1
Hmm. I'm guessing that the database creation fails under pgsql, which is unfortunate. I thought i had a query that worked both ways, but I appear to have been wrong.
I just put in a different query that theoretically should work under postgres but I cannot easily test it.
Update to the 1.1 version (which will be available shortly) and do the pgsql equivalent of this: (should be the same query):
DELETE FROM system WHERE name = 'ljxp';
Then go and re-enable the ljxp module. Check for any errors in your watchdog log, and if they appear please post them on this issue.