cBB Blockgets v2.0.0 SQL Bug


User avatar

Leinad4Mind
 
Posts: 78
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: 78
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: 78
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: 1445
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: 78
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?
(I've added to the calendar controller "AND u.user_posts > 100" in line 377 but this 100 could be a variable at ACP, for calendar and calendar block)

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 (its not compatible with BBAvatars):
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 waythe 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 adda 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 :/
Last edited by Leinad4Mind on Mon Jun 25, 2018 3:57 pm, edited 2 times in total.
User avatar

Leinad4Mind
 
Posts: 78
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: 1445
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: 78
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.

--------

On the search block, the search engine options doesn't work, even if we select them it search always with forum system.
And If I select the Author, it will not search by topics made by that author. It will do always the "message"

-----

The Group choice on every block us kinda weird. If an user is in more then 1 group, let sayModerator and Staff group (this one as default), and I put something visible to Moderators, that user will not have permission to view, just because the groups are just showing for the default value :(

----

You can remove all of the type="text/javascript" and type="text/css" since in html that info is deprectated

------

I wanted to add compatibility with QTE extension, but it seems this is lacking some events so we can change the topic_title adding before the topic attribute from qte extension. :(

--------

On the Who is Online block:
Image

I change the 2 lines to this: $l_online_time = $this->lang->get('VIEW_ONLINE_TIMES', (int) $this->config['load_online_time']); It seems to work.
User avatar

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

Re: cBB Blockgets v2.0.0 SQL Bug

Postby Leinad4Mind » Thu Jan 25, 2018 12:33 pm • via Android
News Block:
The pagination doesn't appear on mobile. Is quite important to appear.

News Block and Hot Topic Block:
If we click on any topic title we are redirect for the 1st post. We should be redirect to the last unread post.
User avatar

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

Re: cBB Blockgets v2.0.0 SQL Bug

Postby Leinad4Mind » Sun Mar 04, 2018 11:40 pm • via Web
Btw I got this SQL error, dunno why, maybe its an heavy operation:

SQL ERROR [ mysqli ]

Server shutdown in progress [1053]

SQL

SELECT u.user_id, u.group_id as default_group, u.username, u.username_clean, u.user_colour, g.group_id, g.group_name, g.group_colour, g.group_type, ug.user_id as ug_user_id FROM (phpbb_users u CROSS JOIN phpbb_groups g) LEFT JOIN phpbb_user_group ug ON (ug.group_id = g.group_id AND ug.user_pending = 0 AND ug.user_id = 2) WHERE u.group_id = g.group_id AND u.group_id IN (11, 18, 13, 12, 17, 15, 16, 14, 25) ORDER BY g.group_name ASC, u.username_clean ASC

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/blocks/leaders_block.php
LINE: 104
CALL: phpbbdbdriverfactory->sql_query()

FILE: [ROOT]/ext/canidev/blockgets/libraries/blockgets.php
LINE: 369
CALL: canidevblockgetsblocksleaders_block->init()

FILE: [ROOT]/ext/canidev/blockgets/libraries/blockgets.php
LINE: 333
CALL: canidevblockgetslibrariesblockgets->block_to_template()

FILE: [ROOT]/ext/canidev/blockgets/libraries/blockgets.php
LINE: 208
CALL: canidevblockgetslibrariesblockgets->load_blocks()

FILE: [ROOT]/ext/canidev/blockgets/event/listener.php
LINE: 137
CALL: canidevblockgetslibrariesblockgets->display_page()

FILE: (not given by php)
LINE: (not given by php)
CALL: canidevblockgetseventlistener->on_footer()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 184
CALL: call_user_func()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 46
CALL: SymfonyComponentEventDispatcherEventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 60
CALL: SymfonyComponentEventDispatcherEventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbbeventdispatcher->dispatch()

FILE: [ROOT]/includes/functions.php
LINE: 4625
CALL: phpbbeventdispatcher->trigger_event()

FILE: [ROOT]/ext/canidev/blockgets/controller/main_controller.php
LINE: 78
CALL: page_footer()

FILE: (not given by php)
LINE: (not given by php)
CALL: canidevblockgetscontrollermain_controller->display()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 144
CALL: call_user_func_array()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 64
CALL: SymfonyComponentHttpKernelHttpKernel->handleRaw()

FILE: [ROOT]/app.php
LINE: 35
CALL: SymfonyComponentHttpKernelHttpKernel->handle()
Next

Who is online

Users browsing this forum: No registered users and 1 guest

cron