Announcement

Collapse
No announcement yet.

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

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

  • 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

  • #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 customization and demonstration site.
    vBulletin 5 Documentation - Updated every Friday. Report issues here.
    vBulletin 5 API - Full / Mobile
    I am not currently available for vB Messenger Chats.

    Comment


    • #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


      • #4

        There is also this problem



        Click image for larger version

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

        Comment


        • #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 customization and demonstration site.
          vBulletin 5 Documentation - Updated every Friday. Report issues here.
          vBulletin 5 API - Full / Mobile
          I am not currently available for vB Messenger Chats.

          Comment

          Related Topics

          Collapse

          Working...
          X