Error after upgrade 1.4-->1.5


#1

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

how could I fix it?


(vipsoft) #2

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';


#3

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’


(vipsoft) #4

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.


#5

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


#6

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


(vipsoft) #7

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


#8

Thank you!


#9

[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


(kartal) #10

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.


(vipsoft) #11

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


(kartal) #12

Hi

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


(vipsoft) #13

plugins/CoreAdminHome is expected

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


#14

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:


#15

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


#16

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