Advertisement:

Author Topic: New install 2.0.15 db error  (Read 2345 times)

Offline Kerrith

  • Charter Member
  • Jr. Member
  • *
  • Posts: 168
  • Gender: Male
    • Big Island Forum
New install 2.0.15 db error
« on: January 26, 2018, 04:45:41 PM »
Forum > Manage Boards and Categories > Error: "Unknown column 'b.is_blog' in 'field list'
File: /xxx/xxx/public_html/teenforum/Sources/Subs-Boards.php
Line: 1085"

Otherwise the install http://www.bigislandforum.org/teenforum/index.php looks good. Got tip?

Thanks, Kerry
SMF 2.0.15 | SMF © 2017, Simple Machines
SimplePortal 2.3.7 © 2008-2018, SimplePortal
XHTML RSS WAP2

PS: I have another installation of SMF with Simple Portal that works fine.
Kerrith H. (Kerry) King
Communication Skills Coach
The Clearing House
... 4 free communication skills exercises—
—a must for anyone intent on mastering communication

Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,519
  • Gender: Male
  • "mods" junkie
    • dopetalk
Re: New install 2.0.15 db error
« Reply #1 on: January 26, 2018, 05:05:28 PM »
refer to similar issue > http://www.simplemachines.org/community/index.php?topic=171958.0

I assume that you are using an old DB and/or have related mods on.

The configuration of my Linux VPS (SMF 2.0 with 145 mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum)

Offline shawnb61

  • Developer
  • SMF Hero
  • *
  • Posts: 1,522
    • sbulen on GitHub
Re: New install 2.0.15 db error
« Reply #2 on: January 26, 2018, 05:26:20 PM »
I can't reproduce this in a vanilla 2.0.15 install.
You may need to report this over on the support thread for SimplePortal. 
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,464
Re: New install 2.0.15 db error
« Reply #3 on: January 26, 2018, 05:28:24 PM »
i dont think SP has a blog as part of it. maybe someone installed a blog at some point and it did not cleanly uninstall.

Offline shawnb61

  • Developer
  • SMF Hero
  • *
  • Posts: 1,522
    • sbulen on GitHub
Re: New install 2.0.15 db error
« Reply #4 on: January 26, 2018, 05:30:53 PM »
OP says it's a new install - 2.0.15 + SP. 

is_blog doesn't exist in 2.0.15.   Maybe a defunct SP feature?
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,519
  • Gender: Male
  • "mods" junkie
    • dopetalk
Re: New install 2.0.15 db error
« Reply #5 on: January 26, 2018, 05:59:17 PM »
if you had this mod on > http://custom.simplemachines.org/mods/index.php?mod=793

IF YOU DON'T WANT THE BLOG DATA: I suggest that you try to install it again then uninstall it but be sure to check the option to delete the data with it this time. I think that option will remove the offending column from the table in your DB and any residual code associated with it ... it may also confirm Illori's suspicion.

IF YOU DO: then do the above but don't delete the data with it ... it may also confirm Illori's suspicion.

it may be another blog mod but i think you get the idea ... what mods have you had on in the past ?
« Last Edit: January 26, 2018, 06:42:03 PM by aegersz »
The configuration of my Linux VPS (SMF 2.0 with 145 mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum)

Offline lurkalot

  • Support Specialist
  • SMF Hero
  • *
  • Posts: 1,496
  • Gender: Male
  • Tinyportal Support
    • guitaristguild on Facebook
    • Tinyportal on GitHub
    • @GuitaristGuild on Twitter
    • Guitarist Guild
Re: New install 2.0.15 db error
« Reply #6 on: January 26, 2018, 06:17:50 PM »
Maybe something to do with that blog button that's missing from the main menu, between Calendar and Login, it points to here, http://www.bigislandforum.org/teenforum/index.php?action=blog

Code: [Select]
<li id="button_calendar">
<a class="firstlevel" href="http://www.bigislandforum.org/teenforum/index.php?action=calendar">
<span class="firstlevel">Calendar</span>
</a>
</li>
<li id="button_blog">
<a class="firstlevel" href="http://www.bigislandforum.org/teenforum/index.php?action=blog">
<span class="firstlevel"></span>
</a>
</li>
<li id="button_login">

Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,519
  • Gender: Male
  • "mods" junkie
    • dopetalk
Re: New install 2.0.15 db error
« Reply #7 on: January 26, 2018, 06:23:42 PM »
highly likely as that mod uses Blog.php

Please backup your DB and files just to be safe before trying out my advice, should you choose to follow it.
« Last Edit: January 26, 2018, 06:41:36 PM by aegersz »
The configuration of my Linux VPS (SMF 2.0 with 145 mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum)

Offline Kerrith

  • Charter Member
  • Jr. Member
  • *
  • Posts: 168
  • Gender: Male
    • Big Island Forum
Re: New install 2.0.15 db error
« Reply #8 on: January 27, 2018, 05:13:05 AM »
Thanks all. I think it's fixed. In Subs-Boards.php I deleted c.can_blog. I'll configure it some more and see.

PS: lurkalot. I wasn't sure what to do with your script.
Kerrith H. (Kerry) King
Communication Skills Coach
The Clearing House
... 4 free communication skills exercises—
—a must for anyone intent on mastering communication

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,699
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: New install 2.0.15 db error
« Reply #9 on: January 27, 2018, 08:48:55 AM »
Thanks all. I think it's fixed.
I don't think it's completely removed yet.
It's still a part of your menu, that was what lurkalot was trying to show you I think.

Also, the button ends up in an error.
A nonexistent action should normally redirect to the forum index.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Kerrith

  • Charter Member
  • Jr. Member
  • *
  • Posts: 168
  • Gender: Male
    • Big Island Forum
Re: New install 2.0.15 db error
« Reply #10 on: January 27, 2018, 04:47:08 PM »
Anyone have a suggestion? This senior is confused.
Thanks, Kerry
Kerrith H. (Kerry) King
Communication Skills Coach
The Clearing House
... 4 free communication skills exercises—
—a must for anyone intent on mastering communication

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,699
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: New install 2.0.15 db error
« Reply #11 on: January 27, 2018, 04:50:36 PM »
If that is really a new install, and you haven't done any larger customizing or installed many mods you wouldn't want to lose - I'd suggest starting from scratch so to say.

https://wiki.simplemachines.org/smf/How_to_upload_a_fresh_set_of_files
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Kerrith

  • Charter Member
  • Jr. Member
  • *
  • Posts: 168
  • Gender: Male
    • Big Island Forum
Re: New install 2.0.15 db error
« Reply #12 on: January 27, 2018, 07:19:17 PM »
If that is really a new install,
Yes, also a new db,
and you haven't done any larger customizing or installed many mods
Only SimplePortal, 
I'd suggest starting from scratch so to say.
I spent an hour editing SMF's files to install SimplePortal, so I'd like to find a fix without having to "upload a fresh set of file" which would overwrite my existing SP edited files.

A couple years and versions ago (SMF 2.0.15 | SimplePortal 2.3.7) I successfully  installed another SMF w/SP forum that's been working perfectly. http://www.bigislandforum.org/forums/index.php

Obviously I need help.


Kerrith H. (Kerry) King
Communication Skills Coach
The Clearing House
... 4 free communication skills exercises—
—a must for anyone intent on mastering communication

Offline Kerrith

  • Charter Member
  • Jr. Member
  • *
  • Posts: 168
  • Gender: Male
    • Big Island Forum
Re: New install 2.0.15 db error
« Reply #13 on: January 27, 2018, 07:24:54 PM »
i don't think SP has a blog as part of it. maybe someone installed a blog at some point and it did not cleanly uninstall.
Me too, I have not found any "blog" file in SP  2.3.7. My install of SMFw/SP is a clean new install with a new db.
Kerrith H. (Kerry) King
Communication Skills Coach
The Clearing House
... 4 free communication skills exercises—
—a must for anyone intent on mastering communication

Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,519
  • Gender: Male
  • "mods" junkie
    • dopetalk
Re: New install 2.0.15 db error
« Reply #14 on: January 27, 2018, 09:27:14 PM »
you could backup those files that you want or backup the entire set of forum files, start another fresh install, check your new forum then copy back those files and see if that reproduces your mystery error.

i have a total of 6 SMF systems and one of those is pure vanilla so i can test/compare mods and source for debugging. others are live copies or systems with just a few mods on. 2 are live.

going to such lengths can isolate a problem quickly.
The configuration of my Linux VPS (SMF 2.0 with 145 mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum)

Offline shawnb61

  • Developer
  • SMF Hero
  • *
  • Posts: 1,522
    • sbulen on GitHub
Re: New install 2.0.15 db error
« Reply #15 on: January 27, 2018, 11:05:17 PM »
I just installed 2.0.15 + the latest SP.   No 'blog' anywhere in subs-boards.php.

There is stray code in there from something else.


Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,699
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: New install 2.0.15 db error
« Reply #16 on: January 28, 2018, 02:53:26 AM »
I spent an hour editing SMF's files to install SimplePortal, so I'd like to find a fix without having to "upload a fresh set of file" which would overwrite my existing SP edited files.

Did not the package manager work, or why did it take that long for you to install?
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Kerrith

  • Charter Member
  • Jr. Member
  • *
  • Posts: 168
  • Gender: Male
    • Big Island Forum
Re: New install 2.0.15 db error
« Reply #17 on: January 28, 2018, 05:40:28 AM »
I just installed 2.0.15 + the latest SP.   No 'blog' anywhere in subs-boards.php.

There is stray code in there from something else.
Just did a search in Sub_boards.php and got:
Code: [Select]
"// --- Begin modification - SMFBlog ---
// Is this board a blog?
if (isset($boardOptions['is_blog']))
{
// We'll need to set the "is_blog" value, depending on what the user chose.
$boardUpdates[] = 'is_blog = ' . ($boardOptions['is_blog'] ? '1' : '0');
// Is it actually a blog? If it is, we need to generate an "alias" for it.
// Only do this if a board name was passed (otherwise, what can we do?).
if ($boardOptions['is_blog'] && isset($boardOptions['board_name']))
{
// Remove any non-alphanumeric characters
$alias = strtolower(preg_replace('/[^A-Za-z0-9 ]/', '', $boardOptions['board_name']));
// Replace any spaces with dashes
$alias = str_replace(' ', '-', $alias);

// Is this alias ambiguous (is it in use by something else?)
$result = $smcFunc['db_query']('', "
SELECT
COUNT(ID_BOARD)
FROM {db_prefix}boards
WHERE blog_alias = '{$alias}'");
list($temp_count) = $smcFunc['db_fetch_row']($result);
$smcFunc['db_free_result']($result);

// It is? Add the board ID to the end.
if ($temp_count > 0)
$alias .= '_' . $board_id;

// Add this as an update
$boardUpdates[] = 'blog_alias = \'' . $alias . '\'';
}
}
// --- End modification ---

Your SP doesn't have this code?



Edited to put the code inside code tags ~ Steve
« Last Edit: January 28, 2018, 12:07:49 PM by Steve »
Kerrith H. (Kerry) King
Communication Skills Coach
The Clearing House
... 4 free communication skills exercises—
—a must for anyone intent on mastering communication

Offline Kerrith

  • Charter Member
  • Jr. Member
  • *
  • Posts: 168
  • Gender: Male
    • Big Island Forum
Re: New install 2.0.15 db error
« Reply #18 on: January 28, 2018, 05:45:02 AM »
I spent an hour editing SMF's files to install SimplePortal, so I'd like to find a fix without having to "upload a fresh set of file" which would overwrite my existing SP edited files.

Did not the package manager work, or why did it take that long for you to install?

Here's the Installation page for SimplePortal with lots of moving and copy-pasting: https://custom.simplemachines.org/mods/index.php?action=parse;mod=1104;attach=254079;smf_version=2.0.13.  I don't know if SP can be installed via SMF's package manager, do you? That would be way cool.
Kerrith H. (Kerry) King
Communication Skills Coach
The Clearing House
... 4 free communication skills exercises—
—a must for anyone intent on mastering communication

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,699
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: New install 2.0.15 db error
« Reply #19 on: January 28, 2018, 05:49:53 AM »
It is a mod, should work like any other :)
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas