Issues saving to PostGreSQL.
spydmobile - February 26, 2008 - 21:33
| Project: | Super Nav |
| Version: | 6.x-1.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Description
This module throws errors all over, here are some, just clicking polls in supernav
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "supernav_user_settings" does not exist in C:\ms4w\Apache\htdocs\itportal\includes\database.pgsql.inc on line 138.
* user warning: query: SELECT * FROM supernav_user_settings WHERE uid="1" in C:\ms4w\Apache\htdocs\itportal\modules\supernav\supernav.module on line 136.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "supernav_user_settings" does not exist in C:\ms4w\Apache\htdocs\itportal\includes\database.pgsql.inc on line 138.
* user warning: query: SELECT * FROM supernav_user_settings WHERE uid="1" in C:\ms4w\Apache\htdocs\itportal\modules\supernav\supernav.module on line 136.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "supernav_user_settings" does not exist in C:\ms4w\Apache\htdocs\itportal\includes\database.pgsql.inc on line 138.
* user warning: query: SELECT * FROM supernav_user_settings WHERE uid="1" in C:\ms4w\Apache\htdocs\itportal\modules\supernav\supernav.module on line 136.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "supernav_bm" does not exist in C:\ms4w\Apache\htdocs\itportal\includes\database.pgsql.inc on line 138.
* user warning: query: SELECT * FROM supernav_bm WHERE uid = "1" ORDER BY ord ASC in C:\ms4w\Apache\htdocs\itportal\modules\supernav\supernav.module on line 313.
#1
Ah, it looks like you're running PostgreSQL, and the tables didn't get installed. I was wondering when someone would run into that problem. ;)
I have switched the installation of the Drupal 6 version to a schema, so it should (hopefully) work on PostgreSQL. Please give the lastest version a run next time it packages, or check it out from CVS. I'd love to get this straight, so please let me know if there's any problems.
If you also felt like testing the Drupal 5 version on PostgreSQL, I would be much obliged. I used a query converter but am not able to test it myself.
Thanks!
Chris
#2
I dont have a d5 on PG here ATM, I have no idea when "the next time it packages" would be, could you give me a hint? also I will endeavor set up a d5 sandbox on PG to test it for you, just dont know when yet...
#3
spydmobile - Drupal 'packages' new versions of the modules a couple times a day. So, by 'next time it packages' would mean somewhere between 1 and 12 hours from the time I upload a release. I don't quite have a feel for when those times are yet, but it's definitely been packaged by now. ;)
Chris
#4
#5
Hi, I checked out the module on my PG server again today, and ended up with some issues you should see.
1) I installed the module
2) Enabled the module
3) Configured permissions for the module for my user (admin but not root)
Got these SQL errors: see attached.....PS this was on d65 using 6.x-1.0
disabled module
and got:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: column "11" does not exist LINE 1: SELECT * FROM supernav_user_settings WHERE uid="11" ^ in C:\Program Files\PostgreSQL\EnterpriseDB ApachePhp\apache\www\includes\database.pgsql.inc on line 138.* user warning: query: SELECT * FROM supernav_user_settings WHERE uid="11" in C:\Program Files\PostgreSQL\EnterpriseDB ApachePhp\apache\www\sites\all\modules\supernav\supernav.module on line 218.
Franco
#6
you may need to revisit your PGSQL coding.....
Just a thought
Franco
#7
Please see http://drupal.org/node/285027#comment-1094346. The Drupal 6 version of Navigate should work for Postgresql, though I haven't tested it yet.