Main | Bug Tracker | View Issues | Change Log | Roadmap | Docs
  

Viewing Issue Simple Details [ Jump to Notes ] [ View Advanced ] [ Issue History ] [ Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0001975 [CubeCart v4] MySQL/Database major always 2010-02-08 12:47 2010-02-18 11:32
Reporter IanBucklar View Status public  
Assigned To al
Priority normal Resolution fixed  
Status resolved   Product Version 4.3.8
Summary 0001975: The eanupcCode field is a bigint (17) when it should be a varchar
Description having the eanupcCode field as a bigint strips off any leading zeros from the barcode - this should be changed to a varchar (14). All barcodes are generally 12, 13 or 14 characters long (although rarely 8 can be used)
Additional Information
Tags No tags attached.
Browser N/A
Install Method N/A
MySQL Version 5.1.x
PHP Version 5.3.x
Server OS Unknown
Skin Classic, Carreta Bright, Carreta Soft
Attached Files

- Relationships

-  Notes
User avatar (0003291)
al (administrator)
2010-02-18 11:32

 Added the following to the upgrade SQL file:
ALTER TABLE `CubeCart_inventory` CHANGE `eanupcCode` `eanupcCode` VARCHAR( 20 ) NULL DEFAULT NULL ; #EOQ

- Issue History
Date Modified Username Field Change
2010-02-08 12:47 IanBucklar New Issue
2010-02-08 12:47 IanBucklar Browser => N/A
2010-02-08 12:47 IanBucklar Install Method => N/A
2010-02-08 12:47 IanBucklar MySQL Version => 5.1.x
2010-02-08 12:47 IanBucklar PHP Version => 5.3.x
2010-02-08 12:47 IanBucklar Server OS => Unknown
2010-02-08 12:47 IanBucklar Skin => Classic, Carreta Bright, Carreta Soft
2010-02-18 11:32 al Status new => resolved
2010-02-18 11:32 al Fixed in Version => 4.3.9
2010-02-18 11:32 al Resolution open => fixed
2010-02-18 11:32 al Assigned To => al
2010-02-18 11:32 al Note Added: 0003291

Copyright © 2000 - 2008 Mantis Group
Powered by Mantis Bugtracker