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

Offline henri

  • Posts: 134
Extensive description in Concert Calendar 2.5.1
« 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

Offline dbs

  • Betatester
  • **
  • Posts: 7920
  • Gender: Male
  • tioz4ever
    • WebsiteBaker - jQuery-Plugins - Module - Droplets - Tests
Re: Extensive description in Concert Calendar 2.5.1
« 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?

Offline jacobi22

  • Posts: 5836
  • Gender: Male
  • Support also via PM or EMail
    • Jacobi22
Re: Extensive description in Concert Calendar 2.5.1
« 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
Probleme sind da, um sie zu lösen, nicht, um nach Ausreden zu suchen.

Offline henri

  • Posts: 134
Re: Extensive description in Concert Calendar 2.5.1
« 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.

Offline henri

  • Posts: 134
Re: Extensive description in Concert Calendar 2.5.1
« 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

Offline jacobi22

  • Posts: 5836
  • Gender: Male
  • Support also via PM or EMail
    • Jacobi22
Re: Extensive description in Concert Calendar 2.5.1
« 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
Probleme sind da, um sie zu lösen, nicht, um nach Ausreden zu suchen.

Offline dbs

  • Betatester
  • **
  • Posts: 7920
  • Gender: Male
  • tioz4ever
    • WebsiteBaker - jQuery-Plugins - Module - Droplets - Tests
Re: Extensive description in Concert Calendar 2.5.1
« 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?

Offline henri

  • Posts: 134
Re: Extensive description in Concert Calendar 2.5.1
« Reply #7 on: February 22, 2019, 05:04:07 PM »
Hello dbs,

Sorry.

Concert

Offline henri

  • Posts: 134
Re: Extensive description in Concert Calendar 2.5.1
« 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

Offline dbs

  • Betatester
  • **
  • Posts: 7920
  • Gender: Male
  • tioz4ever
    • WebsiteBaker - jQuery-Plugins - Module - Droplets - Tests
Re: Extensive description in Concert Calendar 2.5.1
« 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?

Offline henri

  • Posts: 134
Re: Extensive description in Concert Calendar 2.5.1
« Reply #10 on: February 22, 2019, 06:05:19 PM »
Hello dbs,

See Screenshot in pdf

Offline henri

  • Posts: 134
Re: Extensive description in Concert Calendar 2.5.1
« 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

Offline dbs

  • Betatester
  • **
  • Posts: 7920
  • Gender: Male
  • tioz4ever
    • WebsiteBaker - jQuery-Plugins - Module - Droplets - Tests
Re: Extensive description in Concert Calendar 2.5.1
« Reply #12 on: February 22, 2019, 06:27:21 PM »
You are sure in setting in the loop is also the placeholder [INFO] ?

Offline jacobi22

  • Posts: 5836
  • Gender: Male
  • Support also via PM or EMail
    • Jacobi22
Re: Extensive description in Concert Calendar 2.5.1
« Reply #13 on: February 22, 2019, 06:27:56 PM »
You are sure in setting in the loop is also the placeholder [INFO] ?
(Y) (Y)
Probleme sind da, um sie zu lösen, nicht, um nach Ausreden zu suchen.

Offline jacobi22

  • Posts: 5836
  • Gender: Male
  • Support also via PM or EMail
    • Jacobi22
Re: Extensive description in Concert Calendar 2.5.1
« 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!
Probleme sind da, um sie zu lösen, nicht, um nach Ausreden zu suchen.

Offline jacobi22

  • Posts: 5836
  • Gender: Male
  • Support also via PM or EMail
    • Jacobi22
Re: Extensive description in Concert Calendar 2.5.1
« 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
Probleme sind da, um sie zu lösen, nicht, um nach Ausreden zu suchen.

Offline henri

  • Posts: 134
Re: Extensive description in Concert Calendar 2.5.1
« 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

Offline henri

  • Posts: 134
Re: Extensive description in Concert Calendar 2.5.1
« Reply #17 on: February 22, 2019, 06:49:53 PM »
Hello dbs and jacobi 22,

Screenshot in pdf Concert calendar 2.4

Offline jacobi22

  • Posts: 5836
  • Gender: Male
  • Support also via PM or EMail
    • Jacobi22
Re: Extensive description in Concert Calendar 2.5.1
« 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

Probleme sind da, um sie zu lösen, nicht, um nach Ausreden zu suchen.

Offline henri

  • Posts: 134
Re: Extensive description in Concert Calendar 2.5.1
« 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

Offline dbs

  • Betatester
  • **
  • Posts: 7920
  • Gender: Male
  • tioz4ever
    • WebsiteBaker - jQuery-Plugins - Module - Droplets - Tests
Re: Extensive description in Concert Calendar 2.5.1
« 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.

Offline henri

  • Posts: 134
Re: Extensive description in Concert Calendar 2.5.1
« 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

Offline jacobi22

  • Posts: 5836
  • Gender: Male
  • Support also via PM or EMail
    • Jacobi22
Concert Calendar 2.5.1 - needed Changes for MYSQL-STRICT-Mode
« 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());
    }
Probleme sind da, um sie zu lösen, nicht, um nach Ausreden zu suchen.

Offline henri

  • Posts: 134
Re: Extensive description in Concert Calendar 2.5.1
« Reply #23 on: February 23, 2019, 05:14:36 PM »
Hi jacobi22,

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

Offline dbs

  • Betatester
  • **
  • Posts: 7920
  • Gender: Male
  • tioz4ever
    • WebsiteBaker - jQuery-Plugins - Module - Droplets - Tests
Re: Extensive description in Concert Calendar 2.5.1
« 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());
    }

 

postern-length