After the upgrade i got this error
Mysqli prepare error: Unknown column ‘revenue_subtotal’ in ‘field list’
how could I fix it?
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!
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