Advertisement:

Author Topic: Errors during installation  (Read 3799 times)

Offline siavoshkc

  • Semi-Newbie
  • *
  • Posts: 45
  • Gender: Male
Errors during installation
« on: August 17, 2017, 05:52:37 AM »
When I installed SMF locally for the first time (and second time to be able to copy errors for this post), after it populated DB there were some errors as follows:
Quote
•   Line #130: ERROR: operator + already exists
•   Line #131: ERROR: operator <> already exists
•   Line #736: ERROR: syntax error at or near "s"
LINE 4: ...r_holidays (title, event_date) VALUES ('New Year\'s', '0004-...
^
•   Line #738: ERROR: syntax error at or near "s"
LINE 2: ..._holidays (title, event_date) VALUES ('Valentine\'s Day', '0...
^
•   Line #739: ERROR: syntax error at or near "s"
LINE 2: ...olidays (title, event_date) VALUES ('St. Patrick\'s Day', '0...
^
•   Line #744: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
•   Line #745: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
•   Line #746: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
•   Line #747: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
•   Line #748: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
•   Line #749: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
•   Line #750: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
•   Line #751: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
•   Line #752: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
•   Line #753: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
•   Line #754: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
•   Line #755: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
•   Line #756: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
•   Line #757: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
•   Line #758: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
•   Line #759: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
•   Line #760: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
•   Line #761: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
•   Line #762: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
•   Line #763: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
•   Line #764: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
•   Line #765: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
•   Line #2302: ERROR: syntax error at or near "("
LINE 2: ...e, description, smiley_order, hidden) VALUES (':\'(', 'cry.g...
^

(I think the first lines didn't appear at the first time.)
Then after that instead of showing success I got a page with only these lines:
Quote
•   PHP Warning:  session_destroy(): Trying to destroy uninitialized session in C:\inetpub\test2\Sources\Subs-Auth.php on line 166
•   PHP Warning:  session_regenerate_id(): Cannot regenerate session id - session is not active in C:\inetpub\test2\Sources\Subs-Auth.php on line 170


So I manually increased the step in the address bar to see the final page. The forum started to work fine but I am afraid some day it may bump into a problem. Beside that it wasn't a clean install and I am a bit obsessive about that.
Persian Translator

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 67,882
    • Arantor on GitHub
Re: Errors during installation
« Reply #1 on: August 17, 2017, 07:06:44 AM »
What database server? Also, are you running the SQL file directly or letting SMF run it?
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

You either die a hero or live long enough to see yourself become the villain. It seems you have chosen which, and now I must do the same.

Offline siavoshkc

  • Semi-Newbie
  • *
  • Posts: 45
  • Gender: Male
Re: Errors during installation
« Reply #2 on: August 17, 2017, 09:04:14 AM »
What database server? Also, are you running the SQL file directly or letting SMF run it?

Postgres on local machine. I created an empty DB and connected SMF to it.

EDIT: SMF v2.0.14, postgres v9.6.4
Persian Translator

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 47,855
Re: Errors during installation
« Reply #3 on: August 17, 2017, 09:06:14 AM »
how were you trying to populate the database?

Offline siavoshkc

  • Semi-Newbie
  • *
  • Posts: 45
  • Gender: Male
Re: Errors during installation
« Reply #4 on: August 17, 2017, 09:09:14 AM »
how were you trying to populate the database?

I didn't. Installer did.
Persian Translator

Offline shawnb61

  • Support Specialist
  • Full Member
  • *
  • Posts: 455
    • sbulen on GitHub
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline siavoshkc

  • Semi-Newbie
  • *
  • Posts: 45
  • Gender: Male
Re: Errors during installation
« Reply #6 on: August 17, 2017, 09:15:09 AM »
https://www.simplemachines.org/community/index.php?topic=526449.0

I saw that actually but what does it mean by replacing \' with "? Should I change the code?
Persian Translator

Offline albertlast

  • Development Contributor
  • Jr. Member
  • *
  • Posts: 165
Re: Errors during installation
« Reply #7 on: August 17, 2017, 11:18:27 AM »
In my opinion is the smf 2.0.x more worst than
smf 2.1 github version in the case of using postgres.

Offline siavoshkc

  • Semi-Newbie
  • *
  • Posts: 45
  • Gender: Male
Re: Errors during installation
« Reply #8 on: August 17, 2017, 12:20:38 PM »
In my opinion is the smf 2.0.x more worst than
smf 2.1 github version in the case of using postgres.

I have to use 2.0 for the meantime. Though I can change to MySQL.
Persian Translator

Offline shawnb61

  • Support Specialist
  • Full Member
  • *
  • Posts: 455
    • sbulen on GitHub
Re: Errors during installation
« Reply #9 on: August 17, 2017, 02:20:30 PM »
Your call.  I think mod support for pg is spotty.

I haven't installed pg in 2.0, but if I were trying, I'd update the corresponding *.sql file per the instructions in the post referenced above.
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline siavoshkc

  • Semi-Newbie
  • *
  • Posts: 45
  • Gender: Male
Re: Errors during installation
« Reply #10 on: August 17, 2017, 03:11:41 PM »
Your call.  I think mod support for pg is spotty.

I haven't installed pg in 2.0, but if I were trying, I'd update the corresponding *.sql file per the instructions in the post referenced above.

I did it and it fixed the holidays, but not the page with
Quote
•   PHP Warning:  session_destroy(): Trying to destroy uninitialized session in C:\inetpub\test2\Sources\Subs-Auth.php on line 166
•   PHP Warning:  session_regenerate_id(): Cannot regenerate session id - session is not active in C:\inetpub\test2\Sources\Subs-Auth.php on line 170
contents.
Persian Translator

Offline albertlast

  • Development Contributor
  • Jr. Member
  • *
  • Posts: 165
Re: Errors during installation
« Reply #11 on: August 17, 2017, 03:42:58 PM »
two possibilities:
something got wrong by the setup (maybe session table is missing)
or php 7 + pg doesn't work.

The solution keeps in my eyes use smf 2.1 ther you get the best expierence for you setup,
or take mysql and accept that this will be not best setup from performance point of view for smf 2.1 (when you upgrade).

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 67,882
    • Arantor on GitHub
Re: Errors during installation
« Reply #12 on: August 18, 2017, 08:16:23 AM »
That's kind of sad given that 99.99% of all SMF installs aren't on Postgres.
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

You either die a hero or live long enough to see yourself become the villain. It seems you have chosen which, and now I must do the same.

Offline albertlast

  • Development Contributor
  • Jr. Member
  • *
  • Posts: 165
Re: Errors during installation
« Reply #13 on: August 18, 2017, 09:25:31 AM »
well we use 100% posibilities of mysql 5.0 and raised pg from 30%(30% ~ 100% mysql) to 60%.

So ask mysql that they support more sql function and raise the min mysql version to a reasonable version.


Offline shawnb61

  • Support Specialist
  • Full Member
  • *
  • Posts: 455
    • sbulen on GitHub
Re: Errors during installation
« Reply #14 on: August 18, 2017, 09:54:02 AM »
Given these issues, and given that many (most?) mods don't run on pg, I would go with mysql.   There is no way to determine pg support by mods that I know of other than trial and error.   

I would treat this install is a preview of things to come: lots of code tweaking to get things to work.
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline albertlast

  • Development Contributor
  • Jr. Member
  • *
  • Posts: 165
Re: Errors during installation
« Reply #15 on: August 18, 2017, 09:59:44 AM »
Yes your are right,
the mod support is unknown.

I tested yesterday the like mod: http://custom.simplemachines.org/mods/index.php?mod=3708
the most work i needed was to get this thing running on smf 2.1.

And two changes was needed to support pg (i had to change native part to smf api calls).

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 47,855
Re: Errors during installation
« Reply #16 on: August 18, 2017, 10:01:51 AM »
since likes are part of SMF 2.1 that mod should not be installed on SMF 2.1.

Offline albertlast

  • Development Contributor
  • Jr. Member
  • *
  • Posts: 165
Re: Errors during installation
« Reply #17 on: August 18, 2017, 10:11:56 AM »
i'm not the right person to define if the like system which in smf 2.1 is good or not.

For me i want to understand how a mod works,
what are the issue when a mod came from 2.0 and
how it look when i want run this under pg.

Offline siavoshkc

  • Semi-Newbie
  • *
  • Posts: 45
  • Gender: Male
Re: Errors during installation
« Reply #18 on: August 31, 2017, 11:24:54 AM »
Persian Translator

Offline siavoshkc

  • Semi-Newbie
  • *
  • Posts: 45
  • Gender: Male
Re: Errors during installation
« Reply #19 on: September 21, 2017, 01:18:17 AM »
Isn't the problem because I didn't set standard_conforming_strings Poetgres option to off before installation as it was mentioned in the manual?
Persian Translator