[INPUT NEEDED] Can't Delete + Fatal Error

xsporntv · 2011-07-27 03:25:39

I embedded 3 videos. This time selecting 'No' for 'Category Related'. I now have 3 orphan videos that I cannot delete or modify. I receive this message:

Fatal error: Wrong parameters for Exception([string $exception [, long $code ]]) in /home2/smuttv/public_html/libraries/framework/exception.php on line 7

Fatal error: Exception thrown without a stack frame in Unknown on line 0

symtab · 2011-07-27 09:48:51

Fixed in RC3 (i fixed everything related to orphan videos, basically videos will be displayed even if they are not part of any categories).

xsporntv · 2011-07-27 13:26:32

I would like to remove these videos but cannot. When I try to update, modify or delete I get that fatal error mesg. I cannot do a system check either without receiving the fatal error.

xsporntv · 2011-07-28 04:31:53

symtab wrote:

Fixed in RC3 (i fixed everything related to orphan videos, basically videos will be displayed even if they are not part of any categories).

Got this mesg when video is not associated with category. Cannot delete. Basically I want to delete it.

Warning [2]: mysql_fetch_assoc(): 46 is not a valid MySQL result resource on line 108 in file /home2/smuttv/public_html/libraries/framework/database/mysql.phpQuery: SELECT v.locked, GROUP_CONCAT(DISTINCT c.cat_id) AS category, GROUP_CONCAT(DISTINCT m.model_id) AS pornstars FROM video AS v LEFT JOIN video_category AS c ON (c.video_id = v.video_id) LEFT JOIN model_videos AS m ON (m.video_id = v.video_id) WHERE v.video_id = 1 AND v.user_id = 1 AND v.status = 1 LIMIT 1
Error Message:
Error Number: 0

It's stuck there! Even in the admin panel it gives me this mesg: Invalid video id! Are you sure this video exists!?

Last edited by xsporntv (2011-07-28 04:32:24)

symtab · 2011-07-28 07:43:37

Do you have phpmyadmin installed? If you run the above query through phpmyadmin, what happens? (also please send me a email with phpmyadmin access and i will also check, or ssh root access so i can access the mysql console).

xsporntv · 2011-07-29 20:22:29

symtab wrote:

Do you have phpmyadmin installed? If you run the above query through phpmyadmin, what happens? (also please send me a email with phpmyadmin access and i will also check, or ssh root access so i can access the mysql console).

Thank you Adrian for the quick reply and fiix.

Problem solved.

symtab · 2011-09-02 13:52:36

Can you please tell me how you fixed this bug? I cant reproduce this on my installation and i want to add the fix to the main distribution.

xsporntv · 2011-09-03 21:18:02

Go to 'orphan videos' within admin. Select any of the video links that appears. 'The links are the title tags of the videos' Click one. Select 'edit' icon and check off categorie boxes. Save or update. The video will then appear in the video file. You can edit or delete it.

That's it! Any questions post here.

Last edited by xsporntv (2011-09-03 21:20:17)

symtab · 2011-09-04 06:55:40

Ok. The above method is also fixed in RC3 because videos without categories appear in Admin -> Video -> Manage now.

Adult Script Pro Community Forums

#1 2011-07-27 03:25:39

[INPUT NEEDED] Can't Delete + Fatal Error

#2 2011-07-27 09:48:51

Re: [INPUT NEEDED] Can't Delete + Fatal Error

#3 2011-07-27 13:26:32

Re: [INPUT NEEDED] Can't Delete + Fatal Error

#4 2011-07-28 04:31:53

Re: [INPUT NEEDED] Can't Delete + Fatal Error

#5 2011-07-28 07:43:37

Re: [INPUT NEEDED] Can't Delete + Fatal Error

#6 2011-07-29 20:22:29

Re: [INPUT NEEDED] Can't Delete + Fatal Error

#7 2011-09-02 13:52:36

Re: [INPUT NEEDED] Can't Delete + Fatal Error

#8 2011-09-03 21:18:02

Re: [INPUT NEEDED] Can't Delete + Fatal Error

#9 2011-09-04 06:55:40

Re: [INPUT NEEDED] Can't Delete + Fatal Error

Board footer