Error page creating new certificate

cients
Forums
Dear Manager, Greetings from Portugal! Would like to kindly request your help. I have a learning platform already implemented, however am not able to create certificates. As Admin I choose Structure-->certificate-->definition-->create new certificate (http://localhost/elearning/admin/structure/certificates) and when I click "Create New Certificate" (http://localhost/elearning/node/add/certificate?destination=admin/struct...) gives me an error "Internal servor error 500" (page is not loaded). The funny thing is that if I choose "List" the system provides two samples, one for Class and the other for Course. If I click on the PDF link, both work and give me the Chuck Norris logo. Can you please help so that I am able to provide new certificates models and repair the error? Thank you very very much! Luís Nunes
Profile picture for user James Aparicio
James Aparicio

Hi cients

Hi cients Can you please check the error on your apache logs? And inside opigno -> reports recent log messages after you receive the error. Best regards
cients

I'll do that.

Sorry but I had an access problem in Opigno platform and thought you didn't receive my post related to this subject. Immediatelly am trying to check Apache error file. Best regards
cients

Error page and Apache file

The page that Opigno is launching from "New Certificate" option: http://localhost/elearning/node/add/certificate?destination=admin/structure/certificates Error file from Apache: [Tue Jun 10 16:26:39.662355 2014] [ssl:warn] [pid 3688:tid 252] AH01909: RSA certificate configured for www.example.com:443 does NOT include an ID which matches the server name [Tue Jun 10 16:26:39.821364 2014] [core:warn] [pid 3688:tid 252] AH00098: pid file C:/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run? [Tue Jun 10 16:26:39.831364 2014] [ssl:warn] [pid 3688:tid 252] AH01909: RSA certificate configured for www.example.com:443 does NOT include an ID which matches the server name [Tue Jun 10 16:26:40.971430 2014] [mpm_winnt:notice] [pid 3688:tid 252] AH00455: Apache/2.4.7 (Win32) OpenSSL/1.0.1e PHP/5.5.6 configured -- resuming normal operations [Tue Jun 10 16:26:40.972430 2014] [mpm_winnt:notice] [pid 3688:tid 252] AH00456: Apache Lounge VC11 Server built: Nov 21 2013 20:13:01 [Tue Jun 10 16:26:40.972430 2014] [core:notice] [pid 3688:tid 252] AH00094: Command line: 'c:\\xampp\\apache\\bin\\httpd.exe -d C:/xampp/apache' [Tue Jun 10 16:26:40.976430 2014] [mpm_winnt:notice] [pid 3688:tid 252] AH00418: Parent: Created child process 5104 [Tue Jun 10 16:26:42.098494 2014] [ssl:warn] [pid 5104:tid 264] AH01909: RSA certificate configured for www.example.com:443 does NOT include an ID which matches the server name [Tue Jun 10 16:26:42.197500 2014] [ssl:warn] [pid 5104:tid 264] AH01909: RSA certificate configured for www.example.com:443 does NOT include an ID which matches the server name [Tue Jun 10 16:26:42.244502 2014] [mpm_winnt:notice] [pid 5104:tid 264] AH00354: Child: Starting 150 worker threads.
Profile picture for user James Aparicio
James Aparicio

Hi again cients.

Hi again cients. Please post what you have inside opigno -> reports recent log messages after you receive the error. Best regards
cients

Is this the information?

Additional uncaught exception thrown while handling exception. Original PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {system} WHERE type = 'theme' OR (type = 'module' AND status = 1) ORDER BY weight ASC, name ASC; Array ( ) in system_list() (line 165 of C:\xampp\htdocs\elearning\includes\module.inc). Additional PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT s.lid, t.translation, s.version FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid AND t.language = :language WHERE s.source = :source AND s.context = :context AND s.textgroup = 'default'; Array ( [:language] => pt-pt [:source] => The website encountered an unexpected error. Please try again later. [:context] => ) in locale() (line 720 of C:\xampp\htdocs\elearning\modules\locale\locale.module). Uncaught exception thrown in session handler. PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ); Array ( [:db_condition_placeholder_0] => YCKspwENh_QGV310piy9RazWaLwqLOb9dhJ66sto3iw [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 209 of C:\xampp\htdocs\elearning\includes\session.inc).
cients

Or this one?

Detalhes Tipo php Data 06/10/2014 - 16:33 Utilizador Anónimo (não verificado) Localização http://localhost/elearning/ Referência Mensagem Deprecated function: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead em phpmailer_parse_address() (linha 132 de C:\xampp\htdocs\elearning\sites\all\modules\phpmailer\phpmailer.module). Severidade debug Nome do servidor 127.0.0.1 Operações
cients

I have also this one...

Detalhes Tipo cron Data 06/10/2014 - 22:55 Utilizador Anónimo (não verificado) Localização http://localhost/elearning/ Referência Mensagem Execução finalizada do cron. Severidade observação Nome do servidor 127.0.0.1 Operações
cients

And a status report

Relatório de estado Informações Drupal 7.26 Informações Perfil de instalação Opigno LMS (opigno_lms-7.x-1.6) OK A biblioteca GD roda e dessatura efeitos bundled (2.1.0 compatible) OK Aceder ao update.php Protegido OK Actualizar notificações Ativado OK Actualizações à base de dados Atualizado OK Bibioteca Unicode Extensão PHP Mbstring OK CTools CSS Cache Existe OK Date API System date settings The timezone has been set to Europe/London. The medium date format type has been set to to Tue, 10/06/2014 - 23:21. You may find it helpful to add new format types like Date, Time, Month, or Year, with appropriate formats, at Date and time settings. Aviso Estado da atualização de temas e módulos Desactualizado Existem actualizações disponíveis para um ou mais dos seus módulos ou temas. Para assegurar um funcionamento correcto do seu site, deve efectuar as actualizações assim que possível. Veja a página de actualizações disponíveis para mais informações e para instalar as actualizações que faltam. Aviso Estado da atualização do núcleo do Drupal Não foram encontradas versões disponíveis Houve um problema ao verificar actualizações disponíveis para o Drupal. Veja a página de actualizações disponíveis para mais informações e para instalar as actualizações que faltam. OK Extensões PHP Ativado OK Ficheiro de configuração Protegido OK Limite de memória do PHP 450M OK PHP 5.5.6 (mais informação) OK PHPMailer library 5.2.5 OK Permissões de acesso ao nó 37 permissões em utilização Se o site estiver com problemas em relação a permissões sobre o conteúdo, pode necessitar de reconstruir a cache de permissões. A reconstrução irá remover todos os privilégios sobre o conteúdo e substituí-los com as permissões baseadas na configuração e módulos actuais. A reconstrução pode demorar algum tempo se houver bastante conteúdo ou um sistema de permissões complexo. Depois da reconstrução estar completa, o conteúdo usará automaticamente as novas permissões. Reconstruir permissões Informações Progresso do carregamento Inativo O seu servidor é capaz de mostrar o progresso de carregamento de ficheiros mas não tem as bibliotecas necessárias instaladas. É recomendado que instale o PECL uploadprogress library (preferencialmente) ou o APC. OK Servidor web Apache/2.4.7 (Win32) OpenSSL/1.0.1e PHP/5.5.6 OK Sistema de base de dados MySQL, MariaDB, or equivalent OK Sistema de ficheiros Possível escrever (método de descarga público) OK Suporte para PNG da biblioteca GD bundled (2.1.0 compatible) OK Tarefas de manutenção do cron Executado pela última vez há 28 minutos Poderá executar o cron manualmente. Para executar o cron a partir de fora do site, vá a http://localhost/elearning/cron.php?cron_key=KQ-7zMZC8G9QaQfAYdz1T8tVbcjxs-CgYIVMGKCBIgY OK Variáveis globais de registo do PHP (register globals) Desativado OK Versão do sistema de Base de dados 5.6.14 Erro Video transcoder: FFmpeg / avconv Missing the transcoder library. Please install FFmpeg in to your server if you intend to transcode or to auto create thumbnails. Erro Video.js Não encontrado Missing the Video.js library. Please download Video.js and extract it into the sites/all/libraries/video-js directory.
cients

This one?

Detalhes Tipo php Data 06/10/2014 - 16:33 Utilizador Anónimo (não verificado) Localização http://localhost/elearning/ Referência Mensagem Deprecated function: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead em phpmailer_parse_address() (linha 132 de C:\xampp\htdocs\elearning\sites\all\modules\phpmailer\phpmailer.module). Severidade debug Nome do servidor 127.0.0.1 Operações Thank you very much!!!
cients

I think is this one!!!

Detalhes Tipo acesso negado Data 06/10/2014 - 23:33 Utilizador Anónimo (não verificado) Localização http://localhost/elearning/dashboard?destination=dashboard Referência http://localhost/elearning/ Mensagem dashboard Severidade aviso Nome do servidor 127.0.0.1 Operações
Profile picture for user James Aparicio
James Aparicio

Hi cients,

Hi cients, I dont see any fatal error there. Only that your database stopped responding. Are there any other in the recent log messages near -> PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {system} WHERE type = 'theme' OR (type = 'module' AND status = 1) ORDER BY weight ASC, name ASC; Array ( ) in system_list() (line 165 of C:\xampp\htdocs\elearning\includes\module.inc). Additional PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT s.lid, t.translation, s.version FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid AND t.language = :language WHERE s.source = :source AND s.context = :context AND s.textgroup = 'default'; Array ( [:language] => pt-pt [:source] => The website encountered an unexpected error. Please try again later. [:context] => ) in locale() (line 720 of C:\xampp\htdocs\elearning\modules\locale\locale.module). Uncaught exception thrown in session handler. PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ); Array ( [:db_condition_placeholder_0] => YCKspwENh_QGV310piy9RazWaLwqLOb9dhJ66sto3iw [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 209 of C:\xampp\htdocs\elearning\includes\session.inc). ? Best regards
cients

Is giving me this error on a separate page

Additional uncaught exception thrown while handling exception. Original PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {system} WHERE type = 'theme' OR (type = 'module' AND status = 1) ORDER BY weight ASC, name ASC; Array ( ) in system_list() (line 165 of C:\xampp\htdocs\elearning\includes\module.inc). Additional PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT s.lid, t.translation, s.version FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid AND t.language = :language WHERE s.source = :source AND s.context = :context AND s.textgroup = 'default'; Array ( [:language] => pt-pt [:source] => The website encountered an unexpected error. Please try again later. [:context] => ) in locale() (line 720 of C:\xampp\htdocs\elearning\modules\locale\locale.module). Uncaught exception thrown in session handler. PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ); Array ( [:db_condition_placeholder_0] => Qs9eoKA70cCo5lVPzPA63rnZ8-6T9TO7MbovfSj-hTU [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 209 of C:\xampp\htdocs\elearning\includes\session.inc).
cients

Command in line 165 of module.inc

The above mentioned command in line 165 of C:\xampp\htdocs\elearning\includes\module.inc is this one: $result = db_query("SELECT * FROM {system} WHERE type = 'theme' OR (type = 'module' AND status = 1) ORDER BY weight ASC, name ASC");
cients

If I select Edit Certificate gives the same error

When I try to Edit the certificates that are in Opigno by default (Class and Course) it gives the same error page: Additional uncaught exception thrown while handling exception. Original PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {system} WHERE type = 'theme' OR (type = 'module' AND status = 1) ORDER BY weight ASC, name ASC; Array ( ) in system_list() (line 165 of C:\xampp\htdocs\elearning\includes\module.inc). Additional PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT s.lid, t.translation, s.version FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid AND t.language = :language WHERE s.source = :source AND s.context = :context AND s.textgroup = 'default'; Array ( [:language] => pt-pt [:source] => The website encountered an unexpected error. Please try again later. [:context] => ) in locale() (line 720 of C:\xampp\htdocs\elearning\modules\locale\locale.module). Uncaught exception thrown in session handler. PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ); Array ( [:db_condition_placeholder_0] => Qs9eoKA70cCo5lVPzPA63rnZ8-6T9TO7MbovfSj-hTU [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 209 of C:\xampp\htdocs\elearning\includes\session.inc).
Profile picture for user James Aparicio
James Aparicio

Hi cients,

Hi cients, This is very strange. This error just says that your database stopped responding, and the module is a drupal core module. Have you tried restarting mysql? If that does not work take a look at https://drupal.org/node/259580 Best regards
WiSolv

Some Help

Hi, We just had the same problem when we click "Create New Certificate" we had the "Internal servor error 500" message. We finally find the solution, it's quite easy to solve: Open the configuration file of your MySQL server (my.cnf) then add the line : max_allowed_packet=500M Hope this helps! Best regards.