FedEx Shipping - completely lost

-- url of the page with the problem -- : dev.explorationgeochem.com/j25/index.php/blanks-21
-- HikaShop version -- : 2.2.2
-- Joomla version -- : 2.5.16
-- PHP version -- : 5.3.27
-- Browser(s) name and version -- : Chrome 31.0.1650.48
-- Error-message(debug-mod must be tuned on) -- : Error_message n/a

1) Cannot get FEDex shipping to show up on Checkout.
2) Cannot see "zone" selector as in this image in your docs:
www.hikashop.com/support/documentation/1...-shipping-fedex-form
www.hikashop.com/images/stories/fedex_opt11.jpg

3) Do I need to set up SHIPPING ZONES? - I do not see any documentation that says this must be done

Hi,

1. Following each step of the "shipping methods" section of the FAQ will probably help you to solve your problem.

2. You'll find this option through the "restrictions" section of your FedEx configuration screen.

3. No, you can set a shipping zone only if you need to restrict the zones where you want your goods to be shipped.

Mohamed,
Thank you for that - have followed precisely to no avail.
Unfortunately I have found some other errors when turning on DEBUG....

Seems like there are a number of things missing in my DB

In the ADMIN area:
administrator/index.php?option=com_hikashop&ctrl=product&task=edit&cid[]=137

500 - An error has occurred.
JDatabaseMySQLi::query: 1146 - Table 'xxx_25j.j25_hikashop_shipping_price' doesn't exist SQL=SELECT b.*, a.*, c.currency_symbol FROM j25_hikashop_shipping AS a LEFT JOIN j25_hikashop_shipping_price AS b ON a.shipping_id = b.shipping_id AND b.shipping_price_ref_id = 137 INNER JOIN j25_hikashop_currency AS c ON c.currency_id = a.shipping_currency_id WHERE a.shipping_type = 'manual' AND a.shipping_params LIKE '%s:20:\"shipping_per_product\";s:1:\"1\"%' AND (b.shipping_price_ref_id IS NULL OR (b.shipping_price_ref_id = 137 AND b.shipping_price_ref_type = 'product')) ORDER BY a.shipping_id, b.shipping_price_min_quantity

On the front end at Checkout:
500 - JDatabaseMySQLi::query: 1146 - Table 'xxx.j25_hikashop_badge' doesn't exist SQL=SELECT a.* FROM j25_hikashop_badge AS a WHERE a.badge_start <= 1384455751 AND ( a.badge_end >= 1384455751 OR a.badge_end =0 ) AND a.badge_published=1 AND (a.badge_quantity='' OR a.badge_quantity=-1) AND (badge_discount_id=0 OR badge_discount_id=0 )AND ((badge_category_childs = 0 AND (badge_category_id = 0 OR badge_category_id = 27))OR (badge_category_childs = 1 AND (badge_category_id=0 OR badge_category_id = 1 OR badge_category_id = 2 OR badge_category_id = 27))) ORDER BY a.badge_ordering ASC,a.badge_id ASC

** I Just updated to Business Edition ***

Here is a list of ALL the hikashop tables in my db:
j25_hikashop_address
j25_hikashop_banner
j25_hikashop_cart
j25_hikashop_cart_product
j25_hikashop_category
j25_hikashop_characteristic
j25_hikashop_click
j25_hikashop_config
j25_hikashop_currency
j25_hikashop_discount
j25_hikashop_download
j25_hikashop_entry
j25_hikashop_field
j25_hikashop_file
j25_hikashop_filter
j25_hikashop_geolocation
j25_hikashop_history
j25_hikashop_limit
j25_hikashop_order
j25_hikashop_order_product
j25_hikashop_payment
j25_hikashop_price
j25_hikashop_product
j25_hikashop_product_category
j25_hikashop_product_related
j25_hikashop_shipping
j25_hikashop_tax
j25_hikashop_taxation
j25_hikashop_user
j25_hikashop_variant
j25_hikashop_waitlist
j25_hikashop_widget
j25_hikashop_zone
j25_hikashop_zone_link

Thank you!

Ok, so can you download the last Hikashop version through our website, install it, and test it again ?

I actually JUST did that.... BUT OK - I will do this step again..
Downloading Business version now and installing.

EDIT
When going to a product on the front end:
ERROR
500 - JDatabaseMySQLi::query: 1146 - Table 'xxx.j25_hikashop_badge' doesn't exist SQL=SELECT a.* FROM j25_hikashop_badge AS a WHERE a.badge_start <= 1384537163 AND ( a.badge_end >= 1384537163 OR a.badge_end =0 ) AND a.badge_published=1 AND (a.badge_quantity='' OR a.badge_quantity=-1) AND (badge_discount_id=0 OR badge_discount_id=0 )AND ((badge_category_childs = 0 AND (badge_category_id = 0 OR badge_category_id = 27))OR (badge_category_childs = 1 AND (badge_category_id=0 OR badge_category_id = 1 OR badge_category_id = 2 OR badge_category_id = 27))) ORDER BY a.badge_ordering ASC,a.badge_id ASC

WHen going to a product on the BACK END + when making a NEW Product
500 - An error has occurred.
JDatabaseMySQLi::query: 1146 - Table 'xxx.j25_hikashop_shipping_price' doesn't exist SQL=SELECT b.*, a.*, c.currency_symbol FROM j25_hikashop_shipping AS a LEFT JOIN j25_hikashop_shipping_price AS b ON a.shipping_id = b.shipping_id AND b.shipping_price_ref_id = 137 INNER JOIN j25_hikashop_currency AS c ON c.currency_id = a.shipping_currency_id WHERE a.shipping_type = 'manual' AND a.shipping_params LIKE '%s:20:\"shipping_per_product\";s:1:\"1\"%' AND (b.shipping_price_ref_id IS NULL OR (b.shipping_price_ref_id = 137 AND b.shipping_price_ref_type = 'product')) ORDER BY a.shipping_id, b.shipping_price_min_quantity

Hi,

You had a mysql problem (I guess permission) with an HikaShop update.
So you have some missing tables and I think, some missing column in some HikaShop tables.

You have to create this tables manually by executing the SQL script in the HikaShop package.
For the missing column, the problem is that, we can't check easily. So the best is to know from which version you upgrade your HikaShop in order to know which columns we have to check.

Regards,

Hi Jerome,
Thanks for that info - I have worked out how to manually run the sql file in the folder - and that seems to have added the tables which is great.

As to columns that might be missing... I do not know.
I believe I FIRST installed:

com_hikashop_essential_2.1.0
then updated to
com_hikashop_essential_2.2.0
then
com_hikashop_business_2.2.0

*Please note however I was not actively setting up the FedEX shipping plugin until 2.2.0 so I do not know if the issue was there in 2.1.0 in our case

Is there any method to confirm all the tables and the correct columns have been created? - if we do did not have any products in the DB it would be easy to start with a clean install - but we have data already.

Please let me know how to do this check- thanks again.

Hi,

The SQL file you have used contains all HikaShop tables with all default columns.
When you have some custom field (product, item, order, etc) it will create new columns.
So you have to compare your tables in your database with the definition in the SQL file.
If you have a missing column, it means that you will have to create it. If you have an extra column, it should be a custom field (it all cases, you have to keep it).
The order of the column don't have any importance.

It is the best way I know to be sure that the database is right up to date.

Regards,

I am going to need to get some help to check this - I am at my limit of knowledge.... I am not a programmer.

Would be great to have a script to check that everything in the DB is actually set up correctly. joomla has something similar and other paid components have as well.

I hope this function is implemented ASAP - pretty vital for customers like me.