Lots of errors and warnings

Today just isn't my day!

ok the only changes I made were to the shipping module for "zone rates" I reset up my table rates. I tested it once after putting a few rates in and it worked fine then added the whole kit&caboodle and now when i go to the cart it seems fine until i click a category and I get these errors at the top

Warning: Variable passed to each() is not an array or object in /home/protect/public_html/includes/classes/db/mysql/query_factory.php on line 114

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/protect/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/protect/public_html/includes/functions/sessions.php on line 102

Warning: Cannot modify header information - headers already sent by (output started at /home/protect/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/protect/public_html/includes/init_includes/init_templates.php on line 78

and this where the products should be

Warning: Division by zero in /home/protect/public_html/includes/classes/split_page_results.php on line 76
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 '-0, MAX_DISPLAY_PRODUCTS_LISTING' at line 7
in:
[select p.products_quantity, p.products_id, p.products_type, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from protect_products_description pd, protect_products p left join protect_manufacturers m on p.manufacturers_id = m.manufacturers_id, protect_products_to_categories p2c left join protect_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '8' limit -0, MAX_DISPLAY_PRODUCTS_LISTING]

anyone with any help would be my hero for the day.

the only thing i can think of is that maybe the table rate is too large? for example here is my table rates for zone 1 which is the US

(yes i know it's ALOT but i gotta do what i gotta do until shipping can be based on categories) in case you are wondering all products that are non-hidden cameras are listed as weight0.01 and all hidden camera products are listed as weight 1 thats why the table is so large just in case so fool orders up to 99 products or 15 hidden cameras and then this is pretty much duplicated for zone 2 (Canada) and zone 3 (intern'l) just with different prices

message is too long please con't to next post

here goes

Zone 1 Countries
US

Zone 1 Shipping Table
0.01:1.00, 0.02:2.00, 0.03:3.00, 0.04:4.00, 0.05:5.00, 0.06:6.00, 0.07:7.00, 0.08:8.00, 0.09:9.00, 0.10:10.00, 0.11:11.00, 0.12:12.00, 0.13:13.00, 0.14:14.00, 0.15:15.00, 0.16:16.00, 0.17:17.00, 0.18:18.00, 0.19:19.00, 0.20:20.00, 0.21:21.00, 0.22:22.00, 0.23:23.00, 0.24:24.00, 0.25:25.00, 0.26:26.00, 0.27:27.00, 0.28:28.00, 0.29:29.00, 0.30:30.00, 0.31:31.00, 0.32:32.00, 0.33:33.00, 0.34:34.00, 0.35:35.00, 0.36:36.00, 0.37:37.00, 0.38:38.00, 0.39:39.00, 0.40:40.00, 0.41:41.00, 0.42:42.00, 0.43:43.00, 0.44:44.00, 0.45:45.00, 0.46:46.00, 0.47:47.00, 0.48:48.00, 0.49:49.00, 0.50:50.00, 0.51:51.00, 0.52:52.00, 0.53:53.00, 0.54:54.00, 0.55:55.00, 0.56:56.00, 0.57:57.00, 0.58:58.00, 0.59:59.00, 0.60:60.00, 0.61:61.00, 0.62:62.00, 0.63:63.00, 0.64:64.00, 0.65:65.00, 0.66:66.00, 0.67:67.00, 0.68:68.00, 0.69:69.00, 0.70:70.00, 0.71:71.00, 0.72:72.00, 0.73:73.00, 0.74:74.00, 0.75:75.00, 0.76:76.00, 0.77:77.00, 0.78:78.00, 0.79:79.00, 0.80:80.00, 0.81:81.00, 0.82:82.00, 0.83:83.00, 0.84:84.00, 0.85:85.00, 0.86:86.00, 0.87:87.00, 0.88:88.00, 0.89:89.00, 0.90:90.00, 0.91:91.00, 0.92:92.00, 0.93:93.00, 0.94:94.00, 0.95:95.00, 0.96:96.00, 0.97:97.00, 0.98:98.00, 0.99:99.00, 1.00:4.50, 1.01:11.00, 1.02:12.00, 1.03:13.00, 1.04:14.00, 1.05:15.00, 1.06:16.00, 1.07:17.00, 1.08:18.00, 1.09:19.00, 1.10:20.00, 1.11:21.00, 1.12:22.00, 1.13:23.00, 1.14:24.00, 1.15:25.00, 1.16:26.00, 1.17:27.00, 1.18:28.00, 1.19:29.00, 1.20:30.00, 1.21:31.00, 1.22:32.00, 1.23:33.00, 1.24:34.00, 1.25:35.00, 1.26:36.00, 1.27:37.00, 1.28:38.00, 1.29:39.00, 1.30:40.00, 1.31:41.00, 1.32:42.00, 1.33:43.00, 1.34:44.00, 1.35:45.00, 1.36:46.00, 1.37:47.00, 1.38:48.00, 1.39:49.00, 1.40:50.00, 1.41:51.00, 1.42:52.00, 1.43:53.00, 1.44:54.00, 1.45:55.00, 1.46:56.00, 1.47:57.00, 1.48:58.00, 1.49:59.00, 1.50:60.00, 1.51:61.00, 1.52:62.00, 1.53:63.00, 1.54:64.00, 1.55:65.00, 1.56:66.00, 1.57:67.00, 1.58:68.00, 1.59:69.00, 1.60:70.00, 1.61:71.00, 1.62:72.00, 1.63:73.00, 1.64:74.00, 1.65:75.00, 1.66:76.00, 1.67:77.00, 1.68:78.00, 1.69:79.00, 1.70:80.00, 1.71:81.00, 1.72:82.00, 1.73:83.00, 1.74:84.00, 1.75:85.00, 1.76:86.00, 1.77:87.00, 1.78:88.00, 1.79:89.00, 1.80:90.00, 1.81:91.00, 1.82:92.00, 1.83:93.00, 1.84:94.00, 1.85:95.00, 1.86:96.00, 1.87:97.00, 1.88:98.00, 1.89:99.00, 1.90:100.00, 1.91:101.00, 1.92:102.00, 1.93:103.00, 1.94:104.00, 1.95:105.00, 1.96:106.00, 1.97:107.00, 1.98:108.00, 1.99:109.00, 2.00:12.50, 2.01:19.00, 2.02:20.00, 2.03:21.00, 2.04:22.00, 2.05:23.00, 2.06:24.00, 2.07:25.00, 2.08:26.00, 2.09:27.00, 2.10:28.00, 2.11:29.00, 2.12:30.00, 2.13:31.00, 2.14:32.00, 2.15:33.00, 2.16:34.00, 2.17:35.00, 2.18:36.00, 2.19:37.00, 2.20:38.00, 2.21:39.00, 2.22:40.00, 2.23:41.00, 2.24:42.00, 2.25:43.00, 2.26:44.00, 2.27:45.00, 2.28:46.00, 2.29:47.00, 2.30:48.00, 2.31:49.00, 2.32:50.00, 2.33:51.00, 2.34:52.00, 2.35:53.00, 2.36:54.00, 2.37:55.00, 2.38:56.00, 2.39:57.00, 2.40:58.00, 2.41:59.00, 2.42:60.00, 2.43:61.00, 2.44:62.00, 2.45:63.00, 2.46:64.00, 2.47:65.00, 2.48:66.00, 2.49:67.00, 2.50:68.00, 2.51:69.00, 2.52:70.00, 2.53:71.00, 2.54:72.00, 2.55:73.00, 2.56:74.00, 2.57:75.00, 2.58:76.00, 2.59:77.00, 2.60:78.00, 2.61:79.00, 2.62:80.00, 2.63:81.00, 2.64:82.00, 2.65:83.00, 2.66:84.00, 2.67:85.00, 2.68:86.00, 2.69:87.00, 2.70:88.00, 2.71:89.00, 2.72:90.00, 2.73:91.00, 2.74:92.00, 2.75:93.00, 2.76:94.00, 2.77:95.00, 2.78:96.00, 2.79:97.00, 2.80:98.00, 2.81:99.00, 2.82:100.00, 2.83:101.00, 2.84:102.00, 2.85:103.00, 2.86:104.00, 2.87:105.00, 2.88:106.00, 2.89:107.00, 2.90:108.00, 2.91:109.00, 2.92:110.00, 2.93:111.00, 2.94:112.00, 2.95:113.00, 2.96:114.00, 2.97:115.00, 2.98:116.00, 2.99:117.00, 3.00:20.50, 3.01:27.00, 3.02:28.00, 3.03:29.00, 3.04:30.00, 3.05:31.00, 3.06:32.00, 3.07:33.00, 3.08:34.00, 3.09:35.00, 3.10:36.00, 3.11:37.00, 3.12:38.00, 3.13:39.00, 3.14:40.00, 3.15:41.00, 3.16:42.00, 3.17:43.00, 3.18:44.00, 3.19:45.00, 3.20:46.00, 3.21:47.00, 3.22:48.00, 3.23:49.00, 3.24:50.00, 3.25:51.00, 3.26:52.00, 3.27:53.00, 3.28:54.00, 3.29:55.00, 3.30:56.00, 3.31:57.00, 3.32:58.00, 3.33:59.00, 3.34:60.00, 3.35:61.00, 3.36:62.00, 3.37:63.00, 3.38:64.00, 3.39:65.00, 3.40:66.00, 3.41:67.00, 3.42:68.00, 3.43:69.00, 3.44:70.00, 3.45:71.00, 3.46:72.00, 3.47:73.00, 3.48:74.00, 3.49:75.00, 3.50:76.00, 3.51:77.00, 3.52:78.00, 3.53:79.00, 3.54:80.00, 3.55:81.00, 3.56:82.00, 3.57:83.00, 3.58:84.00, 3.59:85.00, 3.60:86.00, 3.61:87.00, 3.62:88.00, 3.63:89.00, 3.64:90.00, 3.65:91.00, 3.66:92.00, 3.67:93.00, 3.68:94.00, 3.69:95.00, 3.70:96.00, 3.71:97.00, 3.72:98.00, 3.73:99.00, 3.74:100.00, 3.75:101.00, 3.76:102.00, 3.77:103.00, 3.78:104.00, 3.79:105.00, 3.80:106.00, 3.81:107.00, 3.82:108.00, 3.83:109.00, 3.84:110.00, 3.85:111.00, 3.86:112.00, 3.87:113.00, 3.88:114.00, 3.89:115.00, 3.90:116.00, 3.91:117.00, 3.92:118.00, 3.93:119.00, 3.94:120.00, 3.95:121.00, 3.96:122.00, 3.97:123.00, 3.98:124.00, 3.99:125.00, 4.00:28.50, 4.01:35.00, 4.02:36.00, 4.03:37.00, 4.04:38.00, 4.05:39.00, 4.06:40.00, 4.07:41.00, 4.08:42.00, 4.09:43.00, 4.10:44.00, 4.11:45.00, 4.12:46.00, 4.13:47.00, 4.14:48.00, 4.15:49.00, 4.16:50.00, 4.17:51.00, 4.18:52.00, 4.19:53.00, 4.20:54.00, 4.21:55.00, 4.22:56.00, 4.23:57.00, 4.24:58.00, 4.25:59.00, 4.26:60.00, 4.27:61.00, 4.28:62.00, 4.29:63.00, 4.30:64.00, 4.31:65.00, 4.32:66.00, 4.33:67.00, 4.34:68.00, 4.35:69.00, 4.36:70.00, 4.37:71.00, 4.38:72.00, 4.39:73.00, 4.40:74.00, 4.41:75.00, 4.42:76.00, 4.43:77.00, 4.44:78.00, 4.45:79.00, 4.46:80.00, 4.47:81.00, 4.48:82.00, 4.49:83.00, 4.50:84.00, 4.51:85.00, 4.52:86.00, 4.53:87.00, 4.54:88.00, 4.55:89.00, 4.56:90.00, 4.57:91.00, 4.58:92.00, 4.59:93.00, 4.60:94.00, 4.61:95.00, 4.62:96.00, 4.63:97.00, 4.64:98.00, 4.65:99.00, 4.66:100.00, 4.67:101.00, 4.68:102.00, 4.69:103.00, 4.70:104.00, 4.71:105.00, 4.72:106.00, 4.73:107.00, 4.74:108.00, 4.75:109.00, 4.76:110.00, 4.77:111.00, 4.78:112.00, 4.79:113.00, 4.80:114.00, 4.81:115.00, 4.82:116.00, 4.83:117.00, 4.84:118.00, 4.85:119.00, 4.86:120.00, 4.87:121.00, 4.88:122.00, 4.89:123.00, 4.90:124.00, 4.91:125.00, 4.92:126.00, 4.93:127.00, 4.94:128.00, 4.95:129.00, 4.96:130.00, 4.97:131.00, 4.98:132.00, 4.99:133.00, 5.00:36.50, 5.01:43.00, 5.02:44.00, 5.03:45.00, 5.04:46.00, 5.05:47.00, 5.06:48.00, 5.07:49.00, 5.08:50.00, 5.09:51.00, 5.10:52.00, 5.11:53.00, 5.12:54.00, 5.13:55.00, 5.14:56.00, 5.15:57.00, 5.16:58.00, 5.17:59.00, 5.18:60.00, 5.19:61.00, 5.20:62.00, 5.21:63.00, 5.22:64.00, 5.23:65.00, 5.24:66.00, 5.25:67.00, 5.26:68.00, 5.27:69.00, 5.28:70.00, 5.29:71.00, 5.30:72.00, 5.31:73.00, 5.32:74.00, 5.33:75.00, 5.34:76.00, 5.35:77.00, 5.36:78.00, 5.37:79.00, 5.38:80.00, 5.39:81.00, 5.40:82.00, 5.41:83.00, 5.42:84.00, 5.43:85.00, 5.44:86.00, 5.45:87.00, 5.46:88.00, 5.47:89.00, 5.48:90.00, 5.49:91.00, 5.50:92.00, 5.51:93.00, 5.52:94.00, 5.53:95.00, 5.54:96.00, 5.55:97.00, 5.56:98.00, 5.57:99.00, 5.58:100.00, 5.59:101.00, 5.60:102.00, 5.61:103.00, 5.62:104.00, 5.63:105.00, 5.64:106.00, 5.65:107.00, 5.66:108.00, 5.67:109.00, 5.68:110.00, 5.69:111.00, 5.70:112.00, 5.71:113.00, 5.72:114.00, 5.73:115.00, 5.74:116.00, 5.75:117.00, 5.76:118.00, 5.77:119.00, 5.78:120.00, 5.79:121.00, 5.80:122.00, 5.81:123.00, 5.82:124.00, 5.83:125.00, 5.84:126.00, 5.85:127.00, 5.86:128.00, 5.87:129.00, 5.88:130.00, 5.89:131.00, 5.90:132.00, 5.91:133.00, 5.92:134.00, 5.93:135.00, 5.94:136.00, 5.95:137.00, 5.96:138.00, 5.97:139.00, 5.98:140.00, 5.99:141.00, 6.00:44.50, 6.01:51.00, 6.02:52.00, 6.03:53.00, 6.04:54.00, 6.05:55.00, 6.06:56.00, 6.07:57.00, 6.08:58.00, 6.09:59.00, 6.10:60.00, 6.11:61.00, 6.12:62.00, 6.13:63.00, 6.14:64.00, 6.15:65.00, 6.16:66.00, 6.17:67.00, 6.18:68.00, 6.19:69.00, 6.20:70.00, 6.21:71.00, 6.22:72.00, 6.23:73.00, 6.24:74.00, 6.25:75.00, 6.26:76.00, 6.27:77.00, 6.28:78.00, 6.29:79.00, 6.30:80.00, 6.31:81.00, 6.32:82.00, 6.33:83.00, 6.34:84.00, 6.35:85.00, 6.36:86.00, 6.37:87.00, 6.38:88.00, 6.39:89.00, 6.40:90.00, 6.41:91.00, 6.42:92.00, 6.43:93.00, 6.44:94.00, 6.45:95.00, 6.46:96.00, 6.47:97.00, 6.48:98.00, 6.49:99.00, 6.50:100.00, 6.51:101.00, 6.52:102.00, 6.53:103.00, 6.54:104.00, 6.55:105.00, 6.56:106.00, 6.57:107.00, 6.58:108.00, 6.59:109.00, 6.60:110.00, 6.61:111.00, 6.62:112.00, 6.63:113.00, 6.64:114.00, 6.65:115.00, 6.66:116.00, 6.67:117.00, 6.68:118.00, 6.69:119.00, 6.70:120.00, 6.71:121.00, 6.72:122.00, 6.73:123.00, 6.74:124.00, 6.75:125.00, 6.76:126.00, 6.77:127.00, 6.78:128.00, 6.79:129.00, 6.80:130.00, 6.81:131.00, 6.82:132.00, 6.83:133.00, 6.84:134.00, 6.85:135.00, 6.86:136.00, 6.87:137.00, 6.88:138.00, 6.89:139.00, 6.90:140.00, 6.91:141.00, 6.92:142.00, 6.93:143.00, 6.94:144.00, 6.95:145.00, 6.96:146.00, 6.97:147.00, 6.98:148.00, 6.99:149.00, 7.00:52.50, 7.01:59.00, 7.02:60.00, 7.03:61.00, 7.04:62.00, 7.05:63.00, 7.06:64.00, 7.07:65.00, 7.08:66.00, 7.09:67.00, 7.10:68.00, 7.11:69.00, 7.12:70.00, 7.13:71.00, 7.14:72.00, 7.15:73.00, 7.16:74.00, 7.17:75.00, 7.18:76.00, 7.19:77.00, 7.20:78.00, 7.21:79.00, 7.22:80.00, 7.23:81.00, 7.24:82.00, 7.25:83.00, 7.26:84.00, 7.27:85.00, 7.28:86.00, 7.29:87.00, 7.30:88.00, 7.31:89.00, 7.32:90.00, 7.33:91.00, 7.34:92.00, 7.35:93.00, 7.36:94.00, 7.37:95.00, 7.38:96.00, 7.39:97.00, 7.40:98.00, 7.41:99.00, 7.42:100.00, 7.43:101.00, 7.44:102.00, 7.45:103.00, 7.46:104.00, 7.47:105.00, 7.48:106.00, 7.49:107.00, 7.50:108.00, 7.51:109.00, 7.52:110.00, 7.53:111.00, 7.54:112.00, 7.55:113.00, 7.56:114.00, 7.57:115.00, 7.58:116.00, 7.59:117.00, 7.60:118.00, 7.61:119.00, 7.62:120.00, 7.63:121.00, 7.64:122.00, 7.65:123.00, 7.66:124.00, 7.67:125.00, 7.68:126.00, 7.69:127.00, 7.70:128.00, 7.71:129.00, 7.72:130.00, 7.73:131.00, 7.74:132.00, 7.75:133.00, 7.76:134.00, 7.77:135.00, 7.78:136.00, 7.79:137.00, 7.80:138.00, 7.81:139.00, 7.82:140.00, 7.83:141.00, 7.84:142.00, 7.85:143.00, 7.86:144.00, 7.87:145.00, 7.88:146.00, 7.89:147.00, 7.90:148.00, 7.91:149.00, 7.92:150.00, 7.93:151.00, 7.94:152.00, 7.95:153.00, 7.96:154.00, 7.97:155.00, 7.98:156.00, 7.99:157.00, 8.00:60.50, 8.01:67.00, 8.02:68.00, 8.03:69.00, 8.04:70.00, 8.05:71.00, 8.06:72.00, 8.07:73.00, 8.08:74.00, 8.09:75.00, 8.10:76.00, 8.11:77.00, 8.12:78.00, 8.13:79.00, 8.14:80.00, 8.15:81.00, 8.16:82.00, 8.17:83.00, 8.18:84.00, 8.19:85.00, 8.20:86.00, 8.21:87.00, 8.22:88.00, 8.23:89.00, 8.24:90.00, 8.25:91.00, 8.26:92.00, 8.27:93.00, 8.28:94.00, 8.29:95.00, 8.30:96.00, 8.31:97.00, 8.32:98.00, 8.33:99.00, 8.34:100.00, 8.35:101.00, 8.36:102.00, 8.37:103.00, 8.38:104.00, 8.39:105.00, 8.40:106.00, 8.41:107.00, 8.42:108.00, 8.43:109.00, 8.44:110.00, 8.45:111.00, 8.46:112.00, 8.47:113.00, 8.48:114.00, 8.49:115.00, 8.50:116.00, 8.51:117.00, 8.52:118.00, 8.53:119.00, 8.54:120.00, 8.55:121.00, 8.56:122.00, 8.57:123.00, 8.58:124.00, 8.59:125.00, 8.60:126.00, 8.61:127.00, 8.62:128.00, 8.63:129.00, 8.64:130.00, 8.65:131.00, 8.66:132.00, 8.67:133.00, 8.68:134.00, 8.69:135.00, 8.70:136.00, 8.71:137.00, 8.72:138.00, 8.73:139.00, 8.74:140.00, 8.75:141.00, 8.76:142.00, 8.77:143.00, 8.78:144.00, 8.79:145.00, 8.80:146.00, 8.81:147.00, 8.82:148.00, 8.83:149.00, 8.84:150.00, 8.85:151.00, 8.86:152.00, 8.87:153.00, 8.88:154.00, 8.89:155.00, 8.90:156.00, 8.91:157.00, 8.92:158.00, 8.93:159.00, 8.94:160.00, 8.95:161.00, 8.96:162.00, 8.97:163.00, 8.98:164.00, 8.99:165.00, 9.00:68.50, 9.01:75.00, 9.02:76.00, 9.03:77.00, 9.04:78.00, 9.05:79.00, 9.06:80.00, 9.07:81.00, 9.08:82.00, 9.09:83.00, 9.10:84.00, 9.11:85.00, 9.12:86.00, 9.13:87.00, 9.14:88.00, 9.15:89.00, 9.16:90.00, 9.17:91.00, 9.18:92.00, 9.19:93.00, 9.20:94.00, 9.21:95.00, 9.22:96.00, 9.23:97.00, 9.24:98.00, 9.25:99.00, 9.26:100.00, 9.27:101.00, 9.28:102.00, 9.29:103.00, 9.30:104.00, 9.31:105.00, 9.32:106.00, 9.33:107.00, 9.34:108.00, 9.35:109.00, 9.36:110.00, 9.37:111.00, 9.38:112.00, 9.39:113.00, 9.40:114.00, 9.41:115.00, 9.42:116.00, 9.43:117.00, 9.44:118.00, 9.45:119.00, 9.46:120.00, 9.47:121.00, 9.48:122.00, 9.49:123.00, 9.50:124.00, 9.51:125.00, 9.52:126.00, 9.53:127.00, 9.54:128.00, 9.55:129.00, 9.56:130.00, 9.57:131.00, 9.58:132.00, 9.59:133.00, 9.60:134.00, 9.61:135.00, 9.62:136.00, 9.63:137.00, 9.64:138.00, 9.65:139.00, 9.66:140.00, 9.67:141.00, 9.68:142.00, 9.69:143.00, 9.70:144.00, 9.71:145.00, 9.72:146.00, 9.73:147.00, 9.74:148.00, 9.75:149.00, 9.76:150.00, 9.77:151.00, 9.78:152.00, 9.79:153.00, 9.80:154.00, 9.81:155.00, 9.82:156.00, 9.83:157.00, 9.84:158.00, 9.85:159.00, 9.86:160.00, 9.87:161.00, 9.88:162.00, 9.89:163.00, 9.90:164.00, 9.91:165.00, 9.92:166.00, 9.93:167.00, 9.94:168.00, 9.95:169.00, 9.96:170.00, 9.97:171.00, 9.98:172.00, 9.99:173.00, 10.00:76.50, 10.01:83.00, 10.02:84.00, 10.03:85.00, 10.04:86.00, 10.05:87.00, 10.06:88.00, 10.07:89.00, 10.08:90.00, 10.09:91.00, 10.10:92.00, 10.11:93.00, 10.12:94.00, 10.13:95.00, 10.14:96.00, 10.15:97.00, 10.16:98.00, 10.17:99.00, 10.18:100.00, 10.19:101.00, 10.20:102.00, 10.21:103.00, 10.22:104.00, 10.23:105.00, 10.24:106.00, 10.25:107.00, 10.26:108.00, 10.27:109.00, 10.28:110.00, 10.29:111.00, 10.30:112.00, 10.31:113.00, 10.32:114.00, 10.33:115.00, 10.34:116.00, 10.35:117.00, 10.36:118.00, 10.37:119.00, 10.38:120.00, 10.39:121.00, 10.40:122.00, 10.41:123.00, 10.42:124.00, 10.43:125.00, 10.44:126.00, 10.45:127.00, 10.46:128.00, 10.47:129.00, 10.48:130.00, 10.49:131.00, 10.50:132.00, 10.51:133.00, 10.52:134.00, 10.53:135.00, 10.54:136.00, 10.55:137.00, 10.56:138.00, 10.57:139.00, 10.58:140.00, 10.59:141.00, 10.60:142.00, 10.61:143.00, 10.62:144.00, 10.63:145.00, 10.64:146.00, 10.65:147.00, 10.66:148.00, 10.67:149.00, 10.68:150.00, 10.69:151.00, 10.70:152.00, 10.71:153.00, 10.72:154.00, 10.73:155.00, 10.74:156.00, 10.75:157.00, 10.76:158.00, 10.77:159.00, 10.78:160.00, 10.79:161.00, 10.80:162.00, 10.81:163.00, 10.82:164.00, 10.83:165.00, 10.84:166.00, 10.85:167.00, 10.86:168.00, 10.87:169.00, 10.88:170.00, 10.89:171.00, 10.90:172.00, 10.91:173.00, 10.92:174.00, 10.93:175.00, 10.94:176.00, 10.95:177.00, 10.96:178.00, 10.97:179.00, 10.98:180.00, 10.99:181.00, 11.00:84.50, 11.01:91.00, 11.02:92.00, 11.03:93.00, 11.04:94.00, 11.05:95.00, 11.06:96.00, 11.07:97.00, 11.08:98.00, 11.09:99.00, 11.10:100.00, 11.11:101.00, 11.12:102.00, 11.13:103.00, 11.14:104.00, 11.15:105.00, 11.16:106.00, 11.17:107.00, 11.18:108.00, 11.19:109.00, 11.20:110.00, 11.21:111.00, 11.22:112.00, 11.23:113.00, 11.24:114.00, 11.25:115.00, 11.26:116.00, 11.27:117.00, 11.28:118.00, 11.29:119.00, 11.30:120.00, 11.31:121.00, 11.32:122.00, 11.33:123.00, 11.34:124.00, 11.35:125.00, 11.36:126.00, 11.37:127.00, 11.38:128.00, 11.39:129.00, 11.40:130.00, 11.41:131.00, 11.42:132.00, 11.43:133.00, 11.44:134.00, 11.45:135.00, 11.46:136.00, 11.47:137.00, 11.48:138.00, 11.49:139.00, 11.50:140.00, 11.51:141.00, 11.52:142.00, 11.53:143.00, 11.54:144.00, 11.55:145.00, 11.56:146.00, 11.57:147.00, 11.58:148.00, 11.59:149.00, 11.60:150.00, 11.61:151.00, 11.62:152.00, 11.63:153.00, 11.64:154.00, 11.65:155.00, 11.66:156.00, 11.67:157.00, 11.68:158.00, 11.69:159.00, 11.70:160.00, 11.71:161.00, 11.72:162.00, 11.73:163.00, 11.74:164.00, 11.75:165.00, 11.76:166.00, 11.77:167.00, 11.78:168.00, 11.79:169.00, 11.80:170.00, 11.81:171.00, 11.82:172.00, 11.83:173.00, 11.84:174.00, 11.85:175.00, 11.86:176.00, 11.87:177.00, 11.88:178.00, 11.89:179.00, 11.90:180.00, 11.91:181.00, 11.92:182.00, 11.93:183.00, 11.94:184.00, 11.95:185.00, 11.96:186.00, 11.97:187.00, 11.98:188.00, 11.99:189.00, 12.00:92.50, 12.01:99.00, 12.02:100.00, 12.03:101.00, 12.04:102.00, 12.05:103.00, 12.06:104.00, 12.07:105.00, 12.08:106.00, 12.09:107.00, 12.10:108.00, 12.11:109.00, 12.12:110.00, 12.13:111.00, 12.14:112.00, 12.15:113.00, 12.16:114.00, 12.17:115.00, 12.18:116.00, 12.19:117.00, 12.20:118.00, 12.21:119.00, 12.22:120.00, 12.23:121.00, 12.24:122.00, 12.25:123.00, 12.26:124.00, 12.27:125.00, 12.28:126.00, 12.29:127.00, 12.30:128.00, 12.31:129.00, 12.32:130.00, 12.33:131.00, 12.34:132.00, 12.35:133.00, 12.36:134.00, 12.37:135.00, 12.38:136.00, 12.39:137.00, 12.40:138.00, 12.41:139.00, 12.42:140.00, 12.43:141.00, 12.44:142.00, 12.45:143.00, 12.46:144.00, 12.47:145.00, 12.48:146.00, 12.49:147.00, 12.50:148.00, 12.51:149.00, 12.52:150.00, 12.53:151.00, 12.54:152.00, 12.55:153.00, 12.56:154.00, 12.57:155.00, 12.58:156.00, 12.59:157.00, 12.60:158.00, 12.61:159.00, 12.62:160.00, 12.63:161.00, 12.64:162.00, 12.65:163.00, 12.66:164.00, 12.67:165.00, 12.68:166.00, 12.69:167.00, 12.70:168.00, 12.71:169.00, 12.72:170.00, 12.73:171.00, 12.74:172.00, 12.75:173.00, 12.76:174.00, 12.77:175.00, 12.78:176.00, 12.79:177.00, 12.80:178.00, 12.81:179.00, 12.82:180.00, 12.83:181.00, 12.84:182.00, 12.85:183.00, 12.86:184.00, 12.87:185.00, 12.88:186.00, 12.89:187.00, 12.90:188.00, 12.91:189.00, 12.92:190.00, 12.93:191.00, 12.94:192.00, 12.95:193.00, 12.96:194.00, 12.97:195.00, 12.98:196.00, 12.99:197.00, 13.00:100.50, 13.01:107.00, 13.02:108.00, 13.03:109.00, 13.04:110.00, 13.05:111.00, 13.06:112.00, 13.07:113.00, 13.08:114.00, 13.09:115.00, 13.10:116.00, 13.11:117.00, 13.12:118.00, 13.13:119.00, 13.14:120.00, 13.15:121.00, 13.16:122.00, 13.17:123.00, 13.18:124.00, 13.19:125.00, 13.20:126.00, 13.21:127.00, 13.22:128.00, 13.23:129.00, 13.24:130.00, 13.25:131.00, 13.26:132.00, 13.27:133.00, 13.28:134.00, 13.29:135.00, 13.30:136.00, 13.31:137.00, 13.32:138.00, 13.33:139.00, 13.34:140.00, 13.35:141.00, 13.36:142.00, 13.37:143.00, 13.38:144.00, 13.39:145.00, 13.40:146.00, 13.41:147.00, 13.42:148.00, 13.43:149.00, 13.44:150.00, 13.45:151.00, 13.46:152.00, 13.47:153.00, 13.48:154.00, 13.49:155.00, 13.50:156.00, 13.51:157.00, 13.52:158.00, 13.53:159.00, 13.54:160.00, 13.55:161.00, 13.56:162.00, 13.57:163.00, 13.58:164.00, 13.59:165.00, 13.60:166.00, 13.61:167.00, 13.62:168.00, 13.63:169.00, 13.64:170.00, 13.65:171.00, 13.66:172.00, 13.67:173.00, 13.68:174.00, 13.69:175.00, 13.70:176.00, 13.71:177.00, 13.72:178.00, 13.73:179.00, 13.74:180.00, 13.75:181.00, 13.76:182.00, 13.77:183.00, 13.78:184.00, 13.79:185.00, 13.80:186.00, 13.81:187.00, 13.82:188.00, 13.83:189.00, 13.84:190.00, 13.85:191.00, 13.86:192.00, 13.87:193.00, 13.88:194.00, 13.89:195.00, 13.90:196.00, 13.91:197.00, 13.92:198.00, 13.93:199.00, 13.94:200.00, 13.95:201.00, 13.96:202.00, 13.97:203.00, 13.98:204.00, 13.99:205.00, 14.00:108.50, 14.01:115.00, 14.02:116.00, 14.03:117.00, 14.04:118.00, 14.05:119.00, 14.06:120.00, 14.07:121.00, 14.08:122.00, 14.09:123.00, 14.10:124.00, 14.11:125.00, 14.12:126.00, 14.13:127.00, 14.14:128.00, 14.15:129.00, 14.16:130.00, 14.17:131.00, 14.18:132.00, 14.19:133.00, 14.20:134.00, 14.21:135.00, 14.22:136.00, 14.23:137.00, 14.24:138.00, 14.25:139.00, 14.26:140.00, 14.27:141.00, 14.28:142.00, 14.29:143.00, 14.30:144.00, 14.31:145.00, 14.32:146.00, 14.33:147.00, 14.34:148.00, 14.35:149.00, 14.36:150.00, 14.37:151.00, 14.38:152.00, 14.39:153.00, 14.40:154.00, 14.41:155.00, 14.42:156.00, 14.43:157.00, 14.44:158.00, 14.45:159.00, 14.46:160.00, 14.47:161.00, 14.48:162.00, 14.49:163.00, 14.50:164.00, 14.51:165.00, 14.52:166.00, 14.53:167.00, 14.54:168.00, 14.55:169.00, 14.56:170.00, 14.57:171.00, 14.58:172.00, 14.59:173.00, 14.60:174.00, 14.61:175.00, 14.62:176.00, 14.63:177.00, 14.64:178.00, 14.65:179.00, 14.66:180.00, 14.67:181.00, 14.68:182.00, 14.69:183.00, 14.70:184.00, 14.71:185.00, 14.72:186.00, 14.73:187.00, 14.74:188.00, 14.75:189.00, 14.76:190.00, 14.77:191.00, 14.78:192.00, 14.79:193.00, 14.80:194.00, 14.81:195.00, 14.82:196.00, 14.83:197.00, 14.84:198.00, 14.85:199.00, 14.86:200.00, 14.87:201.00, 14.88:202.00, 14.89:203.00, 14.90:204.00, 14.91:205.00, 14.92:206.00, 14.93:207.00, 14.94:208.00, 14.95:209.00, 14.96:210.00, 14.97:211.00, 14.98:212.00, 14.99:213.00, 15.00:214.00

Zone 1 Handling Fee
5.50

I just shut the site down on site maint. until this can be worked out

ok i just went back and took out all the table rates just to see and the cart was back to normal - so i guess that narrows the errors down to the table rate is too large or could it be the returns after each line?

if anyone knows i'd be most grateful

okay sorry to be posting so many times but trying different things to narrow it down -
I went back and removed all the carriage returns (and not to mention now my page is just short of 10miles wide) and tried it with the us zone only and the cart was fine went back in and put in the canada rates (with carriage returns removed) and then tried with all 3 zones and got errors and warnings again with zone 2 and then with zone 3. Now I'm clueless

they are each approz the same length and I don't understand if the zone for the US works then why doesn't the zones for canada and international work (when they did before i added all the rates{when i had tested them with smaller rate tables)

another thing i tried is putting the rates in for each zone one at a time (zone 2 rates and then only zone 3 rates) and each time the cart was fine but apparently now with all 3 zones or even just 2 of them it flubs it all up

I check it but after each time i change I go to the cart select a product that has the weight change and then do estimate shipping and choose the correspondig shipping zone

What version of Zen Cart are you using?

Clean install or an upgrade?

How did you install? How did you upgrade?

I can setup a zone with those settings without error ...

Did anything change on your server such as your host upgrading php or MySQL?

Server Host: () Database Host: localhost (127.0.0.1)
Server OS: Database: MySQL 4.1.21-standard-log
Server Date: 06/01/2007 23:35:46 Database Date: 06/01/2007 23:35:46

Server Up Time:
PHP Version: 4.4.2 (Zend: 1.3.0)
HTTP Server: Apache/1.3.37 (Unix) mod_gzip/1.3.26.1a mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.2 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a

Zen Cart
Zen Cart 1.3.5
Database Patch Level: 1.3.5
v1.3.5 [2006-10-23 08:51:27] (Fresh Installation)

To the best of my knowledge no ypgrades were done on my server end to the php and mysql but i could be wrong I will email my guy and ask just to make sure (takes hmi a while sometimes to get back b/c of the time diff b/w us)

whatr i don't understand is that before i sat there and typed all those rates i put just a few in for each zone tested them and it worked (I wasn't sure if it was going to work with using decimals in the weight so before going far I tested to make sure) anyways each zone works by it's self just not more then one at a time. If you think it would help I'm more then willing to give you my admin login in PM if you think it would help you are far more knowledgable then I am in this area and I respect your knowledge and appreciate your willingness to help everyone and would value your opinion I can also give you the login for the hosting cpanel if you think looking at the database set up would help. Like I have said many times before I do not by any means claim to know what I'm doing..when it comes to writing the php code same goes with the databases I can get by on setting them up and have even learned how to extract info from them..lol.. but other then that I haven't a clue what I'm doing - I do know that no one has been into myphpadmin since I set up the database when i installed the cart.

Please if you have the time and don't mind looking let me know and I'll send you all the login info.

Thank you,
Noneya

There are a lot of issues with v1.3.5 that I would recommend upgrading ...

NOTE: PayPal the most recent Patch at:
http://www.zen-cart.com/forum/showthread.php?t=56216

NOTE: USPS has a upgrade for the May 14th server and price changes:
http://www.zen-cart.com/forum/showthread.php?t=65732

Paypal will not be a payment option for this cart due to the nature of the items paypal has informed my client that they will not allow him to process transactions for his items since they are illegal in the state of CA where paypal is HQ'd (so the client told me anyways) CC, MO are the only payment options same as the shipping he will not be using the USPS or the UPS modules since he sets his own shipping prices.

another problem i have is ever since I first started using ZC I was instructed by someone who i believe is no longer with the group to do it a certain way which i learned years after the fact that it was not the recommended way.

I know I will get the third degree for this..lol.. but I don't use the template override Honestly I have tried and it just never seems to work right for me I always end up with things going wrong and so forth so i modify the original source files in the classic temp folders. I have honestly tried with each cart I've installed and get discouraged when i start having problems so i dump everything start over and do it the "wrong" way I wsa taught from the beginning - which yesI know this makes upgrading very hard if not impossible and is one reason why my own site is still sitting in V1.2 i believe..lol..

anyways if you think that you could teach me an easy way (i'm an old dog set in my ways - can't teach an old dog new tricks..lol) But I am willing to try again (I even tried with my latest install on a new site using the book and still gave up

Would it be posible since the temp OR just copies the files to a new directory if I copy all the files i have in the temp sections and includes section and then run the upgrade then i can go back and put my files back in?

I would really learn to use the temp OR system just b/c I know as years go on my clients are going to want the new fangled dodads that come out and by then it's going to be really hard for me to do an upgrade with out just starting over from scratch.

There are numerous issues in v1.3.5 that need to be taken care of for the addresses that may be contributing to this problem ...

I would really recommend getting in the upgrade if these problems continue as the addresses sound like they are not always being set right and this will cause issues on the create account and shipping ...

If you do a search on:
/new_shop

There are numerous posts that break down how to do upgrades and many are in great detail ...

Look back over the last year's worth of posts at least to find these :smile: