Error after upgrade 1.4-->1.5

After the upgrade i got this error
Mysqli prepare error: Unknown column ‘revenue_subtotal’ in ‘field list’

how could I fix it?

The column was added in 1.5-b1. Assuming your table prefix is “piwik_”, try:


UPDATE piwik_option SET option_value = '1.4' WHERE option_name = 'version_core';

thanks Antohn, i tried and at that point it asked to me to update the database.
I did it and it give me again the error…
Mysqli prepare error: Unknown column ‘revenue_subtotal’ in ‘field list’

Odd. Can you PM either Matt or myself your ftp/ssh login+password?

If not, try installing to a fresh database, and then comparing the schemas.

I have the exact same problem as this. PM with login details sent.

Hi Anthon

I was about to send a private message to Matt, regarding the above, but I see that the one I sent to you has been read. Could you give me an update please?

Thanks
Gillian

Yes, I saw your PM. I’ll try to investigate tonight.

Thank you!

[quote=itguy72]
thanks Antohn, i tried and at that point it asked to me to update the database.
I did it and it give me again the error…
Mysqli prepare error: Unknown column ‘revenue_subtotal’ in ‘field list’[/quote]

Did you find a solution to this itguy72? Mine is still not working.

thanks
Gillian

Hi this seemed to help my situation, however it introduced another problem

"
Unable to load plugin ‘AdminHome’ because ‘/var/www/vhosts/XXXX/httpdocs/piwik/plugins/AdminHome/AdminHome.php’ couldn’t be found. You can manually uninstall the plugin by removing the line Plugins = AdminHome from the Piwik config file.
"

Kartal, there is no AdminHome plugin. Did you upgrade from an old (really old) Piwik version?

Hi

I upgraded from 1.4. However I have been upgrading Piwik for sometime, not sure I have been using it since earlier versions.

plugins/CoreAdminHome is expected

if you also have plugins/AdminHome, just remove that directory (or move it out of the plugins folder)

I had issues as well, then I noted that the option table had the version_core at 1.5, yet none of the updates had happened. I changed this back down to 1.5, logged in - it ran the sql upgrades and now it all seems to be running correctly! :slight_smile:

I’ve been through every table looking for a column called ‘revenue_subtotal’ but can’t find one anywhere.

Anyone know where it is?

thanks
Gillian

Still no solution. Please can somebody help!

I tried to do a manual upgrade to 1.5.1 in the hope that this might resolve the:

Mysqli prepare error: Unknown column ‘revenue_subtotal’ in ‘field list’ error.

But it made no difference.

If nobody has a solution to the error does anybody have any ideas of how I can get help to get this working again. It’s not worked for 2 weeks now.

thanks
Gillian