MySql queries for Deleting categories.

hydn · January 5th, 2009, 12:17 AM

I have some categories that I can't get to edit after upgrade. Except for the member category.

I've managed to mass move all images to that one working category. Now how can I manually remove those trouble tables using mysql queries?

Thanks,

Chuck S · January 5th, 2009, 11:52 AM

Well what do you mean you can not edit them we may need to look at that to see maybe did you miss an upgrade etc.

hydn · January 5th, 2009, 02:50 PM

Didn't miss an upgrade. Simply went from 4.2 (first install) to 4.3. Moved servers and possibly the backup isn't working 100%. Every last thing works except for categories.

Is there a query? Or its your way or no way?

We cannot give ftp or admin access. Many companies such as vbseo etc provide great support without requesting admin access as a quick fix. We got a query from them last week which resolved an issue.

Support involves time yes. If not willing to meet my needs let me know.

kind regards,

hydn

Chuck S · January 5th, 2009, 03:09 PM

The way in the program is to hit the delete option to delete a category.

DELETE FROM ppgal_categories WHERE catid=8

replace with the proper catid your deleting and if your forum tables have a prefix add it to the query but that will work.

hydn · January 5th, 2009, 05:54 PM

Thanks that works.

One of the categories has sub-category.

If the category id is 1 and it's sub category ID is 4

Will DELETE FROM ppgal_categories WHERE catid=1 only delete category 1 or will it remove sub category 4 also?

Thanks

Chuck S · January 5th, 2009, 08:26 PM

You can do that

DELETE FROM ppgal_categories WHERE catid=4

hydn · January 5th, 2009, 09:12 PM

Quote:

Originally Posted by Chuck S

You can do that

DELETE FROM ppgal_categories WHERE catid=4

Sorry about type. The red 4. should have been 1

Don't want to delete 4. Its the only cat that works.

Would like to delete id 1 without loosing category 4

Chuck S · January 5th, 2009, 09:21 PM

deleting 1 should not delete 4

hydn · January 5th, 2009, 09:39 PM

The categories are gone from the admin panel but still visible from main gallery. Is there another query to run to remove from main gallery?

When clicked i get:

"No Category specified. If you followed a valid link, please notify the administrator"

So they are def gone. But just still listed.

Chuck S · January 5th, 2009, 09:41 PM

Have you tried running your maintenance script to update things? Your cache is not updated I would suspect.

hydn · January 5th, 2009, 09:43 PM

I tried to run: Update Category Cache

But still get:

Quote:

MySQL Error : Unknown column 'title_clean' in 'field list'

Manual way to clear cache? Maybe via query?

Chuck S · January 5th, 2009, 10:01 PM

Thats the heart of your issue your missing an upgrade.

I would need more info on this site to assist hands on.

hydn · January 5th, 2009, 10:38 PM

Can i zip and send you the DB files from the mysql data folder?

hydn · January 5th, 2009, 10:38 PM

Plugin manager says "PhotoPost vBGallery 2.4.3 PhotoPost vBGallery 2.4.3"

Chuck S · January 6th, 2009, 10:55 AM

I hear what your saying about your version. No thats not going to help I would need to actually have access to the files and database on your server and try and get the actual upgrade to process as this is the only way your going to get over your issue.

hydn · January 7th, 2009, 05:17 AM

easier to just remove it. Thanks anyway.

Chuck S · January 7th, 2009, 09:21 AM

Okay but your still going to have issues if you dont actually fix your gallery I was offering to help not quite sure why you are persistant about not actually obtaining support.