Hi,
I upgraded statusnet from 0.9 to 1.0 on my server. At first it looks like all was OK. The site was up, I saw my contacts and groups and I could post new status updates. But today I discovered that I didn't receive any updates from my contacts. Do you have an idea what could be wrong? If you need any additional information, please let me know!
Thanks!
Björn
Comments
Have you checked you config ?
Did you had a look into logs ?
Can you send updates to remote instances ?
Just forgot: did you read UPGRADE file, and more specifically last part called "Privacy" ?
statusnet is now private by default, which could prevent notice reception (not sure, but never know)
Since the UPGRADE files says that private should be set to "false". I tried this, but this made my site private so I switched back to "0".
I just checked. My followers also didn't get my messages. So it seem like there is a general communication problem. I enabled the log in my config.php:
$config['site']['logfile'] = '/home/schiesbn/websites/status.schiessle.org/htdocs/logs/laconica.log';
$config['site']['logdebug'] = true;
But if I post a status update I get only a log message from the working Twitter bridge:
2011-10-04 11:54:01 LOG_INFO: [status.schiessle.org:1563.87e25cce POST /notice/new] HTTPClient: HTTP GET http://ws.geonames.org/hierarchy?geonameId=2836320&lang=en_GB - 200 OK
2011-10-04 11:54:02 LOG_INFO: [status.schiessle.org:1563.87e25cce POST /notice/new] HTTPClient: HTTP POST https://api.twitter.com/1/statuses/update.json - 200 OK
2011-10-04 11:54:02 LOG_DEBUG: [status.schiessle.org:1563.87e25cce POST /notice/new] Mapping notice 15511 to Twitter status 121191344231301120
2011-10-04 11:54:02 LOG_INFO: [status.schiessle.org:1563.87e25cce POST /notice/new] Twitter bridge - posted notice 15511 to Twitter using OAuth for User bjoern (user id 1).
Please have a look there: http://status.schiessle.org/main/version
You should see OStatus modules enabled (like on identi.ca: http://identi.ca/main/version).
You should add "addPlugin('OStatus')" in your config.php file
2011-10-04 12:27:15 LOG_ERR: [status.schiessle.org:21088.e38d6b39 POST /notice/new] PEAR Error: DB Error: no such field (SELECT *
FROM ostatus_profile
WHERE ( ostatus_profile.peopletag_id = 6 )
[nativecode=1054 ** Unbekanntes Tabellenfeld (my translation: unknown table element) 'ostatus_profile.peopletag_id' in where clause])
2011-10-04 12:27:15 LOG_ERR: [status.schiessle.org:21088.e38d6b39 POST /notice/new] Distrib queue exception saving notice 15516: DB Error: no such field #0 [internal function]: PEAR_ErrorToPEAR_Exception(Object(DB_Error)) #1 /usr/share/php/PEAR.php(890): call_user_func('PEAR_ErrorToPEA...', Object(DB_Error)) #2 /usr/share/php/DB.php(966): PEAR_Error->PEAR_Error('DB Error: no su...', -19, 16, 'PEAR_ErrorToPEA...', 'SELECT * ? FROM...') #3 /usr/share/php/PEAR.php(531): DB_Error->DB_Error(-19, 16, 'PEAR_ErrorToPEA...', 'SELECT * ? FROM...') #4 /usr/share/php/DB/common.php(1903): PEAR->raiseError(NULL, -19, NULL, NULL, 'SELECT * ? FROM...', 'DB_Error', true) #5 /usr/share/php/DB/mysqli.php(928): DB_common->raiseError(-19, NULL, NULL, NULL, '1054 ** Unbekan...') #6 /usr/share/php/DB/mysqli.php(402): DB_mysqli->mysqliRaiseError() #7 /usr/share/php/DB/common.php(1216): DB_mysqli->simpleQuery('SELECT * ? FROM...') #8 /usr/share/php/DB/DataObject.php(2513): DB_common->query('SELECT * ? FROM...') #9 /home/schiesbn/websites/status.schiessle.org/htdocs/classes/Memcached_DataObject.php(636): DB_DataObject->_query('SELECT * ? FROM...') #10 /usr/share/php/DB/DataObject.php(443): Memcached_DataObject->_query('SELECT * ? FROM...') #11 /usr/share/php/DB/DataObject.php(307): DB_DataObject->find(1) #12 /home/schiesbn/websites/status.schiessle.org/htdocs/classes/Memcached_DataObject.php(51): DB_DataObject->get('peopletag_id', '6') #13 /home/schiesbn/websites/status.schiessle.org/htdocs/plugins/OStatus/classes/Ostatus_profile.php(47): Memcached_DataObject->staticGet('Ostatus_profile', 'peopletag_id', '6') #14 /home/schiesbn/websites/status.schiessle.org/htdocs/plugins/OStatus/lib/ostatusqueuehandler.php(94): Ostatus_profile->staticGet('peopletag_id', '6') #15 /home/schiesbn/websites/status.schiessle.org/htdocs/lib/unqueuemanager.php(50): OStatusQueueHandler->handle(Object(Notice)) #16 /home/schiesbn/websites/status.schiessle.org/htdocs/lib/util.php(1498): UnQueueManager->enqueue(Object(Notice), 'ostatus') #17 /home/schiesbn/websites/status.schiessle.org/htdocs/lib/distribqueuehandler.php(94): common_enqueue_notice(Object(Notice)) #18 /home/schiesbn/websites/status.schiessle.org/htdocs/lib/unqueuemanager.php(50): DistribQueueHandler->handle(Object(Notice)) #19 /home/schiesbn/websites/status.schiessle.org/htdocs/classes/Notice.php(2104): UnQueueManager->enqueue(Object(Notice), 'distrib') #20 /home/schiesbn/websites/status.schiessle.org/htdocs/classes/Notice.php(633): Notice->distribute() #21 /home/schiesbn/websites/status.schiessle.org/htdocs/actions/newnotice.php(221): Notice::saveNew('1', 'dam, still some...', 'web', Array) #22 /home/schiesbn/websites/status.schiessle.org/htdocs/actions/newnotice.php(109): NewnoticeAction->saveNewNotice() #23 /home/schiesbn/websites/status.schiessle.org/htdocs/index.php(357): NewnoticeAction->handle(Array) #24 /home/schiesbn/websites/status.schiessle.org/htdocs/index.php(372): main() #25 {main}
Seems like you DB schema is not up-to-date.
Please check config param: $config['db']['schemacheck']
and execute scripts/checkschema.php which is located in statusnet installdir
This should update you DB scheme and make your log cleaner.
$config['db']['schemacheck'] is set to "script" directly in the db, not in the config.php
"php scripts/checkschema.php" seems to does the trick. The error message is gone
Thank you very much for your help!
$config['db']['schemacheck'] set to "script" means that you have to "manually" make changes.
php scripts/checkschema.php execution should have solved the problem.
Please check again your logs and report.
You're welcome, was happy to help :)