About Joyce Cimbalista

This author has not yet filled in any details.
So far Joyce Cimbalista has created 33 entries.

Troubleshooting Reasons for an Unusually Large WordPress Database

My client informed me that when she viewed her website, it was displaying the “Error Establishing Database Connection” message.

When I went to wp-admin, it was displaying another similar message about the database. I logged into the Control Panel and was able to view the database in PHPMYADMIN. I checked to make sure the database name, username, and password matched. Called GoDaddy and found out that the database was over the limit allowed by the hosting plan and so the database user was disabled. We had one week to resolve the issue either by reducing the size of the large WordPress database or moving to a hosting plan that had unlimited database space.

I  browsed the database using PHPMyAdmin, and eventually found that there were over 1 million records in wp_posts! Next, I asked the client to move to a higher level hosting plan and got the site back online. There were only about 1,000 actual posts when viewing Posts from the Dashboard. I continued to browse wp_posts and finally something caught my eye. There were lots of posts of Post-type Http, and a field contained ‘core_control_http_log_item’. I Googled the character string and came up with one match! Googled translated the page from French and I found the answer. It was the Core Control plugin, which had been active for several months and had been logging activity in the database. I had been using it to debug Paypal connection problems and had not disabled it.

Next, I had to remove all posts of post-type http. I used the query:

DELETE a,b,c FROM wp_posts a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_type = ‘http’.

I hope this may help someone else who discovers that they have a large WordPress database that shouldn’t be so excessive in size and need to find the reason why.

How to Troubleshoot Contact Form 7 Configuration Error

Process of Elimination for Contact Form 7 Configuration Error

I use the Contact Form 7 plugin on almost all of the WordPress sites I create. Recently, I was creating a very long form, saving frequently, and then noticed there was a configuration error: “Multiple form controls are in a single label element. ”

I looked through the code and nothing jumped out at me that could have been wrong.

So I thought, how am I going to find the error? There were almost 50 input fields!

Answer: Process of elimination

I opened up Notepad, copied the entire form, and pasted it into Notepad.

Next I went back to the form, and deleted all but the top several fields. Saved it. No error.

This told me that the error was somewhere in the remaining part of the form.

I copied the next few fields from Notepad and pasted it at the bottom of the form.

Saved again. The error showed up! So now I knew the error was in the fields I had just pasted.

So, I used this process to isolate the part of the form with the error. It saved a lot of time that I would have spent going over the code repeatedly, looking for some problem.

I hope this tip will save you time. It can be applied in situations other than just html forms, too.

Turned out the error was a misplacement of the closing ‘label’ tag.

Embedding Javascript HubSpot Contact form into DNN page

I found that just pasting the HubSpot javascript code into the DotNetNuke HTML module wouldn’t work – the editor just erases the javascript.

After Googling around for an hour or two, I found this article, How to Integrate HubSpot Forms with LeadPages, by Mike Hollis, on DoInbound.com’s blog. He created a ‘quick little script’ that converts the HubSpot Javascript to HTML. I plugged in the Portal ID and Form ID, copied the resulting HTML, pasted it into the HTML module, and it worked!

Thanks Mike!

Troubleshooting Outlook Express Errors 0x800CCC0D and 0x008CCC0E

Every once in a while, Outlook has an error such as “Can’t find host – cannot Locate Server” or “Failed to Connect – Cannot Connect to Server”, error codes 0x800CCC0D and 0x008CCC0E. I found the notes below and thought posting it would be a great way to store the info in case I need it in the future.

I found this very helpful link for troubleshooting those errors and other Outlook errors such as Client Response Invalid.

Some other tips:

  • If outgoing port 25 is being blocked, try setting the port to 587.
  • To clear cache and flush DNS, go to DOS command prompt and enter ‘ipconfig/flushdns’
  • Try Control Panel > Network Connections > Local Area Connections. Right-click and choose Repair

Starting Outlook in SafeMode – Tools > Options > Other > Advanced – Add-in manager, clear checkboxes; restart Outlook

 

By |April 30th, 2017|DNS, email, outlook, WordPress|Comments Off on Troubleshooting Outlook Express Errors 0x800CCC0D and 0x008CCC0E

Getting the URL for Google+ Reviews for Your Business

I like to give my clients the link to the Reviews page of their Google+ profile so they can easily give it to clients to write those valuable Google reviews. Sometimes I will create a page on their website with links to their business listings so they can give clients the link to the page and then the client can post their review in one or more places.

On your phone, go to Google.com and search for the business name as it appears in their Google+ listing.

When the Google+ listing appears, touch the blue circle to display more of the listing. Scroll down to Rate and Review section, tap the 5th star and then copy the url. Paste it into an email and send it to yourself.

That’s it!

Site Not Found After Installing WordPress in Subdomain

I installed WordPress in a subdomain so I could develop a new site, however, when visiting the new URL, I got a site not found error. Called tech support, and found out that the main domain’s DNS was the cause. For this particular domain, the email is hosted elsewhere. All I had to do was add an “A” record to the domain’s DNS with a value equal to the name of the subdomain, in this case “preview” and with the IP address of the domain.

Nice Tool for Website Responsiveness

On occasion, I will be working on a WordPress website using a responsive template, but have a need for a three-column page. Rather than use a table, I use a tool called the Responsive Grid System. As it says on the website, it’s not a framework or a boilerplate, and it works on anywhere from a two to a twelve column layout. It’s got examples of HTML and CSS code that plugs right in to your existing code. Check it out!

Not Receiving Emails from a WordPress Contact Form

This happens frequently – you install Contact Form 7 or Fast Secure Contact Form plugin on your WordPress site and emails sent through it just never arrive in the Inbox. Sometimes this can be due to the settings in the form, such as

Sometimes it can be due to an incorrect setting on the host. The cPanel MX Entry is set to Local Mail Exchanger by default but should be set to Remote Mail Exchanger. This means that if a form in your website uses email@yourdomain.com and it’s the same as your website, the web server will attempt to handle the email itself (because it also hosts your site). To solve the problem, change the setting in cPanel to Remote Mail Exchanger which will tell the server to use the MX records to route the email. This problem can occur with any host that uses cPanel including GoDaddy, HostGator, etc. In GoDaddy, this setting can be found under Hosting > Manage > Email > MX Entry. You may also need to add an MX record with priority 10 and remove, if any, an MX record with priority 0.

Finding Previous DNS Settings for a Domain

So the other day I was setting up forwarding for some domains and accidentally forwarded one that I didn’t want forwarded. When I unset the forwarding, the domain reverted back to the default settings and not the settings that it was previously set to. I recall once in the past when this happened, and GoDaddy tech support had said they keep no records of previous DNS settings for domains. Knowing that Google stores cached pages, I wondered if there was anything similar for DNS settings. I searched, and sure enough, there were a couple sites that keep previous DNS settings for domains. All you have to do is type in the domain name, and it comes up with results.

Here are two that I used: http://dnshistory.org/ and http://whoisrequest.org/history/

How to Make a Slideshow Video for YouTube

Start Windows MovieMaker.

Click ‘Add Videos and Photos’

Re-arrange photos, add music, add transitions, etc.

Click Save Movie – for High Definition Display.

Go to YouTube and upload movie.