WebsiteBaker Community Forum
WebsiteBaker Support (2.12.x) => Modules => Topic started by: henri on February 22, 2019, 03:35:23 PM
-
Extensive description of the concert which was specified in word processor during adding performance is not shown in the website when clicking on a Future performance.
I do not know if this should be.
PHP-Version: 7.2.14
WebsiteBaker Version: 2.12.1 -r188
-
You mean you can see the arrow on the right side but it happens nothing after click?
-
How long is this description and do you use MS Word, to write this text?
datatype text can work ~65.000 Chars. Chars means: everything, a letter, a whitespace and also formatted code like this one from MS Word. It is possible in Word, that a simple text with maybe 5000 visible chars like letter, point, commata use this text-field limit, if you use there a lot of text-formations like tabs, colors etc
take a look into the source code (if you have a wysiwyg Editor there) or in the description field from the database for more informations
This Error Notice looks like a message from the wysiwyg editor. i'm not sure about your version - my version use a wysiwyg-editor for the description
-
Hello dbs,
When I click on the arrow, the performance will appear below:
Name of the performance, Location, Room, Start, Admission price.
This is next to each other on one line.
If I click on "Future performances" on the left of the date, you will see the details at the top:
Name of the performance, Location, Room, Start, Admission price.
This is next to each other on one line.
I have typed the extended description (5 words) into the wysiwyg editor that appears in the event calendar under the add event.
-
Error in previous message
After click on date is at the top
1st line: Name of the performance
2nd line: Place, Room, Start, Entrance price
-
the problem in this concert calendar: it loads all events on one page, no pagination, no sql-limits. i have sql-backup's here with 8000 and 12.000 events from the last 20 years. in this special cases, WB show#s only (if i remember correct) 841 events from the list. not realy long descriptions, maybe 100 Words / event
but maybe, i'm thinking in a wrong direction and you mean with the word "performance" not the performance from the page or the system, you mean maybe the event descrpition there. not possible to say for me, how many events and descriptions are in the output list, but if it's too much, the output filter cannot filter everything and stop's his work. Remove one or more (long) description somewhere, cut it from the description field and add it into a new textfile - if you see then some positive results on the page, i'm right
-
... into the wysiwyg editor that appears in the event calendar under ...
Hm, which calendar is the right one? concert or event?
-
Hello dbs,
Sorry.
Concert
-
Hi jacobi22,
I translate everything via google which does not always give the correct meaning of the word.
concert = performance
I would like to upload a screenshot. But that does not work with images
-
Normally the desription should be visible in the details. In the tests all worksfine.
Can you give us a link to the problem page?
-
Hello dbs,
See Screenshot in pdf
-
Hello dbs,
Concert calender 2.5.1 just tested in WB 2.11.0
Result is exactly the same.
PHP-Version: 7.2.14
WebsiteBaker Version: 2.11.0 -r79
-
You are sure in setting in the loop is also the placeholder [INFO] ?
-
You are sure in setting in the loop is also the placeholder [INFO] ?
(Y) (Y)
-
only some additional info: this module doesn't work in mysql-strict mode, specially here the new install and adding of new events
P.S.: has nothing to do with the actual problem!
-
@ Henri: set the first option in Module setting to NO - in your case: (https://i.gyazo.com/624b847767593261b8b5b894d54015f3.png)
it will schon the events incl description in the top of the list
-
Hi dbs and jacobi22,
first option in Module setting to NO
Result remains the same and now no Details for concert is at the top.
Concert calender 2.4 just tested in WB 2.11.0
The result is exactly the same as with version 2.5.1
All settings in admin from Concert calender in both versions the same as in pdf screenshot.
PHP-Version: 7.2.14
WebsiteBaker Version: 2.11.0 -r79
-
Hello dbs and jacobi 22,
Screenshot in pdf Concert calendar 2.4
-
maybe, you did'nt read the post from dbs - you need the placeholder [INFO] in your Loop-settings like this example
(https://i.gyazo.com/2520694223138f7544200066b0b45899.png)
-
Hi dbs and jacobi22,
[INFO] added in version 2.5.1 and version 2.4
Now everything works fine.
Only in version 2.5.1 with the description to the next line.
See screenshot.
TOP
-
If you need the description in next line you have to put this linebrake <br /> before [INFO].
Not sure if this is what you mean.
-
Hello dbs,
Exactly what I meant.
Now it is all right.
In version 2.4 the <br /> is not necessary.
Thanks
-
only a small fix to make the version 2.5.1 ready for mysql-strict-mode
File modules/concert/add_concert.php
replace this lines
$database->query("INSERT INTO `".TABLE_PREFIX."mod_concert_dates` (`page_id`, `section_id`, `concert_date`) VALUES ('$page_id','$section_id','$date')")
with this code
$sql = 'INSERT INTO `'.TABLE_PREFIX.'mod_concert_dates` SET '
. '`section_id` = '.(int)$section_id.', '
. '`page_id` = '.(int)$page_id.', '
. '`concert_date` = \''.$database->escapeString($date).'\', '
. '`concert_desc` = \'\' ';
$database->query($sql);
if($database->is_error()) {
$admin->print_error($database->get_error());
}
-
Hi jacobi22,
I replaced the code with the new code.
And everything works perfectly.
-
Seems for strict are more fields needed?
I have a red "Field 'concert_name' doesn't have a default value" as result of adding new concert.
It works with one line more (concert_name):
$sql = 'INSERT INTO `'.TABLE_PREFIX.'mod_concert_dates` SET '
. '`section_id` = '.(int)$section_id.', '
. '`page_id` = '.(int)$page_id.', '
. '`concert_date` = \''.$database->escapeString($date).'\', '
. '`concert_name` = \'\', '
. '`concert_desc` = \'\' ';
$database->query($sql);
if($database->is_error()) {
$admin->print_error($database->get_error());
}