Forums

Cannot empty trash (Unknown MySQL server host)

Permalink
I need to empty my trash to get rid of old page types. However, when I choose either to empty the whole trash can or individual pages from the trash can, I get the 500 error on the sitemap_delete_forever action:

SQLSTATE[HY000] [2005] Unknown MySQL server host 'localhost:9001' (2)

I guess the problem is that my MySQL server is on a different port than the default 3306? This seems weird, though, since the rest of the system works fine.

Any solution?
plindelauf
 
plindelauf replied on at Permalink Reply
plindelauf
I found that the problem is indeed the non-default port. When using port 3306 all works fine. I reported this as a bug:http://www.concrete5.org/index.php?cID=585716...
crisuwork replied on at Permalink Reply
crisuwork
It seems that the error came from pdo_mysql connection type used in /concrete/core/librariers/queue.php on line 8

If you override the "pdo_mysql" with ",mysql", than works and has nothing to do with mysql Port :/

Standard code C 5.6.3
$type = 'pdo_mysql';
if (!extension_loaded('pdo_mysql')) {
   $type = 'mysql';
}


Update with: 
$type = 'mysql';
if (!extension_loaded('pdo_mysql')) {
   $type = 'mysql';
}
kumapanda replied on at Permalink Reply
There is same problem with 5.7, could you tell me where this setting is for concrete5.7 ?