Author Topic: Extensive description in Concert Calendar 2.5.1 (Read 23948 times)

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

dbs · « **Reply #1 on:** February 22, 2019, 04:01:57 PM »

You mean you can see the arrow on the right side but it happens nothing after click?

jacobi22 · « **Reply #2 on:** February 22, 2019, 04:03:17 PM »

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

henri · « **Reply #3 on:** February 22, 2019, 04:34:06 PM »

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.

henri · « **Reply #4 on:** February 22, 2019, 04:44:27 PM »

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

jacobi22 · « **Reply #5 on:** February 22, 2019, 04:52:03 PM »

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

dbs · « **Reply #6 on:** February 22, 2019, 05:00:07 PM »

Quote

... into the wysiwyg editor that appears in the event calendar under ...

Hm, which calendar is the right one? concert or event?

henri · « **Reply #7 on:** February 22, 2019, 05:04:07 PM »

Hello dbs,

Sorry.

Concert

henri · « **Reply #8 on:** February 22, 2019, 05:06:13 PM »

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

dbs · « **Reply #9 on:** February 22, 2019, 05:35:25 PM »

Normally the desription should be visible in the details. In the tests all worksfine.
Can you give us a link to the problem page?

henri · « **Reply #10 on:** February 22, 2019, 06:05:19 PM »

Hello dbs,

See Screenshot in pdf

henri · « **Reply #11 on:** February 22, 2019, 06:21:02 PM »

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

dbs · « **Reply #12 on:** February 22, 2019, 06:27:21 PM »

You are sure in setting in the loop is also the placeholder [INFO] ?

jacobi22 · « **Reply #13 on:** February 22, 2019, 06:27:56 PM »

Quote from: dbs on February 22, 2019, 06:27:21 PM

You are sure in setting in the loop is also the placeholder [INFO] ?

jacobi22 · « **Reply #14 on:** February 22, 2019, 06:29:17 PM »

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!

jacobi22 · « **Reply #15 on:** February 22, 2019, 06:38:40 PM »

@ Henri: set the first option in Module setting to NO - in your case:

it will schon the events incl description in the top of the list

henri · « **Reply #16 on:** February 22, 2019, 06:44:39 PM »

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

henri · « **Reply #17 on:** February 22, 2019, 06:49:53 PM »

Hello dbs and jacobi 22,

Screenshot in pdf Concert calendar 2.4

jacobi22 · « **Reply #18 on:** February 22, 2019, 06:51:59 PM »

maybe, you did'nt read the post from dbs - you need the placeholder [INFO] in your Loop-settings like this example

henri · « **Reply #19 on:** February 22, 2019, 07:06:24 PM »

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

dbs · « **Reply #20 on:** February 22, 2019, 07:16:44 PM »

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.

henri · « **Reply #21 on:** February 22, 2019, 07:24:23 PM »

Hello dbs,

Exactly what I meant.
Now it is all right.

In version 2.4 the <br /> is not necessary.

Thanks

jacobi22 · « **Reply #22 on:** February 23, 2019, 03:47:48 PM »

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

Code: [Select]

$database->query("INSERT INTO `".TABLE_PREFIX."mod_concert_dates` (`page_id`, `section_id`, `concert_date`) VALUES ('$page_id','$section_id','$date')")

with this code

Code: [Select]

$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());
    }

henri · « **Reply #23 on:** February 23, 2019, 05:14:36 PM »

Hi jacobi22,

I replaced the code with the new code.
And everything works perfectly.

dbs · « **Reply #24 on:** May 16, 2019, 07:58:50 PM »

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):

Code: [Select]

$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());
    }

News

Support WebsiteBaker

Your donations will help to:

You can donate by clicking on the button below.

Author Topic: Extensive description in Concert Calendar 2.5.1 (Read 23948 times)