Announcement

Collapse
No announcement yet.

database error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Wayne Luke
    replied
    It is a warning message and really shouldn't effect the overall operation of your site. Without the actual POLL data (not available from the message), there is no way to know what is causing the issue.

    Leave a comment:


  • saiff
    replied
    you're right wayne, I deleted the caches, after 12 hours only found this message


    [03-Nov-2018 11:25:42 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 11:25:42 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 11:26:17 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 11:26:17 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 13:44:56 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 13:44:56 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 14:20:46 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 14:20:46 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 14:21:28 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 14:21:28 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 14:21:34 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 14:21:34 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 14:21:40 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 14:21:40 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 14:39:58 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 14:39:58 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 15:04:24 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 15:04:24 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 15:04:27 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 15:04:27 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 15:14:17 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 15:14:17 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 16:30:11 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 16:30:11 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 16:32:17 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 16:32:17 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 16:33:20 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 16:33:20 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 16:34:45 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 16:34:45 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 16:39:15 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 16:39:15 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 16:47:48 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 16:47:48 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 18:05:31 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 18:05:31 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 18:06:34 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 18:06:34 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 18:10:43 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 18:10:43 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 18:15:17 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [03-Nov-2018 18:15:17 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86

    Leave a comment:


  • Wayne Luke
    replied
    I don't see a database error here. What is the database error that corresponds with this?

    It vaguely looks like a Node Key is missing from your cache table. You can delete the contents of the cache and cacheevents table in the AdminCP under Mainentance - > Delete System Cache.

    Leave a comment:


  • saiff
    started a topic database error

    database error

    hi,
    I found this error in the error_log:

    [01-Nov-2018 22:00:54 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [01-Nov-2018 22:00:54 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86
    [01-Nov-2018 22:04:32 Asia/Riyadh] Invalid SQL:
    /** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
    ('node_17661628_lvl1data','nodeChg_17661628'),
    ('node_17621312_lvl1data','nodeChg_17621312'),
    ('node_17613528_lvl1data','nodeChg_17613528'),
    ('node_17489905_lvl1data','nodeChg_17489905'),
    ('node_17489761_lvl1data','nodeChg_17489761'),
    ('node_17489231_lvl1data','nodeChg_17489231'),
    ('node_17489230_lvl1data','nodeChg_17489230'),
    ('node_17489229_lvl1data','nodeChg_17489229'),
    ('node_17489228_lvl1data','nodeChg_17489228'),
    ('node_17487307_lvl1data','nodeChg_17487307'),
    ('node_17487306_lvl1data','nodeChg_17487306'),
    ('node_17483342_lvl1data','nodeChg_17483342'),
    ('node_17483341_lvl1data','nodeChg_17483341'),
    ('node_17482240_lvl1data','nodeChg_17482240'),
    ('node_17482155_lvl1data','nodeChg_17482155'),
    ('node_17481717_lvl1data','nodeChg_17481717'),
    ('node_17481354_lvl1data','nodeChg_17481354'),
    ('node_17480106_lvl1data','nodeChg_17480106'),
    ('node_17487427_lvl1data','nodeChg_17487427'),
    ('node_17481153_lvl1data','nodeChg_17481153'),
    ('node_17873182_lvl1data','nodeChg_17873182'),
    ('node_17872075_lvl1data','nodeChg_17872075'),
    ('node_17869562_lvl1data','nodeChg_17869562'),
    ('node_17842115_lvl1data','nodeChg_17842115'),
    ('node_17841190_lvl1data','nodeChg_17841190'),
    ('node_17841157_lvl1data','nodeChg_17841157'),
    ('node_17838539_lvl1data','nodeChg_17838539'),
    ('node_17837125_lvl1data','nodeChg_17837125'),
    ('node_17837087_lvl1data','nodeChg_17837087'),
    ('node_17837084_lvl1data','nodeChg_17837084'),
    ('node_17836885_lvl1data','nodeChg_17836885'),
    ('node_17836840_lvl1data','nodeChg_17836840'),
    ('node_17836486_lvl1data','nodeChg_17836486'),
    ('node_17836451_lvl1data','nodeChg_17836451'),
    ('node_17836219_lvl1data','nodeChg_17836219'),
    ('node_17820445_lvl1data','nodeChg_17820445'),
    ('node_17795865_lvl1data','nodeChg_17795865'),
    ('node_17795681_lvl1data','nodeChg_17795681'),
    ('node_17783259_lvl1data','nodeChg_17783259'),
    ('node_17489816_lvl1data','nodeChg_17489816'),
    ('node_17488271_lvl1data','nodeChg_17488271'),
    ('node_17488268_lvl1data','nodeChg_17488268'),
    ('node_17488196_lvl1data','nodeChg_17488196'),
    ('node_17488193_lvl1data','nodeChg_17488193'),
    ('node_17487958_lvl1data','nodeChg_17487958'),
    ('node_17487957_lvl1data','nodeChg_17487957'),
    ('node_17482723_lvl1data','nodeChg_17482723'),
    ('node_17482721_lvl1data','nodeChg_17482721'),
    ('node_17482439_lvl1data','nodeChg_17482439'),
    ('node_17482299_lvl1data','nodeChg_17482299'),
    ('node_17482298_lvl1data','nodeChg_17482298'),
    ('node_17482297_lvl1data','nodeChg_17482297'),
    ('node_17482296_lvl1data','nodeChg_17482296'),
    ('node_17482119_lvl1data','nodeChg_17482119'),
    ('node_17482118_lvl1data','nodeChg_17482118'),
    ('node_17482084_lvl1data','nodeChg_17482084'),
    ('node_17481773_lvl1data','nodeChg_17481773'),
    ('node_17481525_lvl1data','nodeChg_17481525'),
    ('node_17481288_lvl1data','nodeChg_17481288'),
    ('node_17481287_lvl1data','nodeChg_17481287'),
    ('node_17481286_lvl1data','nodeChg_17481286'),
    ('node_17481224_lvl1data','nodeChg_17481224'),
    ('node_17481222_lvl1data','nodeChg_17481222'),
    ('node_17481219_lvl1data','nodeChg_17481219'),
    ('node_17481188_lvl1data','nodeChg_17481188'),
    ('node_17481187_lvl1data','nodeChg_17481187'),
    ('node_17481184_lvl1data','nodeChg_17481184'),
    ('node_17481183_lvl1data','nodeChg_17481183'),
    ('node_17481182_lvl1data','nodeChg_17481182'),
    ('node_17481179_lvl1data','nodeChg_17481179'),
    ('node_17481178_lvl1data','nodeChg_17481178'),
    ('node_17481177_lvl1data','nodeChg_17481177'),
    ('node_17481176_lvl1data','nodeChg_17481176'),
    ('node_17481175_lvl1data','nodeChg_17481175'),
    ('node_17481174_lvl1data','nodeChg_17481174'),
    ('node_17481146_lvl1data','nodeChg_17481146'),
    ('node_17481145_lvl1data','nodeChg_17481145'),
    ('node_17481144_lvl1data','nodeChg_17481144'),
    ('node_17481143_lvl1data','nodeChg_17481143'),
    ('node_17481142_lvl1data','nodeChg_17481142'),
    ('node_17480795_lvl1data','nodeChg_17480795'),
    ('node_17480794_lvl1data','nodeChg_17480794'),
    ('node_17480793_lvl1data','nodeChg_17480793'),
    ('node_17480767_lvl1data','nodeChg_17480767'),
    ('node_17480511_lvl1data','nodeChg_17480511'),
    ('node_17480509_lvl1data','nodeChg_17480509'),
    ('node_17480502_lvl1data','nodeChg_17480502'),
    ('node_17480216_lvl1data','nodeChg_17480216'),
    ('node_17479021_lvl1data','nodeChg_17479021'),
    ('node_17479013_lvl1data','nodeChg_17479013'),
    ('node_17481326_lvl1data','nodeChg_17481326'),
    ('node_17481325_lvl1data','nodeChg_17481325'),
    ('node_17479020_lvl1data','nodeChg_17479020'),
    ('node_17478969_lvl1data','nodeChg_17478969'),
    ('node_17478698_lvl1data','nodeChg_17478698'),
    ('node_17478697_lvl1data','nodeChg_17478697');
    ## /home/xxxx/public_html/vb/core/vb/database.php(1189) Exception Thrown
    #0 /home/xxx/public_html/vb/core/vb/database/mysqli.php(201): vB_Database->halt()
    #1 /home/xxxx/public_html/vb/core/vb/database.php(542): vB_Database_MySQLi->execute_query(true, Object(mysqli))
    #2 /home/xxxx/public_html/vb/core/vb/db/mysql/querydefs.php(7315): vB_Database->query_write('/** saveDbCache...')
    #3 /home/xxx/public_html/vb/core/vb/db/query/method.php(175): vB_dB_MYSQL_QueryDefs->saveDbCache(Array, Object(vB_Database_MySQLi), false, false)
    #4 /home/xxxx/public_html/vb/core/vb/db/assertor.php(301): vB_dB_Query_Method->execSQL()
    #5 /home/xxxx/public_html/vb/core/vb/cache/db.php(390): vB_dB_Assertor->assertQuery('saveDbCache', Array)
    #6 [internal function]: vB_Cache_Db->shutdown()
    #7 /home/xxxx/public_html/vb/core/vb/shutdown.php(93): call_user_func(Array)
    #8 /home/xxx/public_html/vb/core/vb/vb.php(486): vB_Shutdown->shutdown()
    #9 [internal function]: vB::shutdown()
    #10 {main}
    [01-Nov-2018 22:13:26 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/vb/core/vb/library/content/poll.php on line 86

Related Topics

Collapse

  • MertTurk
    Vbulletin 5 Gruevo.Com
    by MertTurk
    Powered by vBulletin Upgrades 5 I did, but there was a problem? What does this mean Fatal error: Class 'BB' not found in / storage/content/58/146158/gruevo.com/public_html/includes/vb5/template.php on...
    Tue 2 Oct '12, 6:32am
  • saiff
    Invalid SQL: SELECT `varname`,`languageid`,`text` FROM phrase
    by saiff
    What is this error?



    Invalid SQL:
    SELECT `varname`,`languageid`,`text` FROM phrase
    WHERE `varname` IN ('Description cannot be empty. Please set this field.','go_back','my_profile','my_recent_posts','user_settings','log_out','logo','search' ,'filter_search','navbar_home','navbar_blogs','navbar_articles','navbar_social_groups','na vbar_158516011593_15751604158916081585','navbar_15751604157816081575160216101593','navbar_ 15781586161016101606_15751604160516081575159016101593','navbar_newtopics','navbar_todays_p osts','navbar_whos_online','navbar_mark_channels_read','navbar_member_list','search_in_tit les_only','advanced_search','notice_23_html','navbar_help','navbar_contact_us','go_to_top' ,'powered_by_vbulletin','footer_current_time','working_ellipsis','yes','no','ok','cancel')...
    Tue 25 Apr '17, 5:14am
  • bollie
    PHP Warning
    by bollie
    [Thu Mar 01 14:08:56.052710 2018] [:error] [pid 26055] [client 81.11.134.242:62458] PHP Warning: fwrite() expects parameter 1 to be resource, boolean given in /home/pctuts/domains/pctuts.be/public_html/core/vb/api/user.php...
    Thu 1 Mar '18, 4:21am
Working...
X