Search Forums
Forums
Kiwitrees on Twitter
    Tags

    fancy image bar, 7.1, translation, married, default individual, tree, latest version, locked out, 1939 Register, gender change, 3.3.1, tools, fixing errors, Add a wife, order, edit interface, album, husband, 3.0.0, watermark, relationships, future, Administration, roadmap, advent, .mo, language, missing data, kiwitrees 2.0.2, title, feedback, statistics, abbreviate, living, footer, CREM, ID notes, responsive menus, burial, googlemap. modified, xenea, source, zend, immigration, custom, request, sidebar, news module, cousins, simpl_research, Themes change, age, edit, emmigration, type, xmas, seo, individual resource, internal messaging, 2.0.2

    Topic:   Import SQL tables  

    This topic contains 3 replies, has 2 voices, and was last updated by macalter macalter 3 months, 2 weeks ago.

    Viewing 4 posts - 1 through 4 (of 4 total)
    • Author
      Posts
    • #10208
      macalter
      macalter
      Participant

      462 posts

      My host attempted to import my main family tree but it threw up. Host sent back this:

      <ERROR>
      Specifically the following insert into kiwi_change table (Line 666 in
      alters.sql file) as the error indicated:

      ERROR 1064 (42000): 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 ”0 @A306@ INDI\n1 NAME James Rezin /BOWIE/\n2 GIVN James
      Rezin\n2 SURN BOWIE\n1 ‘ at line 2

      mysql> show tables;
      +———————–+
      | Tables_in_mysqlalters |
      +———————–+
      | kiwi_block |
      | kiwi_block_setting |
      | kiwi_change |
      +———————–+
      3 rows in set (0.00 sec)

      mysql> select count(*) from kiwi_block;
      +———-+
      | count(*) |
      +———-+
      | 55 |
      +———-+
      1 row in set (0.00 sec)

      mysql> select count(*) from kiwi_block_setting;
      +———-+
      | count(*) |
      +———-+
      | 71 |
      +———-+
      1 row in set (0.00 sec)

      mysql> select count(*) from kiwi_change;
      +———-+
      | count(*) |
      +———-+
      | 6072 |
      +———-+
      1 row in set (0.01 sec)

      -----
      [updated: 01 Apr 2018]
      MacOS: 10.11.6  (El Capitan)
      Safari  11.1;  Firefox 59.0.2

      PHP 7.1 Fast CGI
      mySQL server: 5.1.56

      Kiwitrees:
      "The Royals 3.3.3 (03)" <royals.rbcsolutions.ca>

      "Rebbes of Ger 3.3.3 (03)" <private>

      "Uncle Ummie's Journal 3.3.3 (03)" <private>

      #10209
      kiwi
      kiwi
      Keymaster

      1636 posts

      No, never seen that. But then I’ve never let web hosts do that sort of job.

      At a guess, I’d say they either ticked some boxes they should have when the data was exported from the old server, or similar in setting up the new one. Incorrect delimiters are a possibility.

      Or perhaps they need to compare setup of each server, to make sure the new one matches the old one.

      I can’t even offer any help with this one, as it requires total access to both your old and new servers. The only thing I am qualified to confirm is that it is not in any way related to kiwitrees’ software itself.

      Nigel
      My personal kiwitrees site is www.our-families.info
      #10210
      kiwi
      kiwi
      Keymaster

      1636 posts

      Just one thought – there is no absolute reason to keep the data in the kiwi_change table. It’s only a log file. So a pragmatic solution would be to remove that part of the exported data.

      However, that error seems so generic, that it might well reappear in another table. 🙁

      Nigel
      My personal kiwitrees site is www.our-families.info
      #10211
      macalter
      macalter
      Participant

      462 posts

      Your confirmation is helpful in itself. I did the export from old server. There seems to be a problem using myPHPAdmin and importing so they’ve assisted me. This is the only one of three that has glitch.

      As they can access both domains will ask them to check.

      -----
      [updated: 01 Apr 2018]
      MacOS: 10.11.6  (El Capitan)
      Safari  11.1;  Firefox 59.0.2

      PHP 7.1 Fast CGI
      mySQL server: 5.1.56

      Kiwitrees:
      "The Royals 3.3.3 (03)" <royals.rbcsolutions.ca>

      "Rebbes of Ger 3.3.3 (03)" <private>

      "Uncle Ummie's Journal 3.3.3 (03)" <private>

    Viewing 4 posts - 1 through 4 (of 4 total)

    You must be logged in to reply to this topic.