I am using PostgreSQL with Drupal 5.5.

Receiving this error when viewing individual orders.

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "uc_updiscounts" does not exist in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
    * user warning: query: SELECT * FROM uc_updiscounts WHERE oid = 3 in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.
CommentFileSizeAuthor
#13 userpoints_ubercart-5.1-dev.patch996 bytesWISEOZ

Comments

bmagistro’s picture

bmagistro commented

I would love to say I have a solution, but I didn't think I created any relationships in there. Also I do not have access to pgsql at the present time. Any chance I can get you to play/poke around with it a little?

WISEOZ’s picture

WISEOZ commented

Update using beta6 ... this issue is still present.

bmagistro’s picture

bmagistro commented

how did you install this? I am looking at the install file I have on locally and there is not db setup for pgsql?

WISEOZ’s picture

WISEOZ commented

I just installed beta 6 the usual way ... gzip -d and tar xvf. Have not made any changes. Just started testing and found that this is still happening

bmagistro’s picture

bmagistro commented

I had meant userpoints_ubercart sorry for the confusion

WISEOZ’s picture

WISEOZ commented

Oh sorry! Same way. Do you want me to try a clean install or re-install of it?

bmagistro’s picture

bmagistro commented

I would be curious to see if the problem still exists in the most recent dev release with a clean install if you don't mind. Thanks.

WISEOZ’s picture

WISEOZ commented
Version: 5.x-1.6 » 5.x-1.x-dev

I performed a clean install using the dev version and still get the same error.

bmagistro’s picture

bmagistro commented

can you use phpPGsqlAdmin or something similar and check your database for the following tables?
uc_uplog and uc_updiscount. I do not have sql cod in my install file for pgsql....which is why i think you are having problems. I can take a stab at writing it but i cannot debug it....

edit:
grab the latest dev, you should be able to just do an upgrade and have it create the pgsql tables...(i just hope i got the syntax right)

WISEOZ’s picture

WISEOZ commented
Status: Active » Fixed

My PostgreSQL guy manually created the tables for me. They were indeed missing. The error is now gone.

bmagistro’s picture

bmagistro commented

any chance he would be willing to look my install file over and make sure the sql I have in there for pgsql is good?

WISEOZ’s picture

WISEOZ commented

Yes. He said he will give you a patch in the morning.

WISEOZ’s picture

WISEOZ commented
Title: ERROR: relation "uc_updiscounts" does not exist » PostgreSQL Patch
Status: Fixed » Needs review
StatusFileSize
new userpoints_ubercart-5.1-dev.patch996 bytes

As promised, the PostgreSQL patch is attached for your review. I also updated the issue title to reflect the patch purpose. Enjoy!

bmagistro’s picture

bmagistro commented

Thanks, I will get this rolled into the dev and do a new release with this in it this weekend. Again thanks for your help with this.

bmagistro’s picture

bmagistro commented
Status: Needs review » Fixed

Marking as fixed since there are no other issues and this has been added to the dev release.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.