OSCommerce Product Manager

OSCommerce Product Manager for Windows
Tasklist

FS#98 - Get field sizes directly from the database.

Attached to Project: OSCommerce Product Manager
Opened by Mario A. Valdez-Ramirez (mvaldez) - Saturday, 28 August 2004, 18:52 GMT-6
Last edited by Mario A. Valdez-Ramirez (mvaldez) - Monday, 06 September 2004, 02:19 GMT-6
Task Type Bug Report
Category Backend / Core
Status Closed
Assigned To Mario A. Valdez-Ramirez (mvaldez)
Operating System All
Severity Low
Priority High
Reported Version any
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

An user reported in the forums that his store uses customized field length (for the product model, at least). The OSCPMWin uses fixed values as defined in the osCommerce documentation.

Proposed solution is to read once (at start up) the field sizes from the database and use the current values as defaults only.

As there is no workaround for this, and assuming lot of OSC facilities are using modified tables, I think (on quick triage) this is Severity = "Major".
This task depends upon

Closed by  Mario A. Valdez-Ramirez (mvaldez)
Monday, 06 September 2004, 02:19 GMT-6
Reason for closing:  
Comment by Mario A. Valdez-Ramirez (mvaldez) - Saturday, 28 August 2004, 18:53 GMT-6

We can get field sizes parsing "SHOW COLUMNS FROM table".

Format of the second column (type) is datatypename(size).
Comment by Mario A. Valdez-Ramirez (mvaldez) - Monday, 06 September 2004, 02:19 GMT-6

This has proven to be more difficult than what I anticipated. Specially with the new SQL-HTTP backend I'm implementing.

I'm deferring the final solution for this. In the mean time, I'm relaxing the max field limit of the model field (which is different in the CRE Loaded 6 version of osCommerce).

Deferred. Closed.

Loading...