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: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

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

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

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: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1