October 12, 2015 at 6:46 PM #34842
I just updated my staging environment on WP Engine hosting and I’m getting the following Warning messages:
Warning: mysql_real_escape_string(): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (13) in /nas/wp/www/staging/tileroofing/wp-content/themes/canvas/functions/admin-interface.php on line 111
Warning: mysql_real_escape_string(): A link to the server could not be established in /nas/wp/www/staging/tileroofing/wp-content/themes/canvas/functions/admin-interface.php on line 111
The plugin seems to be working OK, but the messages are annoying. I won’t upgrade my production site until I know what they mean and how to fix the issue.
My staging site: http://tileroofing.staging.wpengine.com/find-contractor/
WordPress 4.3.1, Canvas Child Theme, Canvas 5.5.7
Store Locator Plus & Add-ons
I’ve uploaded a picture of the warning. I had to copy and paste it to see the full text. I appreciate any advice on how to fix it.
Attachments:You must be logged in to view attached files.October 14, 2015 at 3:12 PM #34900
Just by reading the warning message, it appears to be from your theme, that is not from Store Locator Plus. Review the below link, scroll down the page for different Debugging tips and tools.October 14, 2015 at 5:53 PM #34927October 14, 2015 at 6:12 PM #34929
Thanks for the links. I should have noted that the warning messages only show up on the SLP4 pages in the WP dashboard, so I’m thinking it has something to do with SLP?October 15, 2015 at 3:52 PM #34968
A common assumption but that is not necessarily true. Those messages are specific to canvas . my SQL and WP.
Read some of Lances posts about the MySql issues , also check the jquery version of canvas. Can you use the debugger or Inspect element and see what jquery version Canvas is using, I would contact them if you continue to see the issue. SLP uses the latest jquery versions as advised by Wp best practices.
See the forum post here jquery and themes
(Basically it says) Some plug-ins, sites, or themes, were using older JQuery versions and call backs were forcing jQuery to run old outdated versions which then prevented and caused loss of functionality when updating to the newer SLP version releases updated. Store Locator Plus uses jQuery to process data and is heavily dependent on this core feature in WordPress and SLP. The correct fix should be done by requesting the authors of those plug-ins using the outdated versions to change their code.
You must be logged in to reply to this topic.