[calendar] - Error create event, Roundcube 0.8.6

[GoogleCodeExporter]

Token: dd12c1d22a08aff4be5253f5be23c247 (Don't modify this token!)
Version: 11.0.30 (03-03-2013)
PHP: 5.3.3
RCMAIL: 0.8.6
Database: mysql
SERVER: Apache/2.2.3 (CentOS)
----
I.  Issue Description:
Cant create event in calendar

II. Steps to reproduce the Issue:
1.Select Calendar
2.Create Event
3.JS Error: Error: cannot call methods on dialog prior to initialization; 
attempted to call method 'isOpen'

Original issue reported on code.google.com by mmartine...@gmail.com on 29 Mar 2013 at 11:11

[GoogleCodeExporter]

Attach my roundcube

Original comment by mmartine...@gmail.com on 29 Mar 2013 at 11:41

[GoogleCodeExporter]

Did you update jQuery with the version included in Roundcube 0.9?

Official Roundcube 0.8.6 is shipped with jQuery 1.7.2. This error is related to 
a jQuery update which is not officially supported by Roundcube 0.8.6.

Original comment by roland.l...@gmail.com on 30 Mar 2013 at 4:11

• Changed state: Invalid

[GoogleCodeExporter]

Original comment by roland.l...@gmail.com on 30 Mar 2013 at 4:14

• Changed state: Reproducing

[GoogleCodeExporter]

I replace js /roundcubemail086Test/program/js/jquery.min.js with version 0.9 
and it break calendar.

Original comment by mmartine...@gmail.com on 30 Mar 2013 at 9:41

[GoogleCodeExporter]

You can't just replace files partially. Either you use Roundcube 0.9 and the 
plugin coded for 0.9 or you keep jquery.min.js which has been officially 
distributed with Roundcube 0.8.6.

Original comment by roland.l...@gmail.com on 30 Mar 2013 at 9:53

• Changed state: Invalid

[GoogleCodeExporter]

It means that I cant use calendar with Roundcube 0.8.6. The error occurs with 
the original jquery.min.js.

Also, I got it in log file:
[30-Mar-2013 04:58:59 -0500]: DB Error: _doQuery: [Error message: Could not 
execute statement]
[Last executed query: PREPARE 
mdb2_statement_mysql_572c664fa46674d39673c4ad02a9cb03afad2e7b0 FROM 'SELECT * 
FROM `` \r\n         WHERE `user_id`=?']
[Native code: 1103]
[Native message: Incorrect table name '']
 in /usr/share/roundcubemail086/roundcubemail086Test/program/include/rcube_mdb2.php on line 296 (GET /roundcubemail086Test/?_task=dummy&_action=plugin.calendar_fetchalllayers&_start=1364598000&_end=1364770800&_category=&_tzname=Europe%2FBerlin&_echo=1&_=1364637506579)

Original comment by mmartine...@gmail.com on 30 Mar 2013 at 10:14

[GoogleCodeExporter]

Here you state you have replaced jquery with a newer version:

"I replace js /roundcubemail086Test/program/js/jquery.min.js with version 0.9 
and it break calendar."

So, what did you actually do? I have downloaded Roundcube 0.8.6 today and it is 
distributed with jquery 1.7.2. Check the version you are using.

Original comment by roland.l...@gmail.com on 30 Mar 2013 at 10:17

[GoogleCodeExporter]

Also, I got it in log file:
[30-Mar-2013 04:58:59 -0500]: DB Error: _doQuery: [Error message: Could not 
execute statement]
[Last executed query: PREPARE 
mdb2_statement_mysql_572c664fa46674d39673c4ad02a9cb03afad2e7b0 FROM 'SELECT * 
FROM `` \r\n         WHERE `user_id`=?']
[Native code: 1103]
[Native message: Incorrect table name '']
 in /usr/share/roundcubemail086/roundcubemail086Test/program/include/rcube_mdb2.php on line 296 (GET /roundcubemail086Test/?_task=dummy&_action=plugin.calendar_fetchalllayers&_start=1364598000&_end=1364770800&_category=&_tzname=Europe%2FBerlin&_echo=1&_=1364637506579)

Either you did not created required database tables or you did not configure it 
properly:
/* Database table mapping */
// notice: leading underscore
$rcmail_config['backend_db_table_map'] = array(
  'dummy' => '', // no db table
  'database' => '', // default db table
  'caldav' => '_caldav', // caldav db table (= default db table) extended by _caldav
);

/* database table name (main table) */
$rcmail_config['db_table_events'] = 'events';
$rcmail_config['db_sequence_events'] = 'events_ids';

/* database table name (cache) */
$rcmail_config['db_table_events_cache'] = 'events_cache';
$rcmail_config['db_sequence_events_cache'] = 'events_cache_ids';

/* database table name reminders */
$rcmail_config['db_table_events_reminders'] = 'reminders';

Original comment by roland.l...@gmail.com on 30 Mar 2013 at 10:26

[GoogleCodeExporter]

I replaced the file jquery.min.js to test it because you said "Did you update 
jQuery with the version included in Roundcube 0.9?"

Well I told what I did:
download rouncube 0.8.6
add plugins: automatic_addressbook, globaladdressbook, attachment_reminder
remove line: /skins/larry/includes/header.html
<roundcube:button name="about" type="link" label="about" class="about-link" 
onclick="UI.show_about(this);return false" />
bkp jqueryui > jqueryui BKP
add plugins: plugin_manager
rename plugin_manager\config.inc.php.dist > config.inc.php
Add lines:
  'calendaring' => array(
  'calendar' => array( 
      'label_name' => 'calendar.pluginname',
      'label_description' => 'calendar.plugindescription',
      'buttons' => array('#calendar_button', '#rcmrowcalendarlink', '#rcmrowcalendarcategories', '#rcmrowcalendarfeeds'),
      'reload' => true,
      'config' => './?_task=settings&_action=edit-prefs&_section=calendarlink&_framed=1',
      'section' => 'calendarlink',
      'uninstall' => true,
      'uninstall_request' => array(
        'action' => 'plugin.calendar_uninstall',
        'method' => 'post',
      ),
      'active' => true
    ),
  ),
register plugin(plugin_manager)
download from plugin manager: http_auth, jscolor, timepicker, calendar
create calendar table with SQL
change calendar config.inc.php.dist, add feeds

Thats all, I have done

Original comment by mmartine...@gmail.com on 30 Mar 2013 at 10:41

[GoogleCodeExporter]

#1-
3.JS Error: Error: cannot call methods on dialog prior to initialization; 
attempted to call method 'isOpen'

This error only occurs if you are using jquery > 1.7.2
Clear you cache and check if it still throws the error.
Make sure that no other plugin or application is including a different jquery 
version.

#2-
Check your database if the following tables are present:
- events
- events_caldav
- events_cache
- reminders

#3- Send me privately to myroundcube [at] mail4us [dot] net you Roundcube 
webmail url and access data for a test acount.

Original comment by roland.l...@gmail.com on 30 Mar 2013 at 10:49

[GoogleCodeExporter]

I private message was sent to myroundcube [at] mail4us [dot],

Thanks,

Miguel

Original comment by mmartine...@gmail.com on 30 Mar 2013 at 11:12