Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Import error: method "insert_id"

Quote Reply
Import error: method "insert_id"
Having problems importing pipe delimited file. The file I am trying to import is attached for reference. Error is as follows. Any clues please?


A fatal error has occured:

Can't call method "insert_id" on an undefined value at (eval 9) line 79.GT::SQL::error = Column Full Name cannot be left blank.
Many thanks,

Alex



www.indigoclothing.com




Indigo Clothing is a t-shirt printing company based in the UK.
Indigo Clothing | Promotional Clothing | T-Shirt Printing | Embroidery
Quote Reply
Re: [IndigoClothing] Import error: method "insert_id" In reply to
You don't seem to be defining links_Links.Full_Name at the top of the file. I got a feeling that is part of the problem Wink

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Import error: method "insert_id" In reply to
Andy,

Thanks for the prompt reply. Not sure what you mean! - I am a bit of a novice with this stuff - How EXACTLY do I fix the problem? How do I define links_Links.Full_Name at the top of the file?

Many Thanks

Alex



Indigo Clothing is a t-shirt printing company based in the UK.
Indigo Clothing | Promotional Clothing | T-Shirt Printing | Embroidery
Quote Reply
Re: [IndigoClothing] Import error: method "insert_id" In reply to
Where was this pipe delimited file created?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Import error: method "insert_id" In reply to
Exported from Links admin

Imported into excel - pipe delimited

Saved as tab seperated

Tag --> pipe (via text editor replace function)

Import via Links admin



Indigo Clothing is a t-shirt printing company based in the UK.
Indigo Clothing | Promotional Clothing | T-Shirt Printing | Embroidery
Quote Reply
Re: [IndigoClothing] Import error: method "insert_id" In reply to
I am wondering if some sort of database permission problem is happening as when I try to import via MySQLMan I get the error:


Permission to perform action denied!


MySQL Said: Access denied for user: 'indigo@localhost' (Using password: YES).



Can anyone help?

Thanks - Alex

www.indigoclothing.com




Indigo Clothing is a t-shirt printing company based in the UK.
Indigo Clothing | Promotional Clothing | T-Shirt Printing | Embroidery
Quote Reply
Re: [IndigoClothing] Import error: method "insert_id" In reply to
What happens when you try to run page.cgi? Do you see the cateogires/links that should be there?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Import error: method "insert_id" In reply to
Yup - all runs as it should under page.cgi - just double checked.



Indigo Clothing is a t-shirt printing company based in the UK.
Indigo Clothing | Promotional Clothing | T-Shirt Printing | Embroidery
Quote Reply
Re: [IndigoClothing] Import error: method "insert_id" In reply to
In the end I have manged to insert the data into the MySQL databse using phpadmin instaed of MySQLman and then resynced dabatase in the Links admin.

Thanks for your help - these forums are full of the nicest people - always willing to lend a hand to those with inferior knowledge like myself.

Enjoy the rest of the weekend Cool

Alex

www.indigoclothing.com



Indigo Clothing is a t-shirt printing company based in the UK.
Indigo Clothing | Promotional Clothing | T-Shirt Printing | Embroidery