salescart
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: Restore WP mySQL database from files – Windows serverOk, it doesn’t look like I am 100% there yet. The database is restored but WordPress is giving the error:
Error establishing a database connectionThe issue is I have the “vanilla” /mysql database. When I look at the tables_priv in /mysql it is empty. I’m guessing somehow I need to get the privileges for this WordPress database into /mysql right?
Forum: Fixing WordPress
In reply to: Restore WP mySQL database from files – Windows serverOk, I got it!!
The procedure is.- Install vanilla mySQL on new server (I had already done that)
- Stop mySQL service
- Move the /data/wordpress953 folder over “intact” “as is”.
- and move ONLY the ibdata1 file and ib_logfiles off of the root over.
- Leave the /mysql data “as is” from the vanilla install
- Start mySQL service
It was basically an “incarnation” of what I was doing but you have to only change certain things. The ibdata1 file in the root went with the /wordpress953 folder but apparently not with anything else.
Forum: Fixing WordPress
In reply to: Restore WP mySQL database from files – Windows serverI tried again to reset the password for mySQL but it fails. Here is an image of what I see:
I don’t understand why I can’t reset the mysql password???
Forum: Fixing WordPress
In reply to: Restore WP mySQL database from files – Windows serverThis is NOT a system crash! The hard drive was operating at half speed we believe for some reason so we just moved to a new drive. It was taking 45 mins to reboot and an hour to log in with RDP.
I have ALL the data on the old drive. It is “as if” the mySQL went down for a reboot. No data has changed in the WordPress953 files since 2/22/18 and in the mysql files since 5/31/18 the day before we even had issues. That is the day I changed the root password. It doesn’t make sense to me why I can’t just replace the files and reboot since I have ALL the data. BTW, I have recovered MS SQL and a dozen of other databases like this before no problem and restored 3 MS SQL databases this time as well from just the files.
Attempt 3:
I shut down the mysql server, I put the /mysql and the /wordpress953 folders in the /data folder and the files in the root ibdata1, ib_logfile0, and ib_logfile1 as you indicated. I rebooted the system. I tried to login and I get the same as Attempt 2:
! #1045 Cannot log in to the MySQL serverWhere is the root password saved? In ibdata1? I would have thought this is saved in the /mysql. Isn’t that the master tables?
Forum: Fixing WordPress
In reply to: Restore WP mySQL database from files – Windows server953 -vs- 954 = typo (sorry)
YES, it does. I have ALL of the files including the ibdata1, ibdata0, .frm, etc. files. In both attempt 1 and attempt 2, I am moving the WHOLE /data folder with all files including the ibdata1 file. In fact, there is a .err file created in attempt1 complaining about the isam id problem in the log file.
It’s simply not working.
In attempt 1, I am NOT moving /data/MySQL. I can try that. However, in attempt 2, I am also moving the /data/MySQL!
It is NOT working in either case. Of course, Attempt 2 might be working but I have no way to start MySQL or login to see the database tables. So who knows in that case. I changed the MySQL root password only about 2 weeks ago so I am 100% correct of what it was and I made the new instance with the same root password.
I’ll retry attempt1 moving both the WP MySQL data folder as well as the MySQL data folder ONLY
Forum: Fixing WordPress
In reply to: Site is Down/404 errorYou need to get “file manager” access via a hosting control panel or FTP access using FileZilla and see what files are located in your website directory.
I try to got to plain vanilla files like: http://www.castroyalepodcast.com/license.txt or http://www.castroyalepodcast.com/readme.html and they also don’t show up. These files should be accessible even if there is something severely wrong with your WordPress install.
See this url for basic files you should expect to see in your Root directory with basic FTP access–>
http://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-file-and-directory-structure/lol No that didn’t help at all. I know what chmod is and the equivalency of it in IIS which is a GUI. Keep in mind IIS runs completely different than Apache especially in Windows 2012 where you not only have NTFS file permissions, you also have Application Pool/Application Pool “user” permissions. You also have management pipeline mode/type in the App pool. The App pool is/has it’s own set of permissions.
In Apache, all you have is the “file permissions”.
So it is many times more complex than Unix/Linux/Apache thanks to Microsoft. So what I need is a full break down of permissions.
- The NTFS permissions of IUSR or does IUSR even need NTFS Permissions.
- What the App pool mode should be set to
- The App pool Identity
- Any special permission the App pool identity would need on NTFS in addition to or as it relates to IUSR.
Unfortunately, this is a “migration” backup/restore not a straight install by the widget install which seems to get the permissions right about 60% of the time or all you have to do is open it up a tiny bit for IUSR. So I have a more complicated IIS install problem than normal where I would click on buttons and everything would magically happen. I have to restore from scratch so I actually must “know” what ALL the permissions are to the letter. This has to be documented somewhere by WordPress???
Tara, that is just pushing it off to the hosting provider. We ARE the hosting provider. There is no one to push it off to you.
If you could please direct me to the WordPress documentation of what the IIS (and Windows NTFS) file permissions “should be”, than I can make it so. All the documentation I can find is “UNIX/Linux” centric.
We could certainly can get by with manual installation but I would like to solve the actual problem.
Forum: Reviews
In reply to: [Master Slider - Responsive Touch Slider] TerribleConfusing product naming, distribution/purchase path, and slow support that takes days and days to answer…assuming the person can find it. We eventually got it working after nearly a week. Unfortunately a previous designer used your tool so we were stuck with it or we would have jettisoned it.
Yes, we did post in your support forum….it took us two days to be able to post there because of the steps and hoops you make your customers jump through before they can even make a post. It is VERY confusing which product to buy, how to get support.
We can’t get support there and can’t log-in. It’s a mess. This is just a warning for would be buyers. Avoid this software at all costs. The support is terrible with a 2 day turnaround promised even after you pay. We tried registering but never get any email.
Forum: Plugins
In reply to: [WP-reCAPTCHA] reCaptcha locked me out of my WordPress Web siteWe had to delete the plugin files via FTP, and then reload the plugin. That was the only way around it.
Ok, I give up and reverted back to the previous version. What a mess this version is. Most of what you think are improvements are actually a step in the wrong direction.
And it will probably get as much attention as this thread that you closed. I contacted them and they said unless you got $$$’s, they don’t help you. It appears to be easier to switch to a different plugin.
No, I’m not using any cache plugin and I’ve also disabled all plugins and the problem is not solved in any case. Yes, I have already resaved the permalinks and yes that is where the problem is. Now, I am wordpress on windows and perhaps it was not properly tested in that environment.
This is the what the xml file has for the .xsl xml stylesheet.
‘type=”text/xsl” href=”//www.web-hosters.com/main-sitemap.xsl”?>’
However, the stylesheet is REALLY at //www.web-hosters.com/index.php/main-sitemap.xsl
Its just a plain old bug from my viewpoint. It is not properly taking into account the permalinks and it seems to have somekind of “hardwired” idea of what the permalinks/pathing is. Resetting my permalinks doesn’t fix the problem.
These are my permalinks with the index.php in there.
http://www.web-hosters.com/index.php/sample-post/