Advertisement:

Author Topic: Bug Reports: running the latest SMF 2.1 with pgsql  (Read 1691 times)

Offline i-SPN

  • Newbie
  • *
  • Posts: 7
Bug Reports: running the latest SMF 2.1 with pgsql
« on: October 17, 2018, 02:27:49 AM »
When I pull my smf forum to the latest github now, it complaints such a probem.

OS: FreeBSD 11.2 release
Database: PostgreSQL 9.5 server/client
php version: 7.2
SMF branch:
Code: [Select]
https://github.com/SimpleMachines/SMF2.1release-2.1

[Error Reproduction]

1. upgrade
Code: [Select]
$ doas git pull

2. use browser to open the forum, it shows error:
Code: [Select]
ERROR: relation "smf_board_permissions_view" does not exist LINE 9: ... 3) AND EXISTS (SELECT DI    STINCT bpv.id_board FROM smf_board_... ^

3. downgrade and the error disappears:
Code: [Select]
$ doas git reset --hard f9b50ba2c
HEAD is now at f9b50ba2c Merge pull request #4746 from albertlast/removeSizeCheck

Now open the forum with a browser, it is normal.

I am sure I have never modified the database installed by SMF automatically.

So I ran the commit points got from github and found the error occured at point af31e40,
2b43e54 and the commit points before are OK.


« Last Edit: October 17, 2018, 02:44:42 AM by i-SPN »

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 57,639
  • Gender: Male
    • Kindred-999 on GitHub
Re: Bug Reports: running the latest SMF 2.1 with pgsql
« Reply #1 on: October 17, 2018, 03:11:52 AM »
Did you run upgrade.php?
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline i-SPN

  • Newbie
  • *
  • Posts: 7
Re: Bug Reports: running the latest SMF 2.1 with pgsql
« Reply #2 on: October 17, 2018, 03:19:32 AM »
Did you run upgrade.php?

No.

I backup the forum code and try to run other/upgrade.php and get lots of more errors so I stop continuing, then I recover the forum code back again.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 57,639
  • Gender: Male
    • Kindred-999 on GitHub
Re: Bug Reports: running the latest SMF 2.1 with pgsql
« Reply #3 on: October 17, 2018, 04:07:44 AM »
The re are changes between nightly versions sometimes,  because we are not yet at a stable release. Database may change
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline albertlast

  • Development Contributor
  • Full Member
  • *
  • Posts: 449
Re: Bug Reports: running the latest SMF 2.1 with pgsql
« Reply #4 on: October 17, 2018, 10:41:51 AM »
Sound like you place the upgrade files wrong,
i recomand to use my nightly upgrade pack: https://www.simplemachines.org/community/index.php?topic=558451.0
the call here of the upgrade.php should be work mutch smoother