I'm updating a site from D6 to D7. I have a problem with update #7003.

Whem I running update.php, I receiving this message:

ckeditor module
Update #7003
Failed: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mysite.ckeditor_input_format' doesn't exist: SELECT f.* FROM {ckeditor_input_format} f; Array ( ) in ckeditor_profile_load() (line 280 of C:\wamp\www\mysite\sites\all\modules\ckeditor\ckeditor.module).

Any idea?


#5 1347682.patch1.93 KBjherencia
#7 1347682-2.patch2.12 KBjherencia
Members fund testing for the Drupal project. Drupal Association Learn more


jherencia’s picture

As said in the other issue:
It seems that ckeditor_profile_load, which is executed in update_7003, expects that ckeditor_input_format has been created previously, but somehow it has not.

astutonet’s picture


I think some instruction is missing after line 485 of file ckeditor.install.

I have noticed this problem with other modules as well.

As in other modules, a patch may be able to fix the problem.

Can you help me?

jherencia’s picture

Well, in this commit the table ckeditor_input_format was introduced in hook_schema, but no hook_update was introduced. In every D6 migration ckeditor_input_format will not exist once reached #7003.


It looks like currently there is no upgrade path, it is needed:

  • update_7000 should remove ckeditor_role table wich is no longer used
  • update_7000 should create ckeditor_input_format table
  • adapt update_7003 and create update_7004 for those who have run update.php with previous versions and do not have ckeditor_input_format
mkesicki’s picture

We will check this and try to fix it. Any help is nice welcome ;)

jherencia’s picture

Status: Needs review » Active
1.93 KB

Here is the patch, it important to know that #1329980: [D7] Problem with CKEditor module update needs to be applied too to solve all the issues related to #7003.

jherencia’s picture

Status: Active » Needs review
jherencia’s picture

2.12 KB

I've added some comments.

astutonet’s picture

The patch works fine.


dczepierga’s picture

Status: Active » Fixed

@jherencia, really thx for patch and good work. I commit your patch to GIT.

Pls update to last DEV version.


dczepierga’s picture

Title: D6 to D7: error in update #7003 when running update.php » [D7] D6 to D7: error in update #7003 when running update.php

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

bok11’s picture

I confirm - this patch is working.

Thank you :)

spidersilk’s picture

Version: 7.x-1.x-dev » 7.x-1.12
Status: Closed (fixed) » Active

I'm still having this problem, with version 7.x-1.12 (while upgrading from D6). If the patch was committed in November 2011, and 7.x-1.12 was released in December 2012, wouldn't the change have been included in the official release by then? Or do people still need to use the dev version rather than the stable version?

spidersilk’s picture

Status: Active » Closed (won't fix)

Sorry, never mind, just saw the upgrade.txt file and discovered that you can't upgrade the module at all, just uninstall and reinstall it, and reapply all your settings from scratch.

Closing the issue again, though I don't think "closed (fixed)" really applies under the circumstances...