TOPIC: Drupal database

After inporting Drupal database I get this error: Error
SQL query:

-- -- Dumping data for table `cache` -- INSERT INTO `cache` (`cid`, `data`, `expire`, `created`, `headers`, `serialized`) VALUES ('page_title:settings', 0x613a32363a7b733a31383a22706167655f7469746c655f64656661756c74223b613a393a7b733a353a226c6162656c223b733a373a2244656661756c74223b733a363a2273636f706573223b613a313a7b693a303b733a363a22676c6f62616c223b7d733a383a227265717569726564223b623a313b733a31303a2273686f77206669656c64223b623a303b733a31313a226465736372697074696f6e223b733a38373a2254686973207061747465726e2077696c6c20626520757365642061732061203c656d3e66616c6c6261636b3c2f656d3e202869652c207768656e206e6f206f74686572207061747465726e20697320646566696e656429223b733a363a22776569676874223b693a2d35303b733a373a2264656661756c74223b733a32363a225b706167652d7469746c655d207c205b736974652d6e616d655d223b733a31353a226c6162656c20617267756d656e7473223b613a303a7b7d733a32313a226465736372697074696f6e20617267756d656e7473223b613a303a7b7d7d733a31363a22706167655f7469746c655f66726f6e74223b613a393a7b733a353a226c[...]

MySQL said:

#1062 - Duplicate entry 'page_title:settings' for key 'PRIMARY'

Hey Sigurdur,
After or during the import? Where are you importing the tables? Are you sure that you are importing them in the joomla database? Cause it seems that you are importing those tables in a database that already has the a cache table.

Regards,
Daniel

Hi
Thanks for a fast reply.
It comes at the end. I dropped all tables from the database except those with the jos prefix and tried again. Now i get this:
Error
SQL query:

INSERT INTO `cache` (`cid`, `data`, `expire`, `created`, `headers`, `serialized`) VALUES ('theme_registry:giordani', 0x613a313338343a7b733a31323a22776562666f726d5f76696577223b613a373a7b733a393a22617267756d656e7473223b613a353a7b733a343a226e6f6465223b4e3b733a363a22746561736572223b4e3b733a343a2270616765223b4e3b733a343a22666f726d223b4e3b733a373a22656e61626c6564223b4e3b7d733a343a2274797065223b733a363a226d6f64756c65223b733a31303a227468656d652070617468223b733a32353a2273697465732f616c6c2f6d6f64756c65732f776562666f726d223b733a383a2266756e6374696f6e223b733a31383a227468656d655f776562666f726d5f76696577223b733a31333a22696e636c7564652066696c6573223b613a303a7b7d733a31313a227468656d65207061746873223b613a313a7b693a303b733a32353a2273697465732f616c6c2f6d6f64756c65732f776562666f726d223b7d733a32303a2270726570726f636573732066756e6374696f6e73223b613a313a7b693a303b733a31393a2274656d706c6174655f70726570726f63657373223b7d7d733a32313a22776562666f726d5f766965775f6d65737361676573223b613a373a7b733a393a22617267756d[...]

MySQL said:

#1153 - Got a packet bigger than 'max_allowed_packet' bytes

Hi,
those errors are not connected to the component but to your mysql server. Here is what came up by searching for max_allowed_packet:
stackoverflow.com/questions/93128/mysql-...allowed-packet-bytes

Regards,
Daniel

Thank you
I'm going to see what i can do. I have no experience in fiddling with sql so we'll see

I tried exporting some chosen tables, only content so the sql file was less than 1 mb. After importing which took a long time considering the filesize i got a successful import so I guess I'll try to import few tables at a time. Are there any i don't need? Can I migrate after each import or do i have to import everything first?

You'll need all core drupal tables in order for CMigrator to properly migrate the data.

So the problem with importing is the size of your tables? How big is that drupal database?

The sql file is almost 35mb.

if you zip it, it should become few mbs and you should be able to import it at once.

Tried that and got this message:
You attempted to load file with unsupported compression (application/zip). Either support for it is not implemented or disabled by your configuration.

Even thoug just below it says:
File may be compressed (gzip) or uncompressed.
A compressed file's name must end in .[format].[compression]. Example: .sql.zip

I hope that I'm wrong, but it sounds really like your hosting sucks...

Have you tried to compress the file as gzip? Maybe it only accepts gzips.

Hi It seems I'm running in circles here. the gzip import was much faster but now I'm back to this:

Error
SQL query:

INSERT INTO `cache` (`cid`, `data`, `expire`, `created`, `headers`, `serialized`) VALUES ('theme_registry:giordani', 0x613a313338343a7b733a31323a22776562666f726d5f76696577223b613a373a7b733a393a22617267756d656e7473223b613a353a7b733a343a226e6f6465223b4e3b733a363a22746561736572223b4e3b733a343a2270616765223b4e3b733a343a22666f726d223b4e3b733a373a22656e61626c6564223b4e3b7d733a343a2274797065223b733a363a226d6f64756c65223b733a31303a227468656d652070617468223b733a32353a2273697465732f616c6c2f6d6f64756c65732f776562666f726d223b733a383a2266756e6374696f6e223b733a31383a227468656d655f776562666f726d5f76696577223b733a31333a22696e636c7564652066696c6573223b613a303a7b7d733a31313a227468656d65207061746873223b613a313a7b693a303b733a32353a2273697465732f616c6c2f6d6f64756c65732f776562666f726d223b7d733a32303a2270726570726f636573732066756e6374696f6e73223b613a313a7b693a303b733a31393a2274656d706c6174655f70726570726f63657373223b7d7d733a32313a22776562666f726d5f766965775f6d65737361676573223b613a373a7b733a393a22617267756d[...]

MySQL said:

#1153 - Got a packet bigger than 'max_allowed_packet' bytes

I gave my host a call and they made so I could import my file. Migration went ok until it stopped at migrating tags 1 of 124. It has been like that for an hour now

If you disable the tag migration, does it work then?

How do I try again? There are alot of new content in my Joomla page now from Drupal. Do I delete anything or drop any tables or just migrate again with different settings?

Just, edit the settings -> set tags to no.
Make sure that "clean migration" is set to yes.

Run the migration -> it will clear/delete the previously imported data and will start again with the import.

Regards,

Daniel

P.S. If you want you can start a private ticket and share your db dump with us. I'll try to import it with the tags and if I encounter the problem on my localmachine I'll provide you with a fix.

Everything went great this time. Thanks alot for this.
Guess I was too quick.
After parsing I didn't get any errors but when I got to check on images there weren't any

So, do I have to upload them? If so what folder and where to?