Advertisement:

Author Topic: SMF 2.1 beta3 Database Error  (Read 1202 times)

Offline i-SPN

  • Newbie
  • *
  • Posts: 5
SMF 2.1 beta3 Database Error
« on: May 01, 2018, 04:18:27 PM »
I failed to run smf 2.0 with postgresql on freebsd jail, then I succeed to run smf 2.1 beta 3 with postgresql on freebsd jail. But find some errors. This thread I only post the delete draft error:
When I save a draft and go to the "Forum Info" -> "Show Drafts" to delete the draft, I will see these message:

Quote
Database Error

ERROR: syntax error at or near "LIMIT"
LINE 6: LIMIT 1
^
File: /**********/Sources/Drafts.php
Line: 540

If I edit the code near Line 540, and try to delete the draft again, I will see "hacking" message in the forum admin panel.

Help!

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,274
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: SMF 2.1 beta3 Database Error
« Reply #1 on: May 01, 2018, 04:20:47 PM »
I would download the latest from github probably has your fix already https://github.com/SimpleMachines/SMF2.1
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline i-SPN

  • Newbie
  • *
  • Posts: 5
Re: SMF 2.1 beta3 Database Error
« Reply #2 on: May 01, 2018, 04:22:57 PM »
I would download the latest from github probably has your fix already hxxp:github.com/SimpleMachines/SMF2.1 [nonactive]

Thank you very much, I even didn't know this release.  I will try it.

Offline i-SPN

  • Newbie
  • *
  • Posts: 5
Re: SMF 2.1 beta3 Database Error
« Reply #3 on: May 01, 2018, 05:28:02 PM »
I would download the latest from github probably has your fix already hxxp:github.com/SimpleMachines/SMF2.1 [nonactive]

Hello, sorry, I git cloned the release-2.1 branch code and use them to override my forum files, keep Settings.php but the database error still exists. I read the code near 540 in Drafts.php and found nothing change. The backend admin panel shows the version is 2.1 beta 4 now. And finally I click all the "run task now" buttons in the admin panel but they doesn't help.

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,274
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: SMF 2.1 beta3 Database Error
« Reply #4 on: May 01, 2018, 06:05:00 PM »
I would report the error on github to the developers. We have people that work with your database
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline i-SPN

  • Newbie
  • *
  • Posts: 5
Re: SMF 2.1 beta3 Database Error
« Reply #5 on: May 01, 2018, 06:17:25 PM »
thank you.

Offline albertlast

  • Development Contributor
  • Jr. Member
  • *
  • Posts: 317
Re: SMF 2.1 beta3 Database Error
« Reply #6 on: May 02, 2018, 12:59:29 AM »
Please had in mind,
that the database got changes between beta3 (wiche is mostly a year old) and the version now.

It's recommanded to make a clean install with the github version (personal i recommand to use the nightly download) https://www.simplemachines.org/community/index.php?topic=558451.0

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 56,701
  • Gender: Male
    • Kindred-999 on GitHub
Re: SMF 2.1 beta3 Database Error
« Reply #7 on: May 02, 2018, 09:15:04 AM »
right...    there is no update script between nightly builds.   If you are using a beta, it's assumed that you are either going to do a clean install each time or have the know-how to properly, manually, update your site
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: 5
Re: SMF 2.1 beta3 Database Error
« Reply #8 on: May 03, 2018, 06:54:19 PM »
I am using last_commit_9bc16d3 nightly build with fresh install by destroying and reinitializing postgresql databases , the bug still exists here without change. So I have to disable the save drafts feature. I still express my thanks to your smf hard work.

Offline albertlast

  • Development Contributor
  • Jr. Member
  • *
  • Posts: 317
Re: SMF 2.1 beta3 Database Error
« Reply #9 on: May 04, 2018, 01:04:23 AM »
Special thanks for testing smf2.1 with pg and to mention this bug,
the bug get fixed by this pr: https://github.com/SimpleMachines/SMF2.1/pull/4747
which i hope get merge in the next time.