First user registration has problem

[kjusupov]

After successfully installing, try to register the first user and you will hit error and no data will be committed into database:

Code: Select all

phpMyFAQ warning [2]: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key value violates unique constraint "faquser_pkey" in Pgsql.php on line 91

Re-submit the same form again and this time no error and data gets committed into database...

Also, on the same form there are 3 typos in phpmyfaq/template/register.tpl file (english version):
adress ! = address
awnser != answer
authoriziesed != authorized

[Thorsten]

Hi,

I cannot reproduce your first error... I'll have to investigate this more deeply.

I fixed the typos, thanks for the hint!

bye
Thorsten

[kjusupov]

Hi,

After a clean install:

1. Open the web-UI (public view, do not login as admin)
2. Click on Register and proceed to register as a new user

That's where I got that error...

[Thorsten]

Hi,

I don't get this error on MySQL. I'll check it on PostgreSQL later.

bye
Thorsten