ERROR 500

  • Posts: 33
  • Thank you received: 0
11 years 5 months ago #78248

Hello Hikashop Team,

I have updated to joomla 3.0, and installed hikashop new version, maybe to soon.

But now i got:

500 - Ha ocurrido un error.

SQL=SELECT * FROM n28py_hikashop_widget WHERE widget_published=1 ORDER BY widget_ordering ASC

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

  • Posts: 26007
  • Thank you received: 4004
  • MODERATOR
11 years 5 months ago #78256

Hi,

Please use the HikaMysqli driver in order to have the mysql error.
www.hikashop.com/en/forum/2-general-talk...p-20-beta.html#72321

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: 33
  • Thank you received: 0
11 years 5 months ago #78280

Hi Jerome, i went to the other Topic, installed (com_hikashop_Starter_2_0_0_2012-10-26.zip), followed the steps, no result, the error doesnt go away.

And later on i see like alot more .zip. ¿Wich is the one i should install ?

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

  • Posts: 26007
  • Thank you received: 4004
  • MODERATOR
11 years 5 months ago #78281

Hi,

I asked you to install the HikaMysqli driver so install "hikamysqli.zip".
Read the topic message 72321.

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: 33
  • Thank you received: 0
11 years 5 months ago #78285

Perfect, i didn't had the correct permissions, sorry,

Now i got this error:


1054 - Ha ocurrido un error.

SQL Error Unknown column 'widget_published' in 'where clause'

SELECT * FROM n28py_hikashop_widget WHERE widget_published=1 ORDER BY widget_ordering ASC


Thank you again.

Attachments:

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

  • Posts: 26007
  • Thank you received: 4004
  • MODERATOR
11 years 5 months ago #78287

Hi,

It's like HikaShop does not execute SQL updates.
HikaShop 1.5.9 added new columns in the widget table.
From which HikaShop version did you update ?

I think you would have to execute the SQL from 1.5.9, 1.6.0 and 2.0.0 updates.

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: 33
  • Thank you received: 0
11 years 4 months ago #80297

Hi Jerome,

Excuse my stupidity, i dont remember wich version it exactly was, normally i update each new update that comes out, that why i update to soon to Joomla 3.0.

Can you explain me briefly how to solve it ? I have the essential Hikashop if it matters.

I have to execute and older SQL ? or Install something ?

Regards.

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

  • Posts: 26007
  • Thank you received: 4004
  • MODERATOR
11 years 4 months ago #80312

Hi,

Would it be possible to have a backend access for you store and a PHPMyAdmin access ?
We would make a manual SQL update of your HikaShop and check your server configuration.
You can send me theses access by private message.

Thanks

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.

Time to create page: 0.069 seconds
Powered by Kunena Forum