search

WWBN / AVideo

Create Your Own Broadcast Network With AVideo Platform Open-Source. OAVP OVP
https://avideo.tube/AVideo_OpenSource
Other
1.91k stars 972 forks source link

Livesearch plugin not work #6584

Closed wetubeclub closed 2 years ago

wetubeclub commented 2 years ago

Hello, The livesearch on my site does not work any more I disabled the following plugins PPV and PPV live and it started working some help ?

Thank you Ilias

[14-May-2022 14:32:11 Europe/Stockholm] AVideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed again return false SCRIPT_NAME: /view/index.php

[14-May-2022 14:32:11 Europe/Stockholm] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/var\/www\/html\/AVideo\/objects\/mysql_dal.php","line":171,"function":"log_error"},{"file":"\/var\/www\/html\/AVideo\/plugin\/PayPerViewLive\/Objects\/Ppvlive_schedule.php(18) : eval()'d code(1) : eval()'d code","line":215,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/PayPerViewLive\/PayPerViewLive.php(18) : eval()'d code(1) : eval()'d code","line":167,"function":"getAll","class":"Ppvlive_schedule","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/AVideoPlugin.php","line":881,"function":"getLiveApplicationArray","class":"PayPerViewLive","type":"->"},{"file":"\/var\/www\/html\/AVideo\/objects\/functions.php","line":6932,"function":"getLiveApplicationArray","class":"AVideoPlugin","type":"::"}] SCRIPT_NAME: /view/index.php

[14-May-2022 14:32:11 Europe/Stockholm] AVideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed: (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 'AND ( parameters LIKE '%james%' OR CONVERT(CAST(parameters as BINARY) USIN' at line 1) preparedStatement = "SELECT pp., s. FROM ppvlive_schedule s LEFT JOIN ppvlive_plans pp ON pp.id = ppvlive_plans_id WHERE 1=1 AND live_ends > NOW() AND live_starts > NOW() AND pp.status = 'a' AND s.status = 'a' ORDER BY live_starts ASC AND ( parameters LIKE '%james%' OR CONVERT(CAST(parameters as BINARY) USING utf8) LIKE '%james%' ) LIMIT 0, 1000 " formats = "" values = [] refreshCache = false stmt = false SCRIPT_NAME: /view/index.php

[14-May-2022 14:32:11 Europe/Stockholm] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/var\/www\/html\/AVideo\/objects\/mysql_dal.php","line":166,"function":"log_error"},{"file":"\/var\/www\/html\/AVideo\/plugin\/PayPerViewLive\/Objects\/Ppvlive_schedule.php(18) : eval()'d code(1) : eval()'d code","line":215,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/PayPerViewLive\/PayPerViewLive.php(18) : eval()'d code(1) : eval()'d code","line":167,"function":"getAll","class":"Ppvlive_schedule","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/AVideoPlugin.php","line":881,"function":"getLiveApplicationArray","class":"PayPerViewLive","type":"->"},{"file":"\/var\/www\/html\/AVideo\/objects\/functions.php","line":6932,"function":"getLiveApplicationArray","class":"AVideoPlugin","type":"::"}] SCRIPT_NAME: /view/index.php

...

DanielnetoDotCom commented 2 years ago

Thanks for noticing that.

I just sent a new version of PayPerViewLive version 2.3 that may resolve this problem. please confirm

wetubeclub commented 2 years ago

Hello Daniel, is working normally now!!

Thank you Ilias

wetubeclub commented 2 years ago

S.O.S the search works but the videos are not displayed and code is displayed

kodd

[14-May-2022 18:13:48 Europe/Stockholm] AVideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed again return false SCRIPT_NAME: /view/index.php

[14-May-2022 18:13:48 Europe/Stockholm] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/var\/www\/html\/AVideo\/objects\/mysql_dal.php","line":171,"function":"log_error"},{"file":"\/var\/www\/html\/AVideo\/objects\/video.php","line":1273,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/var\/www\/html\/AVideo\/view\/videosList.php","line":56,"function":"getAllVideos","class":"Video","type":"::"},{"file":"\/var\/www\/html\/AVideo\/view\/modeYoutubeBottomRight.php","line":77,"args":["\/var\/www\/html\/AVideo\/view\/videosList.php"],"function":"include"},{"file":"\/var\/www\/html\/AVideo\/view\/modeYoutubeBundle.php","line":44,"args":["\/var\/www\/html\/AVideo\/view\/modeYoutubeBottomRight.php"],"function":"require"}] SCRIPT_NAME: /view/index.php

[14-May-2022 18:13:48 Europe/Stockholm] AVideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed: (1054) (Unknown column 'v.live_starts' in 'order clause') preparedStatement = "SELECT u., v., c.iconClass, c.name as category, c.clean_name as clean_category,c.description as category_description, v.created as videoCreation, v.modified as videoModified FROM videos as v LEFT JOIN categories c ON categories_id = c.id LEFT JOIN users u ON v.users_id = u.id WHERE 2=2 AND v.users_id NOT IN ('') AND (v.users_id = '1' OR v.users_id_company = '1') AND u.status = 'a' AND v.status IN ('a','k','f') ORDER BY v.live_starts ASC LIMIT 0, 10 " formats = "" values = [] refreshCache = false stmt = false SCRIPT_NAME: /view/index.php

[14-May-2022 18:13:48 Europe/Stockholm] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/var\/www\/html\/AVideo\/objects\/mysql_dal.php","line":166,"function":"log_error"},{"file":"\/var\/www\/html\/AVideo\/objects\/video.php","line":1273,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/var\/www\/html\/AVideo\/view\/videosList.php","line":56,"function":"getAllVideos","class":"Video","type":"::"},{"file":"\/var\/www\/html\/AVideo\/view\/modeYoutubeBottomRight.php","line":77,"args":["\/var\/www\/html\/AVideo\/view\/videosList.php"],"function":"include"},{"file":"\/var\/www\/html\/AVideo\/view\/modeYoutubeBundle.php","line":44,"args":["\/var\/www\/html\/AVideo\/view\/modeYoutubeBottomRight.php"],"function":"require"}] SCRIPT_NAME: /view/index.php

DanielnetoDotCom commented 2 years ago

Sorry about that, I am sending now version 2.4

wetubeclub commented 2 years ago

it's okay now everything works!!!

Thank you Ilias