Forums / General Questions / Database field order - where is that file?

Database field order - where is that file?

Locked

Views: 1,094

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
24 Jun 2007, 4:43 PM
#1
kappaluppa avatar

kappaluppa

New Zenner

Join Date:
Nov 2006
Posts:
68
Plugin Contributions:
0

Database field order - where is that file?

I added fields to a database at one time and the data would not go in. Then I found a file that had all the fields for the databases with a number next to the fields that showed the order in which the data was entered. Adding the fields to this file fixed my problem.

Now I have the same problem again. But I cannot find FOR THE LIFE OF ME which file it was! :censored:

Anyone out there have a clue as to what I'm talking about... :cry:

Thanks,
K

24 Jun 2007, 5:03 PM
#2
theoracle avatar

theoracle

Suspended

Join Date:
Aug 2004
Posts:
3,180
Plugin Contributions:
1

Re: Database field order - where is that file?

I found a file that had all the fields for the databases

The core file you're referring to is from your: includes/database_tables.php file. Althought, you're not suppose to edit this file since the includes/extra_definitions folder can already support your additional table definition names (without being affected in the upgrade). :wink2:

24 Jun 2007, 5:34 PM
#3
kappaluppa avatar

kappaluppa

New Zenner

Join Date:
Nov 2006
Posts:
68
Plugin Contributions:
0

Re: Database field order - where is that file?

Thanks for your reply...

But, I checked the database_tables.php file it looks more like a 'language' file. It has a lot of defines in it.

The one I was looking for had something like

orders_id --> orders_id [1]
customer_id --> customer_id [2]
customers_name --> customers_name [3]
customers_company --> customers_company [4]

and so on. And it had it for all the tables. The number represented the field input order. But, obviously, this is not the exact wording, otherwise I would have been able to find it! lol

AND... after all that is said and done... just to put a PS on the story, I was able to get my data into the database without it. My original question was to help me figure out how to get my eCheck data in the database: http://www.zen-cart.com/forum/showthread.php?p=393949