X-Cart forums

[bngwarehouse]

*********:.TESTING X-Cart 4.1.0 .:************

To start out with I have (chmod) the files and dir as showed in the INSTALL (How-to <file>).

Here is the error after <clicking> on the (users) option in the Admin planel.

This also happens when I <clicked>

Orders
Countries
States
General settings
languages

So I am hoping someone can see a pattern here..... Does this mean that mySql db has crashed or damaged?

It did crash you can say the other day, (X-cart 4.1.0 rc4 )

I was deleting the db and importing 9786 rows of info into the db.
Ok here is the error..........

Repairing table /var/tmp/#sql_63c_0...1 : Can't create/write to file '/var/tmp/#sql_63c_0.MYI' (Errcode: 13)
INVALID SQL: 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 '/var/tmp/#sql_63c_0 EXTENDED' at line 1

SQL QUERY FAILURE:SELECT xcart_countries.*, IFNULL(lng1c.value, lng2c.value) as country, IFNULL(lng1l.value, lng2l.value) as language FROM xcart_countries LEFT JOIN xcart_languages as lng1c ON lng1c.name = CONCAT('country_', xcart_countries.code) AND lng1c.code = 'US' LEFT JOIN xcart_languages as lng2c ON lng2c.name = CONCAT('country_', xcart_countries.code) AND lng2c.code = 'US' LEFT JOIN xcart_languages as lng1l ON lng1l.name = CONCAT('language_', xcart_countries.code) AND lng1l.code = 'US' LEFT JOIN xcart_languages as lng2l ON lng2l.name = CONCAT('language_', xcart_countries.code) AND lng2l.code = 'US' WHERE (lng1l.value != '' OR lng2l.value != '') GROUP BY language ORDER BY language

Thanks
Wesley

[B00MER]

Its great and all that 4.1.x is released, but personally I wouldn't upgrade to the latest branch until a few more subversion releases occur. Simply to squish out more bugs as it seems there are more real world bugs unidentified, that only a real world testing environment will identify.

I didn't start moving clients over from 4.0.x until around 4.0.5+ as it seemed to become more usuable in a production environment.

Just my 2cents.

[moneysaver67]

Is MySQL 5.x support native to 4.1? If I can use MySQL 5.x w/ 4.0.18 then 4.1.x can wait!

[mmx]

Afer installing 4.1, I wanted to change the Company Name, so via Admin/General Settings/Company Options/ I changed the company Name and clicked save - However I still get "Your Company name"

- appearing in the TitleBar of the browser
- and in location.tpl

even though it shows in the Admin section the Company Name has actually been changed.

[svowl]

Please, do not post bug reports here. It will be very hard for you to find information on a specific report if all the reports will be in one thread. Post bug reports to the 'Bugs & Fixes' section, please.

[svowl]

Originally Posted by mmx

Afer installing 4.1, I wanted to change the Company Name, so via Admin/General Settings/Company Options/ I changed the company Name and clicked save - However I still get "Your Company name"

- appearing in the TitleBar of the browser
- and in location.tpl

even though it shows in the Admin section the Company Name has actually been changed.

The Company name and site title are separated in 4.1.0. Company name is used in invoices. To edit Site title you need to edit the language variable 'lbl_site_name' (you can do it in the Webmaster mode or in the 'Languages' section of the admin interface)

[svowl]

Originally Posted by moneysaver67

Is MySQL 5.x support native to 4.1? If I can use MySQL 5.x w/ 4.0.18 then 4.1.x can wait!

X-Cart 4.1.0 supports MySQL 5, X-Cart 4.0.x does not support it

[svowl]

Originally Posted by bngwarehouse

Repairing table /var/tmp/#sql_63c_0...1 : Can't create/write to file '/var/tmp/#sql_63c_0.MYI' (Errcode: 13)
INVALID SQL: 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 '/var/tmp/#sql_63c_0 EXTENDED' at line 1

I think, you should ask your hosting administrator to help you configure MySQL server.

[B00MER]

Originally Posted by svowl

Please, do not post bug reports here. It will be very hard for you to find information on a specific report if all the reports will be in one thread. Post bug reports to the 'Bugs & Fixes' section, please.

Vladimir & X-Cart crew, as usual you guys are right on top of things. I will try and keep an eye on this thread for any future bug posts.

[svowl]

Originally Posted by mart

Q1: 4.1 is cannot Import DISTRIBUTION,the error when i add !DISTRIBUTION on csv file,i want to know Where i Import DISTRIBUTION?
and 3-4 Import cannot be using too

Try applying the attached patch (4.1.0).
Thank you