HI,
I am trying to install phPay V2.01 on a system with a running postgres server. I could not get the web-based routine to build either database,or tables so I have now tried the sql files in admin/doc/phpayv201complete.sql. These bang out completely as the comment "#" is not accepted with postgresql. Having changed them, I found that the "DROP TABLE IF EXISTS xxx" also does not exist in postgresql. Am I missing something, or are the complete setup, etc only for MySQL??
regards
John Read
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
HI,
I have editted the sql file to allow it to pass in postgresql,. There are a lot of changes. One major change is that the table "user" is not allowed, it is a reserved name. I can imagine that this is a show-stopper!!
I can send you the modified sql file. I have left the original sql in places where the changes are not obvious.
The question remains: has phpay ever run using postgres?? or is it always run on MySQL?
regards
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I was into it recently and is definitive :
major changes needed to run postgresql
- phpayv201complete.sql
- uses reserved word "user" as table
- no KEY ID (ID)
- no tinyint(1)
- no smallint(4)
- *.php files
- "from user" & "updated user" should be replaced
- On "insert" or "delete" it uses "or db_die()" when Postgresql never returns nothing...
- definitive: a major effort to porting
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Whilst experimenting I found that the variable $db_type is automatically set to the wrong value during first start. It is set to "postgresl" not "postgresql". (in admin/admain.php). This means that the postgresql code never got called anyway!!!
The real problem is the "user" table I think.
I have got a working (passing) phpayv201complete.sql that I can send.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
HI,
I am trying to install phPay V2.01 on a system with a running postgres server. I could not get the web-based routine to build either database,or tables so I have now tried the sql files in admin/doc/phpayv201complete.sql. These bang out completely as the comment "#" is not accepted with postgresql. Having changed them, I found that the "DROP TABLE IF EXISTS xxx" also does not exist in postgresql. Am I missing something, or are the complete setup, etc only for MySQL??
regards
John Read
HI,
I have editted the sql file to allow it to pass in postgresql,. There are a lot of changes. One major change is that the table "user" is not allowed, it is a reserved name. I can imagine that this is a show-stopper!!
I can send you the modified sql file. I have left the original sql in places where the changes are not obvious.
The question remains: has phpay ever run using postgres?? or is it always run on MySQL?
regards
John
I was into it recently and is definitive :
major changes needed to run postgresql
- phpayv201complete.sql
I was into it recently and is definitive :
major changes needed to run postgresql
- phpayv201complete.sql
- uses reserved word "user" as table
- no KEY ID (ID)
- no tinyint(1)
- no smallint(4)
- *.php files
- "from user" & "updated user" should be replaced
- On "insert" or "delete" it uses "or db_die()" when Postgresql never returns nothing...
- definitive: a major effort to porting
Whilst experimenting I found that the variable $db_type is automatically set to the wrong value during first start. It is set to "postgresl" not "postgresql". (in admin/admain.php). This means that the postgresql code never got called anyway!!!
The real problem is the "user" table I think.
I have got a working (passing) phpayv201complete.sql that I can send.
I created a new forum to for PostgreSQL.
http://sourceforge.net/forum/forum.php?forum_id=199615