SimplePortal

Customization => Blocks and Modifications => Block Requests => Topic started by: Poshnjari on January 11, 2013, 06:51:53 PM

Title: Block List hepl
Post by: Poshnjari on January 11, 2013, 06:51:53 PM

Hi,
I think change  Block List for add link now I can't change
displays this message

Quote

Unknown column 'allowed_groups' in 'field list'
File: /home/123456/public_html/Sources/PortalAdminBlocks.php
Line: 790

Title: Re: Block List hepl
Post by: Poshnjari on January 12, 2013, 04:56:19 PM

any help me please!

Title: Re: Block List hepl
Post by: Chen Zhen on January 13, 2013, 02:06:08 AM

Poshnjari,

  I am not sure if I understand correctly, please clarify..

  You have a block that is giving you a database error which has been enabled for everywhere on your site?

  If this is the issue then you can enter your site admin url directly which will prompt you with p/w or login inputs & then you can disable the block from within your smf admin until you can adjust its code properly.

ie...
http://YOUR_SITE/index.php?action=admin

Title: Re: Block List hepl
Post by: Poshnjari on January 13, 2013, 07:20:52 PM

ok I have this problem, I can't modify this block on right bottom my site is www.forumfamiljar.com

Code: [Select]

);

if (!empty($blockInfo['row']))
$block_fields[] = "row = {int:row}";
else
unset($blockInfo['row']);

$smcFunc['db_query']('','
UPDATE {db_prefix}sp_blocks
SET ' . implode(', ', $block_fields) . '
WHERE id_block = {int:id}',
$blockInfo
);[code]



Title: Re: Block List hepl
Post by: Chen Zhen on January 14, 2013, 12:01:25 AM

Poshnjari,

  You will need to take the time to explain the issue you are having in detail as we are not able to understand exactly what has transpired with the limited info you are supplying.
 
  Why are you displaying code from PortalAdminBlocks.php ??

Title: Re: Block List hepl
Post by: Poshnjari on January 14, 2013, 09:53:21 AM

ok view this images

Title: Re: Block List hepl
Post by: Poshnjari on January 15, 2013, 07:12:15 AM

any help me please ;(

Title: Re: Block List hepl
Post by: AngelinaBelle on January 15, 2013, 09:41:50 AM

Thanks for the images.
Sometimes a picture is worth 1000 words.

Please let us know if this is correct:
1) You are trying to edit a custom BBC block (Faqet Partners)
2) When you try to save this block, you get an error Unknown column 'allowed_groups' in 'field list'
3) You are using SimplePortal 2.3.5 and SMF 2.0.2

----
Have you made any changes to the file PortalAdminBlocks.php ?

Title: Re: Block List hepl
Post by: Poshnjari on January 15, 2013, 01:26:23 PM

No I have not done any changes and code is

Code: [Select]

);

if (!empty($blockInfo['row']))
$block_fields[] = "row = {int:row}";
else
unset($blockInfo['row']);

$smcFunc['db_query']('','
UPDATE {db_prefix}sp_blocks
SET ' . implode(', ', $block_fields) . '
WHERE id_block = {int:id}',
$blockInfo
);

Title: Re: Block List hepl
Post by: AngelinaBelle on January 15, 2013, 03:56:21 PM

Please check the SimplePortal version at the top of the file.
I don't see that code at line 790 of PortalAdminBlocks, SimplePortal version 2.3.5.

I see code like this near line 873
 
Also, in my copy of  PortalAdminBlocks, I do not see 'allowed_groups' .  I see 'groups_allowed'.

Title: Re: Block List hepl
Post by: velorooms on January 15, 2013, 05:05:04 PM

groups_allowed confirmed, both 2.3.4 and 2.3.5

Title: Re: Block List hepl
Post by: Poshnjari on January 15, 2013, 05:33:05 PM

 :applause: now is ok, I have installing manual mode. Now I upload new file and is fine  :thumbsup:

Title: Re: Block List hepl
Post by: AngelinaBelle on January 16, 2013, 01:45:52 PM

Good.  I am glad you solved it.

It sounds like there had been a problem with copying files during the SimplePortal install.
You may run into this problem again, with other mods that need to copy files into SMF directories.

For more information, please see http://simpleportal.net/index.php?action=docs;area=solving_install_problems

I will mark this problem solved for you.  If you need to reopen it, please use the "Topic not Solved" button.

Thanks!