Hi,

Could you provide more details, which version of poweradmin you are using?
Did you have the same issue with the latest code from the GitHub master
branch?

-Edmondas

On Thu, Mar 22, 2012 at 6:05 AM, TimH <[email protected]> wrote:

> I have decided to try out poweradmin, and all seemed OK until I tied to
> add a zone.
>
> I have created a template, and I tried to add a zone using this template.
>
> I get this error from add_zone_master.php:
>
> Error: _doQuery: [Error message: Could not execute statement] [Last
> executed query: SELECT substring((SELECT substring(pg_get_expr(d.adbin,
> d.adrelid) for 128) FROM pg_attrdef d WHERE d.adrelid = a.attrelid AND
> d.adnum = a.attnum AND a.atthasdef ) FROM 'nextval[^\']*\'([^\']*)') FROM
> pg_attribute a LEFT JOIN pg_class c ON c.oid = a.attrelid LEFT JOIN
> pg_attrdef d ON d.adrelid = a.attrelid AND d.adnum = a.attnum AND
> a.atthasdef WHERE (c.relname = 'domains_id' OR (c.relname = 'domains' AND
> a.attname = 'id') ) AND NOT a.attisdropped AND a.attnum > 0 AND
> pg_get_expr(d.adbin, d.adrelid) LIKE 'nextval%' ORDER BY a.attnum] [Native
> message: ERROR: syntax error at or near "]" LINE 6: ) FROM
> 'nextval[^\']*\'([^\']*)') ^]
>
>
> After I get this error, the zone is created, but it does not use the
> template I have selected.
>
> Afterwards, I am able to edit the zone to use the template.
>
> I am using Pg, which seems to be significant.
>
> Any help appreciated.
>
> --TimH
>
> _______________________________________________
> poweradmin-users mailing list
> [email protected]
> http://lists.poweradmin.org/cgi-bin/mailman/listinfo/poweradmin-users
>
_______________________________________________
poweradmin-users mailing list
[email protected]
http://lists.poweradmin.org/cgi-bin/mailman/listinfo/poweradmin-users

Reply via email to