collapse

* Simple Portal Archived Forum

This is an Archive Forum.

The content in this forum may be out-of-date or have been superseded by newer information, and links in forum pages to other sites may not work.
This forum contains archives for future reference.

Visit our thread at Simple Machines Forum for current support.

SMF 2.1 users: EhPortal is a ported version of Simple Portal specifically designed for the SMF 2.1 branch.
Please visit web-develop.ca to download EhPortal and for its support.

* User Info

 
 
Welcome, Guest. Please login or register.

* Who's Online

  • Dot Guests: 399
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.

* Shoutbox

Refresh History
  • Shoutbox is not for support!
  • {OCS}MasterSeal: Yup, Still adore SP
    April 21, 2019, 07:08:06 PM
  • {OCS}MasterSeal: STILL love SP :)
    November 24, 2018, 05:05:50 AM
  • ♦ Ninja ZX-10RR ♦: <3 aegersz
    September 13, 2018, 03:36:09 PM
  • aegersz: I STILL <3 LOVE SimplePortal
    September 13, 2018, 07:11:39 AM
  • aegersz: o LOVE you guys - Simple Portal rocks !
    May 09, 2018, 05:18:59 AM
  • Chen Zhen: our apologies for the site being down.. please read server issues topic
    March 22, 2018, 05:32:38 AM
  • {OCS}MasterSeal: LOL PLEASE forget I just posted that. I found the answer in my own dang post back in 2015. lol sorry!
    July 04, 2017, 10:47:55 PM
  • {OCS}MasterSeal: I know this SB isnt' for support, but I just have a general question. Who would I contact to find out where SP stores its block info? Is it DB driven or files? I searched the site but came up with nothing. probably my fault any insight is appreciated.
    July 04, 2017, 10:43:36 PM
  • ♦ Ninja ZX-10RR ♦: Excuse me but what does Simpleportal have to deal with that?
    February 05, 2017, 08:21:14 PM
  • WhiteEagle: of course IMHO that site appears to be dead :(
    February 04, 2017, 01:08:05 PM
  • WhiteEagle: If I can get that, then I'll use it for that site...
    February 04, 2017, 01:07:35 PM
  • WhiteEagle: decided to not use SMF for any projects, unless I can get a copy of the premium version of the fanfiction archive plugin
    February 04, 2017, 01:06:54 PM
  • expertdecisions: cloudflare
    January 28, 2017, 08:01:47 AM
  • aegersz: SM release 2.0.13 !
    January 12, 2017, 06:00:13 AM
  • raffo: Tks Emanuele, even if I didn't understand the fix :D
    November 07, 2016, 02:01:20 AM
  • emanuele: [link]
    November 01, 2016, 12:43:50 PM
  • emanuele: raffo: the English support board is a good place. ;)
    November 01, 2016, 12:43:38 PM
  • raffo: Where can I find the fix for the shoutbox?
    November 01, 2016, 05:06:09 AM
  • {OCS}MasterSeal: To the SP team, I make a point to come here and thank you as much as possible for your work.  so again, THANK YOU!
    October 28, 2016, 10:38:05 AM
  • emanuele: That's indeed funny, the limit is present only in the patch and not the full install.
    October 22, 2016, 06:14:58 PM

* Recent Posts

Adding Forums Button to Nav bar by jirapon
[August 01, 2019, 09:07:12 AM]


Re: Board Icons by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 04:03:41 PM]


MOVED: Czech translation???? by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 03:04:51 PM]


Board Icons by jirapon
[July 30, 2019, 07:28:44 AM]


Re: Thankyou Simpleportal, by ♦ Ninja ZX-10RR ♦
[July 29, 2019, 09:41:29 AM]

If you're interested in helping other members with support requests, consider joining the Community Support Helpers group.

Author Topic: "Database error in block code" when adding valid php block  (Read 2974 times)

0 Members and 1 Guest are viewing this topic.

Offline frymaster

  • Newbie
  • Posts: 3
  • SMF Version: 2 RC5
  • SP Version: 2.3.3
When adding seemingly any valid non-black php page, preview works but clicking "Edit page" gives the error:

Quote
Database error in block code. Please check the code.

This is the case even when the code is
Code: [Select]
echo 'test';
...which works fine in preview.

Using SMF 2RC5, Simpleportal 2.3.3.  No other mods installed - I wiped the database and filesystem after encountering this error, but that hasn't helped.

No errors in the SMF log (it's totally blank since I just reinstalled), and no errors in apache logs.

Any ideas?
« Last Edit: May 10, 2011, 10:38:39 AM by AngelinaBelle »

Offline frymaster

  • Newbie
  • Posts: 3
  • SMF Version: 2 RC5
  • SP Version: 2.3.3
Re: "Database error in block code" when adding php page
« Reply #1 on: May 07, 2011, 03:31:28 PM »
on later investigation, this only happens when we have apache authentication on (as this is a test site, we're restricting access until it's ready)

is there a fix for this?

Offline AngelinaBelle

  • Comrade
  • *
  • Posts: 4870
  • Gender: Female
  • SMF Version: 2 RC3
  • SP Version: 2.3.2
Re: "Database error in block code" when adding valid php block
« Reply #2 on: May 12, 2011, 07:38:23 AM »
I've just asked for dev help on this, but, as Sinan is busy working on the SMF 2.0 release, I hope you won't mind me taking a stab at it.
I don't know anything about how apache authentication, what it might do to SMF URLs or session ids or data posted from a form.
One suggestion would be to use maintenance mode instead -- this prevents anyone but admin from seeing anything but the "Sorry, we're in maintenance mode" message.
Are you getting any errors on your SMF error log?
Please to keep this website running, if you like SimplePortal, make a
one-time subscription. Thank you for your support.

Have you tried the SimplePortal documentation?

Offline frymaster

  • Newbie
  • Posts: 3
  • SMF Version: 2 RC5
  • SP Version: 2.3.3
Re: "Database error in block code" when adding valid php block
« Reply #3 on: May 12, 2011, 11:52:03 AM »
nope, nothing in the error log at all - nothing in the apache error log either.

apache auth shouldn't alter any existing server data - it certainly won't change URLs or POST data - but it will change the environment somewhat.  For example, there'll be an environment variable called REMOTE_USER set to the username entered into the auth popup

atm I'm more concerned about finishing up the website since it's meant to go live tomorrow, but when I get a moment I'll post the complete list of changes with auth on or off.

Offline AngelinaBelle

  • Comrade
  • *
  • Posts: 4870
  • Gender: Female
  • SMF Version: 2 RC3
  • SP Version: 2.3.2
Re: "Database error in block code" when adding valid php block
« Reply #4 on: May 12, 2011, 02:46:27 PM »
You could try, in settings.php, setting
Code: [Select]
$db_show_debug=true;, and seeing what  you discover (look for complete SQL queries at the bottom of the page). You might look for the difference with apache authentication turned on or off -- of course, you need to be very cautious about allowing guests into the forum when you are displaying SQL queries and related database debugging information.
No matter what the problem turns out to be, I think I will be surprised, since I have no idea.

Since SimplePortal was not designed to work with apache authentication, and was not tested in that environment, there was no consideration given to what sort of affect it could have on the storing of php code to the database.
Please to keep this website running, if you like SimplePortal, make a
one-time subscription. Thank you for your support.

Have you tried the SimplePortal documentation?