The Joomla! Forum ™

Download

Demo


Board index » Joomla! 2.5 - Ask Support Questions Here » Administration Joomla! 2.5

Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  Page 1 of 1
  [ 10 posts ] 
  Print view Previous topic | Next topic 
Author Message
jsgdmbnhl
PostPosted: Thu Jul 26, 2012 5:09 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Thu Jul 05, 2012 4:32 pm
Posts: 156
I get the following error message when trying to delete my Infrastructure access view...

You cannot delete the view access level '12:Infrastructure' because it is being used by content.
You cannot delete the view access level '12:Infrastructure' because it is being used by content.

I confirmed that I did not have any content with Infrastructure. I think I checked everywhere: users, menus, articles, categories and newsfeeds. I checked all statuses, and then checked the trash and the cache. It did not exist.

My concern is that both this Infrastructure user access level has an ID 12, and the Category Manager: Newsfeeds Uncategorized also has an ID 12.

I attempted to check phpMyAdmin based on a previous post and looked at jxx_content. I found that they deleted the access= but I cannot find that. I did find ID 12 in this table but it has no relation to the Infrastructure group. I am not comfortable deleting this row without confirmation.

Please advise on this situation. Thanks.


Last edited by jsgdmbnhl on Tue Jul 31, 2012 2:53 pm, edited 1 time in total.

Top
 Profile  
 
bbolli
PostPosted: Thu Jul 26, 2012 5:20 pm 
Joomla! Explorer
Joomla! Explorer

Joined: Fri Nov 11, 2011 9:43 pm
Posts: 435
Location: Chicago, IL
I've gone through this song and dance before, and there is a much easier way to correct. Sometimes the category is tied to a previously "trashed" item, so if you haven't actively changed the state in all of your articles it could be in there.

If you did, then most probably there is a lost entry in your DB tables. Using PHPMyAdmin, do a search in articles for any row where catid=12. I would verify this article cannot be deleted or have its category altered in Joomla first, and if not, manually delete the row from the DB and try and delete the category again from the Joomla Administrator's interface.

That should do it.
Top
 Profile  
 
jsgdmbnhl
PostPosted: Thu Jul 26, 2012 8:00 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Thu Jul 05, 2012 4:32 pm
Posts: 156
I know I trashed a lot of items lately in many locations within Joomla, but I have searched with all statuses and particularly with the trashed status and did not find it tied in any of the places. I checked the entire Users, Menu, and Content menus and did not find the associated content.

I performed the search in PHPMyAdmin table jxx_content for catid=12. MySQL returned an empty result set (zero rows). I am not sure if I should delete the entry in jxx_viewlevels where the Infrastructure cannot be deleted.
Top
 Profile  
 
bbolli
PostPosted: Thu Jul 26, 2012 8:47 pm 
Joomla! Explorer
Joomla! Explorer

Joined: Fri Nov 11, 2011 9:43 pm
Posts: 435
Location: Chicago, IL
Then I would open up the search to any table field with the number 12, matching the category id. You will get a lot of non-relevant positives in your search results, but considering you have already combed the administrators interface the entry has to be in the db.

Scan through and see if any of the results have a reference to category id 12 and manually change.
Top
 Profile  
 
jsgdmbnhl
PostPosted: Thu Jul 26, 2012 9:09 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Thu Jul 05, 2012 4:32 pm
Posts: 156
This is my first time going through PHPMyAdmin like this so my searches are a little slow. I went through each table in the bitnami_joomla database one by one. I clicked Search when available. I ran a search when there was a catid field. I did catid=12. There were zero results found for each and every search. I wish I could tell you I got plenty of non-relavant positives in my searches but "MySQL returned an empty result set (zero rows)."

Thanks, bbolli, for continuing to work with me on this issue.
Top
 Profile  
 
bbolli
PostPosted: Thu Jul 26, 2012 9:20 pm 
Joomla! Explorer
Joomla! Explorer

Joined: Fri Nov 11, 2011 9:43 pm
Posts: 435
Location: Chicago, IL
Attachment:
Capture.PNG

This is the search screen you want, just be sure you selected the database from the list on the left side before clicking the search menu tab on top. You want to search the entire db for just the number 12, so in the search input field just put 12. Be sure to click Select All to search all the tables and process, you should get a bunch of results then.


You do not have the required permissions to view the files attached to this post.

Top
 Profile  
 
jsgdmbnhl
PostPosted: Fri Jul 27, 2012 2:21 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Thu Jul 05, 2012 4:32 pm
Posts: 156
I searched the entire database as you suggested and I found something that did not belong. It was an attachment that I thought was deleted a while ago. It was sitting in a folder I had created. When I checked the folder in Media Manager, the attachment was not there. I decided to delete the entire folder which did not contain anything. I tried to delete the View Access level but I received the same error.

Using PHPMyAdmin, I checked the folder location on the server command line and was able to find it there as well. I am not sure where I should start deleting the the attachment and the associated rows.

The further I dig, the further down the rabbit hole I seem to go.
Top
 Profile  
 
bbolli
PostPosted: Fri Jul 27, 2012 2:53 pm 
Joomla! Explorer
Joomla! Explorer

Joined: Fri Nov 11, 2011 9:43 pm
Posts: 435
Location: Chicago, IL
Delete the entry in the db using PHP MY Admin, although deleting the folder was the correct thing to do as far as Joomla is concerned it is still there until the entry is removed from the database. Once you remove entry from the db table you should be able to remove the view level.
Top
 Profile  
 
jsgdmbnhl
PostPosted: Fri Jul 27, 2012 3:36 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Thu Jul 05, 2012 4:32 pm
Posts: 156
SOLVED!!

After deleting the folder, I deleted the entry in PHP My Admin. I then deleted the file on the server itself. After all that I was able to go back the the View Access level and delete the Infrastructure view successfully.

Thanks so much for all your help on this bbolli.
Top
 Profile  
 
bbolli
PostPosted: Fri Jul 27, 2012 4:42 pm 
Joomla! Explorer
Joomla! Explorer

Joined: Fri Nov 11, 2011 9:43 pm
Posts: 435
Location: Chicago, IL
No problem, glad you got is working!
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 10 posts ] 


Board index » Joomla! 2.5 - Ask Support Questions Here » Administration Joomla! 2.5

Who is online

Users browsing this forum: No registered users and 42 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group