Hi, I'm evaluating alternative solution for a hosted Jira (for obvious reasons). Today I came to Pachno.
The installation worked mostly fine (Xubuntu 20.04, apache2, PostgreSQL) but after I've been asked about the apache autoconfiguration I got a SQL Error in the website.
The Website says (SQL formatted by me):
The following error occurred:
ERROR: syntax error at or near ".2"
LINE 1: ...il, users5.enable_2fa AS users5_enable_2fa, users5.2fa_token...
^
An exception was thrown in the B2DB framework
SQL:
SELECT
settings3.name AS settings3_name,
settings3.updated_at AS settings3_updated_at,
settings3.uid AS settings3_uid,
settings3.module AS settings3_module,
settings3.value AS settings3_value,
settings3.scope AS settings3_scope,
settings3.id AS settings3_id,
users5.username AS users5_username,
users5.password AS users5_password,
users5.realname AS users5_realname,
users5.buddyname AS users5_buddyname,
users5.email AS users5_email,
users5.private_email AS users5_private_email,
users5.enable_2fa AS users5_enable_2fa,
users5.2fa_token AS users5_2fa_token,
users5.userstate AS users5_userstate,
users5.customstate AS users5_customstate,
users5.homepage AS users5_homepage,
users5.language AS users5_language,
users5.avatar AS users5_avatar,
users5.use_gravatar AS users5_use_gravatar,
users5.lastseen AS users5_lastseen,
users5.timezone AS users5_timezone,
users5.quota AS users5_quota,
users5.joined AS users5_joined,
users5.enabled AS users5_enabled,
users5.openid_locked AS users5_openid_locked,
users5.activated AS users5_activated,
users5.deleted AS users5_deleted,
users5.preferred_issues_syntax AS users5_preferred_issues_syntax,
users5.preferred_wiki_syntax AS users5_preferred_wiki_syntax,
users5.preferred_comments_syntax AS users5_preferred_comments_syntax,
users5.prefer_wiki_markdown AS users5_prefer_wiki_markdown,
users5.id AS users5_id, scopes6.name AS scopes6_name,
scopes6.description AS scopes6_description,
scopes6.enabled AS scopes6_enabled,
scopes6.uploads_enabled AS scopes6_uploads_enabled,
scopes6.max_upload_limit AS scopes6_max_upload_limit,
scopes6.custom_workflows_enabled AS scopes6_custom_workflows_enabled,
scopes6.max_workflows AS scopes6_max_workflows,
scopes6.max_users AS scopes6_max_users,
scopes6.max_projects AS scopes6_max_projects,
scopes6.max_teams AS scopes6_max_teams,
scopes6.id AS scopes6_id
FROM "pachno_settings" "settings3"
LEFT JOIN "pachno_users" "users5"
ON ("users5"."id"="settings3"."uid")
LEFT JOIN "pachno_scopes" "scopes6"
ON ("scopes6"."id"="settings3"."scope")
WHERE ("settings3"."name" = 'theme_name'
AND "settings3"."module" = 'core'
AND "settings3"."uid" = 0
AND "settings3"."scope" = 1)
LIMIT 1 ;
If I run this SQL in the postgres console I get the same ERROR.
The problem is this line:
users5.2fa_token AS users5_2fa_token,
If I remove it, the SQL gives a result.
Looks to me like a weird PostgreSQL problem.
This works:
select * from pachno_users;
select users5.* from "pachno_users" "users5";
select 2fa_token from pachno_users;
But this does not work:
select users5.2fa_token from "pachno_users" "users5";
ERROR: syntax error at or near ".2"
ZEILE 1: select users5.2fa_token from "pachno_users" "users5"
^
What can I do to get a runnig Pachno with PostgreSQL?
