Unable to start Apache2 with Error AH00526: Syntax error - Invalid command $

Question

I was revising the theory of joins in PostgreSQL a bit and I couldn't find the syntax that I usually use:

SELECT * FROM TABLE_A A 
JOIN TABLE_B B ON (A.COLUMN_A = B.COLUMN_B) [WHERE ..]

What kind of join is this? Is it equivalent with the INNER JOIN?

SELECT * FROM TABLE_A A 
INNER JOIN TABLE_B B ON (A.COLUMN_A = B.COLUMN_B) [WHERE ..]

Solution 1

Remove the $, that's all.

sudo nano /etc/apache2/apache2.conf

Navigate to line 222 and use a # as comment or remove the $ if you need the configuration in /etc/phpmyadmin/apache.conf.

Solution 2

Seems to obvious to me: the error complains about a $. There is a $ in the config file ad you copied it.

That $ does not belong in the config file. Please delete it.

Comments

[A.B.]

Post the content of line 222 /etc/apache2/apache2.conf' in your question.

[Dhaval Simaria]

@Achu It is giving a blank apache error log.

[Haleemur Ali]

join and inner join are the same thing. also depending on what is present in a where clause, a left|right join may also be equivalent to an inner join

[A.B.]

aaarg :P +1 ^_^ This was my question ... :)

[Rinzwind]

I was 20 sec quicker ;-) lol

[Dhaval Simaria]

removing $ showed some more error. Then I tried putting # in the beginning which worked. Appreciate your effort.

[Ian Wilson]

The words INNER and OUTER are optional in all forms. INNER is the default; LEFT, RIGHT, and FULL imply an outer join. SEE Qualified Joins under 7.2.1.1. Joined Tables within postgresql.org/docs/13/…

[logjammin]

Thanks Ian, I'll put that in the answer.