X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   News and Announcements (https://forum.x-cart.com/forumdisplay.php?f=28)
-   -   X-Cart 4.1.0 released (https://forum.x-cart.com/showthread.php?t=21186)

bngwarehouse 04-25-2006 01:16 PM

Bug or just me not seeing something?
 
*********:.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 04-25-2006 01:16 PM

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. :wink:

moneysaver67 04-25-2006 04:46 PM

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 04-25-2006 05:27 PM

Your Companmy Name
 
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 04-25-2006 09:13 PM

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 04-25-2006 09:18 PM

Re: Your Companmy Name
 
Quote:

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 04-25-2006 09:21 PM

Quote:

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 04-25-2006 09:24 PM

Re: Bug or just me not seeing something?
 
Quote:

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 04-25-2006 09:42 PM

Quote:

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 04-25-2006 09:44 PM

Re: Cannot Import DISTRIBUTION
 
1 Attachment(s)
Quote:

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


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

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