Advertisement:

Author Topic: PostgreSQL error.(Openshift)  (Read 16081 times)

Offline andong

  • Newbie
  • *
  • Posts: 1
PostgreSQL error.(Openshift)
« on: August 15, 2014, 10:11:29 AM »
Error Message
Line #121: ERROR: operator + already exists
Line #122: ERROR: operator <> already exists
Line #646: ERROR: syntax error at or near "s"
LINE 4: ...r_holidays (title, event_date) VALUES ('New Year\'s', '0004-...
^
Line #648: ERROR: syntax error at or near "s"
LINE 2: ..._holidays (title, event_date) VALUES ('Valentine\'s Day', '0...
^
Line #649: ERROR: syntax error at or near "s"
LINE 2: ...olidays (title, event_date) VALUES ('St. Patrick\'s Day', '0...
^
Line #654: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #655: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #656: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #657: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #658: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #659: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #660: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #661: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #662: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #663: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #664: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #665: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #666: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #667: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #668: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #669: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #670: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #671: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #672: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #673: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #674: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #675: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #1859: ERROR: syntax error at or near "("
LINE 2: ...e, description, smiley_order, hidden) VALUES (':\'(', 'cry.g...

How to?

Offline Oldiesmann

  • Developer
  • SMF Super Hero
  • *
  • Posts: 24,814
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • http://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: PostgreSQL error.(Openshift)
« Reply #1 on: August 21, 2014, 02:05:13 AM »
You can ignore the "Operator already exists" errors.

For the holidays, just replace \' with ''.
Michael Eshom
Webmaster / SMF Lead Developer
oldiesmann@simplemachines.org