Advertisement:

Author Topic: Kunena>SMF, Problem with converting attachments!  (Read 2364 times)

Offline Lumi

  • Newbie
  • *
  • Posts: 1
Kunena>SMF, Problem with converting attachments!
« on: December 29, 2011, 04:10:42 PM »
Hello!

This is my problem: When I'm trying to convert Kunena 1.7 to SMF 2.0.2, converter is founding an error:
Code: [Select]
Converting attachments...
Unsuccessful!
This query:

    SELECT mesid AS id_msg, filelocation
    FROM `spektro_defi`.jos_kunena_attachments
    LIMIT 0, 500;

Caused the error:

    Unknown column 'filelocation' in 'field list'

I saw that someone got similar problem, but no one could solve that...

Please help me.

Offline K@

  • Lead Support Specialist
  • SMF Master
  • *
  • Posts: 38,750
  • Gender: Male
  • Nothing (Or nothing you can see)
Re: Kunena>SMF, Problem with converting attachments!
« Reply #1 on: December 29, 2011, 04:36:10 PM »
Do you know about phpmyadmin (Silly name, or what?)

If so, can you look at the "filelist" table and see if the "filelocation" column doesn't, indeed, exist?

If it doesn't, it might pay you to backup the database and create it.

If that doesn't help, you can always restore the backup. :)

Offline jamenvafan

  • Newbie
  • *
  • Posts: 3
Re: Kunena>SMF, Problem with converting attachments!
« Reply #2 on: January 03, 2012, 07:03:55 AM »
fThere is an error in the sql file. It says 'filelocation' where it should say 'folder'.

Mine also said 'fb' where it should say 'kunena'.

YMMV