Hi,

I installed and setup this module, put the block on the left sidebar of my site : www.zvps.co.uk.
Everything was working fine.

Today i was notified my site was showing a 500 internal server error.

On investigating the server logs i found one error repeated as I refreshed the page:

[Wed May 02 05:14:14 2012] [error] [client 37.59.16.142] PHP Fatal error:  Call to undefined function _twitter_db_generate_content() in /var/zpanel/hostdata/zadmin/public_html/zvps_co_uk/sites/all/modules/twitter_db/twitter_db.module on line 79
[Wed May 02 06:10:59 2012] [error] [client 89.149.59.174] PHP Fatal error:  Call to undefined function _twitter_db_generate_content() in /var/zpanel/hostdata/zadmin/public_html/zvps_co_uk/sites/all/modules/twitter_db/twitter_db.module on line 79, referer: http://forums.zpanelcp.com/showthread.php?7133-zVPS-Start-Supporting-ZpanelCP!/page2
[Wed May 02 06:11:04 2012] [error] [client 89.149.59.174] PHP Fatal error:  Call to undefined function _twitter_db_generate_content() in /var/zpanel/hostdata/zadmin/public_html/zvps_co_uk/sites/all/modules/twitter_db/twitter_db.module on line 79
[Wed May 02 06:12:56 2012] [error] [client 89.149.59.174] PHP Fatal error:  Call to undefined function _twitter_db_generate_content() in /var/zpanel/hostdata/zadmin/public_html/zvps_co_uk/sites/all/modules/twitter_db/twitter_db.module on line 79, referer: http://forums.zpanelcp.com/showthread.php?7133-zVPS-Start-Supporting-ZpanelCP!/page3
[Wed May 02 06:40:20 2012] [error] [client 66.249.71.179] PHP Fatal error:  Call to undefined function _twitter_db_generate_content() in /var/zpanel/hostdata/zadmin/public_html/zvps_co_uk/sites/all/modules/twitter_db/twitter_db.module on line 79
[Wed May 02 07:11:33 2012] [error] [client 66.249.71.179] PHP Fatal error:  Call to undefined function _twitter_db_generate_content() in /var/zpanel/hostdata/zadmin/public_html/zvps_co_uk/sites/all/modules/twitter_db/twitter_db.module on line 79
[Wed May 02 07:17:39 2012] [error] [client 220.181.108.76] PHP Fatal error:  Call to undefined function _twitter_db_generate_content() in /var/zpanel/hostdata/zadmin/public_html/zvps_co_uk/sites/all/modules/twitter_db/twitter_db.module on line 79
[Wed May 02 07:17:40 2012] [error] [client 123.125.71.17] PHP Fatal error:  Call to undefined function _twitter_db_generate_content() in /var/zpanel/hostdata/zadmin/public_html/zvps_co_uk/sites/all/modules/twitter_db/twitter_db.module on line 79
[Wed May 02 07:28:09 2012] [error] [client 66.249.71.179] PHP Fatal error:  Call to undefined function _twitter_db_generate_content() in /var/zpanel/hostdata/zadmin/public_html/zvps_co_uk/sites/all/modules/twitter_db/twitter_db.module on line 79
[Wed May 02 07:31:28 2012] [error] [client 94.21.153.24] PHP Fatal error:  Call to undefined function _twitter_db_generate_content() in /var/zpanel/hostdata/zadmin/public_html/zvps_co_uk/sites/all/modules/twitter_db/twitter_db.module on line 79, referer: http://forums.zpanelcp.com/member.php?4378-Caffeine-Addict

PHP Fatal error: Call to undefined function _twitter_db_generate_content() in /var/zpanel/hostdata/zadmin/public_html/zvps_co_uk/sites/all/modules/twitter_db/twitter_db.module on line 79

On deleting the module folder in /sites/all/modules/twitter_db the site instantly started working again.

Any ideas on what would have caused such a crash? I have not touched the site since setting up the twitter db module, the site first started getting the error at 5am... no other errors in the error_log...

Comments

Caffeine Addict’s picture

Caffeine Addict commented

Looking in the drupal_watchdog table i've found some suspect errors:

'Twitter DB: update', 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ''197088374769729537'' for key ''PRIMARY''', '1335929310'
'job_scheduler', 'Finished processing scheduled jobs (!time s, !total total, !failed failed).', '1335929310'
'job_scheduler', 'Could not find Job Scheduler cron information for twitter_db_update', '1335970399'

Just before the site started showing the php errors in the apache error_log...

Caffeine Addict’s picture

Caffeine Addict commented

Anyone got any ideas where I can start looking to solve this issue? Its quite a critical bug..

dhavyd’s picture

dhavyd commented
Assigned: Unassigned » dhavyd

Hi! It sounds very critical... I'll look at that and will return about it in a few days...

Caffeine Addict’s picture

Caffeine Addict commented

Thanks, I've yet to start looking at it myself, I have however installed the beta version and that seems ok so far... need to start tweeting to see ...

acke’s picture

acke commented

I also see the notice for SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '198886609729490944' for key 'PRIMARY' in the log when cron runs. But the site is working and job scheduler runs fine.

dhavyd’s picture

dhavyd commented
Status: Active » Closed (cannot reproduce)

Hi! I have looked for the error, but I could not reproduce it whti the latest code for the module. I wonder is due to other factors... I plain to rebuild the module and merge the functions for the version 1 and 2. The new version will have the Twitter accounts as fields. I'll do it in a few months.

I close this issue so far... Please, reopen this issue if the problem persists.

Caffeine Addict’s picture

Caffeine Addict commented

No worries, thanks very much for spending some time on this!

I've not had this happen again with the latest beta version so fingers crossed.