Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

new store stuck in maintenance

 
Reply
   X-Cart forums > X-Cart 5 > Dev Questions (X-Cart 5)
 
Thread Tools Search this Thread
  #51  
Old 06-15-2015, 04:01 AM
  tony_sologubov's Avatar 
tony_sologubov tony_sologubov is offline
 

X-Cart team
  
Join Date: Jan 2009
Posts: 2,431
 

Default Re: new store stuck in maintenance

Thanks for the instruction, Steve.

I just tried to select 50 modules and install them. It went through pretty good, with no errors.
Could you please let me know whether you used X-Cart Free edition?

Thank you.

Tony

Quote:
Originally Posted by cflsystems
1. Brand new stock installation.
2. Show all modules from marketplace which are free.
3. Selected all to install.
4. At this point clicking on install modules took forever and I think it was not doing anything actually. I left it like this for about 2 hours and nothing but the animation.
5. It looks like selecting modules to install from different pages in the modules list causes this. Selecting 5-6 which are on the same page works.
6. The module I remember showing sql error with order was Multicurrency.
7. I was not able to install MailChip and Mandrill together within the same selection. Separate they installed.
__________________
Found a bug in X-Cart? Post it to our bug tracker!
Know how to make X-Cart better? Suggest an idea!
Reply With Quote
  #52  
Old 06-15-2015, 04:18 AM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,190
 

Default Re: new store stuck in maintenance

X-Cart NFR license. I don't think this is the free version.
Brand new installation, didn't even have the license key entered yet.
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
  #53  
Old 06-15-2015, 05:27 AM
 
PatPgtips PatPgtips is offline
 

Newbie
  
Join Date: Jun 2015
Posts: 7
 

Default Re: new store stuck in maintenance

the module was Related Products

i removed it started the update process and fails everytime at the error shown above

the version i have is the latest free version i only downloaded yesterday
__________________
free
Reply With Quote
  #54  
Old 06-15-2015, 09:02 AM
 
mgwashburn mgwashburn is offline
 

Advanced Member
  
Join Date: Sep 2013
Posts: 82
 

Default Re: new store stuck in maintenance

OMG,

same issue here,

We started the upgrade process from 4.2 to the new 5.2 in April and we are supposed to go live this week.

I downloaded the updates from 5.2.x to 5.2.5 and a couple of days later the entire system took a dump.

The client had added in 600+ products with thousands of photos and pdf files...also static pages etc.

Now the mysql database is corrupt and trying a rebuild always brings the error :


Deploying store [step 5 of 13], please wait...
Run the "Doctrine_Plugin_UpdateSchema" plugin...

ERROR: "0" (code N/A)
An exception occurred while executing 'ALTER TABLE `xc_profiles` MODIFY `default_card_id` INT UNSIGNED NULL, MODIFY `pending_zero_auth` VARCHAR(255) NULL, MODIFY `pending_zero_auth_txn_id` VARCHAR(255) NULL, MODIFY `pending_zero_auth_status` CHAR(1) NULL, MODIFY `pending_zero_auth_interface` VARCHAR(255) NULL,': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

After spending 40+ hours with no sleep attempting to restore the data from backups, we realize there is a serious problem with the new 5.2.5 version and we are screwed.

I have now attempted a brand new vanilla install with the barebones modules...only the Banner and Flyout Menu modules we purchased are added.

As soon as we add a few categories, add a couple of static pages and then...bang

same thing, shopping cart goes to "The site is temporarily closed for maintenance"

and we are screwed...

PLEASE make the 5.2.4 file available as we cannot even install this version.

we neeed help!!!
__________________
Marc Washburn
www.EverythingGraphic.com
Running four successful X-cart 5.3.x installations and one 5.4.x
Reply With Quote
  #55  
Old 06-16-2015, 01:37 AM
  tony_sologubov's Avatar 
tony_sologubov tony_sologubov is offline
 

X-Cart team
  
Join Date: Jan 2009
Posts: 2,431
 

Default Re: new store stuck in maintenance

Hello @mgwashburn,

I am sorry to hear about those problems. Let us try to find what we can do:

1) When your new store shows the "The site is temporarily closed for maintenance" message, did you try to recover it as described here:
http://kb.x-cart.com/display/XDD/What+to+do+if+you+cannot+access+your+store+and+it+ says+we+are+deploying+new+changes#Whattodoifyoucan notaccessyourstoreanditsayswearedeployingnewchange s-Dropandre-createyoursite'scache

It should help without installation of 5.2.4

2) Just in case you still need 5.2.4, you can download it from here: https://dl.dropboxusercontent.com/u/23858825/x-cart-5.2.4-en.tgz

3) If you still have files and database of the store that produced the aforementioned error:
Code:
An exception occurred while executing 'ALTER TABLE `xc_profiles` MODIFY `default_card_id` INT UNSIGNED NULL, MODIFY `pending_zero_auth` VARCHAR(255) NULL, MODIFY `pending_zero_auth_txn_id` VARCHAR(255) NULL, MODIFY `pending_zero_auth_status` CHAR(1) NULL, MODIFY `pending_zero_auth_interface` VARCHAR(255) NULL,': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

could you please pack and send them to me? It would allow the team to check the problem and apply some fix, so you would be sure it is not going to happen again.

Thank you.

Tony
__________________
Found a bug in X-Cart? Post it to our bug tracker!
Know how to make X-Cart better? Suggest an idea!
Reply With Quote
  #56  
Old 06-16-2015, 01:42 AM
  tony_sologubov's Avatar 
tony_sologubov tony_sologubov is offline
 

X-Cart team
  
Join Date: Jan 2009
Posts: 2,431
 

Default Re: new store stuck in maintenance

@PatPgtips,

Just tried to replace this problem locally and it does not happen to me.

Could you please let me know whether I can investigate the problem directly on your server? if so, please email us at sales@x-cart.com with reference to Tony Sologubov.

Thank you.

Tony

Quote:
Originally Posted by PatPgtips
the module was Related Products

i removed it started the update process and fails everytime at the error shown above

the version i have is the latest free version i only downloaded yesterday
__________________
Found a bug in X-Cart? Post it to our bug tracker!
Know how to make X-Cart better? Suggest an idea!
Reply With Quote
  #57  
Old 06-16-2015, 02:04 AM
 
PatPgtips PatPgtips is offline
 

Newbie
  
Join Date: Jun 2015
Posts: 7
 

Default Re: new store stuck in maintenance

Quote:
Originally Posted by tony_sologubov
@PatPgtips,

Just tried to replace this problem locally and it does not happen to me.

Could you please let me know whether I can investigate the problem directly on your server? if so, please email us at sales@x-cart.com with reference to Tony Sologubov.

Thank you.

Tony

ive tried a new subdomain install i removed all payment processors i didnt need and i have the same error again

i think ill just look for something else for now its a shame though its the ideal cart for what i need but as it is now i have lost all the work i put into the first cart
__________________
free
Reply With Quote
  #58  
Old 06-16-2015, 04:56 AM
  tony_sologubov's Avatar 
tony_sologubov tony_sologubov is offline
 

X-Cart team
  
Join Date: Jan 2009
Posts: 2,431
 

Default Re: new store stuck in maintenance

@PatPgtips,

Could you please allow me to investigate the problem right on your server? I feel it is something related to the environment. If we figure out what is wrong, you will be able to save time switching to another solution.

If it sounds interesting, please just send a message to sales@x-cart.com with reference to Tony Sologubov and this thread.

Thank you.

Tony

Quote:
Originally Posted by PatPgtips
ive tried a new subdomain install i removed all payment processors i didnt need and i have the same error again

i think ill just look for something else for now its a shame though its the ideal cart for what i need but as it is now i have lost all the work i put into the first cart
__________________
Found a bug in X-Cart? Post it to our bug tracker!
Know how to make X-Cart better? Suggest an idea!
Reply With Quote
  #59  
Old 06-16-2015, 07:39 AM
 
PatPgtips PatPgtips is offline
 

Newbie
  
Join Date: Jun 2015
Posts: 7
 

Default Re: new store stuck in maintenance

Quote:
Originally Posted by tony_sologubov
@PatPgtips,

Could you please allow me to investigate the problem right on your server? I feel it is something related to the environment. If we figure out what is wrong, you will be able to save time switching to another solution.

If it sounds interesting, please just send a message to sales@x-cart.com with reference to Tony Sologubov and this thread.

Thank you.

Tony

ive sent an email

thanks for taking the time to look at this
__________________
free
Reply With Quote
  #60  
Old 06-17-2015, 03:09 PM
 
Mona Not Mona Not is offline
 

Advanced Member
  
Join Date: Jun 2008
Posts: 87
 

Default Re: new store stuck in maintenance

Same problem with new install of 5.2.5

Now I get this Friggin' Error!!!

Deploying store [step 5 of 13], please wait...
Run the "Doctrine_Plugin_UpdateSchema" plugin...


ERROR: "0" (code N/A)
An exception occurred while executing 'DROP INDEX IDX_ED2984B1BF05C450 ON xc_clean_urls': SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'IDX_ED2984B1BF05C450'; check that column/key exists



This occurred when activating banner system module.

How do I fix it on a new install?

Ok, reinstalled the store and activated the banner module first. It worked fine. I continued to enable modules one at a time... no problem. I tried to disable 3 modules at one time... I get this Friggin' error again!

ERROR: "0" (code N/A)
An exception occurred while executing 'DROP INDEX IDX_ED2984B1BF05C450 ON xc_clean_urls': SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'IDX_ED2984B1BF05C450'; check that column/key exists


It does not matter which module or order, it's seemingly random.

Anybody have a clue as to how I can fix this.
__________________
Lite Commerce Ver: 2.2.35 [linux] - Retired
X-Cart Gold Plus Ver: 4.6.0 [linux] - Live php 5.3.3
X-Cart 5.1.11 Business [linux] - Live -
X-Cart 5.2.5 Free [linux] - Live-
X-Cart 5.2.6 Business [linux] - Live -
X-Cart 5.x mobile [linux] - inactive
Reply With Quote
Reply
   X-Cart forums > X-Cart 5 > Dev Questions (X-Cart 5)


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 12:45 PM.

   

 
X-Cart forums © 2001-2020