chrometweaks.org

What is the BEST iPage web host & why?

Click Here To View All Answers...


First question I have is What is the BEST iPage web host & why? Looking forward for any answer. Another quick question... Does anyone know what is causing these errors. The first one is on the orders page which is the following.

1054 - Unknown column 'orders_status_id' in 'field list'.

Select orders_status_id, date_added, customer_notified, comments from orders_status_history where orders_id = '1' order by date_added.

[TEP STOP].

On the store admin page it gives this.

Warning: Missing argument 2 for tep_get_zone_name() in /home/kustom/public_html/catalog/admin/includes/functions/general.php on line 270.

Warning: Missing argument 3 for tep_get_zone_name() in /home/kustom/public_html/catalog/admin/includes/functions/general.php on line 270.

I cant find anything in the forums for these errors, if any one has any knowledge how to correct these it would be greatly appreciated, thanks in advanced I am running the most recent release of oscommerce..

This post has been edited by.

50mb.

: 31 August 2004, 11:59..

Comments (148)

Hmm... I need to find out myself. I don't know what is the right answer. I'll do some research in Google and get back to you if I bump into an decent answer. You should email the people at iPage as they probably can answer it..

Comment #1

Here is the zone part of the db check and see if it's right. I am not tto good with the db thanks my zone is texas.

# phpMyAdmin SQL Dump.

# version 2.5.6.

# http://www.phpmyadmin.net.

#.

# Host: localhost.

# Generation Time: Aug 31, 2004 at 10:03 AM.

# Server version: 4.0.20.

# PHP Version: 4.2.3.

#.

# Database : `kustom_catalog`.

#.

#.

#.

# Table structure for table `zones`.

#.

CREATE TABLE `zones` (.

`zone_id` int(11) NOT NULL auto_increment,.

`zone_country_id` int(11) NOT NULL default '0',.

`zone_code` varchar(32) NOT NULL default '',.

`zone_name` varchar(32) NOT NULL default '',.

PRIMARY KEY (`zone_id`).

) TYPE=MyISAM AUTO_INCREMENT=182;.

#.

# Dumping data for table `zones`.

#.

INSERT INTO `zones` VALUES (1, 223, 'AL', 'Alabama');.

INSERT INTO `zones` VALUES (2, 223, 'AK', 'Alaska');.

INSERT INTO `zones` VALUES (3, 223, 'AS', 'American Samoa');.

INSERT INTO `zones` VALUES (4, 223, 'AZ', 'Arizona');.

INSERT INTO `zones` VALUES (5, 223, 'AR', 'Arkansas');.

INSERT INTO `zones` VALUES (6, 223, 'AF', 'Armed Forces Africa');.

INSERT INTO `zones` VALUES (7, 223, 'AA', 'Armed Forces Americas');.

INSERT INTO `zones` VALUES (8, 223, 'AC', 'Armed Forces Canada');.

INSERT INTO `zones` VALUES (9, 223, 'AE', 'Armed Forces Europe');.

INSERT INTO `zones` VALUES (10, 223, 'AM', 'Armed Forces Middle East');.

INSERT INTO `zones` VALUES (11, 223, 'AP', 'Armed Forces Pacific');.

INSERT INTO `zones` VALUES (12, 223, 'CA', 'California');.

INSERT INTO `zones` VALUES (13, 223, 'CO', 'Colorado');.

INSERT INTO `zones` VALUES (14, 223, 'CT', 'Connecticut');.

INSERT INTO `zones` VALUES (15, 223, 'DE', 'Delaware');.

INSERT INTO `zones` VALUES (16, 223, 'DC', 'District of Columbia');.

INSERT INTO `zones` VALUES (17, 223, 'FM', 'Federated States Of Micronesia');.

INSERT INTO `zones` VALUES (18, 223, 'FL', 'Florida');.

INSERT INTO `zones` VALUES (19, 223, 'GA', 'Georgia');.

INSERT INTO `zones` VALUES (20, 223, 'GU', 'Guam');.

INSERT INTO `zones` VALUES (21, 223, 'HI', 'Hawaii');.

INSERT INTO `zones` VALUES (22, 223, 'ID', 'Idaho');.

INSERT INTO `zones` VALUES (23, 223, 'IL', 'Illinois');.

INSERT INTO `zones` VALUES (24, 223, 'IN', 'Indiana');.

INSERT INTO `zones` VALUES (25, 223, 'IA', 'Iowa');.

INSERT INTO `zones` VALUES (26, 223, 'KS', 'Kansas');.

INSERT INTO `zones` VALUES (27, 223, 'KY', 'Kentucky');.

INSERT INTO `zones` VALUES (28, 223, 'LA', 'Louisiana');.

INSERT INTO `zones` VALUES (29, 223, 'ME', 'Maine');.

INSERT INTO `zones` VALUES (30, 223, 'MH', 'Marshall Islands');.

INSERT INTO `zones` VALUES (31, 223, 'MD', 'Maryland');.

INSERT INTO `zones` VALUES (32, 223, 'MA', 'Massachusetts');.

INSERT INTO `zones` VALUES (33, 223, 'MI', 'Michigan');.

INSERT INTO `zones` VALUES (34, 223, 'MN', 'Minnesota');.

INSERT INTO `zones` VALUES (35, 223, 'MS', 'Mississippi');.

INSERT INTO `zones` VALUES (36, 223, 'MO', 'Missouri');.

INSERT INTO `zones` VALUES (37, 223, 'MT', 'Montana');.

INSERT INTO `zones` VALUES (38, 223, 'NE', 'Nebraska');.

INSERT INTO `zones` VALUES (39, 223, 'NV', 'Nevada');.

INSERT INTO `zones` VALUES (40, 223, 'NH', 'New Hampshire');.

INSERT INTO `zones` VALUES (41, 223, 'NJ', 'New Jersey');.

INSERT INTO `zones` VALUES (42, 223, 'NM', 'New Mexico');.

INSERT INTO `zones` VALUES (43, 223, 'NY', 'New York');.

INSERT INTO `zones` VALUES (44, 223, 'NC', 'North Carolina');.

INSERT INTO `zones` VALUES (45, 223, 'ND', 'North Dakota');.

INSERT INTO `zones` VALUES (46, 223, 'MP', 'Northern Mariana Islands');.

INSERT INTO `zones` VALUES (47, 223, 'OH', 'Ohio');.

INSERT INTO `zones` VALUES (48, 223, 'OK', 'Oklahoma');.

INSERT INTO `zones` VALUES (49, 223, 'OR', 'Oregon');.

INSERT INTO `zones` VALUES (50, 223, 'PW', 'Palau');.

INSERT INTO `zones` VALUES (51, 223, 'PA', 'Pennsylvania');.

INSERT INTO `zones` VALUES (52, 223, 'PR', 'Puerto Rico');.

INSERT INTO `zones` VALUES (53, 223, 'RI', 'Rhode Island');.

INSERT INTO `zones` VALUES (54, 223, 'SC', 'South Carolina');.

INSERT INTO `zones` VALUES (55, 223, 'SD', 'South Dakota');.

INSERT INTO `zones` VALUES (56, 223, 'TN', 'Tennessee');.

INSERT INTO `zones` VALUES (57, 223, 'TX', 'Texas');.

INSERT INTO `zones` VALUES (58, 223, 'UT', 'Utah');.

INSERT INTO `zones` VALUES (59, 223, 'VT', 'Vermont');.

INSERT INTO `zones` VALUES (60, 223, 'VI', 'Virgin Islands');.

INSERT INTO `zones` VALUES (61, 223, 'VA', 'Virginia');.

INSERT INTO `zones` VALUES (62, 223, 'WA', 'Washington');.

INSERT INTO `zones` VALUES (63, 223, 'WV', 'West Virginia');.

INSERT INTO `zones` VALUES (64, 223, 'WI', 'Wisconsin');.

INSERT INTO `zones` VALUES (65, 223, 'WY', 'Wyoming');.

INSERT INTO `zones` VALUES (66, 38, 'AB', 'Alberta');.

INSERT INTO `zones` VALUES (67, 38, 'BC', 'British Columbia');.

INSERT INTO `zones` VALUES (68, 38, 'MB', 'Manitoba');.

INSERT INTO `zones` VALUES (69, 38, 'NF', 'Newfoundland');.

INSERT INTO `zones` VALUES (70, 38, 'NB', 'New Brunswick');.

INSERT INTO `zones` VALUES (71, 38, 'NS', 'Nova Scotia');.

INSERT INTO `zones` VALUES (72, 38, 'NT', 'Northwest Territories');.

INSERT INTO `zones` VALUES (73, 38, 'NU', 'Nunavut');.

INSERT INTO `zones` VALUES (74, 38, 'ON', 'Ontario');.

INSERT INTO `zones` VALUES (75, 38, 'PE', 'Prince Edward Island');.

INSERT INTO `zones` VALUES (76, 38, 'QC', 'Quebec');.

INSERT INTO `zones` VALUES (77, 38, 'SK', 'Saskatchewan');.

INSERT INTO `zones` VALUES (78, 38, 'YT', 'Yukon Territory');.

INSERT INTO `zones` VALUES (79, 81, 'NDS', 'Niedersachsen');.

INSERT INTO `zones` VALUES (80, 81, 'BAW', 'Baden-Wrttemberg');.

INSERT INTO `zones` VALUES (81, 81, 'BAY', 'Bayern');.

INSERT INTO `zones` VALUES (82, 81, 'BER', 'Berlin');.

INSERT INTO `zones` VALUES (83, 81, 'BRG', 'Brandenburg');.

INSERT INTO `zones` VALUES (84, 81, 'BRE', 'Bremen');.

INSERT INTO `zones` VALUES (85, 81, 'HAM', 'Hamburg');.

INSERT INTO `zones` VALUES (86, 81, 'HES', 'Hessen');.

INSERT INTO `zones` VALUES (87, 81, 'MEC', 'Mecklenburg-Vorpommern');.

INSERT INTO `zones` VALUES (88, 81, 'NRW', 'Nordrhein-Westfalen');.

INSERT INTO `zones` VALUES (89, 81, 'RHE', 'Rheinland-Pfalz');.

INSERT INTO `zones` VALUES (90, 81, 'SAR', 'Saarland');.

INSERT INTO `zones` VALUES (91, 81, 'SAS', 'Sachsen');.

INSERT INTO `zones` VALUES (92, 81, 'SAC', 'Sachsen-Anhalt');.

INSERT INTO `zones` VALUES (93, 81, 'SCN', 'Schleswig-Holstein');.

INSERT INTO `zones` VALUES (94, 81, 'THE', 'Thringen');.

INSERT INTO `zones` VALUES (95, 14, 'WI', 'Wien');.

INSERT INTO `zones` VALUES (96, 14, 'NO', 'Niedersterreich');.

INSERT INTO `zones` VALUES (97, 14, 'OO', 'Obersterreich');.

INSERT INTO `zones` VALUES (98, 14, 'SB', 'Salzburg');.

INSERT INTO `zones` VALUES (99, 14, 'KN', 'Krnten');.

INSERT INTO `zones` VALUES (100, 14, 'ST', 'Steiermark');.

INSERT INTO `zones` VALUES (101, 14, 'TI', 'Tirol');.

INSERT INTO `zones` VALUES (102, 14, 'BL', 'Burgenland');.

INSERT INTO `zones` VALUES (103, 14, 'VB', 'Voralberg');.

INSERT INTO `zones` VALUES (104, 204, 'AG', 'Aargau');.

INSERT INTO `zones` VALUES (105, 204, 'AI', 'Appenzell Innerrhoden');.

INSERT INTO `zones` VALUES (106, 204, 'AR', 'Appenzell Ausserrhoden');.

INSERT INTO `zones` VALUES (107, 204, 'BE', 'Bern');.

INSERT INTO `zones` VALUES (108, 204, 'BL', 'Basel-Landschaft');.

INSERT INTO `zones` VALUES (109, 204, 'BS', 'Basel-Stadt');.

INSERT INTO `zones` VALUES (110, 204, 'FR', 'Freiburg');.

INSERT INTO `zones` VALUES (111, 204, 'GE', 'Genf');.

INSERT INTO `zones` VALUES (112, 204, 'GL', 'Glarus');.

INSERT INTO `zones` VALUES (113, 204, 'JU', 'Graubnden');.

INSERT INTO `zones` VALUES (114, 204, 'JU', 'Jura');.

INSERT INTO `zones` VALUES (115, 204, 'LU', 'Luzern');.

INSERT INTO `zones` VALUES (116, 204, 'NE', 'Neuenburg');.

INSERT INTO `zones` VALUES (117, 204, 'NW', 'Nidwalden');.

INSERT INTO `zones` VALUES (118, 204, 'OW', 'Obwalden');.

INSERT INTO `zones` VALUES (119, 204, 'SG', 'St. Gallen');.

INSERT INTO `zones` VALUES (120, 204, 'SH', 'Schaffhausen');.

INSERT INTO `zones` VALUES (121, 204, 'SO', 'Solothurn');.

INSERT INTO `zones` VALUES (122, 204, 'SZ', 'Schwyz');.

INSERT INTO `zones` VALUES (123, 204, 'TG', 'Thurgau');.

INSERT INTO `zones` VALUES (124, 204, 'TI', 'Tessin');.

INSERT INTO `zones` VALUES (125, 204, 'UR', 'Uri');.

INSERT INTO `zones` VALUES (126, 204, 'VD', 'Waadt');.

INSERT INTO `zones` VALUES (127, 204, 'VS', 'Wallis');.

INSERT INTO `zones` VALUES (128, 204, 'ZG', 'Zug');.

INSERT INTO `zones` VALUES (129, 204, 'ZH', 'Zrich');.

INSERT INTO `zones` VALUES (130, 195, 'Alava', 'Alava');.

INSERT INTO `zones` VALUES (131, 195, 'Malaga', 'Malaga');.

INSERT INTO `zones` VALUES (132, 195, 'Segovia', 'Segovia');.

INSERT INTO `zones` VALUES (133, 195, 'Granada', 'Granada');.

INSERT INTO `zones` VALUES (134, 195, 'Jaen', 'Jaen');.

INSERT INTO `zones` VALUES (135, 195, 'Sevilla', 'Sevilla');.

INSERT INTO `zones` VALUES (136, 195, 'Barcelona', 'Barcelona');.

INSERT INTO `zones` VALUES (137, 195, 'Valencia', 'Valencia');.

INSERT INTO `zones` VALUES (138, 195, 'Alicante', 'Alicante');.

INSERT INTO `zones` VALUES (139, 195, 'Almeria', 'Almeria');.

INSERT INTO `zones` VALUES (140, 195, 'Asturias', 'Asturias');.

INSERT INTO `zones` VALUES (141, 195, 'Avila', 'Avila');.

INSERT INTO `zones` VALUES (142, 195, 'Badajoz', 'Badajoz');.

INSERT INTO `zones` VALUES (143, 195, 'Burgos', 'Burgos');.

INSERT INTO `zones` VALUES (144, 195, 'Caceres', 'Caceres');.

INSERT INTO `zones` VALUES (145, 195, 'Cadiz', 'Cadiz');.

INSERT INTO `zones` VALUES (146, 195, 'Cantabria', 'Cantabria');.

INSERT INTO `zones` VALUES (147, 195, 'Castellon', 'Castellon');.

INSERT INTO `zones` VALUES (148, 195, 'Ceuta', 'Ceuta');.

INSERT INTO `zones` VALUES (149, 195, 'Ciudad Real', 'Ciudad Real');.

INSERT INTO `zones` VALUES (150, 195, 'Cordoba', 'Cordoba');.

INSERT INTO `zones` VALUES (151, 195, 'Cuenca', 'Cuenca');.

INSERT INTO `zones` VALUES (152, 195, 'Girona', 'Girona');.

INSERT INTO `zones` VALUES (153, 195, 'Las Palmas', 'Las Palmas');.

INSERT INTO `zones` VALUES (154, 195, 'Guadalajara', 'Guadalajara');.

INSERT INTO `zones` VALUES (155, 195, 'Guipuzcoa', 'Guipuzcoa');.

INSERT INTO `zones` VALUES (156, 195, 'Huelva', 'Huelva');.

INSERT INTO `zones` VALUES (157, 195, 'Huesca', 'Huesca');.

INSERT INTO `zones` VALUES (158, 195, 'A Corua', 'A Corua');.

INSERT INTO `zones` VALUES (159, 195, 'La Rioja', 'La Rioja');.

INSERT INTO `zones` VALUES (160, 195, 'Leon', 'Leon');.

INSERT INTO `zones` VALUES (161, 195, 'Lugo', 'Lugo');.

INSERT INTO `zones` VALUES (162, 195, 'Lleida', 'Lleida');.

INSERT INTO `zones` VALUES (163, 195, 'Madrid', 'Madrid');.

INSERT INTO `zones` VALUES (164, 195, 'Baleares', 'Baleares');.

INSERT INTO `zones` VALUES (165, 195, 'Cantabria', 'Cantabria');.

INSERT INTO `zones` VALUES (166, 195, 'Murcia', 'Murcia');.

INSERT INTO `zones` VALUES (167, 195, 'Navarra', 'Navarra');.

INSERT INTO `zones` VALUES (168, 195, 'Ourense', 'Ourense');.

INSERT INTO `zones` VALUES (169, 195, 'Palencia', 'Palencia');.

INSERT INTO `zones` VALUES (170, 195, 'Pontevedra', 'Pontevedra');.

INSERT INTO `zones` VALUES (171, 195, 'Salamanca', 'Salamanca');.

INSERT INTO `zones` VALUES (172, 195, 'Soria', 'Soria');.

INSERT INTO `zones` VALUES (173, 195, 'Tarragona', 'Tarragona');.

INSERT INTO `zones` VALUES (174, 195, 'Tenerife', 'Tenerife');.

INSERT INTO `zones` VALUES (175, 195, 'Teruel', 'Teruel');.

INSERT INTO `zones` VALUES (176, 195, 'Toledo', 'Toledo');.

INSERT INTO `zones` VALUES (177, 195, 'Valladolid', 'Valladolid');.

INSERT INTO `zones` VALUES (178, 195, 'Vizcaya', 'Vizcaya');.

INSERT INTO `zones` VALUES (179, 195, 'Zamora', 'Zamora');.

INSERT INTO `zones` VALUES (180, 195, 'Zaragoza', 'Zaragoza');.

INSERT INTO `zones` VALUES (181, 195, 'Melilla', 'Melilla');.

Thanks in advance.

What about the orders page is there a fix for that?.

This post has been edited by.

50mb.

: 31 August 2004, 15:06..

Comment #2

Hi,.

Can you dump the shema for the table "orders_status_history" please..

Regards zones, "Texas" is defined as:.

INSERT INTO `zones` VALUES (57, 223, 'TX', 'Texas');.

And there is some good info here:.

Http://www.oscommerc.../kb?search=zone.

About zones. From memory, the 'deafult' store has only Florida, and as you can see by the default setup SQL code:.

# USA/Florida.

INSERT INTO tax_rates VALUES (1, 1, 1, 1, 7.0, 'FL TAX 7.0%', now(), now());.

INSERT INTO geo_zones (geo_zone_id,geo_zone_name,geo_zone_description,date_added) VALUES (1,"Florida","Florida local sales tax zone",now());.

INSERT INTO zones_to_geo_zones (association_id,zone_country_id,zone_id,geo_zone_id,date_added) VALUES (1,223,18,1,now());.

That is why only Florida is setup. You need Texas, so you would have to do similar under admin (I assume)..

1. Add the tax rate.

2. Add the 'geo zone'.

3. Associate the zone (Texas) to the 'geo zone'.

Peter..

Comment #3

I dont understand what dump the shema is so can you please be more specific. I was in the database under phpmyadmin and I didnt see thw ord shema, please be more specfic on that, ok I entered the code you told me to and it said duplicate entry, so what now? thanks.

To help you out this db is from the old setup, I was told it would work, so I hope it can be fixed.

This post has been edited by.

50mb.

: 01 September 2004, 04:53..

Comment #4

I have dunped the complete zonea nd reinserted and the error is satill there. I repolaced the od with the new one from 2.2 and it's still has an error aggravaiting..

Comment #5

Hi,.

1. phpmyadmin.

2. EXPORT tab.

3. Check 'save as file".

4. Press GO.

And then look in the file that has been exported, for the table called "orders_status_history".

Hmm, .. but you stated in your first post in this thread .......

????.

Peter..

Comment #6

Would linkpoint addon cause this somehow? yes most recent release but the old db from the old setup store is way to big to redo so I asked in here and they said it would work I have only 3 errors.

Cant find curl.

The zone and orders page.

But here is the iPage site if you wan to see it.

Http://www.nskustomp...nce.com/catalog.

And here is a pic of the error page it's on.

Http://www.nskustomp...om/untitled.JPG.

Hope I explained this right lol thanks.

This post has been edited by.

50mb.

: 01 September 2004, 05:13..

Comment #7

Hi,.

Have you done this, it would appear not ??.

Peter..

Comment #8

I dunno what the geo zone would be 223? 195? I'm not sure what the 3rd one means lol, I am sorry to be a pest I'm new at this and I'm doing my best to do it on my own but it just isnt working and where can I find what to do to the .pem file thanks..

Comment #9

Hi,.

Please read this:.

Http://www.oscommerce.info/kb/osCommerce/A...s_and_Taxes/169.

And set the tax zone up for Texas..

The error you are getting under admin is this line ..........

 function tep_get_zone_name($country_id, $zone_id, $default_zone) {.

So both:.

$zone_id.

$default_zone.

Are missing, when parsed as arguments, when this function is called..

Peter..

Comment #10

Ok I followed that link id did everything it told me to, ok I added the tax zones and all but there is still something missing, do I have to add something to the db? below is apic of the proof that texas is in the db but maybe I am doing something wrong or forgot to add something,.

Http://www.nskustomp....com/zone-1.JPG..

Comment #11

Fixed!!.

I backed up all the products etc and removed the rest did a fresh install of the recent db and it fixed the zone part. I really appreciate your help on that, now if there is a way to make this curl thing work I prolly be set, I have read many many forums and cant seem to find the fix for this to make it work, curl is enabled under server status, I edited a file that I found in the forums and it wont work for me and it's the same version they are using if any ideas from you once more I would really appreciate it , thanks in advance..

Comment #12

Hi,.

Good that it is fixed, you must be relieved..

I know nothing about curl, except that when I had lots of hair, then there were curls as well..

When you say it won't work, is there an error message to trace the cause ??.

Peter..

Comment #13

The curl problem has been fixed as well thanks for your help.

This post has been edited by.

50mb.

: 02 September 2004, 11:15..

Comment #14

Does anyone know what is causing these errors. The first one is on the orders page which is the following.

1054 - Unknown column 'orders_status_id' in 'field list'.

Select orders_status_id, date_added, customer_notified, comments from orders_status_history where orders_id = '1' order by date_added.

[TEP STOP].

On the store admin page it gives this.

Warning: Missing argument 2 for tep_get_zone_name() in /home/kustom/public_html/catalog/admin/includes/functions/general.php on line 270.

Warning: Missing argument 3 for tep_get_zone_name() in /home/kustom/public_html/catalog/admin/includes/functions/general.php on line 270.

I cant find anything in the forums for these errors, if any one has any knowledge how to correct these it would be greatly appreciated, thanks in advanced I am running the most recent release of oscommerce..

This post has been edited by.

50mb.

: 31 August 2004, 11:59..

Comment #15

Hi,.

Here is the schema for that table, and the column should be there ??.

CREATE TABLE orders_status_history (.

  orders_status_history_id int NOT NULL auto_increment,.

  orders_id int NOT NULL,.

  orders_status_id int(5) NOT NULL,.

  date_added datetime NOT NULL,.

  customer_notified int(1) DEFAULT '0',.

  comments text,.

  PRIMARY KEY (orders_status_history_id).

);.

Can yu check the db, to see if the column is in that tbale ? .

Peter..

Comment #16


This question was taken from a support group/message board and re-posted here so others can learn from it.