search

Twizanex / gutwacaptcha

Elgg Captcha or gutwacaptcha plugin provides captcha support for Elgg
www.twizanex.com
Other
0 stars 3 forks source link

Fatal Error. #4

Open Omenicus opened 9 years ago

Omenicus commented 9 years ago

There were a number of issues: 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 '--CREATE TABLE IF NOT EXISTS elgg_captcha_codes (

--) ENGINE=MyISAM DEFAULT C' at line 1

QUERY: --CREATE TABLE IF NOT EXISTS elgg_captcha_codes (

--) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DatabaseException Object ( [message:protected] => There were a number of issues: 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 '--CREATE TABLE IF NOT EXISTS elgg_captcha_codes (

--) ENGINE=MyISAM DEFAULT C' at line 1

QUERY: --CREATE TABLE IF NOT EXISTS elgg_captcha_codes (

--) ENGINE=MyISAM DEFAULT CHARSET=utf8; [string:Exception:private] => exception 'DatabaseException' with message 'There were a number of issues: 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 '--CREATE TABLE IF NOT EXISTS elgg_captcha_codes (

--) ENGINE=MyISAM DEFAULT C' at line 1

QUERY: --CREATE TABLE IF NOT EXISTS elgg_captcha_codes (

--) ENGINE=MyISAM DEFAULT CHARSET=utf8;' in /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/engine/classes/Elgg/Database.php:464 Stack trace:

0 /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/engine/lib/database.php(131): Elgg_Database->runSqlScript('/hermes/bosoraw...')

1 /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/mod/gutwacaptcha/activate.php(12): run_sql_script('/hermes/bosoraw...')

2 /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/engine/classes/ElggPlugin.php(779): include('/hermes/bosoraw...')

3 /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/engine/classes/ElggPlugin.php(671): ElggPlugin->includeFile('activate.php')

4 /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/actions/admin/plugins/activate.php(29): ElggPlugin->activate()

5 /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/engine/classes/Elgg/ActionsService.php(69): include('/hermes/bosoraw...')

6 /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/engine/lib/actions.php(20): Elgg_ActionsService->execute('admin/plugins/a...')

7 [internal function]: _elgg_action_handler(Array, 'action')

8 /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/engine/classes/Elgg/Router.php(79): call_user_func('_elgg_action_ha...', Array, 'action')

9 /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/index.php(22): Elgg_Router->route(Object(Elgg_Http_Request))

10 {main}

[code:protected] => 0 [file:protected] => /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/engine/classes/Elgg/Database.php [line:protected] => 464 [trace:Exception:private] => Array ( [0] => Array ( [file] => /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/engine/lib/database.php [line] => 131 [function] => runSqlScript [class] => Elgg_Database [type] => -> [args] => Array ( [0] => /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/mod/gutwacaptcha/sql/create_captcha_tables.sql )

)

[1] => Array ( [file] => /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/mod/gutwacaptcha/activate.php [line] => 12 [function] => run_sql_script [args] => Array ( [0] => /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/mod/gutwacaptcha/sql/create_captcha_tables.sql )

)

[2] => Array ( [file] => /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/engine/classes/ElggPlugin.php [line] => 779 [args] => Array ( [0] => /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/mod/gutwacaptcha/activate.php )

[function] => include )

[3] => Array ( [file] => /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/engine/classes/ElggPlugin.php [line] => 671 [function] => includeFile [class] => ElggPlugin [type] => -> [args] => Array ( [0] => activate.php )

)

[4] => Array ( [file] => /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/actions/admin/plugins/activate.php [line] => 29 [function] => activate [class] => ElggPlugin [type] => -> [args] => Array ( )

)

[5] => Array ( [file] => /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/engine/classes/Elgg/ActionsService.php [line] => 69 [args] => Array ( [0] => /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/actions/admin/plugins/activate.php )

[function] => include )

[6] => Array ( [file] => /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/engine/lib/actions.php [line] => 20 [function] => execute [class] => Elgg_ActionsService [type] => -> [args] => Array ( [0] => admin/plugins/activate )

)

[7] => Array ( [function] => _elgg_action_handler [args] => Array ( [0] => Array ( [0] => admin [1] => plugins [2] => activate )

[1] => action )

)

[8] => Array ( [file] => /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/engine/classes/Elgg/Router.php [line] => 79 [function] => call_user_func [args] => Array ( [0] => _elgg_action_handler [1] => Array ( [0] => admin [1] => plugins [2] => activate )

[2] => action )

)

[9] => Array ( [file] => /hermes/bosoraweb052/b2873/myd.natrus12/public_html/NS_Three/index.php [line] => 22 [function] => route [class] => Elgg_Router [type] => -> [args] => Array ( [0] => Elgg_Http_Request Object ( [query] => Elgg_Http_ParameterBag Object ( [parameters:protected] => Array ( [__elgg_uri] => action/admin/plugins/activate [plugin_guids] => Array ( [0] => 94 )

[__elgg_ts] => 1428692466 [__elgg_token] => 9ba2be75f4853c65a6c0e2e64b4767a4 )

)

[request] => Elgg_Http_ParameterBag Object ( [parameters:protected] => Array ( )

)

[cookies] => Elgg_Http_ParameterBag Object ( [parameters:protected] => Array ( [phpbb3_r1my2_u] => 1 [phpbb3_r1my2_k] => [phpbb3_r1my2_sid] => 81fecf4d60c78cfb70fb136295039235 [Elgg] => 0bb933a89f7477b6c0c24a4ce40ed497 )

)

[files] => Elgg_Http_ParameterBag Object ( [parameters:protected] => Array ( )

)

[server] => Elgg_Http_ParameterBag Object ( [parameters:protected] => Array ( [PATH] => /usr/local/bin:/usr/bin:/bin [SCRIPT_NAME] => /NS_Three/index.php [REQUEST_METHOD] => GET [HTTPACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,/_;q=0.8 [SCRIPT_FILENAME] => /home/users/web/b2873/myd.natrus12/public_html/NS_Three/index.php [SERVER_SOFTWARE] => Apache/2 [QUERY_STRING] => elgg_uri=action/admin/plugins/activate&plugin_guids%5B0%5D=94&elgg_ts=1428692466&elgg_token=9ba2be75f4853c65a6c0e2e64b4767a4 [REMOTE_PORT] => 58876 [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.118 Safari/537.36 [REDIRECT_QUERY_STRING] => elgg_uri=action/admin/plugins/activate&plugin_guids%5B0%5D=94&elgg_ts=1428692466&__elgg_token=9ba2be75f4853c65a6c0e2e64b4767a4 [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.8 [GATEWAY_INTERFACE] => CGI/1.1 [SCRIPT_URL] => /NS_Three/action/admin/plugins/activate [DOCUMENT_ROOT] => /home/users/web/b2873/myd.natrus12/public_html [UNIQUE_ID] => VSgd-QoUcLAAAE@7rvsAAAAO [SERVER_NAME] => omnibusnews.org [HTTP_REFERER] => http://omnibusnews.org/NS_Three/admin/plugins [SERVER_ADMIN] => cgiadmin@yourhostingaccount.com [HTTP_ACCEPT_ENCODING] => gzip, deflate, sdch [SCRIPT_URI] => http://omnibusnews.org/NS_Three/action/admin/plugins/activate [REDIRECT_URL] => /NS_Three/action/admin/plugins/activate [SERVER_PORT] => 80 [REDIRECT_STATUS] => 200 [HTTP_COOKIE] => phpbb3_r1my2_u=1; phpbb3_r1my2_k=; phpbb3_r1my2_sid=81fecf4d60c78cfb70fb136295039235; Elgg=0bb933a89f7477b6c0c24a4ce40ed497 [REMOTE_ADDR] => 172.56.36.211 [SERVER_PROTOCOL] => HTTP/1.1 [REQUEST_URI] => /NS_Three/action/admin/plugins/activate?plugin_guids%5B0%5D=94&elgg_ts=1428692466&elgg_token=9ba2be75f4853c65a6c0e2e64b4767a4 [HTTP_X_VARNISH] => 2095638970 [HTTP_HOST] => omnibusnews.org [TZ] => EST5EDT [PHP_SELF] => /NS_Three/index.php [REQUEST_TIME] => 1428692477 [argv] => Array ( [0] => elgg_uri=action/admin/plugins/activate&plugin_guids%5B0%5D=94&elgg_ts=1428692466&elgg_token=9ba2be75f4853c65a6c0e2e64b4767a4 )

[argc] => 1 )

)

[headers] => Elgg_HttpParameterBag Object ( [parameters:protected] => Array ( [Accept] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,/_;q=0.8 [User-Agent] => Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.118 Safari/537.36 [Accept-Language] => en-US,en;q=0.8 [Referer] => http://omnibusnews.org/NS_Three/admin/plugins [Accept-Encoding] => gzip, deflate, sdch [Cookie] => phpbb3_r1my2_u=1; phpbb3_r1my2_k=; phpbb3_r1my2_sid=81fecf4d60c78cfb70fb136295039235; Elgg=0bb933a89f7477b6c0c24a4ce40ed497 [X-Varnish] => 2095638970 [Host] => omnibusnews.org )

)

[baseUrl:protected] => [requestUri:protected] => /NS_Three/action/admin/plugins/activate?plugin_guids%5B0%5D=94&__elgg_ts=1428692466&__elgg_token=9ba2be75f4853c65a6c0e2e64b4767a4 [pathInfo:protected] => )

)

)

)

[previous:Exception:private] => )

TomOndiba commented 7 years ago

Thanks for reporting, this error is due to ENGINE=MyISAM DEFAULT CHARSET=latin1; the right engine mysql engine should be ENGINE=MyISAM DEFAULT CHARSET=utf8

I have fixed it and the changes will be in the next latest release for elgg 2.3 versions.