Issues saving to PostGreSQL.
spydmobile - February 26, 2008 - 21:33
| Project: | Super Nav |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active (needs more info) |
Jump to:
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