panels_info is not cooperating.... please help
First of all I would like to mention that I have no clue whatsoever what this panels_info is, or where to find it, or how to fix it... or even if it is what needs to be fixed...
This is the error on my home page:
user warning: Table 'pinkiand_lilpinki.panels_info' doesn't exist query: SELECT * FROM panels_info WHERE path = 'home' in /home/pinkiand/public_html/lilpinki/includes/database.mysql.inc on line 172.
and a similar error appears on EVERY page, whether logged in or not. Everything was working fine until I removed an old folder from my server (it contained an old version of the site, before I decided to use drupal), this folder was in the same directory as the folder in which my drupal site is running... completely unrelated, but ever since then this error message hasn't left my screen. Weird.
Any help would be greatly appreciated.
The "panels_info" table
The "panels_info" table belongs to the panels module. It seems that the module is installed and active (is it?) but its database tables are missing.
The panels module's files should be in a "panels" directory under where you have all your additional modules (usually /sites/all/modules/panels. The first time you installed and enabled the module it should have created its tables in the database (panels_info and panels_area). Apparently they are not there.
Did you install it recently? Try to run http://example.com/update.php to see if it corrects the problem.
If you don't need the panels module now, just disable it from the /admin/build/modules page. Also look for the "Uninstall" tab on the top to uninstall any of its tables left. If you need it later you can reinstall it and reenable it.
f you need it now, you must make it create its tables by running the SQL queries contained in the panels.install file.
Thank you for the reply....
I installed the panels module about a month ago and until yesterday it was working perfectly. Every page on my site uses the panels module, so I don't think uninstalling it would be an option since I would lose all the information (right?). Although I would do it as a last resort.
As far as making the module create its tables by running SQL queries from the panels.install file.... can someone please elaborate on how this can be done?
Thanks :)
You need your old panels
You need your old panels with the data already stored there and not just empty database tables... Then the priorities change. (Any database backup? No? Ok...)
I am now looking at the the different versions of the panels module. I see that:
- versions 5.x-1.x have 2 tables: panels_info, panels_area
- versions 5.x-2.x have have 3 tables: panels_page, panels_display, panels_pane
So, you probably have currently one of the 5.x-1.x versions, which is looking for a panels_info table. Go to your database with phpMyAdmin and look for any of these table names to find out what you really have.
I guess you didn't delete a table deliberately, so I have a theory...
- You used to have a 5.x-2.x version (or you upgraded at some point and you ran update.php)
- Recently you uploaded a 5.x-1.x version, thinking that it was newer, or you decided to go back.
- You still have the 3 tables of the 5.x-2.x version in your database (hopefully)
Am I right? If so, delete your panels module directory with all its files, upload the panels-5.x-2.x-alpha7 release and cross your fingers. If not... report back with your exact version and with what you found in your database.
The following are in the
The following are in the database: panels_page, panels_display, panels_pane and panels_node
I deleted the panels directory and installed panels 5.x-2.x....
the panels_info errror still appeared everywhere....
Drupal told me there was some kind of error and i should run the Database Update thingie to fix it... i did
the panels_info error still appeared everywhere....
There must be some old code
There must be some old code somewhere in there which still looks for the panels_info table. Is it possible that you have another old copy of the panels module somewhere in your installation?
Also
- Did those tables exist before you installed 5.x-2.x? Or did you look only afterwards?
- Is it only the error message that annoys you, or the panels don't work at all? Because if the panels work you can disable error reporting from /admin/settings/error-reporting, where its says "Write errors to the log and to the screen".
the tables were there before
the tables were there before i installed the new version... BUT... I may have tried to run an update previously... because I never downloaded the new version of panels previous to just now with this problem...
ALSO... is it possible that the new panels are what is causing the problem?
I downloaded the latest version of drupal and installed it into an altogether separate directory, created a new database, installed the NEW version of panels... it is giving me the SAME error... (looking for panels_info in the new databse)
Can I just go back to the OLD version of panels that never gave me any errors?
The site works perfectly fine... I guess I could just make it not show the error... but I am just curious as to what is causing this.
Thank you for your help.
If the new tables were there
If the new tables were there before, then you already had installed panels2 before. There is no way panels1 would work with the new tables -- it would not recognize them.
Also, you can't go back to panels1 because there is no available script to convert the new tables back to the old ones. There is only a script to convert the old ones to the new (in panels2 panels.install). I guess someone who knew well the internals of panels could write such a script, but I don't know how easy it is.
There is still the question where the query for the old table comes from. I ran a grep on the panels2 files and there is no such query. It must be either in an old installation somewhere or in the database itself, or something custom in the theme.
Was you fresh installation on a clean database, or did you upload the same one? Did you use exactly the same theme?
Could it be coming from
Could it be coming from another module or perhaps the theme I am using?
In my new installation, I used a new database, I installed all the modules my site used and my current theme and got the error... so I deleted everything and tried again, but only installing the Panels module... no error.. must be something in the theme then... is there a way to find out where the error is and fix it or is this unnecessary and can just be left alone?
From another module which
From another module which uses panels... hmm... good idea. The views_bonus module package is one, it contains some modules which depend on panels. But after a quick search I didn't find any mention of "panels_info".
So, search in all the files of your theme for the string "panels_info". If you find any instances try to change it to "panels_page" which seems to be the closest new table.
Or search all your Drupal installation for the text, starting from the root. In Linux this is very fast with a
grep -r "panels_info" .. Or you can download everything to Windows to search. If you find it in the panels.install file it is ok -- it is just the update to panels2 which ran only once.Now, can it be left alone? My guess is as good as yours.
Well.... i removed the bonus
Well.... i removed the bonus views module and that did NOTHING...
I'm actually using OSX... which found no instance of panels_info anywhere... I tried using dreamweaver to search for it, and it found nothing either... maybe I'm checking the wrong boxes when searching... but since I'm not really familiar with dreamweaver, it's trial and error and its turning up nothing anyway...
I am guessing it is not the theme... since my admin theme is the drupal default and the error shows up there as well.
I think im just going to let it be... although I am VERY curious where it is coming from... do you know of any other way i can try searching?
I ran a grep on the whole
I ran a grep on the whole DRUPAL-5 CVS branch and found two more modules which contain "panels_info" queries, the find_path module and the pressflow_preempt_panels module, but you would have probably found them when you searched in your modules.
If it isn't in your theme either, then only the database remains. You could search for "panels_info" in all the database using phpMyAdmin or in a database dump using a text editor.
nodewords Modul
I had the same Problem - and in my case it was the nodewords Modul - there i had to change panels_info -> panels_page - then everything works fine
regards
Christian
nodewords Modul
I had the same Problem - and in my case it was the nodewords Modul - there i had to change panels_info -> panels_page - then everything works fine
regards
Christian
Yes.
That's right, it nothing to do with the panel (no issue if you are using the old panel that created panel_info table).
For now, simply replace all "panels_info" with "panels_page" in nodewords.module (until someone get the patch done).
-najibx-
WORKS Like a Charm
Thanks for this fix with nodewords. Got rid of the nasty pink error!
Thanks All
venusrising
thanks
this helped me too with the same panels_info error coming from nodewords.
i am having same problem.
i am having same problem. But i am not sure how to change in nodewords? could some one guide me.
I don't know php .i did managed to go to phpmydmin and checked ..but i don't see any yhing linke panel_page or some thing to change .
Thanks inadvance
=-=
what you are seeking is in the nodewords.module file.
open that module file and do the find and replace
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
thanks for quick reply i
thanks for quick reply i replaced it, But still i am getting same error.
=-=
you must replace all occurances of the code.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )