SimplePortal

[LOVELORD]

I have  a problem with SP.... Need a table in mysql???

What table i must insert into the tabe, when i create a teble in mysql?

Error message is this:

Code Select Expand

Table 'balkandd_iis.iis_sp_blocks' doesn't exist
File: /home/balkandd/public_html/iis/Sources/Subs-SPortal1-1.php
Line: 44

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.7, while your database is at version 1.1.6. The above error might possibly go away if you execute the latest version of upgrade.php.

[aw06]

seeing these errors in my logs ..

Using SP 2.1 with SMF 1.1.7

8: Undefined index: block_info
File: /home/xxxxx/public_html/forum/Sources/SPortalAdmin1-1.php
Line: 382

8: Undefined index: sp-forum
File: /home/xxxxx/public_html/forum/Themes/default/Login.template.php (eval?)
Line: 329

8: Undefined index: DESCRIPTION
File: /home/xxxxx/public_html/forum/Sources/SPortal1-1.php
Line: 2222

8: Undefined index: LINK
File: /home/xxxxx/public_html/forum/Sources/SPortal1-1.php
Line: 2221

8: Undefined index: TITLE
File: /home/xxxxx/public_html/forum/Sources/SPortal1-1.php
Line: 2221

8: Undefined index: sp-forum
File: /home/xxxxx/public_html/forum/Themes/default/Login.template.php (eval?)
Line: 329

[nomnomfish]

i am using simpleportal.
is there any way to change the width of the boards so i do not have to scroll when viewing 1024x768 rez?
i noticed that i can change the width of the left and right blocks, but not the top blocks or the boards.
any help would be appreciated. 
thanks

btw, if you would like to see my site, its: http://swampratracing.com/forum

[B.SkiLLs]

Can somebody help me out with this issue and see what maybe they think it might be coming from.

Weird errors help

Sorry i happen to post it there in the admin support even tho it had the sp_forum info in the errors (if you read that thread you will see why i did and posted there but)

Thanks

[vivithemage]

is there an automatic installation, or is it only manual?

I am installing for 1.1.7...there is no readme file in that download, so I am kind of lost...

[[SiNaN]]

LOVELORD:

Run this query from phpMyAdmin:

Code Select Expand

CREATE TABLE IF NOT EXISTS `smf_sp_articles` (
  `ID_ARTICLE` int(10) NOT NULL auto_increment,
  `ID_CATEGORY` int(10) NOT NULL default '0',
  `ID_MESSAGE` int(10) NOT NULL default '0',
  `approved` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`ID_ARTICLE`)
) ENGINE=MyISAM ;

CREATE TABLE IF NOT EXISTS `smf_sp_blocks` (
  `ID_BLOCK` int(10) unsigned NOT NULL auto_increment,
  `label` tinytext NOT NULL,
  `type` text NOT NULL,
  `content` text NOT NULL,
  `parameters` tinytext NOT NULL,
  `col` tinyint(4) unsigned NOT NULL default '0',
  `row` tinyint(4) unsigned NOT NULL default '0',
  `state` tinyint(4) NOT NULL default '1',
  `allowed_groups` text NOT NULL,
  `force_view` tinyint(2) unsigned NOT NULL default '0',
  `permission_type` tinyint(2) unsigned NOT NULL default '0',
  `display` text NOT NULL,
  PRIMARY KEY  (`ID_BLOCK`)
) ENGINE=MyISAM ;

CREATE TABLE IF NOT EXISTS `smf_sp_categories` (
  `ID_CATEGORY` int(10) unsigned NOT NULL auto_increment,
  `name` tinytext NOT NULL,
  `picture` tinytext NOT NULL,
  `articles` tinyint(4) NOT NULL default '0',
  `publish` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`ID_CATEGORY`)
) ENGINE=MyISAM ;

CREATE TABLE IF NOT EXISTS `smf_sp_functions` (
  `ID_FUNCTION` tinyint(4) NOT NULL auto_increment,
  `name` tinytext NOT NULL,
  `parameter` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`ID_FUNCTION`)
) ENGINE=MyISAM ;

INSERT INTO `smf_sp_functions` (`ID_FUNCTION`, `name`, `parameter`) VALUES
(18, 'sp_php', 0),
(17, 'sp_html', 0),
(16, 'sp_smfGallery', 1),
(15, 'sp_smfArcade', 1),
(14, 'sp_smfShop', 0),
(13, 'sp_news', 0),
(12, 'sp_boardNews', 5),
(11, 'sp_recentTopics', 1),
(10, 'sp_recentPosts', 1),
(9, 'sp_topTopics', 2),
(8, 'sp_topBoards', 1),
(7, 'sp_topPoster', 1),
(6, 'sp_quickSearch', 0),
(5, 'sp_boardStats', 0),
(4, 'sp_showPoll', 1),
(3, 'sp_whosOnline', 0),
(2, 'sp_latestMember', 0),
(1, 'sp_userInfo', 0),
(19, 'sp_bbc', 0),
(20, 'sp_attachmentImage', 1),
(21, 'sp_attachmentRecent', 1),
(22, 'sp_mgallery', 2),
(23, 'sp_recent', 2),
(24, 'sp_calendarInformation', 4),
(25, 'sp_rssFeed', 1);

rsanchez78118:

../Themes/BlackRainV2/style.css

Find:

Code Select Expand

1090

Replace:

Code Select Expand

820

B.SkiLLs:

That's a hard to figure out bug, but let's try this:

SPortal1-1.php

Find:

Code Select Expand

// Why bother for wireless? Its not worth it. ;D
if(WIRELESS)
return;

$sportal_version = '2.1.1';

$context['page_title'] = $context['forum_name'];
$context['portalactive'] = !empty($modSettings['portalactive']);

require_once($sourcedir . '/Subs-SPortal1-1.php');

//Why not? We need it anyway 8)
if(loadLanguage('SPortal', '', false) === false)
loadLanguage('SPortal', 'english', false);

Replace:

Code Select Expand

$sportal_version = '2.1.1';

$context['page_title'] = $context['forum_name'];
$context['portalactive'] = !empty($modSettings['portalactive']);

require_once($sourcedir . '/Subs-SPortal1-1.php');

//Why not? We need it anyway 8)
if(loadLanguage('SPortal', '', false) === false)
loadLanguage('SPortal', 'english', false);

// Why bother for wireless? Its not worth it. ;D
if(WIRELESS)
return;

vivithemage:

There is the package. Just install it using your Package Manager.

[BOS4O]

hi,
hot to add this code in one php block in the simple portal

this is the code for random images from the SMF Media Gallery

Code Select Expand

// Random items?
if(!empty($context['random_items'])) {
echo '
<div class="catbg item_heading">',$txt['mgallery_random_items'],'</div>
<div id="random_pics">
<ul id="pics">';
foreach($context['random_items'] as $i) {
echo '
<li class="windowbg smalltext">
<a href="',$galurl,'sa=viewitem;id=',$i['id'],'">',$i['item_title'],'</a><br />
<a href="',$galurl,'sa=viewitem;id=',$i['id'],'"><img alt="" src="',$galurl,'sa=getmedia;id=',$i['id_thumb'],'" /></a><br />
',$txt['mgallery_views'],' : ',$i['views'],'<br />
',$txt['mgallery_posted_by'],' : <a href="',$scripturl,'?action=profile;u=',$i['member_id'],'">',$i['member_name'],'</a><br />
',$txt['mgallery_in_album'],' : <a href="',$galurl,'sa=viewalbum;id=',$i['id_album'],'">',$i['album_name'],'</a>
',$i['is_new'] ? '<br /><img alt="" src="' . $settings['images_url'] . '/' . $context['user']['language'] . '/new.gif" border="0" />' : '','
</li>';
}
echo '</ul>
</div>
<br style="clear: left;" />';
}


and these are the includes

Code Select Expand

global $context, $mgalSettings, $txt, $galurl, $galurl2, $scripturl, $settings;

when i try to add something like that

Code Select Expand

global $context, $mgalSettings, $txt, $galurl, $galurl2, $scripturl, $settings;
// Random items?
if(!empty($context['random_items'])) {
echo '
<div class="catbg item_heading">',$txt['mgallery_random_items'],'</div>
<div id="random_pics">
<ul id="pics">';
foreach($context['random_items'] as $i) {
echo '
<li class="windowbg smalltext">
<a href="',$galurl,'sa=viewitem;id=',$i['id'],'">',$i['item_title'],'</a><br />
<a href="',$galurl,'sa=viewitem;id=',$i['id'],'"><img alt="" src="',$galurl,'sa=getmedia;id=',$i['id_thumb'],'" /></a><br />
',$txt['mgallery_views'],' : ',$i['views'],'<br />
',$txt['mgallery_posted_by'],' : <a href="',$scripturl,'?action=profile;u=',$i['member_id'],'">',$i['member_name'],'</a><br />
',$txt['mgallery_in_album'],' : <a href="',$galurl,'sa=viewalbum;id=',$i['id_album'],'">',$i['album_name'],'</a>
',$i['is_new'] ? '<br /><img alt="" src="' . $settings['images_url'] . '/' . $context['user']['language'] . '/new.gif" border="0" />' : '','
</li>';
}
echo '</ul>
</div>
<br style="clear: left;" />';
}
echo '
</div>';
?>


this is my forum http://lfs-bg.net

--------------------------

when making a new table for the smf gallery is tells me

Code Select Expand

Table 'bos4o_smf.smf_gallery_pic' doesn't exist
File: /www/hostrator.com/b/o/s/bos4o/htdocs/Sources/SPortal.php
Line: 1357
it needs to be bos4o_smf_gallery_pic how to fix it?
it tells me a error like that for the smf shop too
i need to remove the one smf from this here

Code Select Expand

bos4o_smf.smf_gallery_pic
how? 

[vivithemage]

thanks!!!

[[SiNaN]]

BOS4O:

Do you have a kind of gallery mod installed on your forum? If yes, which is that?

vivithemage:

Thanks for you too, for using SimplePortal.

[flamechica]

HELP PLEASE! I am freaking out. I have SP and I was trying to put a gallery block at the bottom center of my forum. I got an error saying my database was 1.1.6 and my forum was 1.1.7 so, I figured out how to fix that, but then I was still getting an error saying I needed to update my mysql, so I sent off an email to to my server to try to get that straightened out. So, I figured this was no big deal and that I would leave the gallery block on my forum with the error message, that it shouldn't hurt nothing. However, I had noticed that since I had added the gallery block to the bottom center that my 2 blocks that I had put on the right side of the page had disappeared. I thought well, maybe I can adjust the position of the bottom center one to the left a bit. So, I went into the admin panel and was looking at the "Block List" page and noticed the little left and right arrows. So, I clicked the left one. Once I did that it messed everything up. Now, if I try to get into my forum all I get is one big white blank page.

Please, Please say you can help. I really don't want to have to start over, I have put so much work and time into this already.

[BOS4O]

BOS4O:

Do you have a kind of gallery mod installed on your forum? If yes, which is that?

vivithemage:

Thanks for you too, for using SimplePortal.

yes, i have the " SMF Media Gallery © SMF-Media.com "

[Tiribulus]

Am I correct in assuming that SP is not ready for SMF 2 RC1?

[nomnomfish]

LOVELORD:

Run this query from phpMyAdmin:

Code Select Expand

CREATE TABLE IF NOT EXISTS `smf_sp_articles` (
  `ID_ARTICLE` int(10) NOT NULL auto_increment,
  `ID_CATEGORY` int(10) NOT NULL default '0',
  `ID_MESSAGE` int(10) NOT NULL default '0',
  `approved` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`ID_ARTICLE`)
) ENGINE=MyISAM ;

CREATE TABLE IF NOT EXISTS `smf_sp_blocks` (
  `ID_BLOCK` int(10) unsigned NOT NULL auto_increment,
  `label` tinytext NOT NULL,
  `type` text NOT NULL,
  `content` text NOT NULL,
  `parameters` tinytext NOT NULL,
  `col` tinyint(4) unsigned NOT NULL default '0',
  `row` tinyint(4) unsigned NOT NULL default '0',
  `state` tinyint(4) NOT NULL default '1',
  `allowed_groups` text NOT NULL,
  `force_view` tinyint(2) unsigned NOT NULL default '0',
  `permission_type` tinyint(2) unsigned NOT NULL default '0',
  `display` text NOT NULL,
  PRIMARY KEY  (`ID_BLOCK`)
) ENGINE=MyISAM ;

CREATE TABLE IF NOT EXISTS `smf_sp_categories` (
  `ID_CATEGORY` int(10) unsigned NOT NULL auto_increment,
  `name` tinytext NOT NULL,
  `picture` tinytext NOT NULL,
  `articles` tinyint(4) NOT NULL default '0',
  `publish` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`ID_CATEGORY`)
) ENGINE=MyISAM ;

CREATE TABLE IF NOT EXISTS `smf_sp_functions` (
  `ID_FUNCTION` tinyint(4) NOT NULL auto_increment,
  `name` tinytext NOT NULL,
  `parameter` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`ID_FUNCTION`)
) ENGINE=MyISAM ;

INSERT INTO `smf_sp_functions` (`ID_FUNCTION`, `name`, `parameter`) VALUES
(18, 'sp_php', 0),
(17, 'sp_html', 0),
(16, 'sp_smfGallery', 1),
(15, 'sp_smfArcade', 1),
(14, 'sp_smfShop', 0),
(13, 'sp_news', 0),
(12, 'sp_boardNews', 5),
(11, 'sp_recentTopics', 1),
(10, 'sp_recentPosts', 1),
(9, 'sp_topTopics', 2),
(8, 'sp_topBoards', 1),
(7, 'sp_topPoster', 1),
(6, 'sp_quickSearch', 0),
(5, 'sp_boardStats', 0),
(4, 'sp_showPoll', 1),
(3, 'sp_whosOnline', 0),
(2, 'sp_latestMember', 0),
(1, 'sp_userInfo', 0),
(19, 'sp_bbc', 0),
(20, 'sp_attachmentImage', 1),
(21, 'sp_attachmentRecent', 1),
(22, 'sp_mgallery', 2),
(23, 'sp_recent', 2),
(24, 'sp_calendarInformation', 4),
(25, 'sp_rssFeed', 1);

rsanchez78118:

../Themes/BlackRainV2/style.css

Find:

Code Select Expand

1090

Replace:

Code Select Expand

820

B.SkiLLs:

That's a hard to figure out bug, but let's try this:

SPortal1-1.php

Find:

Code Select Expand

// Why bother for wireless? Its not worth it. ;D
if(WIRELESS)
return;

$sportal_version = '2.1.1';

$context['page_title'] = $context['forum_name'];
$context['portalactive'] = !empty($modSettings['portalactive']);

require_once($sourcedir . '/Subs-SPortal1-1.php');

//Why not? We need it anyway 8)
if(loadLanguage('SPortal', '', false) === false)
loadLanguage('SPortal', 'english', false);

Replace:

Code Select Expand

$sportal_version = '2.1.1';

$context['page_title'] = $context['forum_name'];
$context['portalactive'] = !empty($modSettings['portalactive']);

require_once($sourcedir . '/Subs-SPortal1-1.php');

//Why not? We need it anyway 8)
if(loadLanguage('SPortal', '', false) === false)
loadLanguage('SPortal', 'english', false);

// Why bother for wireless? Its not worth it. ;D
if(WIRELESS)
return;

vivithemage:

There is the package. Just install it using your Package Manager.

thanks for your response blue dream, but i have already tried that. that adjusts the forum width to 820, but not the image i have on top, which is 1065x88. the image ends up going over the right side. is there any way for the image to automatically adjust based on who is viewing it? or do i have to make a new one?

i would just change it to an 820px width like u suggested, but i dont have enough space because then the right blocks go over the side. 

thanks 

[KahneFan]

Am I correct in assuming that SP is not ready for SMF 2 RC1?

It's OK as far as I can tell. If you're running it on b4 and are going to upgrade, I would suggest uninstalling it before the upgrade, the reinstalling it after. (that goes for all mods)

I have it running on a site with RC1 running as well.

[Tiribulus]

Am I correct in assuming that SP is not ready for SMF 2 RC1?

It's OK as far as I can tell. If you're running it on b4 and are going to upgrade, I would suggest uninstalling it before the upgrade, the reinstalling it after. (that goes for all mods)

I have it running on a site with RC1 running as well.

I'm getting this:

*     16.     Execute Modification     ./Themes/default/css/dropmenu.css     Test failed
      1.    Replace    ./Themes/default/css/dropmenu.css    Test failed

The line it's telling me to replace in dropmenu.css doesn't exist

[Lamarck]

I have a problem: I updated to RC1 (before,I uninstalled simpleportal).Now,when I install it,I get a db error.Even with that error,SP installs fine BUT the problem is that it keeps appearing as not installed in the package list so I can't uninstall/upgrade or whatever.
Any help?

[PerryM]

2.1.1 is not compatible with smf 2.0 RC1.

Brand new install gives the following error when SimplePortal is  Apply Mod to install:

16 ./Themes/default/css/dropmenu.css test failed


Absolutely nothing else installed.

Can't live without SimplePortal!!!

Thanks for a super module.

[navjotjsingh]

One more error for fresh install on 2.0 RC1:

Code Select Expand


10.  Execute Modification  ./Sources/Subs.php  Test failed
1. Replace ./Sources/Subs.php Test successful
2. Replace ./Sources/Subs.php Test successful
3. Replace ./Sources/Subs.php Test failed
4. Replace ./Sources/Subs.php Test successful


[[SiNaN]]

dropmenu.css edit is okay to ignore.

----

It does not fail in Subs.php. There should be a problem with your files, as I myself have installed it more than 10 times in the last two days. Which edit is that?

[Tiribulus]

For some reason I am having no end of woe. Ignoring the dropmenu thing gets me this:

Database Error
Table 'smf2.sp_articles' doesn't exist
File: /srv/www/htdocs/forum1/Packages/temp/install2.php
Line: 50

and it doesn't install.

Maybe I should delete the folder and database and start over. This is a totally beta forum anyway.