Invalid SQL: SELECT `varname`,`languageid`,`text` FROM phrase

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

    Invalid SQL: SELECT `varname`,`languageid`,`text` FROM phrase


    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') AND `languageid` IN (32,0,-1);
    =====================================================

    https://www.vbulletin.com/forum/foru...re-waiting-for
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73976

    #2
    That query works without error on my database. What error did MySQL complain about?
    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
      Warning: Invalid argument supplied for foreach() in /home/user/public_html/vb/core/vb/library/content/poll.php on line 89
      [25-Apr-2017 16:26:20 Asia/Riyadh] Warning: Invalid argument supplied for foreach() in /home/user/public_html/vb/core/vb/library/content/poll.php on line 89
      [25-Apr-2017 19:04:49 Asia/Riyadh] Warning: Illegal string offset 'moderatorperms' in /home/user/public_html/vb/includes/vb5/template.php(318) : eval()'d code on line 738
      [25-Apr-2017 19:04:49 Asia/Riyadh] Warning: Illegal string offset 'channeltype' in /home/user/public_html/vb/includes/vb5/template.php(318) : eval()'d code on line 48
      [25-Apr-2017 19:04:49 Asia/Riyadh] Warning: Illegal string offset 'canmoderate' in /home/user/public_html/vb/includes/vb5/template.php(318) : eval()'d code on line 97
      [25-Apr-2017 19:13:53 Asia/Riyadh] Warning: Illegal string offset 'moderatorperms' in /home/user/public_html/vb/includes/vb5/template.php(318) : eval()'d code on line 738
      [25-Apr-2017 19:13:53 Asia/Riyadh] Warning: Illegal string offset 'channeltype' in /home/user/public_html/vb/includes/vb5/template.php(318) : eval()'d code on line 48
      [25-Apr-2017 19:13:53 Asia/Riyadh] Warning: Illegal string offset 'canmoderate' in /home/user/public_html/vb/includes/vb5/template.php(318) : eval()'d code on line 97
      [25-Apr-2017 19:33:06 Asia/Riyadh] Warning: Illegal string offset 'moderatorperms' in /home/user/public_html/vb/includes/vb5/template.php(318) : eval()'d code on line 738
      [25-Apr-2017 19:33:06 Asia/Riyadh] Warning: Illegal string offset 'channeltype' in /home/user/public_html/vb/includes/vb5/template.php(318) : eval()'d code on line 48
      [25-Apr-2017 19:33:06 Asia/Riyadh] Warning: Illegal string offset 'canmoderate' in /home/user/public_html/vb/includes/vb5/template.php(318) : eval()'d code on line 97

      [25-Apr-2017 21:26:40 Asia/Riyadh] Warning: file_get_contents(/home/user/public_html/vb/core/atta/1/5/7/9/9/4/76707.attach): failed to open stream: No such file or directory in /home/user/public_html/vb/core/vb/image.php on line 1012
      [25-Apr-2017 21:26:40 Asia/Riyadh] Warning: Cannot modify header information - headers already sent by (output started at /home/user/public_html/vb/core/vb/vb.php:1133) in /home/user/public_html/vb/includes/vb5/frontend/applicationlight.php on line 573
      [25-Apr-2017 21:26:40 Asia/Riyadh] Warning: Cannot modify header information - headers already sent by (output started at /home/user/public_html/vb/core/vb/vb.php:1133) in /home/user/public_html/vb/includes/vb5/frontend/applicationlight.php on line 574

      [25-Apr-2017 21:54:19 Asia/Riyadh] Warning: Illegal string offset 'moderatorperms' in /home/user/public_html/vb/includes/vb5/template.php(318) : eval()'d code on line 738
      [25-Apr-2017 21:54:19 Asia/Riyadh] Warning: Illegal string offset 'channeltype' in /home/user/public_html/vb/includes/vb5/template.php(318) : eval()'d code on line 48
      [25-Apr-2017 21:54:19 Asia/Riyadh] Warning: Illegal string offset 'canmoderate' in /home/user/public_html/vb/includes/vb5/template.php(318) : eval()'d code on line 97

      https://www.vbulletin.com/forum/foru...re-waiting-for

      Comment

      • saiff
        Senior Member
        • Mar 2010
        • 551

        #4

        There is also this problem



        Click image for larger version

Name:	error log.jpg
Views:	82
Size:	200.3 KB
ID:	4368915
        https://www.vbulletin.com/forum/foru...re-waiting-for

        Comment

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

          #5
          One issue at a time. Neither of your new posts has anything to do with the database error in the first post.

          The database error is related to pulling phrases.

          Post #3 refers to a problem with Polls and is a PHP error.

          Post #4 doesn't really provide any information that is helpful.


          First, what we need is the actual MySQL Error that you encountered. You merely provided a query.

          p.s. Your signature picture has been removed as it violates community rules.
          Translations provided by Google.

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

          Comment

          Related Topics

          Collapse

          Working...