[FIXED] Error message if deleting a category

MS_DA · 2011-05-10 22:25:24

I´m getting the following error if i delete a category

Query: SELECT cat_id FROM video_categories WHERE parent_id = LIMIT 1
Error Message: 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 'LIMIT 1' at line 4
Error Number: 1064

Ben

Last edited by MS_DA (2011-05-10 22:26:09)

marshalbros · 2011-05-10 22:38:56

I get this too and previously posted a thread on it. No resolution yet.

marshalbros · 2011-05-10 22:39:57

heres the thread

http://forum.adultscriptpro.com/viewtopic.php?id=318

MS_DA · 2011-05-10 23:00:07

Ohh... didn´t see your topic about this error - thanks

symtab · 2011-05-11 06:43:18

This happens when you delete a category? I just tested this and i can delete a category without any problems. Do you have subcategories enabled?

symtab · 2011-05-11 06:49:45

Ok. Got it. It works from the icon on the right, but returns a error from the mass actions checkbox on the left.

symtab · 2011-05-11 07:01:00

To fix edit admin/modules/video/components/category.php and find the following line:

if (isset($_POST['submit_actions'])) {

a few lines below the above line find the following lines:

                if ($this->delete_video_category($cat_id)) {
                    $messages[] = 'Category deleted!';
                    $cache->remove('categories');
                } else {
                    $errors[] = 'You cannot delete this category! It contains subcategories!';
                }

replace with:

               $success = TRUE;
                foreach ($ids as $cat_id) {
                    $cat_id = (int) $cat_id;
                    if (!$this->delete_video_category($cat_id)) {
                        $success = FALSE;
                    }
                }

                if ($success === TRUE) {
                    $messages[] = 'Selected categories deleted!';
                } else {
                    $errors[]   = 'Failed to delete one or more categories because they contain subcategories!';
                }

MS_DA · 2011-05-11 08:50:24

This was a quickly fix - works perfect now

Many thanks!

Ben

Adult Script Pro Community Forums

#1 2011-05-10 22:25:24

[FIXED] Error message if deleting a category

#2 2011-05-10 22:38:56

Re: [FIXED] Error message if deleting a category

#3 2011-05-10 22:39:57

Re: [FIXED] Error message if deleting a category

#4 2011-05-10 23:00:07

Re: [FIXED] Error message if deleting a category

#5 2011-05-11 06:43:18

Re: [FIXED] Error message if deleting a category

#6 2011-05-11 06:49:45

Re: [FIXED] Error message if deleting a category

#7 2011-05-11 07:01:00

Re: [FIXED] Error message if deleting a category

#8 2011-05-11 08:50:24

Re: [FIXED] Error message if deleting a category

Board footer