X-Cart forums

[herber@wirehub.nl]

Sorry for the previous post!

Since the upgrade to 4.7.2, I get the following error:

When trying to change the address in the One-Page-Checkout, the following error occurs:

Error: Specified user name contains unallowed characters or exceeds the length limit (127 characters max).

It seems to be about the email address, but the email address is valid (and not changed, this situation is about a logged in user trying to just change the steersman & not the email) but it will not save the already provided email address.

See the screenshot.

This means nobody can change their email address in the One Page Checkout module.

To us this is quite a serious bug, because the entire form cannot be saved because of this.


--------
I found the cause of this:
Our X-Cart installation still uses usernames (we cannot switch to email: too many users with double email addresses in the database) and this user, had a username with a space in it ( ) and the system apparently won't allow this anymore, but doesn't account for the fact that in the past it used to allow this. So all users with a space in the username (which is not shown in that form of the One Page Checkout, but apparently it is saved and checked) will have this bug.
When I remove this space from his username, it is solved. However, there may be more users with a space in the username and it is still a bug.

[aim]

Originally Posted by herber@wirehub.nl

Sorry for the previous post!

Since the upgrade to 4.7.2, I get the following error:

When trying to change the address in the One-Page-Checkout, the following error occurs:


It seems to be about the email address, but the email address is valid (and not changed, this situation is about a logged in user trying to just change the steersman & not the email) but it will not save the already provided email address.

See the screenshot.

This means nobody can change their email address in the One Page Checkout module.

To us this is quite a serious bug, because the entire form cannot be saved because of this.


--------
I found the cause of this:
Our X-Cart installation still uses usernames (we cannot switch to email: too many users with double email addresses in the database) and this user, had a username with a space in it ( ) and the system apparently won't allow this anymore, but doesn't account for the fact that in the past it used to allow this. So all users with a space in the username (which is not shown in that form of the One Page Checkout, but apparently it is saved and checked) will have this bug.
When I remove this space from his username, it is solved. However, there may be more users with a space in the username and it is still a bug.

It seems this is a problem in DB since your X-Cart 4.1.8 version.

Starting from X-Cart 4.1.10 we have disabled special characters in usernames.

You can find all old users with special chars via this SQL query

SELECT id,login,username,email FROM xcart_customers WHERE login REGEXP '[^.@A-Za-z_0-9-]' OR username REGEXP '[^.@A-Za-z_0-9-]';

[herber@wirehub.nl]

Originally Posted by aim

It seems this is a problem in DB since your X-Cart 4.1.8 version.

Starting from X-Cart 4.1.10 we have disabled special characters in usernames.

You can find all old users with special chars via this SQL query

SELECT id,login,username,email FROM xcart_customers WHERE login REGEXP '[^.@A-Za-z_0-9-]' OR username REGEXP '[^.@A-Za-z_0-9-]';

Showing rows 0 - 29 (664 total, Query took 0.0061 sec)

That's going to be fun..

[aim]

Originally Posted by herber@wirehub.nl

Showing rows 0 - 29 (664 total, Query took 0.0061 sec)

That's going to be fun..

The possible solution is to replace all spaces to '_' symbol

your algorithm

----------------------------
1 Backup your DB
2 Notify all your customers about the changes
3 alter table xcart_customers add UNIQUE login(login);
4 alter table xcart_customers add UNIQUE username(username);

5

  update xcart_customers set login=replace(login,' ', '_') WHERE login REGEXP '[^.@A-Za-z_0-9-]' and usertype IN ('C','B');
  update xcart_customers set username=replace(username,' ', '_') WHERE username REGEXP '[^.@A-Za-z_0-9-]' and usertype IN ('C','B');

}

6 alter table xcart_customers drop index login;
7 alter table xcart_customers drop index username;
8 check your shop
----------------------------

[herber@wirehub.nl]

What permissions are necessary on the files of the Mobile Admin module?

After a successful installation, we get this error in the logs & a white blank page when trying to load the configuration page of the module:

8-Jun-2015 16:08:57 Europe/Berlin] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 105646081 bytes) in /include/lib/smarty3/Smarty.class.php on line 1616

The module works on our testserver (different OS/file owner setup) so I guess this is caused by a difference in permissions.
Are there any files in this module that need special permissions in order for it to work & prevent this error?

[aim]

Have you applied the patch from
https://bt.x-cart.com/view.php?id=44643#attachments ?

[herber@wirehub.nl]

Originally Posted by aim

Have you applied the patch from
https://bt.x-cart.com/view.php?id=44643#attachments ?

Thank you, I had not. Now that I did, the error is visible & a template file did not have the right permissions so it could not be read.
All fixed now, thank you!

----
The app does not display any data though, should mobile_admin_api.php be given any other permissions than normal (which is 644 in our case)?

[herber@wirehub.nl]

Without any changes to the Product Notifications module, we suddenly get this error when accessing the list of users who signed up for Product Nofitications:

[09-Jun-2015 09:59:08 Europe/Berlin] PHP Fatal error: Cannot use string offset as an array in /modules/Product_Notifications/product_notifications_admin.php on line 114

And the page is blank.
Line 112-115:

if (
!empty($page)
&& $search_data['product_notifications']['page'] != intval($page)
) {

(Yes, only an error & blank page when using the pagination, so page 1 is shown just fine, but other pages aren't)

[aim]

Originally Posted by herber@wirehub.nl

Without any changes to the Product Notifications module, we suddenly get this error when accessing the list of users who signed up for Product Nofitications:

And the page is blank.
Line 112-115:


(Yes, only an error & blank page when using the pagination, so page 1 is shown just fine, but other pages aren't)

https://bt.x-cart.com/view.php?id=44782#attachments

Thank you.

[herber@wirehub.nl]

Originally Posted by aim

https://bt.x-cart.com/view.php?id=44782#attachments

Thank you.

Thanks, that fixes it!

My other problem though, with the Mobile Admin app still exists:


----
The app does not display any data though, should mobile_admin_api.php be given any other permissions than normal (which is 644 in our case)?
----

Scanning the QR code or entering the API key & URL is accepted by the app, but no data is fed into the app.