WebsiteBaker Support (2.12.x) > Modules

Extensive description in Concert Calendar 2.5.1

<< < (5/5)

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:
Hello dbs,

Exactly what I meant.
Now it is all right.

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

Thanks

jacobi22:
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: ---$database->query("INSERT INTO `".TABLE_PREFIX."mod_concert_dates` (`page_id`, `section_id`, `concert_date`) VALUES ('$page_id','$section_id','$date')")
--- End code ---

with this code


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

henri:
Hi jacobi22,

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

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

Navigation

[0] Message Index

[*] Previous page