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 ?

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.