Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.Joomal: Version 1.5.20
Drupal: Version 7.8
Hi,
I have been trying to use the Joomla to Drupal import tool and have come across and error message on the front page after the import has completed:
----------------
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jaylenschallenge_axleuk.jos_myblog_content_categories' doesn't exist: SELECT mcc.category,mc.name FROM jos_myblog_content_categories mcc JOIN jos_myblog_categories mc on mc.id = mcc.category WHERE mcc.contentid = :contentid; Array ( [:contentid] => node ) in joomla_myblog_process_node() (line 176 of /home/axle/www.axleuk.com/sites/all/modules/joomla/joomla_myblog.module).
----------------
I have seen a similiar post concerning the same issue and was hoping that I cuold get some assistance as to how best solve this problem.
| Comment | File | Size | Author |
|---|---|---|---|
| #16 | Error after import in admin.PNG | 62.5 KB | Axleuk |
| #10 | for Paris.sql_.zip | 15.23 KB | Axleuk |
| #7 | Error after import in admin.PNG | 62.5 KB | Axleuk |
| Error after import.PNG | 18.52 KB | Axleuk |
Comments
Comment #1
ParisLiakos commentedSeems you dont have any categories in your joomla installation?
did you run the import with the import categories checkbox checked?
Comment #2
Axleuk commentedComment #3
Axleuk commentedYes I did.
Comment #4
ParisLiakos commentedTry the import,without checking that:)
and everything will go OK
Its cause you dont have any joomla categories.you checked the box,module thought u did have category table and that's where u got the error!
Comment #5
Axleuk commentedI did try it unticked and I got the same error message. I checked Joomla and all of my 'MyBlog' posts are in a category called 'MyBlog'
I am in the process of restoring the database and I will try again with the categories option unticked to see if it makes any difference.
Comment #6
ParisLiakos commentedah i see.
sorry for that,my bad.never noticed you are using myblog submodule:/
seems there has been a change in myblog's structure in joomla.
can you provide me your database dump?
or just the structure of it,if it contains sensitive data?
Comment #7
Axleuk commentedI just restored the database and started again, this time only selecting the 'content' option. As soon as I click the 'imprt' button it returns the attached error message.
Comment #8
Axleuk commentedWhat format would you like the dump in? CSV or SQL?
Comment #9
ParisLiakos commentedYou will have to disable-uninstall-enable joomla module.
btw i ll have to take a look to your joomla db structure (SQL format)
Comment #10
Axleuk commentedHere you go
Comment #11
ParisLiakos commentedok.there will be a new version tomorrow that will fix this !
thanks for the db!
Comment #12
Axleuk commentedThat's great! Really apreciate the speed at which you have jumped on this. Very good first impressioon of the support mechanism that the Drupal community have here :)
Comment #13
ParisLiakos commentedyeah drupal community rocks.
btw one question i forgot to ask...did the import finished succesfully?
and after got the error?
And if yes,did you delete the joomla database after the import?
then visiting the drupal site you got the error?:)
Comment #14
ParisLiakos commented7.x-1.0-alpha3 is out.update your module and everything should be fine!
thanks for reporting this bug:)
Comment #15
ParisLiakos commentedComment #16
Axleuk commentedHey Paris,
This is great. I was able to import the posts and categories across now and they are safetly in Drupal. I did get error messages show up just after the import but it did not seem to affect anything from what I can see. I have attached the error for you in case it is something that needs to be addressed.
Comment #17
ParisLiakos commentedThanks!i fixed those notices too:)