Jump to content

Archived

This topic is now archived and is closed to further replies.

balfred1345

Database Error Possibly Leading to DMS2 Not Working?

Recommended Posts

balfred1345

HI,

I started having odd behavior on a page I'm developing today:

A TextBox section and column within which the TextBox was held disappeared completely. I was not editing it. I did not inadvertently delete it.

 

I attempted to redo the Text Box, but decided to use a PLNextBox within a column. The column disappears, but an additional PLNextBox appears in its place.

Columns disappear after a save and page refresh.

When I put some placeholder content in the NextBox, saved and refreshed, the NextBox disappeared, and the placeholder content became part of the TextBox above it. Very strange.

 

I disabled all plugins except for the below PL plugins, but still have the problem:

Installed Plugins
dms-dev-tools/dms-dev-tools.php
dms-plugin-pro/dms-plugin-pro.php
pagelines-updater/pagelines-updater.php
pl-nextbox/pl-nextbox.php

 

I quit out of Chrome, when I restarted and went to load the page from Dashboard/Pages I saw this Error message:

Notice: like_escape is deprecated since version 4.0! Use wpdb::esc_like() instead. in /home/videoh6/public_html/cidev2.com/wp-includes/functions.php on line 3201

WordPress database error: [Table 'videoh6_cidev2A.wp_postmeta' doesn't exist]
SELECT post_id from wp_postmeta where meta_key = 'pl-settings' and meta_value LIKE concat( '%', ( SELECT uid FROM wp_pl_data_sections WHERE live LIKE '%%' order by id DESC limit 1 ), '%')

 

 

I'm using WP 4.0, and latest DMS2 (2.1.7)

 

The page URL: http://whub34.webhostinghub.com/~videoh6/cidev2.com/moving-services/mankato-mn-movers/

 

You'll see there should be a NextBox under "Mankato MN Residential Movers" but my placeholder text is now held in the TextBox that should be above the NextBox (but the NextBox disappeared).

 

I look forward to your help, since I can't work on this page until this issue is resolved.

 

Thanks,

Bruce

Share this post


Link to post
Share on other sites
Danny

Hi Bruce,

 

Is this statement you mentioned above correct? "A TextBox section and column within which the TextBox was held disappeared completely." As you can not place a column section inside a TextBox, it is the other way round. Sections can be placed inside a Column section but not vice versa.

 

If you have sections disappearing or removing themselves, the likely cause is either plugins you have installed or your servers configuration. If you only have the plugins installed you mentioned above, then the likely cause is your server.

In regards to your WordPress database error, I have no idea what videoh6_cidev2A is, you will likely need to speak to your web host provider and post this error on the WordPress support forums, as a WordPress database error is just that a WordPress error.

 

From my experience, these issues are generally caused by bad hosting, I did a reverse IP check and found that the server your site is on has over 500 other websites running on the same server. This points to shared hosting which is an extremely poor environment to host a website on. Especially if you do not want to encounter issues or performance problems.

 

https://cloudup.com/cvqBrL00P25

Therefore, I recommend you switch host and use FlyWheel, who specialise in hosting WordPress powered websites. They're that good that we use them to host pagelines.com


Please search our forums, before posting!

Share this post


Link to post
Share on other sites
balfred1345

Thanks for your response. 

I did mean a TextBox within a Column. 

 

I did have only the plugins installed as noted, so I'll have to look into the WordPress database error.

 

I used Reverse IP Domain Check to do a reverse IP check myself. Oddly, none of the websites that I have on whub34 are listed, so I'm not sure that Reverse IP Domain Check is giving accurate results. Nonetheless, I hear what you are saying about hosts, and will check out FlyWheel.

 

Thanks,

Bruce

 

 

Share this post


Link to post
Share on other sites
Danny

Yeah, I just checked the reverse IP checker again and all domains seem to have been removed, this is likely because it is a dev or staging environment. However, the fact remains that the issues you're encountering are a WordPress database error and therefore, are likely caused by your server. I am not even sure how to recreate the error when you only have those plugins installed.

 

Therefore, I think the best course of action would be to check out FlyWheel, who we know is a very good host and therefore, shouldn't encounter any issues. If you still encounter database issues using FlyWheel, then there is definitely an issue with your WordPress setup.

 

Please keep us posted.


Please search our forums, before posting!

Share this post


Link to post
Share on other sites
balfred1345

I couldn't get a good answer from my host on the issue, as all of my databases were showing up as "OK" in CPanel.

So, I went back to a backup from before the problem started. After installing the backup (rolled back the databases using BackupBuddy) I was able to work on the site, and Pagelines sections worked as expected. But, about an hour in to my work, the PL "editor" (sorry, I don't know its official name), at the bottom of the page stopped showing up as full width / lost its background. This remained the case when I disabled all plugins.  See the screenshot here: 

http://screencast.com/t/uFyfkOMyI

 

Can you tell me how to get the "editor" to show up correctly. Let me know if this should be a separate post.

 

Thanks,

Bruce

Share this post


Link to post
Share on other sites
Danny

Bruce that kind of error can only be caused by one of the following:

 

1. Custom CSS/LESS CSS you may have added.

2. A custom script you may have added.

3. A plugin you have installed.

4. Some code you have added to a section or page, which is causing the issue.

That kind of error is not possible in DMS without the assistance from custom code, script or plugin. It can not be caused I don't think by any database error or server configuration issue. It has to be something you have added.


Please search our forums, before posting!

Share this post


Link to post
Share on other sites
balfred1345

Danny

Thanks. I removed my style.less file, and the editor showed up correctly. So, I've got to go through my LESS file and see what could be causing this problem. I always use #site, and I thought PL was developed so that if we use #page or #site, our styles wouldn't impact DMS?? 

 

-Bruce

 

 

Share this post


Link to post
Share on other sites
balfred1345

I went through my 600 lines in style.less and 2.5 hours later, I was able to isolate the code that was breaking the formatting of the PL Editor/Toolbox. I have no idea why these lines were breaking the PL Editor/Toolbox formatting, so I am afraid that I don't know how to avoid this issue in the future. Can you please look at the below code and the notes and tell me why this was breaking the formatting of the PL Editor/Toolbox so I can learn from this problem and avoid this issue in the future?

 

Thanks,

Bruce

#page .ba-Background p, li {
    font-size: 16px;
    line-height: @baseLineHeight * 1.05;
    // margin-bottom: 6px;
   //  it was margin-bottom in the above line that was one of two lines breaking PL editor
}

//had ol, ul. Took out ol here which was the second change that fixed the PL editor/toolbox
#site .listSpacing ul {
    margin: 1.3em 0 1.3em 1.3em;
} 

Share this post


Link to post
Share on other sites
Simon

it this bit:

#page .ba-Background p, li {}

 

If you break that down it is two rules...

 

1. Any p tag that has ba-Background class within the #page ID

2. ANY yes ANY li tag

 

perhaps your code should read: 

#page .ba-Background p,

#page .ba-Background li {}

 

which would equate to:

1. Any p tag that has ba-Background class within the #page ID

2. Any li tag that has ba-Background class within the #page ID

Share this post


Link to post
Share on other sites
balfred1345

Simon_P

 

Thank you so much!

I obviously had no idea... I've always mistakenly thought that the comma added the tag on to the preceding class and ID, not that it was just hanging out there on its own without any rules attached to it. 

 

Thank you for explaining so clearly!

 

-Bruce

Share this post


Link to post
Share on other sites
Simon

you're welcome :)

Share this post


Link to post
Share on other sites

  • Similar Content

    • Lisa Haran
      By Lisa Haran+
      Hi 
      I have a map here http://www.iloveoffset.com/maps/
      I want to add several pointer locations to the map, but when I do they do not appear.
      On this map there are 2 pointer locations and as you can there is only one visible.
      Earlier today I added 7 and could only see 4 so there is something odd going on.
      My theme is up to date
    • clj182
      By clj182+
      Hello,
      I've been having trouble unlocking the template section for past couple of weeks. When I try clicking nothing happens. 
      I've deleted my custom css and removed plugins. Im down to having only the following plugins:
      Akismet
      Contact Form 7
      DMS Professional Tools
      Pagelines Updater
      WooCommerce
      It was working fine before i have no idea what's going on with it.
    • flourishdesignstudio
      By flourishdesignstudio+
      My DMS 2 site http://www.heart-stone.com/ will not save any new custom css... I can still edit templates and publish those but any custom css that I enter never saves.
      All WP files, themes, and plugins are up to date. 
      Any thought about what might be causing this?
    • flourishdesignstudio
      By flourishdesignstudio+
      Is there a way to edit the custom CSS via FTP? I know I can edit the custom code in the Chrome editor but is there a file path I can use to find and edit the CSS directly from our FTP?
      Thanks in advance for the help!
    • nizami
      By nizami+
      Using navbar section with correctly configured WP menu to display main navigation at https://elenaangel.com. 
      All fine in desktop viewport. Menu displays twice in hamburger mode. How to fix this please? 

×