Project

General

Profile

Actions

Support #1346

closed

Error when run blog example with postgres backend

Added by Anonymous over 12 years ago. Updated about 12 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
07/03/2012
Due date:
% Done:

0%

Estimated time:

Description

sql error


Files

wt_blog_error.png (49.1 KB) wt_blog_error.png Marcio Sales, 07/06/2012 02:07 PM
Actions #1

Updated by Jake Petroules over 12 years ago

Could you please provide more information on exactly what errors you are receiving?

Actions #2

Updated by Marcio Sales over 12 years ago

look at the image

Actions #3

Updated by Koen Deforche over 12 years ago

  • Status changed from New to InProgress
  • Assignee set to Koen Deforche

Hey,

Indeed, it seems that .id is used but that is not a column in table user ? Could you confirm ?

So it could be that it is inadvertently hardcoded somewhere (it is always available in sqlite)...

Regards

koen

Actions #4

Updated by Marcio Sales over 12 years ago

no confirm. in table user have id column, but when I run sql select * from user in postgres appears a result of a system table

you must add the schema, sql following example

select u.id, u.version, u.name, u.password, u.password_method,

u.password_salt, u.role, u.failed_login_attempts, u.last_login_attempt,

u.oauth_id, u.oauth_provider from adempiere.user u join token t on u.id = t.user_id

Actions #5

Updated by Koen Deforche over 12 years ago

Hey,

Aah, so "user" is a really an unlucky table name. It means that we must add more explicit support for schema's instead of the current half-baked support.

Regards,

koen

Actions #6

Updated by Marcio Sales about 12 years ago

resolved, add the schema to mapping classes

change on BlogSession.C

mapClass("comment");

mapClass("post");

mapClass("tag");

mapClass("token");

mapClass("user");

to

mapClass("adempiere.comment");

mapClass("adempiere.post");

mapClass("adempiere.tag");

mapClass("adempiere.token");

mapClass("adempiere.user");

Actions #7

Updated by Koen Deforche about 12 years ago

  • Status changed from InProgress to Resolved
Actions #8

Updated by Koen Deforche about 12 years ago

  • Status changed from Resolved to Closed
  • Target version set to 3.2.3

Fixed in Wt 3.2.3 RC1.

Actions

Also available in: Atom PDF