search

PHPVibe / phpvibe-lite

PHPVibe Open source video CMS / Video Sharing CMS / Youtube Api v3 / Video Embeds
https://www.phpvibe.com
MIT License
75 stars 55 forks source link

PHPVibe will silently fail to add videos #6

Closed bugz8unny69 closed 3 years ago

bugz8unny69 commented 5 years ago

Videos do not get added when you click add video.

Expected Result:

Videos added to Manage Videos

Actual Result:

List is empty

Additional notes:

array (size=2)
          'error_str' => string 'Incorrect integer value: '' for column `phpvibe_db`.`vibe_videos`.`category` at row 1' (length=85)
          'query' => string 'INSERT INTO vibe_videos (`privacy`,`pub`,`source`, `user_id`, `date`, `thumb`, `title`, `duration`, `tags` ,  `liked` , `category`, `description`, `nsfw`, `views`, `featured`) VALUES 
('0','1','https://www.youtube.com/watch?v=Lr8ogzNZ7-0', '1', now() , 'storage/media/thumbs/e887b29a64e92397aa5d70ae6e4b92c4-1.png', 'sssssss', '1403', 'english', '0','','','0','1','0')' (length=368)
PHPVibe commented 5 years ago

Hi,

Turn off safe mode in mysql as per the requirements.

bugz8unny69 commented 5 years ago

https://www.phpvibe.com/requirements/ isn't clear regarding what Safe_mode Off is referring to. The assumption here is PHP Safe Mode. Additionally, MySQL Safe Mode ref [1], is entirely different issue. Your insert query fails if category is empty due to table constraints.

  1. https://www.xpertdeveloper.com/mysql-safe-update/
PHPVibe commented 4 years ago

I know, the sql got pretty old after the last updates and restrictions that came with it. It would need a full recheck.

PHPVibe commented 4 years ago

Sorry about the requirements not being clear.