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

    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 @[email protected] 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: 11 Jun 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 89.0
    PHP 7.4 FastCGI

    Alter-Drukarsh connections... 3.3.8 <private>
    The Royals 3.3.8<royals.rbcsolutions.ca
    >
    The Gerrer Rebbes 3.3.8 <royals.rbcsolutions.ca/index.php?ged=rebbes>

  • #10209

    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

    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

    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: 11 Jun 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 89.0
    PHP 7.4 FastCGI

    Alter-Drukarsh connections... 3.3.8 <private>
    The Royals 3.3.8<royals.rbcsolutions.ca
    >
    The Gerrer Rebbes 3.3.8 <royals.rbcsolutions.ca/index.php?ged=rebbes>

Viewing 4 posts - 1 through 4 (of 4 total)
  • The topic ‘Import SQL tables’ is closed to new replies.