Help... Clicking add to cart does not working

I need help!

When ever I click add to cart on any product on my site, it directs to the checkout page... good... But the cart is empty!
It was working 24 hours ago and has now stopped. The only things I have altered that could have broken it are.

• Altered the styling of the front end css sheet. (minor changes visual only)

• Added item custom fields to the products category.
I suspect this has caused the problem. My products have an option to remove an branding imprint. This is product option. When you select this product and include the option. The option is added to the cart but not the product. If you select product and dont include the option nothing is added to the cart.

Help does anyone know how to fix this? any assistance would really be appreciated.

Also I have changed the name product option... any ideas?

Okay its definitely the custom fields that are causing the problem. Unpublished them and it works fine.

I have checked the settings against the similar "address" custom fields and everything looks correct.... help!

Okay its definitely the custom fields that are causing the problem. Unpublished them and it works fine.

I have checked the settings against the similar "address" custom fields and everything looks correct.... help!

Okay its definitely the custom fields that are causing the problem. Unpublished them and it works fine.

I have checked the settings against the similar "address" custom fields and everything looks correct.... help!

Thank you for the ongoing help Nicolas. I have gone back to my hosting provider with the article you directed me to and asked for them to correct this.

Hi Nicolas,

I have gone back to my hosting provider with the three possible ways to correct the problem. I will list the problem and the hosting providers answer below.
(the hosting providers answer will in italics to make the dialogue more clear.)

1. Your MySQL user do not have the ALTER privilege which is essential to the update of tables structure.

Your MySQL user has full privileges and we don't restrict MySQL in this way.

2. Your MySQL server could not run all the queries because it was limited by some resource restrictions put in place by your hosting.

If issue #2 was happening, you'd see other database errors and a general slow down of your site.

3. You can add the column manually (via phpmyadmin) in the tables hikashop_cart_product and hikashop_order_product with the column name of your custom field in order to have it working.

I have tried to do this and there are multiple matches for the line those instructions are talking about, even though the instructions only seem to be mentioning one match.

Are you able to be more specific about how to fix "3. You can add the column manually" so I can go back to my hosting provider and ask that they correct the issue. If you can please be very specific, as my hosting provider is in New Zealand and I assume you are in Europe. The different time zones involved will mean that if we have to email backwards and forwards to clarify how to fix this it will take days to correct this problem.

If you cannot help can you provide contact details of any one at Hika Shop that can? (I have purchased the Business Edition so I am entitled to ongoing support via email)

Hi Nicolas,

Thanks again for the ongoing support. Below is the error I got by turning debug joomla on. I have coloured to to make it easier to read.
From this can you please let me know what is the name of the column I need to ask my hosting provider to insert into the tables hikashop_cart_product and hikashop_order_product

I ask this is above my understanding and I wish to be very clear with my hosting provider.


JDatabaseMySQL::query: 1054 - Unknown column 'ifyouwanttochangethesolganonthefrontofthecardwhats' in 'field list' SQL=INSERT INTO l9ehd_hikashop_cart_product (cart_id,cart_product_modified,product_id,cart_product_parent_id,cart_product_quantity,cart_product_option_parent_id,`ifyouwanttochangethesolganonthefrontofthecardwhats`,`whatisyourbusinessname`,`whatisyourbusinessaddress`,`openinghours`,`whichdrinkshouldbefree`) VALUES (78,1338567573,1,0,250,0,'gfdfhdfh','gfhfgj','fjgghdfhg','dsggddfsds','8th')
• Home Page

Call stack
#
Function
Location
1
JSite->dispatch()
/var/www/vhosts/londonstudio.co.nz/httpdocs/index.php:42
2
JComponentHelper::renderComponent()
/var/www/vhosts/londonstudio.co.nz/httpdocs/includes/application.php:198
3
JComponentHelper::executeComponent()
/var/www/vhosts/londonstudio.co.nz/httpdocs/libraries/joomla/application/component/helper.php:357
4
require_once()
/var/www/vhosts/londonstudio.co.nz/httpdocs/libraries/joomla/application/component/helper.php:388
5
JController->execute()
/var/www/vhosts/londonstudio.co.nz/httpdocs/components/com_hikashop/hikashop.php:53
6
productController->updatecart()
/var/www/vhosts/londonstudio.co.nz/httpdocs/libraries/joomla/application/component/controller.php:754
7
hikashopCartClass->update()
/var/www/vhosts/londonstudio.co.nz/httpdocs/components/com_hikashop/controllers/product.php:246
8
hikashopCartClass->updateEntry()
/var/www/vhosts/londonstudio.co.nz/httpdocs/administrator/components/com_hikashop/classes/cart.php:231
9
JDatabaseMySQL->query()
/var/www/vhosts/londonstudio.co.nz/httpdocs/administrator/components/com_hikashop/classes/cart.php:423
10
JError::raiseError()
/var/www/vhosts/londonstudio.co.nz/httpdocs/libraries/joomla/database/database/mysql.php:542
11
JError::raise()
/var/www/vhosts/londonstudio.co.nz/httpdocs/libraries/joomla/error/error.php:251

Hi Nicolas,

I have heard back from my hosting provider with this message and its not good news:

I have had a look at the latest instructions and they are poor instructions and could break your site.
They say to add "ifyouwanttochangethesolganonthefrontofthecardwhats" to your table, but it doesn't specify to add it to the end of the table, or insert it at a particular point.

This is outside of our support scope and something you really need to get a developer to work on, personally, I would suggest using an alternative shopping script, as you shouldn't have this much trouble simply installing their script.

Can you please give me step by step instructions on how I go about fixing this keeping in mind I have no experience with mySQL. As I will now need need to correct this my self or pay a developer to fix this for me.

Cheers Ben

Thank you for the continued support Nicolas,

Unfortunately I got stuck and couldn't work out how to add a column.

If I provide you login details to phpmyadmin via a private message will you please correct this for me?

- That way I will stop bugging you.

Nicolas,

Thank you so much. I have just sent you the connection details via the contact us form.

Please let me know if you need any further clarification.

Cheers Ben

Thanks for looking Nicolas,

Yes you can definitely access phpmyadmin. It is hiding here.

From the first screen you see after logging in.
Click on the "Database" icon in the box labeled "Applications and Services"
Click on the "LS-database" text link
Click on the "webadmin" icon
This will open phpmyadmin in a new window.

Nicolas, Thank you.

Its working, I'm so pleased to have the site able to receive orders.
Thank you so much, is there any where were I can leave a positive review of testimonial of Hikashop? - I would like to.

Your customer service is excellent.