Hi.

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?

Tks

Files: 
CommentFileSizeAuthor
#5 1347682.patch1.93 KBjherencia
#7 1347682-2.patch2.12 KBjherencia

Comments

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.

Ok.

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?

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.

http://drupalcode.org/project/ckeditor.git/commitdiff/067a502f949e3baec0...

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

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

Status:Needs review» Active
StatusFileSize
new1.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.

Status:Active» Needs review

StatusFileSize
new2.12 KB

I've added some comments.

The patch works fine.

Tks.

Status:Active» Fixed

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

Pls update to last DEV version.

Greetings

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.

I confirm - this patch is working.

Thank you :)

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?

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...