Support

Admin Tools

#14097 Database isue

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by nicholas on Wednesday, 14 November 2012 09:16 CST

user528

Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Didn't see any
Joomla! version: 2.5.8
PHP version: 5.3.16
MySQL version: 5.1.62
Host: lunarpages 
Admin Tools version: 2.4.2

Description of my issue:

Hello,

I just found out today that I have a Database error on my site. I am running Joomla 2.5, with Jomsocial. The issue is occurring when trying to link to a video in JomSocial. I get this error:

DB function failed with error number 1054 
Unknown column 'alias' in 'where clause' SQL=SELECT id FROM snfxv_assets WHERE alias = 'root'


The error occurs for all guests, and registered users. As a Super Admin however, I am able to see the video and not get an error.

I can't imagine that Admin Tools caused it, but I'm grasping at straws.  I just updated Admin tools, and then a user mentioned that teh error was occuring.  Coincidence?  Possibly...just not sure.  So, any ideas what might be causing this?

Here is a link to a video list. Click any video on the page, and it'll show the error. http://tiny url.com/cdvhmex
============
Side question: There are these table prefixes that also have _assets. Should there be so many prefixes? (Again, please excuse my noobishness)

fyvp_assets
jos_assets
x0i4t_assets
y8ce4_assets
zn7si_assets

 

nicholas
Akeeba Staff
Manager

Let's make sure that the problem is indeed caused by Admin Tools. In order to do so, try the following:

1. Try setting the Error Reporting level in your Global Configuration to "None". Many errors are caused by harmless PHP Notices and Warnings being output to the browser, breaking anything which requires HTTP header manipulation such as Joomla!'s session management, AJAX calls and download systems.

2. Try to replicate the issue after disabling the "System - Admin Tools" plugin. If you can still replicate the issue, it is not caused by Admin Tools. Disabling that plugin means that Admin Tools code (including the Web Application Firewall) is not running on your site.

3. If you suspect an issue with the .htaccess file, replace its contents with the contents of the stock htaccess.txt file shipped with every version of Joomla!. If you are on GoDaddy please wait for 1-30 minutes for the changes to be effective. Then, retry loading the problem page. If you can still reproduce the error, then it is not caused by .htaccess Maker.

If doing any of the above resulted in the issue still occurring, it's not related with Admin Tools and I can't help you. If doing any of the above did stop the issue from occurring, we'll have to do some troubleshooting.

First go to Admin Tools, Web Application Firewall, Configure WAF. Make sure "Log security exceptions" is set to Yes; if it's not, set it to Yes and click on Save. Now try reproducing your issue. Immediately after that, please go to Admin Tools, Web Application Firewall, Security Exceptions Log and go to the last page. The last log entry should have the date and time of when the issue occurred. Please copy the Reason and Target URL here so that I can help you.

If, however, you do not see a log entry, or the Date and/or IP address do not match your last access, this problem is not caused by Admin Tools' WAF. In this case, you will have to do some .htaccess troubleshooting. You may need to read the general .htaccess troubleshooting page, as well as the page on finding out necessary .htaccess exceptions.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user528

Hey Nicholas - none of those things stopped the error.  I'll keep looking elsewhere.  Thanks  :)

user528

Problem solved - someone in another forum told me to run this query:

[code]DELETE FROM prefix_assets WHERE `parent_id`='0' AND `id` != 1;[/code]

It worked like a charm

nicholas
Akeeba Staff
Manager

That someone just screwed up your site, once and for all. Thank him for nothing. By removing all the #__assets records you have destroyed Joomla!'s ACLs. This may cause funky things to happen, like articles not appearing in the front-end unless you open and save them one by one, regular users or huests gaining access to administrative functions of components and so on. Rebuilding the assets table manually is not an option (uless you are a developer with 10-12 hours to spare). I would recommend buying ACL Manager (it's a dirt cheap 15€) and using its Diagnostic feature to fix the assets table automatically. You get to click on a button labelled "Fix Asset Issues", wait about 20 seconds and your site is back into working order.

Before you ask: yes, I've tried it on live sites (including this one, when I botched the migration of categories from the old J! 1.5 site) and no, it's not an affiliate link. I am a customer of Sander and his a customer of mine, but that's all.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user528

@#$%!

Man I hate computers...why does it all have to be so hard??!    @#$%!  But, thank you for your advice.  I will download it and run it.

I will also be kind and pass this info onto the dude in the other forum who gave me the suggestion.

nicholas
Akeeba Staff
Manager

I am sure that he meant no harm, but that's what you get on free public forums. There's always the possibility that someone with inadequate knowledge to be correct and enough knowledge to be harmful posts a reply. The problem is that the solution does seem to work and the new problem it introduces is not apparent. Oops :)

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!