X-Cart forums

[tony_sologubov]

Hello @Mona Not ,

I am sorry for this problem. I am investigating the problem right now and once I find out what causes it, I will post a solution here.

Meanwhile, could you please recover the store from the recent backup, so it would operate properly while I am looking for a solution?

Thank you.

Tony

[tony_sologubov]

@Mona Not,

Could you please pack the store (files and database) that has this problem and send them to me via sales@x-cart.com? Please refer to this thread and Tony Sologubov in your email.

I will have a look at why this problem is happening in your store.

Thank you.

Tony

[Mona Not]

Hi Tony,

Sorry, I had already deleted the 5.2.5 and installed 5.2.4
The 5.2.4 works as it should.

There seems to be a problem with the install script on 5.2.5 It doesn't do any checking like the previous versions. It also does not verify your email password like the previous version.
5.2.4 does this.

Is it possible there was a mix up in the file for download? Perhaps a developer's copy?

Try installing the download link copy, you will see what I mean.

If you want I can upload the tarball 5.2.5 that I have, but you should be able to get it from your site or from my file area.

Peter

[tony_sologubov]

For future reference, the problem with

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

error message was caused by X-Cart's bug, which will be fixed in 5.2.6.

In order to work around this issue, you should change the <X-Cart>/classes/XLite/Model/Repo/ARepo.php file and replace the following piece of code there:

PHP Code:

$schema = preg_replace(
    '/(ALTER TABLE `' . $tablePrefix . $t . '`.*) DROP `?' . $f . '`?(, |$)/Ss',
    '\1 ',
    $schema
); 


with the next one:

PHP Code:

$schema = trim(preg_replace(
    '/(ALTER TABLE `' . $tablePrefix . $t . '`.*) DROP `?' . $substr . '`?(, |$)/Ss',
    '\1 ',
    $schema
), ', \t\n\r\0\x0B'); 


It is in the processSchema() function near line 1161.

[tony_sologubov]

I am not sure about faulty distribution, because I was trying to replicate the problem on the version downloaded from the web-site and I could not see the problem. I feel, it is something related to the particular configuration of the store, but I do not know exact configuration which causes the problem.

If you face the problem one more time, just backup files and database of the store and send them to us, so we could have a look as I did for @PatPgtips

Thank you.

Tony

Originally Posted by Mona Not

Hi Tony,

Sorry, I had already deleted the 5.2.5 and installed 5.2.4
The 5.2.4 works as it should.

There seems to be a problem with the install script on 5.2.5 It doesn't do any checking like the previous versions. It also does not verify your email password like the previous version.
5.2.4 does this.

Is it possible there was a mix up in the file for download? Perhaps a developer's copy?

Try installing the download link copy, you will see what I mean.

If you want I can upload the tarball 5.2.5 that I have, but you should be able to get it from your site or from my file area.

Peter

[Mona Not]

Hi Tony,

I'm going to backup and reinstall using a fresh download of 5.2.5 Maybe the file became corrupt in the process?? If it does the same thing, I'll package these together for you.

Cheers,
Peter

Originally Posted by tony_sologubov

I am not sure about faulty distribution, because I was trying to replicate the problem on the version downloaded from the web-site and I could not see the problem. I feel, it is something related to the particular configuration of the store, but I do not know exact configuration which causes the problem.

If you face the problem one more time, just backup files and database of the store and send them to us, so we could have a look as I did for @PatPgtips

Thank you.

Tony

[tony_sologubov]

Thank you a lot for your effort, Peter!

[Mona Not]

Hi Tony,

I've sent you an email with dropbox link containing the store files and the sql dump.

The store is in "error state" I have not touched/altered any files other than activated, enable and disable modules.

Originally Posted by tony_sologubov

Thank you a lot for your effort, Peter!

[Mona Not]

Hi Tony,

Update...

I've deleted the 5.2.5 and reinstalled 5.2.4 which appeared to work fine.

I then updated the 5.2.4 to 5.2.5 ... It works as it should so far. I still have not connected payment processors or shippers, but I was able to update modules, enable or disable modules which would return the error leaving the store in maintenance mode.

The problem seems to be with a new install of 5.2.5
Updating from 5.2.4 to 5.2.5 seems to work fine.


Peter

Originally Posted by tony_sologubov

I am not sure about faulty distribution, because I was trying to replicate the problem on the version downloaded from the web-site and I could not see the problem. I feel, it is something related to the particular configuration of the store, but I do not know exact configuration which causes the problem.

If you face the problem one more time, just backup files and database of the store and send them to us, so we could have a look as I did for @PatPgtips

Thank you.

Tony

[mohammadUMAR]

Hi Tony,

I've provided cpanel and ftp passwords to x-cart team for detailed investigation of errors (struck during maintenance).

Instead of providing me a viable solution of the problem, they installed a fresh instance and try to prove that its working fine.

The store installed by xcart team has crashed as well. http://www.meditools.com.au/xcart5/index.php

I'm sorry to say, its nothing to do with the installation, I've done installation again and again nearly 20 times, store crashes when I on/off modules or redeploy it.

I've dropped a couple of emails but helpdesk but no answer.

Its almost a month I'm trying to setup but still its not done. I'm a loyal customer since 2008, at the moment I'm losing my trust with x-cart.

I'm expecting solution of bug.

Regards,
Mohammad