Is It A Bug? Site Keeps Giving "under Construction" Logo

We have found over and over again with version 4.2.3 that when we go to do certain things in the admin we are given the little sign that says, the “store is closed” or the “All Shucks…”. Has anyone else ran in to this? We know there was a bug (or whatever they want to call it) that messed up your site if you didn't have the www in the domain name, but this is different.



What is even stranger is we have items that are discontinued or categories that we do not need any longer so we are changing them. These are things we disabled back a couple of months ago. Well, now if we try to make those categories “hidden” or "active' it says…

[quote]404

ERROR

Well Shucks!

It looks like something you were looking for has been moved. Please try one of the links above or a quick link below.



The page you have requested cannot be found.

Error code: Page Not Found

[/quote]



In the process of adding redirects to broken links (most from things we are changing), we have started to find that we can NOT create a redirect for some items. Most of the items were something we marked as “disabled” so we wanted to create a redirect…but the system will not let us create the redirect for some items. Then when we go to try to delete those items we were getting the above errors. Even after deleting the item we still are unable to create the redirect.



I would STRONGLY recommend you not update to the current versions of CS. If you are on CS 2.2.5, STAY THERE. I can not say much about the abandoned version 3, but version 4 is NOT ready for the real world and sadly CS just keeps making it worse by either rigging the software, not listening or adding too many new add ons without fixing previous “issues”, bugs or whatever they want to call them. We upgraded because we thought we “needed” some of the new features and sadly it was a HUGE mistake that has cost us a LOT OF BUSINESS and headaches.

in the upgrade proces store has to be closed… under general you have to uncheck close store front…

I believe Jim is referring to the admin side. In V4, when there is a DB error the admin generates a Store Closed page rather than the previous “Oops something goes wrong” message that used to display.

[quote name='tbirnseth' timestamp='1415231583' post='196174']

I believe Jim is referring to the admin side. In V4, when there is a DB error the admin generates a Store Closed page rather than the previous “Oops something goes wrong” message that used to display.

[/quote]

Is that seriously why the store closed is coming up? Because of a database error?

As I said, they changed from a “Oops something goes wrong” as a notification message to the Service Unavailable page in V4.

If you cut the URL back to your main admin url, you’d see that it is a error page and that your store isn’t really closed.



I’m sure it’s in the documentation somewhere! :-)

admin panel is always available it can't be set closed… this is a separate issue

[quote name='demeldoo' timestamp='1415363614' post='196373']

admin panel is always available it can't be set closed… this is a separate issue

[/quote]

You are correct, the problem is that is where we keep getting the errors.

@demeldoo - Technically it's not closed but the page displayed indicates that it is. Not sure why they changed to this in the Admin panel but they did. It was better to just have the notification. However, this certainly does a better job of “call to action” rather than the notification simply being ignored.

have you tried to edit those categories and set the new seo name for it and then try to enable or disable or whatever with it…



maybe it will update the the rule or redirect you to pages you need… do you have a category above or something like that… maybe you are trying to access a subcategory which is disabled by default by category…check this options because i'm running 4.2.3 and dont' have any of those problems…and updated my cs cart from…i don't rember version…

Just uncomment or add a:

define('DEVELOPMENT', true);

line in either your config.local.php or local_conf.php. The specific DB error will then be shown instead of the Service Unavailable page.

[quote name=‘tbirnseth’ timestamp=‘1415406364’ post=‘196415’]

Just uncomment or add a:

define('DEVELOPMENT', true);
```<br />
line in either your config.local.php or local_conf.php.  The specific DB error will then be shown instead of the Service Unavailable page.<br />
[/quote]<br />
<br />
yes tbirnseth this is the best solution... we are guessing <img src="upload://rA9Qa8gnUPZzRZRdI8kt3dpjkrs.png" class="bbc_emoticon" alt=":)">

I am experiencing this same problem. I am getting an intermittent “[font=“arial, verdana, tahoma, sans-serif”][color=”#282828"]Service Unavailable" page when trying to access my site or the backend. This is occurring after performing the 4.2.3 upgrade that came out a couple of days ago. Is it possible this is a bug? I am having customers complaining that they can intermittently access the site. [/color][/font]

[quote name='syscrusher' timestamp='1415498658' post='196454']

I am experiencing this same problem. I am getting an intermittent “[font=“arial, verdana, tahoma, sans-serif”][color=#282828]Service Unavailable” page when trying to access my site or the backend. This is occurring after performing the 4.2.3 upgrade that came out a couple of days ago. Is it possible this is a bug? I am having customers complaining that they can intermittently access the site. [/color][/font]

[/quote]



Please try solution from post #10

I just heard back from cs-cart. Apparently this is a know bug in the current versin. Here is the fix. I will try this and let you know if this fixes it.



Unfortunately, the issue is caused by a bug in the current version of CS-Cart. In order to fix it, please take these steps:


  1. Open the app/functions/fn.ultimate.php file of your installation and replace this line:

    $companies = db_get_array(“SELECT company_id, $field FROM ?:companies WHERE $field LIKE ?l OR $field LIKE ?l”, $short_host . '%', $host . '%');



    with this one:

    $companies = db_get_array(“SELECT company_id, $field FROM ?:companies WHERE $field RLIKE ?l”, '^(www[0-9]*.)?' . $short_host);




  2. Save the file.

It appears that some of our “well shucks” errors may have been partially caused by the fact that we have mod_security installed on our server and enabled. Even with mod_security turned off we are still getting the database errors. So we have not narrowed those down yet.