update issues

  • Posts: 84
  • Thank you received: 0
11 years 10 months ago #127633

-- url of the page with the problem -- : www.bodyconquest.com.au/
-- HikaShop version -- : 2.0.0
-- Joomla version -- : 3.1
-- PHP version -- : 5.4.2
-- Browser(s) name and version -- : all
-- Error-message(debug-mod must be tuned on) -- :

Hi,

I just did an install of an update purchased this morning (W1Z0K566). I thought I had attached the update to the site bodyconquest.com.au (I am under the impression this was a business install) . Download no problem, install seemed fine, but post install whilst some of the backend is fine and accessible (products, customers) others are not: orders (http:// http://awesomescreenshot.com/09b1tmgx72 )

Unfortunately this has had an effect on the front end as well, overriding css and not allowing access to products.

I was hoping an update was going to help rectify another issue, but seems I have only made things worse ... :(

Is the only option doing a reinstall?

luke

Please Log in or Create an account to join the conversation.

  • Posts: 26264
  • Thank you received: 4043
  • MODERATOR
11 years 10 months ago #127642

Hi,

You are using the driver "mysql" for your Joomla 3, if you change this driver to the driver "mysqli" you will have more details about SQL errors.

You should have installed the latest version (2.2.2) on an HikaShop 2.0.0
I thinkt that you have some SQL problems during the update and some tables are not up to date.

More precisely, the table "hikashop_payment" does not have the column "payment_ordering".
In the file "install.hikashop.php" there are some SQL queries in order to update the database by creating new columns (most of time).
In HikaShop 2.2.0 we add new columns in the table "hikashop_payment".

If you have a PHPmyAdmin for your website, the best will be to make the missing updates manually.
So you won't have to reinstall all. If the database is up to date, HikaShop 2.2.2 will work correctly.
If you have some troubles to make this update, you can send me a private message and I will personally take a look.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 84
  • Thank you received: 0
11 years 10 months ago #127645

ok, so if i work from a backup that hasn't had the update done yet, I should:

1) change to mysqli
2) update to 2.2.2 business as per normal
3) make manual updates if neccessary... where do I find the file you refer to - install.hikashop.php - in the update package?

Please Log in or Create an account to join the conversation.

  • Posts: 26264
  • Thank you received: 4043
  • MODERATOR
11 years 10 months ago #127647

Hi,

Right. I think you can do that.
With a backup it will be good to retry a update and hope that it will work fine this time.

Notice that the "mysqli" driver is better than the "mysql" one in Joomla 3. It gives more details when there are some errors.
After that, I don't think it is the source of the problem. It's just that the screenshot does not have the SQL error message but I deduce that the column "payment_ordering" does not exist.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 84
  • Thank you received: 0
11 years 10 months ago #127660

Hi Jerome,

So I reinstalled on a subdomain for testing: bc.bodyconquest.com.au

I set to mysqli as suggested and then uploaded the update of business edition.

As soon as the updating was finished I got the following:




Same as before, issues in back and front end although when trying to access the cart now I get this error:


I have phpmyadmin access, so I can attmept to resolve this, you suggested " In the file "install.hikashop.php" there are some SQL queries" where will I find this? in the update?

kindly,

luke

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 26264
  • Thank you received: 4043
  • MODERATOR
11 years 10 months ago #127662

Hi,

The "install.hikashop.php" file in is the root folder in the package file.
It looks like you already have the column product_alias in your 2.0.0 package.
That's why the update script failed there.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 84
  • Thank you received: 0
11 years 10 months ago #127663

I forgot to add, maybe not important, maybe important, that it was an update on version 2.0.0



I tried all the updates manually in myphpadmin but they had already been made :( (error duplicate table)

luke

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 26264
  • Thank you received: 4043
  • MODERATOR
11 years 10 months ago #127664

Hi,

I really don't know what you tried to do but. I knew that you had the 2.0.0 version, it was mentioned in your first post and you can read it in my previous post...
I don't know why your HikaShop 2.0.0 is broken, why you have column that your shouldn't have.
Deleting these column before trying to make an update could be another solution but the solution I gave you previously is a good solution and is working perfectly. Even if the update does not update the database, if you did it manually... It will work !

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 84
  • Thank you received: 0
11 years 9 months ago #128504

Hi Jerome,

Sorry to bother again. I haven't had any luck with trying to do an update and continue to get the same message; maybe I have missed a column. What I am wondering, as I still am not getting confirmation from Paypal anymore (since upgrade to 2.5 -->3.1), is if I shouldn't do an export then a clean install. How should I go about this as my business package is now way out of date?

regards,

luke

Please Log in or Create an account to join the conversation.

  • Posts: 26264
  • Thank you received: 4043
  • MODERATOR
11 years 9 months ago #128625

Hi,

Like that I can't give you precise information, I am a little bit "blind" without an access to the data.
The update could work if the database is "clean up" before (removing the columns which shouldn't be there). I know that it is not simple to do so if you can give us some accesses, we will take a look for you.

About your paypal problem, it means that you are not receiving the IPN anymore.
You can take a look at the "paypal issue page" in our documentation, it will give you more details about the problem and how fix it.
www.hikashop.com/support/integrated-docu...nt-paypal-error.html

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 84
  • Thank you received: 0
10 years 11 months ago #170514

Hi again,

Sorry but I am returning to this issue after many attempts to update unsuccesfully over the last months - I think I may have sufficient time (with some guidance) to finally resolve the issue.

I am still a little unsure of which columns I should be removing in order to aide the update.

If your kind offer of having a look is still an option I will glady pass on access details!

kindly,

Luke

Please Log in or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
10 years 11 months ago #170526

Hello Luke,
This time can you download the last Hikashop version through our website (2.3.2), install it, and test it again ?
Thanks.

Please Log in or Create an account to join the conversation.

Time to create page: 0.110 seconds
Powered by Kunena Forum