Hi Damon!
When Stream is activated it creates 3 new database tables. Based on what you just described it sounds like it could be that your server environment is preventing new tables from being created.
If you are able, go check your WordPress database tables (using phpMyAdmin or something) and look for wp_stream, wp_stream_context, and wp_stream_meta. If they aren’t there, then you will need to contact your database administrator/hosting company.
Please keep us posted!
Frankie,
Yes, I see 3 db tables were created 12/12: wp_stream_meta, wp_stream, wp_stream_context. Still no information displaying on the Stream dashboard. I just upgraded to 0.8.1
Please advise.
Hey Damon, just re-reading your first comment, I see that you mentioned you are a “Super Admin”.
It should be noted that the plugin doesn’t fully support Multisite yet. We are tracking it as an issue in GitHub (#65).
There is already a support forum topic for this: http://ww.wp.xz.cn/support/topic/network-multisite?replies=4
I misspoke. I’m not running multisite, but just an individual site. I just meant user 1, Admin role.
Hey Damon, just spoke with all the other lead devs for Stream and none of us are able to replicate what you are describing here. Also, it seems this issue may be isolated because it hasn’t been reported by any other users yet.
So I guess the only thing left to do is get more information from you in hopes it might point us in some kind of direction:
- PHP version
- MySQL version
- WordPress version
- Stream plugin version
Sure, of course:
1. PHP 5.3.27
2. MySQL 5.5.9
3. WordPress 3.8
4. Stream 0.8.2
I’m going to try installing on another site on our hosting to see if the issue persists throughout our Linux box, and will report back briefly.
I just tried on another one of our sites.
This site had the following configuration:
1. PHP 5.3.27
2. MySQL 5.5.9
3. WordPress 3.7.1
4. Stream 0.8.2
I installed Stream, went and created a new Post and saved as a Draft, then visited Stream dashboard and saw nothing. Am I not using it correct? I was logged in as Admin.
I verified that the three Stream tables were created in the db.
Very strange indeed, can you enable WP_DEBUG to see if there are any errors being thrown?
If this is a production site and you can’t do that, please take a look at the server’s PHP error log.
Ah, here we go…error log says:
WordPress database error Field ‘ip’ doesn’t have a default value for query INSERT INTO vi3pl_stream (created,summary) VALUES (‘2013-12-13 13:23:54′,’ logged out’) made by wp_clear_auth_cookie, do_action(‘clear_auth_cookie’), call_user_func_array, WP_Stream_Connector::callback, call_user_func_array, WP_Stream_Connector_Users::callback_clear_auth_cookie, WP_Stream_Connector::log, WP_Stream_Log->log, WP_Stream_DB->insert
Not sure what this implies though.
Thanks for the info, Damon.
Since we can’t reproduce this, it would be great if you could try some things for us here to see if we can resolve these errors.
Open the includes/log.php file. And scroll to the bottom.
1) Change the ‘ip’ argument like so: https://gist.github.com/fjarrett/8058052#file-gistfile1-php-L30
2) And add these two lines before the $recordarr: https://gist.github.com/fjarrett/8058052#file-gistfile1-php-L18-L19
Ok, I modified the file with both edits. Deactivated, re-activated plugin, deleted Post, and went to Stream dash and there is nothing recorded.
And does the same error appear in the PHP log, or a different one?
I tried disabling all plugins on the site, and this did not resolve either.
To make things weirder and more confusing I tried installing on a third site on same server and it works. This site is PHP: 5.3.27, MySQL: 5.0.96, WP 3.8, with Stream 0.8.2. However, I did notice on this site that there are so far 5 entries for Stream, and under the IP column nothing is listed.
OK on the last site you tried (the one where Stream worked), did you also modify the log.php file on that site?
If yes, try using the plugin as-is without the gist changes I gave you and see if the IP appears in the records.
No error seems to have stopped. I just have a few entries for:
[20-Dec-2013 17:44:30 UTC] Use Google Libraries: Another plugin has registered or enqued a script before the “init” action. Attempting to work around it.
Which aren’t related, but that is why I tried disabling all plugins to narrow the debugging, but didn’t help.
