Advertisement:

Author Topic: NEED HELP - Converting calendar events...Error in convert script - line 571!  (Read 9647 times)

Offline Craw

  • Semi-Newbie
  • *
  • Posts: 62
  • 4x4ph.com
Hi guys,

I need help. While converting my IPB to SMF 2 I encountered this error:

Code: [Select]
Converting calendar events...Error in convert script - line 571!
Unsuccessful!
This query:
TRUNCATE `travels4_sm4440`.kdq_calendar
SELECT
event_id AS id_event,
event_unixstamp AS start_date, event_unixstamp AS end_date,
'0' AS id_board, '0' AS id_topic, SUBSTRING(event_title, 1, 60) AS title, event_member_id AS id_member
FROM `travels4_4xforum`.ibf_cal_events
LIMIT 0, 500;
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT
event_id AS id_event,
event_unixstamp AS start_date, event_unixstamp AS' at line 2

I'm a newbie so please be gentle haha :D

Thanks in advance, guys.
4x4 Philippines | www.4xph.com

But He (Jesus Christ) said to me, "My grace is sufficient for you,
for my power is made perfect in weakness."
Therefore
I will boast all the more gladly about my weaknesses,
so that Christ's power may rest on me. -- 2 Corinthians 12:9

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Which converter? From which IPB version?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Craw

  • Semi-Newbie
  • *
  • Posts: 62
  • 4x4ph.com
Which converter? From which IPB version?

IPB version 2.3.x to SMF 2

Thanks, Margarett.
4x4 Philippines | www.4xph.com

But He (Jesus Christ) said to me, "My grace is sufficient for you,
for my power is made perfect in weakness."
Therefore
I will boast all the more gladly about my weaknesses,
so that Christ's power may rest on me. -- 2 Corinthians 12:9

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
And are you using the converter from here http://download.simplemachines.org/?converters;software=invision ?
This one: "Invision 2.3 to SMF 2-0"?

edit: there is an error, yes. Open the .sql file, line 551, you will find this:
Code: [Select]
TRUNCATE {$to_prefix}calendarIt misses a ; at the end, so it should become:
Code: [Select]
TRUNCATE {$to_prefix}calendar;
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Colin

  • Lead Developer
  • SMF Hero
  • *
  • Posts: 7,760
  • Gender: Male
  • SMF Developer
    • colinschoen on GitHub
Pesky semicolons.
"If everybody is thinking alike, then somebody is not thinking." - Gen. George S. Patton Jr.

Colin

Offline Craw

  • Semi-Newbie
  • *
  • Posts: 62
  • 4x4ph.com
Thanks. Now this is the error I'm getting:

Code: [Select]
Converting calendar events...Wrong value type sent to the database. Date expected. (start_date)
4x4 Philippines | www.4xph.com

But He (Jesus Christ) said to me, "My grace is sufficient for you,
for my power is made perfect in weakness."
Therefore
I will boast all the more gladly about my weaknesses,
so that Christ's power may rest on me. -- 2 Corinthians 12:9

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
I'm sorry, I have no access to a IPB database. Can you please take a printscreen of some records of your IPB's "cal_events" table?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Craw

  • Semi-Newbie
  • *
  • Posts: 62
  • 4x4ph.com
Here are screenshots of some of the tables (2 parts to show all available columns) :

http://awesomescreenshot.com/0d73ygkud0
http://awesomescreenshot.com/0e43ygl808
4x4 Philippines | www.4xph.com

But He (Jesus Christ) said to me, "My grace is sufficient for you,
for my power is made perfect in weakness."
Therefore
I will boast all the more gladly about my weaknesses,
so that Christ's power may rest on me. -- 2 Corinthians 12:9

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Could you please order that table for "event_unixstamp" (click on the column header)?
I'm trying to understand if you have some null or empty rows in this column ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Craw

  • Semi-Newbie
  • *
  • Posts: 62
  • 4x4ph.com
Could you please order that table for "event_unixstamp" (click on the column header)?
I'm trying to understand if you have some null or empty rows in this column ;)
I checked and there weren't any null or empty rows :(
4x4 Philippines | www.4xph.com

But He (Jesus Christ) said to me, "My grace is sufficient for you,
for my power is made perfect in weakness."
Therefore
I will boast all the more gladly about my weaknesses,
so that Christ's power may rest on me. -- 2 Corinthians 12:9

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
I have to change something on the converter to test, then. I'm not on the computer, will check later ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Craw

  • Semi-Newbie
  • *
  • Posts: 62
  • 4x4ph.com
I have to change something on the converter to test, then. I'm not on the computer, will check later ;)
OK. Thanks for the time. Really appreciate it.
4x4 Philippines | www.4xph.com

But He (Jesus Christ) said to me, "My grace is sufficient for you,
for my power is made perfect in weakness."
Therefore
I will boast all the more gladly about my weaknesses,
so that Christ's power may rest on me. -- 2 Corinthians 12:9

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Try this, please. If it succeeds, make sure that the dates are correctly converted ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Craw

  • Semi-Newbie
  • *
  • Posts: 62
  • 4x4ph.com
Try this, please. If it succeeds, make sure that the dates are correctly converted ;)
Thanks! Will try it and update you :)
4x4 Philippines | www.4xph.com

But He (Jesus Christ) said to me, "My grace is sufficient for you,
for my power is made perfect in weakness."
Therefore
I will boast all the more gladly about my weaknesses,
so that Christ's power may rest on me. -- 2 Corinthians 12:9

Offline Craw

  • Semi-Newbie
  • *
  • Posts: 62
  • 4x4ph.com
Got this error :(

Code: [Select]
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
4x4 Philippines | www.4xph.com

But He (Jesus Christ) said to me, "My grace is sufficient for you,
for my power is made perfect in weakness."
Therefore
I will boast all the more gladly about my weaknesses,
so that Christ's power may rest on me. -- 2 Corinthians 12:9

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Which means that worked :)

Let me do the same for members.
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Craw

  • Semi-Newbie
  • *
  • Posts: 62
  • 4x4ph.com
Which means that worked :)

Let me do the same for members.
Thanks!
4x4 Philippines | www.4xph.com

But He (Jesus Christ) said to me, "My grace is sufficient for you,
for my power is made perfect in weakness."
Therefore
I will boast all the more gladly about my weaknesses,
so that Christ's power may rest on me. -- 2 Corinthians 12:9

Offline Craw

  • Semi-Newbie
  • *
  • Posts: 62
  • 4x4ph.com
Which means that worked :)

Let me do the same for members.

Hi Margarett. Any updates?

Thanks.
4x4 Philippines | www.4xph.com

But He (Jesus Christ) said to me, "My grace is sufficient for you,
for my power is made perfect in weakness."
Therefore
I will boast all the more gladly about my weaknesses,
so that Christ's power may rest on me. -- 2 Corinthians 12:9

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Ups, I forgot, sorry :(

This is different from the other issue, though. And now that I think about it, members are converted before calendar so this error should have triggered first...
Can you get me a printscreen of your members table, with the columns bday_year, bday_month, bday_day? Also please check for inconsistent entries in these columns
And of course, mask out sensitive informations from your members ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair