#4550 unable to import libreoffice odf files

[holly.golightly]

Database server

Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.5.38-0ubuntu0.14.04.1 - (Ubuntu)
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)

Web server

Apache/2.4.7 (Ubuntu)
Database client version: libmysql - 5.5.38
PHP extension: mysqli Documentation

phpMyAdmin

Version information: 4.0.10deb1

I don't have the following problem when I run phpmyadmin from XAMPP 1.8.2-6 in Windows, or XAMPP 1.8.304 in xubuntu 64-bit.

When I try to import an .ods file, I get:

CREATE TABLE IF NOT EXISTS bpslk_txp.a_bks (
02002001 varchar( 10 ) ,
02002001 varchar( 11 ) ,
Connected Discourses of the Buddha varchar( 132 ) ,
17 int( 3 )
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL said: Documentation

1060 - Duplicate column name '02002001'

Yes, I have checked "first row contains column names"

The query should be (I think--I'm only an amateur):

CREATE TABLE IF NOT EXISTS bpslk_txp.a_bks (
dbid varchar( 10 ) ,
catno varchar( 11 ) ,
title varchar( 132 ) ,
qis int( 3 )
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

This is the first two rows of the .ods spreadsheet.

dbid catno title qis
02002001 02002001 Connected Discourses of the Buddha 17

[Isaac Bennetch]

Hi,

I tested with 4.0.10.2 and the current development branch and didn't have any problems; I also see you tried two other systems and didn't have trouble with those. I don't see any reason in the development logs or ChangeLog file indicating why this would have happened for you. Any chance there's any notice in your webserver error log when this occurs?

[Madhura Jayaratne]

Can you attach a small .odf file which gives you trouble when importing.

[Marc Delisle]

holly.golightly, any feedback please?