New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Investigation: Fatal error: Class 'Piwik_Db_Schema_Myisam' not found in core/Db/Schema.php on line 139 #3049
Comments
The missing file is core/Db/Schema/Myisam.php https://github.com/piwik/piwik/blob/master/5924/trunk/core/Db/Schema/Myisam.php I've confirmed that the file exists in the .zip file. Sounds like a problem when batch uploading the files from one's desktop (e.g., a file dropped by Filezilla). |
Sorry I don't have permissions to reopen this ticket, but it does need to be reopened. vipsoft said in #comment:1
I know that the file exists:
I have also tried replacing it with the svn version as suggested on the forum http://forum.piwik.org/read.php?2,85650,page=1#msg-85657
And still the same error message all over the place:
The fact that the error reports that there is a problem with line 139 indicates to me that piwik is aware that the file exists?
Any suggestions about how I can fix this problem? I have also tried running the cron job to rebuild the graphs and also reinstalling APC, which was reported to fix the bug on the forum, see http://forum.piwik.org/read.php?2,85650,page=1#msg-87189 |
Please use the corrected link above. It should be rev 5924. |
Replying to vipsoft:
I have done that:
And it hasn't made any difference, this error message appears all over the place in the piwik admin interface:
However the class is in the file, line 19:
And this is line 139:
Is there anything else I can try? Thanks |
cc, not sure what the problem is in your case... appart from this error, is Piwik working or is it broken? can you try a fresh 1.7.1 install? maybe some other files are corrupted. Or maybe there is some kind of auto loader bug on your config? |
Replying to matt:
It's partially working, but the admin interface mostly displays this error, see the screenshot posted to the forums -- this is what I get also. I still don't think this ticket should be closed as this bug is not resolved. http://forum.piwik.org/file.php?2,file=501
By a fresh install do you mean use the existing database with a new set of pwiki files? Because this is what I did... If it helps at all I documented the upgrade here https://tech.transitionnetwork.org/trac/ticket/393 it was done initially on a development server, which didn't have this problem, and then on the live server and this is where the problem occurs. How would I test to see if there is a "auto loader bug on your config"? |
on your live server, can you try reinstall piwik in a new DB, in a new directory, do you see the same bug? or have you really done that already? |
Replying to matt:
The upgrade was done using a new directory in the same location (old one moved out of the way as a backup), but I kept the existing database and ran the database update on the command line. I can do a totally fresh install, later today, and run it on another domain name with a new database but I'm not sure how this will help getting the existing site with the bug working properly? |
if your new install works, you can move the config.ini.php over to the new one, delete old one, move new one over old one |
I have done a new install, in a new directory, with a new database, on a new domain name and I get the same error (I haven't copied across the old config file, a new one has been created):
Details of the new install here, https://tech.transitionnetwork.org/trac/ticket/393#comment:11 You can login yourself to see:
|
Maybe it's an APC+autoloader conflict? Open core/Piwik/Db/Schema.php in an editor. At the end of the file, you should see the interface definition for Piwik_Db_Schema_Interface. Try removing the interface from Schema.php, and creating a new file in core/Piwik/Db/Schema/Interface.php that contains:
|
Thanks for looking at this problem. Replying to vipsoft:
Perhaps, the other person with this problem solved it with a APC reinstall, see http://forum.piwik.org/read.php?2,85650,page=1#msg-87189
That file doesn't exist, but there is a
Yes.
I commented line 266 to the end.
I created
Is there anything else I can try? |
Sorry about the typo -- I was responding from my phone. =P Glad, you figured out the right paths. In ./index.php, change these lines:
to:
And reload the URL to your dashboard. What do you see? |
Replying to vipsoft:
Ah, no worries, you must have a better phone than me, I gave up trying to use trac on mine after one attempt ;-) I have made the changes and is is what is now displayed:
|
Opps, this is with the whitespace fixed:
|
Yes, it's a bit masochistic. Just because one can fork a github project, edit a file, and submit a pull request from one's phone, doesn't mean one should. ;) But I digress. It's quite perplexing given that index.php is the central dispatcher that calls the front controller for all dashboard, widget, and API requests. I was hoping it would fail. I assume you're not using bootstrap.php to override PIWIK_INCLUDE_PATH. If you can you email ssh login/password to us, we can take a look and try to diagnose the root cause. |
Replying to vipsoft:
LOL
No, I have never touched that file.
That's OK with me but, I need to check with the client first, can you email a ssh public key to the email address at the bottom of this page: http://quince.transitionnetwork.org/ (the anti-spam features on this trac install mean that email addresses don't show up here). Thanks a lot. |
Replying to cc:
The client is OK with this, it's a production server so I'm slightly nervous about it... can you either email me your pgp public key or a ssh public key so I can get it set up securely? Thanks Chris |
Replying to vipsoft:
Replying to cc:
I don't appear to have heard from you, is this offer to help still available? My email address is at the bottom of this page http://quince.transitionnetwork.org/ Thanks again Chris |
If you don't have time to look at the problem I'm having with Piwik could you at least reopen this ticket so others can see it's not solved in case someone else is able to help with it? |
Replying to cc:
I have shut this test site down now as I don't think it's needed any more. I'd still appreciate it if this ticket could be re-opened even if nobody has any time to look at this problem at the moment -- closed as "answered" is not an accurate state -- the problem is ongoing and the pikwi install at stats.transitionnetwork.org still has an unusable web interface. |
Sorry you still have the problem. I must say we are too busy to help at this stage apparently, but if more users experience this ticket or if we have less work in the future we will look into. Thanks! |
On ticket:3092#comment:1 matt agreed that this ticked should be reopened, could that now be done as this problem isn't resolved. I appreciate that you don't consider this to be a Piwik problem but there clearly is a problem with the Piwik install I have running even if the problem is with the way that the environment is configured (it was suggested that the problem could be with APC). |
I have emailed chris my ssh public key and re-opened for investigation. |
Nice one, I see you have got in, thanks a lot for looking at this :-) |
Resolved; turning off apc.include_once_override (experimental) and setting apc.mmap_file_mask = /dev/zero I'll update the FAQ and forum post. |
Thank a lot for looking at this, the problem was with APC, specifically these two settings in
When these were changed to:
The problems were fixed :-) |
After upgrading to 1.7.1 most the piwik admin pages display this error:
Fatal error: Class 'Piwik_Db_Schema_Myisam' not found in (..)/piwik/core/Db/Schema.php on line 139
This has been raised on the forum here: http://forum.piwik.org/read.php?2,85650
Neither of the suggested solutions there worked, they are:
Are there any other suggestions regarding how to address this problem?
The text was updated successfully, but these errors were encountered: