View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
2120Composr alpha bug reportsGeneral / Uncategorisedpublic2015-12-15 13:282024-08-09 08:17
Reportermythus Assigned ToChris Graham  
PrioritynormalSeverity@70@ 
Status resolvedResolutionfixed 
Summary2120: Using Shoutbox in Composr Causes Crash
DescriptionUsing 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 ReproduceHave the Shoutbox module.
Type something, anything in it
Hit send
See crash happen.
Additional InformationStack 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
TagsNo tags attached.
Attach Tags
Sponsorship open

Sponsor

Date Added Member Amount Sponsored

Activities

Chris Graham

2015-12-16 22:33

administrator   ~3251

Issue in Trickstr addon, code we inherited had SQL no longer compatible with MySQL 5.6

Issue History

Date Modified Username Field Change
2023-02-26 18:29 Chris Graham Category General => General / Uncategorised
2024-08-09 05:36 Guest Note Added: 0009133
2024-08-09 08:17 Guest File Added: file.txt
2024-08-09 20:39 PDStig File Deleted: file.txt