Hanna Code Mysql error?

[kasperwf]

Hi all!

I've just deployed my site - which worked perfectly (AWESOMELY I might add) on localhost, and everything seems to work just fine.

However, on the live domain (www.sejero-festival.dk) when I go to Setup -> Hanna Code, I get the following error(s):

Warning: mysqli::set_charset(): Couldn't fetch Database in /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/Database.php on line 71 Warning: Database::query(): Couldn't fetch Database in /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/Database.php on line 114

 TemplateFile: SELECT id, name, type, modified, accessed, code FROM hanna_code ORDER BY name<pre>#0 [internal function]: Database->query('SELECT id, name...') #1 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/DatabaseMysqli.php(35): call_user_func_array(Array, Array) #2 /customers/9/8/c/sejero-festival.dk/httpd.www/site/modules/TextformatterHannaCode/ProcessHannaCode.module(97): DatabaseMysqli->__call('query', Array) #3 /customers/9/8/c/sejero-festival.dk/httpd.www/site/modules/TextformatterHannaCode/ProcessHannaCode.module(97): DatabaseMysqli->query('SELECT id, name...') #4 [internal function]: ProcessHannaCode->___execute() #5 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/Wire.php(359): call_user_func_array(Array, Array) #6 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/Wire.php(317): Wire->runHooks('execute', Array) #7 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/ProcessController.php(196): Wire->__call('execute', Array) #8 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/ProcessController.php(196): ProcessHannaCode->execute() #9 [internal function]: ProcessController->___execute() #10 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/Wire.php(359): call_user_func_array(Array, Array) #11 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/Wire.php(317): Wire->runHooks('execute', Array) #12 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/admin.php(64): Wire->__call('execute', Array) #13 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/admin.php(64): ProcessController->execute() #14 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/modules/AdminTheme/AdminThemeDefault/controller.php(13): require('/customers/9/8/...') #15 /customers/9/8/c/sejero-festival.dk/httpd.www/site/templates/admin.php(15): require('/customers/9/8/...') #16 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/TemplateFile.php(140): require('/customers/9/8/...') #17 [internal function]: TemplateFile->___render() #18 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/Wire.php(359): call_user_func_array(Array, Array) #19 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/Wire.php(317): Wire->runHooks('render', Array) #20 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/modules/PageRender.module(337): Wire->__call('render', Array) #21 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/modules/PageRender.module(337): TemplateFile->render() #22 [internal function]: PageRender->___renderPage(Object(HookEvent)) #23 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/Wire.php(359): call_user_func_array(Array, Array) #24 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/Wire.php(317): Wire->runHooks('renderPage', Array) #25 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/Wire.php(381): Wire->__call('renderPage', Array) #26 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/Wire.php(381): PageRender->renderPage(Object(HookEvent)) #27 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/Wire.php(317): Wire->runHooks('render', Array) #28 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/modules/Process/ProcessPageView.module(152): Wire->__call('render', Array) #29 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/modules/Process/ProcessPageView.module(152): Page->render() #30 [internal function]: ProcessPageView->___execute() #31 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/Wire.php(359): call_user_func_array(Array, Array) #32 /customers/9/8/c/sejero-festival.dk/httpd.www/wire/core/Wire.php(317): Wire->runHooks('execute', Array) #33 /customers/9/8/c/sejero-festival.dk/httpd.www/index.php(194): Wire->__call('execute', Array) #34 /customers/9/8/c/sejero-festival.dk/httpd.www/index.php(194): ProcessPageView->execute() #35 {main}</pre>

Does anyone knows what could be causing this and how I might fix it?

I've tried to uninstall Hanna Code and delete the module folder from the server, and then reinstall it through the admin interface, but with same results, so I'm thinking the MySQL server on the host is different somehow from the one on my computer. :-/

[WillyC]

what.mysequel versions and pw versions u.have ? 

[kasperwf]

Hi Willy

PW is 2.4

MySQL is:

MySQL version = 5.5.37-MariaDB-1~wheezy

MySQL driver version: mysqlnd 5.0.8-dev - 20102224 - $Id: 731e5b87ba42146a687c29995d2dfd8b4e40b325 $

max_user_connections = 24

max_allowed_packet = 16 MB

[kasperwf]

Hmm.. in the PhpMyAdmin panel it says:

Database server

• Server: 10.246.16.42 via TCP/IP
• Software: MySQL
• Software version: 5.1.73-1 - (Debian)
• Protocol version: 10
• User: xxxxx@xxxxx
• Server charset: UTF-8 Unicode (utf8)

Any clues??