We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Please Help restore my admins profile page? | Forum

Topic location: Forum home » Support » General Questions
Carol Schumacher
Carol Schumacher Jan 9 '17
My Admin has a profile page.  Attempted to post a video.  I found the video that was posted.  By going to Developer Tools under debugging, but I can't do anything with it there.  I know by posting that video it has interrupted their profile page.  I don't want to delete their page as they also have groups on my site we'd like to keep in tact.  I believe they just had a problem with using a greater than sign or space when putting in the code.  Can anyone help me fix this?
Darryl B Leader
Darryl B Jan 9 '17
If you can access the profile, check this post, or if you know what the bad code looks like you can search the db table they mention and delete it.

https://developers.oxwall.com/forum/topic/7665
The Forum post is edited by Darryl B Jan 9 '17
dave Leader
dave Jan 10 '17
Cant you just delete the post itself in newsfeed.  I guess im not understanding this, how did they try to post a video, how and where?
Carol Schumacher
Carol Schumacher Jan 10 '17
Darryl B and dave,
  I have the plugin which allows me to log in as the user, but this feature won't work with their profile now. Their page:  Only two widget with graphics and one with a banner.  No profile info,  no drop down menus at the top to log out and etc. 
This all happened when the user added a widget for the graphics and possible that another widget had some code problems.
  I went to Developer Tools, I can see the codes for those widgets but cannot manipulate those codes at all under debugging.
Carol Schumacher
Carol Schumacher Jan 10 '17
I took admin status away from this user in hopes I could customize their page again, noooo, the button won't work either.  I don't want to delete user and have them make another profile because they have two groups on my site and those will go down as well.  But if we can't get their page to go back to default or if we can't customize their page at all, then what?
bobbi
bobbi Jan 10 '17
Have you tried this http://Your site/user/username/customize

Change username to your members user name and your site to your website name, or got to their profile and add /customize to the end of the URL it may work it may not but worth a try
The Forum post is edited by bobbi Jan 10 '17
Carol Schumacher
Carol Schumacher Jan 10 '17
bobbi, that took me to a page not found.
bobbi
bobbi Jan 10 '17
This way has worked for me in the past, I tried your admins profile and I get page not found too, add /customize to the end of your admins URL and it might work, if not then you will have to go to your database and delete the table, there is a post here somewhere that tells you how to do it,
Darryl B Leader
Darryl B Jan 10 '17
My thought was that the user entered the code in a custom html block since you mentioned that they entered the code incorrectly, and that is the only way they can enter code on their profile. If that is the case, you should be able to find the code, using the info in the link I provided, by going to phpmyadmin, and removing the code from that database. If it wasn't entered using the custom html box, how was the code entered?
Carol Schumacher
Carol Schumacher Jan 10 '17
Darryl B, the code was entered in a custom html box.  The info you provided, the photos don't appear for me (just little x's)  so won't be helpful to me I suppose. I'm not up on where to find phpmyadmin though.
Carol Schumacher
Carol Schumacher Jan 10 '17
bobbi, how to go to database, big question mark. 
Darryl B Leader
Darryl B Jan 10 '17
phpmyadmin is accessed via cpanel. The images weren't showing, but the steps were there. I found it using a google search using "oxwall remove custom html from database".
There are some others. That one seemed most informative. I'm about to go get supper, but will be back on in a bit.
Carol Schumacher
Carol Schumacher Jan 10 '17
Ah my hosting provider has my cpanel.  I could go to that, access cpanel, how to find this one user in the entire website, wow, don't know if I can.  My site is free for the users, I don't make money, however the user would like to pay for a specialist to fix their page even at that.  Any suggestions?
Senior Developer Leader
Senior Developer Jan 10 '17

+1 Darryl B

Hi Carol Schumacher!


Look in the table 'ow_base_component_entity_setting', the field 'value' does have the content of all the widgets (in this case html content), you just need to search the one who has the bad code and clear the html value of that field.


To make money you can add buy and install a store plugin and you can add your services to your store inside your website.

Carol Schumacher
Carol Schumacher Jan 10 '17
I will attempt to look into my cpanel and find it, before clearing or deleting anything. :) thanks you.  I'll come back let you know if or when I get it done.
Carol Schumacher
Carol Schumacher Jan 10 '17
Went to 'ow_base_component_entity_setting'  found what I thought it was, deleted it, and it didn't change a thing.    There was no clear option, just delete.   So in the phpadmin  that wasn't any help at all and I had the Bluehost guy helping who so happens to be an Oxwall knowledgable person.
Darryl B Leader
Darryl B Jan 10 '17
From Alia's instruction, did you also go to the ow_base_component_place_cache table., and clear it. The reason she says to do that is that there would probably be a cached version of it there as well.
Darryl B Leader
Darryl B Jan 10 '17
Forgetting about the pics. Here are the steps she defined with an example.

1. Visit Jane's profile page. Right mouse click on the "Test" widget>>Inspect Element with "Firebug" or any other debugger>>find  the entity of the widget in place. In my case it is:

ow_box ow_stdmargin clearfix entity-5110c5f27c286 ow_break_word
2. Copy the entity ID ( in my case :entity-5110c5f27c286)

3. Go to your database>>ow_base_component_entity_position  table >>click "search">>paste copied entity ID as shown in the screen shot bellow>>click "Go"

4. Delete found entity.

5. Go to ow_base_component_place_cache table.
Select everything you have within this table and delete.

6. Go to "Jane"s profile. "Test" custom HTML widget should not be there anymore.
Darryl B Leader
Darryl B Jan 10 '17
One other thing that you may have to do is clear your browser cache in case it is storing a cached version of the page, and possibly clear the site cache by going to oxwall / includes / config_php. scroll to the bottom of the page, and change dev mode from false to true, and click save. Go to your site, and refresh the page. Set dev mode back to false, and click save. This will clear your site cache. This is just an additional step, if needed.
Carol Schumacher
Carol Schumacher Jan 10 '17
I'm lost.  Can't find it again, so going to ow_base_component_place_cache table doesn't do be any good at all if I can't search.
Pages: 1 2 »