(I guess if I wanted to make a really clean roll back, I could get the disk image from last backup of /Applications/MAMP/db/mysql/ee_thisdatabase and roll back to that point.)Īny advice for what to do would be greatly appreciated. However, I have been backing it up through regular backups. I have not been backing up this local MAMP-based database by doing periodic SQL dumps. Query: ALTER TABLE exp_matrix_data ADD col_id_16 TEXTīut this time, the new field did NOT get created.įROM THIS POINT, WHERE DO I TROUBLESHOOT?ĭo I hang out in phpmyadmin/ mySQL and do things like check/repair/analyze/of flush the tables? Complete the process, click Submit.ĭescription: Duplicate column name ‘col_id_16’ Got similar message, but it did get created okay.Ĭ) Now attempting to create third field, a Matrix field. The strange thing, though, is that the field did get added OK, despite the message.ī) Did that again with a new text area field. Query: ALTER TABLE exp_weblog_data ADD COLUMN field_id_43 text NOT NULL So I go about attempting to re-create my work.Īfter filling out the items for a new text field, I click Submit button.ĭescription: Duplicate column name ‘field_id_43’ Restarted, launched MAMP, VirtualHostX, and set about starting again where I left off.Įxcept all the fields I created in today’s session are not there. I shut down as many apps as I could (including MAMP, VirtualHostX) and tried to reboot system (terminal: sudo shutdown -r now), but computer wouldn’t shutdown. Couldn’t force quit Safari, nor another app. Somehow that browser crash was bad enough to bring many things down. Don’t really flinch at this browser crash because they’ve happened before.) Incidentally, this crash happened when I attempted to do file upload inside of image matrix on the publish page. In midst of doing first test publish to 1 of new weblogs (with new field group, etc.), I managed to crash Safari browser (Safari crashes happen often enough due to ridiculous # of windows/tabs I keep open. Today I added some new fieldgroups, some new fields, two new weblogs, one new category group. ![]() I play with it on MAMP, figure stuff out, then duplicate efforts on live site. Install is a sandbox-y version of a site that’s also live. Have EE 1.6.8 running in MAMP environment on MacOS 10.5 computer. If you are having trouble fixing this problem with the instructions above, but are being able to solve this problem with any another method please describe it in the comment section below.I need help figuring out how to troubleshoot the situation I’ve gotten myself into. Now the MAMP should start the MySql server without errors. Launch MAMP and click the Start Servers button.This file will be automatically rebuilt by MAMP on the next launch. This file is a plain text file with a PID in it. Try the following variants:Ģ) /Library/Application Support/appsolute/MAMP/tmp/mysqlĭelete the lock file. Note! The path to this folder may be different on your system. In the Finder, go to the folder Applications -> MAMP -> tmp -> mysql.You do not need to download and install anything, because it is already built into every macOS. I have encountered this problem on many occasions, and in most cases the following solutions work: For example, when your computer was hard powered off, or you force the MAMP app to quit. Most often, the problems listed above occur after an incorrect shutdown of the MAMP app. To find out the exact cause of the problem, you need to look in the MySQL log file located in /Applications/MAMP/logs/ or /Library/Application Support/appsolute/MAMP/logs/. The current user not having permissions to the file.Another mysql service running on the same port. ![]() The most common problems with MySQL server not starting are the following: The reasons for the problems with running MySQL server can be different in different cases. If you use the non-standard version of the app, but the PRO one, then in the following steps, replace “MAMP” with “MAMP PRO”, respectively. I’m using version 4.2.1 of the MAMP app, but in your case there can be any other version of the MAMP app. It describes how to do almost the same thing, but using the Terminal app. For experienced users, I recommend reading another article about this problem. We will use the Finder and the Activity Monitor app to solve the problem. This article is intended for regular users. But sometimes there are problems such as the following error message when I try to start the servers: So far, this is the perfect app for me to have a local server environment. On my macOS devices I use MAMP app by appsolute GmbH for local web development.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |