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

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

Comments

jherencia’s picture

jherencia commented

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

astutonet
Location Sao Paulo, SP
commented

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?

jherencia’s picture

jherencia commented

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
mkesicki’s picture

mkesicki commented

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

jherencia’s picture

jherencia commented
Status: Needs review » Active
StatusFileSize
new 1347682.patch1.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

jherencia commented
Status: Active » Needs review
jherencia’s picture

jherencia commented
StatusFileSize
new 1347682-2.patch2.12 KB

I've added some comments.

astutonet’s picture

astutonet
Location Sao Paulo, SP
commented

The patch works fine.

Tks.

dczepierga’s picture

dczepierga commented
Status: Active » Fixed

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

Pls update to last DEV version.

Greetings

dczepierga’s picture

dczepierga commented
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

bok11 commented

I confirm - this patch is working.

Thank you :)

spidersilk’s picture

spidersilk commented
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

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