Using D7.2 I installed Quicktabs and built a simple 2 tabbed form. Went away for a few days and came back to a corrupt SQL file. Was able to straighten all out except for this message and the inablilty to access Quicktabs.
"PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mfsasia_drupal7.quicktabs' doesn't exist: SELECT t__0.* FROM {quicktabs} t__0; Array ( ) in ctools_export_load_object() (line 427 of /home/mfsasia/public_html/sites/all/modules/ctools/includes/export.inc)."
If I uninstall QTabs module the site works fine. But when I re-install I get above message. I am assuming something is left in the tables when I uninstall it making the re-install continue to have the problem. Any suggestions where I might look to delete Quicktabs refernces from tables?
Updated to D7.4 today with same results.
Thanks
-Neil
| Comment | File | Size | Author |
|---|---|---|---|
| #4 | QuickTabs Neil.png | 22.56 KB | nfriend |
Comments
Comment #1
nfriend commentedAgain - any suggestions as to what table to look in to clear out remnants of Quicktabs so I can get it working again? Apparently when I re-install it it doesn't generate the table it needs to because of a conflicting flag perhaps indicating it's already installed.
Thanks
-Neil
Comment #2
katbailey commentedDoes the Quicktabs table still exist in your db or not? Also, do you have the latest release of ctools?
Comment #3
nfriend commentedThanks for the follow up.
ctools: 7.x-1.0-beta1
The quicktabs table does not exist. I looked at it in another system to confirm what I was looking for and it's not in this one.
I tried updating to the new release and the UPdate.php said updating Quicktabs and then errored out, with this message:
"PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mfsasia_drupal7.quicktabs' doesn't exist: SELECT t__0.* FROM {quicktabs} t__0; Array ( ) in ctools_export_load_object() (line 427 of /home/mfsasia/public_html/sites/all/modules/ctools/includes/export.inc)."
Is there any other reference to the existence of Quicktabs? it almost appears that when I install it (activate the module) it thinks its already there so it doesn't create the table.
Thanks for your help.
-Neil
Comment #4
nfriend commentedHere the Update screen attached...
Comment #5
nfriend commentedLooks like I'm back in action with Quicktabs. I installed a fresh D7.4, only activated a few modules - one of them being Quicktabs - which gave me the table that was not being created.
Did NOT Have Qtabs module activated in old setup and With Backup & Restore: Backed up Problem install and Restored it to New install. Then activated Qtabs module - it gave me "PDO.." etc error but then worked as designed and all seems to have resolved itself. Created Tabs and it's working.
Probably a one time ever problem just to make me appreciate when things are working smoothly :>) but if anyone ever comes across it maybe this will help.
Thanks
-Neil
Comment #6
harriska2 commentedI sure can't get this error to stop. Tried 7.3.4 and the dev version. The table is there. I tried to update but gives me error the same error as the issue title (PDOException: SQLSTATE[42S02]: Base table or view not found...)
UPDATE:
OK. Here is what happened to me - and how I got the error. I installed. Kept getting errors. Didn't uninstall but unchecked quicktabs (made it inactive) and deleted the table (in trying to fix the error). I think it would have been fine had I of just run update.php immediately after install.
So now I can't get it to install with the table. Does someone have a SQL create table script for me? I can't decipher the install php script.
UPDATE 2:
I just grabbed the table structure from a 6.x version on a different database. Ran update and walla, works like a charm.
Comment #7
smustgrave commentedWith D7 EOL approaching in a month I'm starting to triage the D7 side of quicktabs queue. This doesn't appear to have any code so believe this may not make it, sorry! Thanks though!
If still an issue or needed for 4.0.x (latest branch) feel free to reopen