Problems on my MAMP server on windows...

User 2660596 Photo


Registered User
15 posts

Hello,
I've just made my first form and while it works on my host providers server, it doesn't on my local MAMP for windows setup. After trying really hard to sort this, I have to throw my hands up.... best I can figure is it's something to do with pdo_mysql.default_socket path but I'm not sure how to fix it.

I run a php file on my mamp server with:

<?php
print_r(get_loaded_extensions());
?>

Which outputs:

Array ( [0] => Core [1] => bcmath [2] => calendar [3] => com_dotnet [4] => ctype [5] => date [6] => ereg [7] => filter [8] => hash [9] => iconv [10] => json [11] => mcrypt [12] => SPL [13] => odbc [14] => pcre [15] => Reflection [16] => session [17] => sockets [18] => standard [19] => mysqlnd [20] => tidy [21] => tokenizer [22] => zip [23] => zlib [24] => libxml [25] => dom [26] => PDO [27] => pdo_mysql [28] => bz2 [29] => SimpleXML [30] => soap [31] => wddx [32] => xml [33] => xmlreader [34] => xmlwriter [35] => apache2handler [36] => openssl [37] => fileinfo [38] => gd [39] => mbstring [40] => exif [41] => mysql [42] => mysqli [43] => pdo_sqlite [44] => sqlite3 [45] => curl [46] => Phar [47] => imagick )

Comparing phpinfo() on my remote host and my mamp, I see this difference under pdo_mysql:

pdo_mysql.default_socket /var/tmp/mysql.sock /var/tmp/mysql.sock (on my host provider and missing from mamp)

Any help with this would be greatly appreciated.

Regards.


pdo_mysql.default_socket
User 187934 Photo


Senior Advisor
20,271 posts

Are you using the iframe script as provided by the form builder? If so remove the script wrapping it and see if that fixes the issue.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2660596 Photo


Registered User
15 posts

Hey Eric,

Thank you for that!

I have removed the following and the basic iframe works.

<script type="text/javascript">document.write(unescape("%3Ciframe id=\"fb_iframe\" src=\"Inquiry_form_coffeecup.php" + window.location.search + "\" width=\"100%\" height=\"763\"allowtransparency=\"true\" scrolling=\"no\" frameborder=\"0\"%3E&lt;a href=\"Inquiry_form_coffeecup.php\" title=\"Inquiry_form_coffeecup\"&gt;Check out my CoffeeCup Form&lt;/a&gt;%3C/iframe%3E"));</script>
<noscript>
</noscript>

Just to help me understand better, what is going on that the script wrapper won't work?
User 2660596 Photo


Registered User
15 posts

Oh and is having the basic iframe sufficient? Just would like to get why both options are added and the script as 1st option?
User 2660596 Photo


Registered User
15 posts

Actually no the form shows now on mamp and host provider but it won't store to database. I've double checked the login details and they are correct.
User 2660596 Photo


Registered User
15 posts

Sorry for all these posts! I just tried again with a user with max permissions and it worked. What are the minimum permission required for the mysql user?
User 187934 Photo


Senior Advisor
20,271 posts

The permissions thing was next. Glad you got it working.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.