X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Dev Questions (X-Cart 5) (https://forum.x-cart.com/forumdisplay.php?f=56)
-   -   new store stuck in maintenance (https://forum.x-cart.com/showthread.php?t=68559)

xanadude 02-26-2014 03:13 AM

Re: new store stuck in maintenance
 
Hi Tony

Could not upgrade as not able to get into the admin side at all as it stuck at that error display so I have completely rebuilt.

Thanks for looking into it though

tony_sologubov 02-27-2014 05:07 AM

Re: new store stuck in maintenance
 
This problem is caused by the bug in our attribute system.

In order to fix the problem you should delete all product attributes via MySQL.

For that you need to clean up the following tables:
| xlite_attribute_group_translations |
| xlite_attribute_groups |
| xlite_attribute_option_translations |
| xlite_attribute_options |
| xlite_attribute_translations |
| xlite_attribute_values_checkbox |
| xlite_attribute_values_select |
| xlite_attribute_values_text |
| xlite_attributes |
| xlite_product_variant_attribute_value_checkbox |
| xlite_product_variant_attribute_value_select |
| xlite_product_variants_attributes

and rebuild the cache. After that you will be able to upgrade to 5.0.11 where this bug is fixed.

poloplata 02-27-2014 05:28 PM

Re: new store stuck in maintenance
 
Attempted to enable UPS module and same problem occurred - stuck in maintenance. Able to recover but still need to enable UPS.

tony_sologubov 03-06-2014 01:01 PM

Re: new store stuck in maintenance
 
Hi!

Do you have any errors in the files of <X-Cart 5>/var/log/ folder? If it is clean, please check your web-server error logs too.

Tony.

Charlie@dsemedical.com 03-20-2014 08:26 AM

Re: new store stuck in maintenance
 
Tony - we are having the same problem, Im inside the Database, what exactly am I deleting? If I delete all of the attributes within those Tables, when I rebuild would those come back?

tony_sologubov 05-08-2014 04:54 AM

Re: new store stuck in maintenance
 
Hi Charlie!

Is this problem still actual for you? If so, you need to delete all the data from the tables mentioned here:
http://forum.x-cart.com/showpost.php?p=370085&postcount=22 and then rebuild the cache. It should be working properly after that.

djancak 07-19-2014 12:56 PM

Re: new store stuck in maintenance
 
X-Cart 5 got stuck in maintenance after I tried the free activation. I tried the solution mentioned earlier to remove the /var/.rebuildStarted file but now it is just giving me an ugly error in the cache rebuild. First it started with http://puu.sh/aiu0f/01ea5e4420.png and has progressed to http://puu.sh/aiuix/69406088db.png which it is stuck on again. This is depressing as I had just gotten done doing a lot of work on the website and now it's unusable again. I'm running version 5.1.3 and I don't know what modules are installed since I can't access X-Cart any more.

tony_sologubov 07-21-2014 04:49 AM

Re: new store stuck in maintenance
 
Hi!

Just sent you an email.

Tony.

Mosherbk 07-27-2014 04:57 PM

Re: new store stuck in maintenance
 
I was advised by the X-cart support person to post this to the forums. This looks like a good as place as any. I have Version 5.1.4 Free Version.

Whenever I install, enable, disable etc. a module I get the "store closed issue" and must fix it with the knowledge based instructions here: http://kb.x-cart.com/pages/viewpage....pageId=7504187.

One of the links used to usually fixes it but some of them disables all the modules so I'm further behind.

Now when I attempt to use these solutions I get this error message:
ERROR: "42000" (code N/A)
SQLSTATE[42000]: Syntax error or access violation: 1226 User 'shalebrooksoap' has exceeded the 'max_questions' resource (current value: 75000)

Any help?
Thanks

Andrew_J 07-29-2014 07:26 AM

Re: new store stuck in maintenance
 
I don't know how to link to posts in other threads so I'll quote my post here. First, what I wrote in another thread:

--------------------------------------------------------------------------------------------------------------------------

Re X-Cart 5 being stuck in maintenance mode, I discovered two things that seemed to be true.

-If you are attempting to install a new module and the cache rebuild fails on step 9, you could have a syntax error in one of the files. This was the case with me.

-If you have a cache rebuild fail on steps 1-5, it could be a connection timeout. If you can't increase the time to 300 seconds, get hosting somewhere else.

I got hosting at Total Solutions (formerly EWD) and that fixed this timeout issue for me entirely.

--------------------------------------------------------------------------------------------------------------------------

Now, an additional comment about your MySQL error. I think your host placed limits on your DB requests that is below what X-Cart needs to operate. Switching hosts will fix this. :D

Quote:

Originally Posted by Mosherbk
I was advised by the X-cart support person to post this to the forums. This looks like a good as place as any. I have Version 5.1.4 Free Version.

Whenever I install, enable, disable etc. a module I get the "store closed issue" and must fix it with the knowledge based instructions here: http://kb.x-cart.com/pages/viewpage....pageId=7504187.

One of the links used to usually fixes it but some of them disables all the modules so I'm further behind.

Now when I attempt to use these solutions I get this error message:
ERROR: "42000" (code N/A)
SQLSTATE[42000]: Syntax error or access violation: 1226 User 'shalebrooksoap' has exceeded the 'max_questions' resource (current value: 75000)

Any help?
Thanks



All times are GMT -8. The time now is 10:54 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.