cBB Blockgets v2.0.0 SQL Bug


User avatar

Leinad4Mind
 
Posts: 30
Joined: Thu Oct 15, 2015 10:10 pm

cBB Blockgets v2.0.0 SQL Bug

Postby Leinad4Mind » Sun Jan 07, 2018 6:48 pm • via Web
When I try to edit group permissions on a block:

Data too long for column 'block_groups' at row 1 [1406]

SQL

UPDATE phpbb_blockgets_blocks SET block_title = 'Search', block_content = '', block_alias = 'search_block', block_icon = 'blg-icon-search', block_page = '1', block_enabled = 1, block_groups = '5,6,4,1,7,2,3,9,28,26,11,18,13,20,23,12,19,17,15,16,14,22,25,21', allow_collapse = 1, block_style = '1', bbcode_bitfield = '', bbcode_uid = '' WHERE block_id = 12

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbbdbdriverdriver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbbdbdrivermysqli->sql_query()

FILE: [ROOT]/ext/canidev/blockgets/controller/admin_controller_pages.php
LINE: 1091
CALL: phpbbdbdriverfactory->sql_query()

FILE: [ROOT]/ext/canidev/blockgets/controller/admin_controller_pages.php
LINE: 649
CALL: canidevblockgetscontrolleradmin_controller_pages->manage_block()

FILE: [ROOT]/ext/canidev/blockgets/controller/admin_controller_pages.php
LINE: 34
CALL: canidevblockgetscontrolleradmin_controller_pages->manage_page()

FILE: [ROOT]/ext/canidev/blockgets/controller/admin_controller_base.php
LINE: 100
CALL: canidevblockgetscontrolleradmin_controller_pages->_display()

FILE: [ROOT]/ext/canidev/blockgets/acp/main_module.php
LINE: 37
CALL: canidevblockgetscontrolleradmin_controller_base->display()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: canidevblockgetsacpmain_module->main()

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()


Cheers
User avatar

Leinad4Mind
 
Posts: 30
Joined: Thu Oct 15, 2015 10:10 pm

Re: cBB Blockgets v2.0.0 SQL Bug

Postby Leinad4Mind » Sun Jan 07, 2018 7:02 pm • via Web
I get this too on console in portal page:

Uncaught ReferenceError: jblockgets is not defined
at portal:653
portal:936 Uncaught ReferenceError: jQuery is not defined
at portal:936

And youtube looks bad on FLATBOOTS:
Image
User avatar

Leinad4Mind
 
Posts: 30
Joined: Thu Oct 15, 2015 10:10 pm

Re: cBB Blockgets v2.0.0 SQL Bug

Postby Leinad4Mind » Sun Jan 07, 2018 7:13 pm • via Web
I'm getting this now when trying to submit a new post with another bug here:

Forbidden
You don't have permission to access /posting.php on this server.

This was what I was trying to post:
Image
User avatar

IvanPF
Site Admin
 
Posts: 977
Joined: Fri Jun 17, 2011 12:15 am
Location: España (Spain)

Re: cBB Blockgets v2.0.0 SQL Bug

Postby IvanPF » Sun Jan 07, 2018 7:21 pm • via Web
Hi,

1. It is caused by selecting too many groups in the permissions.
You can solve this error by accessing the table "_blockgets_blocks" from phpmyadmin and modify the column "block_groups" by changing it, for example, from VCHAR (50) to VCHAR (100)

2. Have you installed the adaptation for the FLATBOOTS style?

3. This hosting has some restrictive filters and there are certain codes that does not allow to post.
You can publish that code in pastebin.com and use the bbcode
Code: Select all
[pastebin={height}]{pastebin ID}[/pastebin]
User avatar

Leinad4Mind
 
Posts: 30
Joined: Thu Oct 15, 2015 10:10 pm

Re: cBB Blockgets v2.0.0 SQL Bug

Postby Leinad4Mind » Sun Jan 07, 2018 7:58 pm • via Web
1. Thanks ( but it would be great to be solved on next version too ;) )

2. Yes I've.

3. It would be great if the image would work as this BBCode:


Usage: [previewvideo="O Gangue do Parque|853x480"]2LO-X-4zl0Y|2LO-X-4zl0Y|64|5244[/previewvideo]

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


New "problem": On the calendar, since I've a LOT of users, it would be great to have a SQL limitation for birthdays. Like: All users with less then 1 post for example will not be shown on the calendar as birthday. Can this be added?

The same thing for the block of Birthday, if it was possible to limit by less then x posts, would be great for large forums!

And on the calendar page, it appears the birthday list even if we put on the block to not appear on the block. Is there any other option to not appear in there too?
It looks bad on large boards:
Image
And as you can see there is many files missing template as calendar :(


And I get this error on console on the calendar page:
calendar:808 Uncaught ReferenceError: jQuery is not defined
at calendar:808

-----------

There is this problem too:
Image

And this colors as blue could be changed to be more alike the theme too:
Image


----------

Another bug : [phpBB Debug] PHP Warning: in file [ROOT]/ext/canidev/blockgets/blocks/quote_of_day_block.php on line 128: mt_rand(): max(-1) is smaller than min(0)
Solution: On that file, FIND: $new_id = mt_rand(0, (count($data['quotes'])-1)); AND REPLACE WITH: $new_id = mt_rand(0, (count($data['list'])-1));

And the "Keep all day:" option doesn't work if the Random option is enabled.

-------

Btw on the Topic Index is it possible to add an option to follow a regular expression, that way the admin could insert a regular expression like this: /[[A-Z0-9_-]/] (.+)
And it will parse only the content inside the (.+) Since all my topics has [text] Topic title and I wanted to ignore the first text. I beleive more people have the same problem, maybe with another kind of statement on the begining, so thats why the regular expression to be inserted on ACP would give a lot of power to all admins ;)Can this be done?

------

The Cloudtag doesn't work with MySQL Search :(
And its a Flash cloud, flash is so outdated :/
Same thing for the Clock...
And you could add a Countdown too ;)

------

The leaders block could have an option so we could see not only the predefined group of each user, but since some users are in more then one group, let say the founder is on admin and mod group, I want him to appear on both groups and not the admin one since its the default group for him. If you dont plan to add that option, how can I acheive that?
------

New Feature: Would bepossible to add a new block compatible with phpBB Gallery Extension: https://www.phpbb.com/customise/db/exte ... b_gallery/

------

RSS Reader takes too much time to show anything :/
User avatar

Leinad4Mind
 
Posts: 30
Joined: Thu Oct 15, 2015 10:10 pm

Re: cBB Blockgets v2.0.0 SQL Bug

Postby Leinad4Mind » Tue Jan 16, 2018 3:27 am • via Web
Canidev, the News block for example is showing all the results including the ones that should not appear since I use this ext: https://github.com/brunoais/readOthersTopics

Can anything be done to hide according those permissions?
User avatar

IvanPF
Site Admin
 
Posts: 977
Joined: Fri Jun 17, 2011 12:15 am
Location: España (Spain)

Re: cBB Blockgets v2.0.0 SQL Bug

Postby IvanPF » Tue Jan 16, 2018 11:30 am • via Web
Hi,

I will review all these errors and suggestions as soon as possible.
User avatar

Leinad4Mind
 
Posts: 30
Joined: Thu Oct 15, 2015 10:10 pm

Re: cBB Blockgets v2.0.0 SQL Bug

Postby Leinad4Mind » Tue Jan 16, 2018 3:49 pm • via Web
Sure, take your time ;)

I'll just let here an idea for the calendar.

Image
The Today button could be clicable, and appear options to users to let say Hide birthdays for example, or for hide events. So we as user could filter the calendar information. In case the admin enables both (even with the >1 post for birthdays).

----------

On Recent Topics:

Title limit:
Number of characters that be show in the topic titles.

This settings does not work. I can put 20, or 10 it will not trim the title text.

---------

I've found too that on the Leaders Block we don't have username colors, like we've on the friends block.

Who is online

Users browsing this forum: No registered users and 1 guest