Extensive description in Concert Calendar 2.5.1

[dbs]

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 Expand

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

[henri]

Hi jacobi22,

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

[Gast]

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 Expand

$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 Expand

$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]

Hello dbs,

Exactly what I meant.
Now it is all right.

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

Thanks

[dbs]

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]

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

[Gast]

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

[henri]

Hello dbs and jacobi 22,

Screenshot in pdf Concert calendar 2.4

[henri]

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

[Gast]

@ 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

[Gast]

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!

[Gast]

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

[dbs]

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

[henri]

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

[henri]

Hello dbs,

See Screenshot in pdf

[dbs]

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]

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

[henri]

Hello dbs,

Sorry.

Concert

[dbs]

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

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

[Gast]

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

[henri]

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

[henri]

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.

[Gast]

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

[dbs]

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

[henri]

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