Re: [libreoffice-users] SQL Error on Insert

On Tue, Nov 13, 2012 at 9:25 AM, Ian Whitfield <whitfield@telkomsa.net>wrote:

> Hi All
>
> My saga continues with getting Base to work with MySQL!! I am almost there
> but our "friend" Murphy has caught me yet again.
>
> After a MAJOR battle I managed to get all my data out of the old HSQL
> Database. If I tried to extract it all in one go Base either froze or
> crashed. So I added a select function to pull out all the 'As", the 'Bs'
> etc etc and that worked. I then concatenated all the Data in Calc and spent
> a few days cleaning it all up.
>
> Right final step - to INSERT it into the already prepared SQL Databse,
> (created using My Admin). I tried the SQL scripts in a terminal for well
> over a day with no results except error messages. While Googling about this
> I came across a tutorial on how to do this with MyAdmin so decided to go
> that route.
>
> After several hiccups due to differences in Field Names all seemed to be
> right but do what want I can not get past the error "Invalid column count
> in CSV input on line 1." I have tried everything I can think of and tried
> all the "answers" I found after lots of Googling but the problem remains!!
>
> Does anyone know what causes this error or better how to fix it??
>
> ANY help would be appreciated
>
> IanW
> Pretoria RSA
Ian ,

The error means your columns should be listed on line 1 or the column count
does not match the columns within the database. This does not sound like a
LibreO issue but a issue between your CSV files and Mysql.



-- 
--
Masekela Walls
Web Security Analyst | Senior Server Administrator
Powserve.com / Gemini ISP Networks

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted