Misawinb's Video

Go Back Previous Next

Great is Thy Faithfulness

More Videos

         ADOConnection._Execute(SELECT v.playing_time, v.video_id, v.user_id, v.video_title, v.video_caption, TIMEDIFF(NOW(), date_added) as date_added, v.video..., false) % line  853, file: adodb.inc.php
      ADOConnection.Execute(SELECT v.playing_time, v.video_id, v.user_id, v.video_title, v.video_caption, TIMEDIFF(NOW(), date_added) as date_added, v.video...) % line 1120, file: viewVideo.php
   ViewVideo.populateRleatedVideo(tag) % line 1218, file: viewVideo.php
ViewVideo.displayVideo() % line 2006, file: viewVideo.php
require_once(/home/mychrist/public_html/general/viewVideo.php) % line   48, file: viewVideo.php

Error: [256] [User Error] 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's[[:>:]]|[[:<:]]love[[:>:]]|[[:<:]]faithful[[:>:]]|[[:<:]]strength[[:>:]]') AN' at line 1
Line: [1122] /home/mychrist/public_html/general/viewVideo.php
Source:

1120                $rs = $this->dbObj->Execute($stmt);
1121                    if (!$rs)
1122                        trigger_error($this->dbObj->ErrorNo().' '.$this->dbObj->ErrorMsg(), E_USER_ERROR);
1123
1124                $total_records = $rs->PO_RecordCount();

Debug Trace:

      Line: [1122] /home/mychrist/public_html/general/viewVideo.php
      trigger_error("1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's[[:>:]]|[[:<:]]love[[:>:]]|[[:<:]]faithful[[:>:]]|[[:<:]]strength[[:>:]]')   AN' at line 1", "256")
    Line: [1218] /home/mychrist/public_html/general/viewVideo.php
    ViewVideo->populateRleatedVideo("tag")
  Line: [2006] /home/mychrist/public_html/general/viewVideo.php
  ViewVideo->displayVideo()
Line: [48] /home/mychrist/public_html/viewVideo.php
require_once("/home/mychrist/public_html/general/viewVideo.php")

Context Variables:

array (
  'pg' => 'tag',
  'default_fields' => 'v.playing_time, v.video_id, v.user_id, v.video_title, v.video_caption, TIMEDIFF(NOW(), date_added) as date_added, v.video_server_url, v.total_views, v.s_width, v.s_height, v.video_ext, v.video_tags',
  'add_fields' => '',
  'order_by' => 'v.video_id DESC',
  'video_tags' => 'Piano music christian worship praise God\''s love faithful strength',
  'sql_condition' => 'v.video_id!=''111'' AND v.video_status=''Ok'' AND  (video_tags REGEXP ''[[:<:]]Piano[[:>:]]|[[:<:]]music[[:>:]]|[[:<:]]christian[[:>:]]|[[:<:]]worship[[:>:]]|[[:<:]]praise[[:>:]]|[[:<:]]God\''''s[[:>:]]|[[:<:]]love[[:>:]]|[[:<:]]faithful[[:>:]]|[[:<:]]strength[[:>:]]'')   AND (v.user_id = 0 OR v.video_access_type = ''Public'')',
  'more_link' => 'http://mychristianmusicvideos.com/videolist/videonew/?tags=Piano music christian worship praise God\''s love faithful strength',
  'sql' => 'SELECT v.playing_time, v.video_id, v.user_id, v.video_title, v.video_caption, TIMEDIFF(NOW(), date_added) as date_added, v.video_server_url, v.total_views, v.s_width, v.s_height, v.video_ext, v.video_tags FROM video AS v WHERE v.video_id!=''111'' AND v.video_status=''Ok'' AND  (video_tags REGEXP ''[[:<:]]Piano[[:>:]]|[[:<:]]music[[:>:]]|[[:<:]]christian[[:>:]]|[[:<:]]worship[[:>:]]|[[:<:]]praise[[:>:]]|[[:<:]]God\''''s[[:>:]]|[[:<:]]love[[:>:]]|[[:<:]]faithful[[:>:]]|[[:<:]]strength[[:>:]]'')   AND (v.user_id = 0 OR v.video_access_type = ''Public'') ORDER BY v.video_id DESC LIMIT 4',
  'stmt' => 'SELECT v.playing_time, v.video_id, v.user_id, v.video_title, v.video_caption, TIMEDIFF(NOW(), date_added) as date_added, v.video_server_url, v.total_views, v.s_width, v.s_height, v.video_ext, v.video_tags FROM video AS v WHERE v.video_id!=''111'' AND v.video_status=''Ok'' AND  (video_tags REGEXP ''[[:<:]]Piano[[:>:]]|[[:<:]]music[[:>:]]|[[:<:]]christian[[:>:]]|[[:<:]]worship[[:>:]]|[[:<:]]praise[[:>:]]|[[:<:]]God\''''s[[:>:]]|[[:<:]]love[[:>:]]|[[:<:]]faithful[[:>:]]|[[:<:]]strength[[:>:]]'')   AND (v.user_id = 0 OR v.video_access_type = ''Public'') ORDER BY v.video_id DESC LIMIT 4',
  'rs' => ,
)
Script error occured. Please retry later!