database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • saiff
    Senior Member
    • Mar 2010
    • 551

    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
    https://www.vbulletin.com/forum/foru...re-waiting-for
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73979

    #2
    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.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • saiff
      Senior Member
      • Mar 2010
      • 551

      #3
      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
      https://www.vbulletin.com/forum/foru...re-waiting-for

      Comment

      • Wayne Luke
        vBulletin Technical Support Lead
        • Aug 2000
        • 73979

        #4
        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.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

        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...