ericomtx

there is an error on postgres log :
ERROR: syntax error at or near “(” at character 485
STATEMENT: SELECT pg_attribute.attname AS “Field”,
CASE pg_type.typname
WHEN ‘int2’ THEN ‘int(4)’
WHEN ‘int4’ THEN ‘int(11)’
WHEN ‘int8’ THEN ‘bigint(20) unsigned’
WHEN ‘varchar’ THEN ‘varchar(‘ || pg_attribute.atttypmod-4 || ‘)’
WHEN ‘timestamp’ THEN ‘datetime’
WHEN ‘text’ THEN ‘longtext’
ELSE pg_type.typname
END AS “Type”,
CASE WHEN pg_attribute.attnotnull THEN ”
ELSE ‘YES’
END AS “Null”,
CASE pg_type.typname
WHEN ‘varchar’ THEN substring(pg_attrdef.adsrc FROM ‘^\'(.*)\’.*$’)
WHEN ‘timestamp’ THEN CASE WHEN pg_attrdef.adsrc LIKE ‘%now()%’ THEN ‘0000-00-00 00:00:00’ ELSE pg_attrdef.adsrc END
ELSE pg_attrdef.adsrc
END AS “Default”
FROM pg_class
INNER JOIN pg_attribute
ON (pg_class.oid=pg_attribute.attrelid)
INNER JOIN pg_type
ON (pg_attribute.atttypid=pg_type.oid)
LEFT JOIN pg_attrdef
ON (pg_class.oid=pg_attrdef.adrelid AND pg_attribute.attnum=pg_attrdef.adnum)
WHERE pg_class.relname=’wp_term_relationships’ AND pg_attribute.attnum>=1 AND NOT pg_attribute.attisdropped;

can it be related to the problem ?

Wouldn’t this be a postgres issue ? I have the pgphpadmin installed local and I am able to access the application. I got istalled by macports on /opt/local/www and the dir is with the admin and owner from htpdocs …

I mean … would be missing any privilege in the DB side ?

I see in the MySQL install there is a step for setting the granting in MySql DB … ?

Thks for your assistance on this !!
Regards
Érico