ERROR 500

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

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,

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 ?

Hi,

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

Regards,

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.

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,

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.

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