#5864 - Using Shoutbox in Composr Causes Crash

  • By
  • Added
  • 2 views
Identifier #5864
Issue type Feature request or suggestion
Title Using Shoutbox in Composr Causes Crash
Status Open
Handling member Deleted
Addon General / Uncategorised
Description Using the shoutbox module in composr causes a crash. Anytime you type something in the shoutbox in Composr, assuming you have included a shoutbox, a crash happens and you will notice two things.

1. The crash itself. This crash displays a stacktrash which I'll provide below.

2. The shoutbox will say that Flood Control blocked the message, but the message will still display. It will make this claim even if this is the very first message ever sent to shoutbox.
Steps to reproduce

Have the Shoutbox module.

Type something, anything in it

Hit send

See crash happen.
Additional information Stack Trace Below:

An error has occurred

Unfortunately a query has failed [CREATE TABLE conversationlog ( bot tinyint(3) unsigned NOT NULL default '0', id int(11) NOT NULL auto_increment, input text, response text, uid varchar(255) default NULL, enteredtime timestamp(6) NOT NULL, PRIMARY KEY (id), KEY botid (bot) ) ENGINE=MyISAM] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, PRIMARY KEY (id), KEY botid (bot) ) ENGINE=MyISAM' at line 7] (version: 10 alpha1, PHP version: 5.6.8, URL: /v10/composr/index.php?page=start&room_id=1&keep_devtest=1&posted=1)

Here is the stack trace:

Below is a stack trace revealing the state Composr was in when the error occurred. If this represents a bug in the unmodified software, you may want to check Composr website for a fix, and if there isn't one, report this as a bug. Please note that merely posting a stack trace is not sufficient for us to solve your problem; the stack trace is just an aid that presents us with additional information. We still need to know the error message, what you tried to do, how you tried to do it, version numbers, and any other appropriate information.
We apologize for this problem and if it's a bug we hope you will work with us so that we can fix it for you promptly.

File '/home/mythus/public_html/v10/composr/sources/failure.php'
Line 958
Function 'get_html_trace'
Args
File '/home/mythus/public_html/v10/composr/sources/global2.php'
Line 897
Function '_fatal_exit'
Args
Tempcode -> ...
File '/home/mythus/public_html/v10/composr/sources/database/mysql.php'
Line 256
Function 'fatal_exit'
Args
Tempcode -> ...
File '/home/mythus/public_html/v10/composr/sources/database.php'
Line 1,283
Function 'db_query'
Class 'Database_Static_mysql'
Object O:21:"Database_Static_mysql":3:{s:8:"cache_db";a:0:{}s:14:"last_select_db";s:3:"v10";s:16:"reconnected_once";b:0;}
Type '->'
Args
'CREATE TABLE conversationlog (\n bot tinyint(3) unsigned NOT NULL default '0',\n id int(11) NOT NULL auto_increment,\n input text,\n response text,\n uid varchar(255) default NULL,\n enteredtime timestamp(6) NOT NULL,\n PRIMARY KEY (id),\n KEY botid (bot)\n ) ENGINE=MyISAM'

a:2:{i:0;i:0;i:1;s:3:"v10";}

NULL

NULL

false

false

false

false
File '/home/mythus/public_html/v10/composr/sources/database.php'
Line 1,058
Function '_query'
Class 'DatabaseConnector'
Object O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:6:"cms10_";s:15:"connection_read";a:2:{i:0;i:0;i:1;s:3:"v10";}s:16:"connection_write";a:2:{i:0;i:0;i:1;s:3:"v10";}s:26:"text_lookup_original_cache";a:0:{}s:17:"text_lookup_cache";a:0:{}s:18:"table_exists_cache";a:1:{s:16:"credit_purchases";b:1;}s:9:"static_ob";O:21:"Database_Static_mysql":3:{s:8:"cache_db";a:0:{}s:14:"last_select_db";s:3:"v10";s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:0;}
Type '->'
Args
'CREATE TABLE conversationlog (\n bot tinyint(3) unsigned NOT NULL default '0',\n id int(11) NOT NULL auto_increment,\n input text,\n response text,\n uid varchar(255) default NULL,\n enteredtime timestamp(6) NOT NULL,\n PRIMARY KEY (id),\n KEY botid (bot)\n ) ENGINE=MyISAM'

NULL

NULL

false

false

NULL

''
File '/home/mythus/public_html/v10/composr/sources_custom/hooks/modules/chat_bots/trickstr.php'
Line 137
Function 'query'
Class 'DatabaseConnector'
Object O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:6:"cms10_";s:15:"connection_read";a:2:{i:0;i:0;i:1;s:3:"v10";}s:16:"connection_write";a:2:{i:0;i:0;i:1;s:3:"v10";}s:26:"text_lookup_original_cache";a:0:{}s:17:"text_lookup_cache";a:0:{}s:18:"table_exists_cache";a:1:{s:16:"credit_purchases";b:1;}s:9:"static_ob";O:21:"Database_Static_mysql":3:{s:8:"cache_db";a:0:{}s:14:"last_select_db";s:3:"v10";s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:0;}
Type '->'
Args
'CREATE TABLE conversationlog (\n bot tinyint(3) unsigned NOT NULL default '0',\n id int(11) NOT NULL auto_increment,\n input text,\n response text,\n uid varchar(255) default NULL,\n enteredtime timestamp(6) NOT NULL,\n PRIMARY KEY (id),\n KEY botid (bot)\n ) ENGINE=MyISAM'
File '/home/mythus/public_html/v10/composr/sources_custom/hooks/modules/chat_bots/trickstr.php'
Line 75
Function 'handle_commands'
Class 'Hook_chat_bot_trickstr'
Object O:22:"Hook_chat_bot_trickstr":0:{}
Type '->'
Args
1

'test'
File '/home/mythus/public_html/v10/composr/sources/chat.php'
Line 902
Function 'reply_to_any_communication'
Class 'Hook_chat_bot_trickstr'
Object O:22:"Hook_chat_bot_trickstr":0:{}
Type '->'
Args
1

'test'
File '/home/mythus/public_html/v10/composr/sources_custom/blocks/side_shoutbox.php'
Line 101
Function 'chat_post_message'
Args
1

'test'

'Verdana'

'inherit'

15
File '/home/mythus/public_html/v10/composr/sources/zones.php'
Line 1,141
Function 'run'
Class 'Block_side_shoutbox'
Object O:19:"Block_side_shoutbox":0:{}
Type '->'
Args
a:2:{s:5:"block";s:13:"side_shoutbox";s:5:"cache";s:1:"1";}
File '/home/mythus/public_html/v10/composr/sources/tempcode.php'
Line 1,017
Function 'do_block'
Args
'side_shoutbox'

a:1:{s:5:"block";s:13:"side_shoutbox";}
File '/home/mythus/public_html/v10/composr/sources/symbols.php'
Line 2,962
Function 'handle_symbol_preprocessing'
Args
a:4:{i:0;a:0:{}i:1;i:0;i:2;s:5:"BLOCK";i:3;a:1:{i:0;s:19:"block=side_shoutbox";}}

a:0:{}
File '/home/mythus/public_html/v10/composr/sources/tempcode.php(1904) : eval()'d code'
Line 1
Function 'ecv_BLOCK'
Args
'EN'

a:0:{}

a:1:{i:0;s:19:"block=side_shoutbox";}
File '/home/mythus/public_html/v10/composr/sources/tempcode.php'
Line 1,904
Function 'eval'
File '/home/mythus/public_html/v10/composr/sources/tempcode.php'
Line 182
Function 'evaluate'
Class 'Tempcode'
Object Tempcode -> ...
Type '->'
Args
File '/home/mythus/public_html/v10/composr/sources/tempcode.php(1904) : eval()'d code'
Line 1
Function 'otp'
Args
Tempcode -> ...

'CONTENT/COMCODE_PAGE_SCREEN'
File '/home/mythus/public_html/v10/composr/sources/tempcode.php'
Line 1,904
Function 'eval'
File '/home/mythus/public_html/v10/composr/sources/tempcode.php'
Line 1,123
Function 'evaluate'
Class 'Tempcode'
Object Tempcode -> ...
Type '->'
Args
File '/home/mythus/public_html/v10/composr/sources/tempcode.php'
Line 1,713
Function 'handle_symbol_preprocessing'
Args
array

NULL
File '/home/mythus/public_html/v10/composr/sources/global3.php'
Line 474
Function 'handle_symbol_preprocessing'
Class 'Tempcode'
Object Tempcode -> ...
Type '->'
Args
File '/home/mythus/public_html/v10/composr/sources/site.php'
Line 849
Function 'globalise'
Args
NULL

NULL

''

true
File '/home/mythus/public_html/v10/composr/index.php'
Line 67
Function 'do_site'
Args
Parameters

y70b076077ef9896c332c574ad24f514d
session_id
2bf382e6ea4d1
shoutbox_message
test
Funded? No
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated