Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Import problems

Quote Reply
Import problems
Alex,

I've tried the import, and I'm getting the following error no matter how I break it up, from trying to import 1 SQL -> SQL 2

==

Can't call method "connect" on an undefined value at /www/postcards/cgi-bin/DP_Test/admin/import.cgi line 191.
Database handle destroyed without explicit disconnect.

===

I figured I'd try importing from the backups, as a delimited file, and got:

Can't locate object method "critical" via package "Interface::CGI" at /www/postcards/cgi-bin/DP_Test/admin/import.cgi line 576.


--

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://postcards.com/FAQ


Quote Reply
Re: Import problems In reply to
I got the same error. Import in alpha10 worked fine.

Quote Reply
Re: Import problems In reply to
using that info, I got the same error with the import.cgi from version 10. Different line.

So, most likely it's a problem in the change to the libraries, not import.cgi itself.

And, you are right... I dropped back to Alpha 10, and the import worked with the alpha 10 libraries, so it has to be something with the Alpha11 library changes that is incompatible with the import.cgi "connect" routine.

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://postcards.com/FAQ


Quote Reply
Re: Import problems Alpha11 In reply to
Can't locate object method "critical" via package "Interface::Text" at import.cgi line 584.
-=-=-=
Line 584

sub import_L2S2 {
$Int->critical("Not yet implemented");
}

----------------------------------------------------------
This wants to say that still it is not possible to import for the data base?
Quote Reply
Re: Import problems Alpha11 In reply to
First, L2S2 seems to be Links 2 to SQL 2.

Second, the import works, there is a problem in the new one. I imported my database without a problem using the Alpha 10 install. The Alpha 11 has a problem, but it should be easy to fix.

Third, "Crital" is probably just the error reporting, which doesn't mean it won't work, it just won't give detailed errors.

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://postcards.com/FAQ


Quote Reply
Re: Import problems Alpha11 In reply to
yes, I want to import the data of a bank links 2.
I also cannot matter in alpha 10, I am with error also.

-=-=-=-=-=-=-=-=-
LinksSQL User
-=-=-=-=-=-=-=-=
Quote Reply
Re: Import problems In reply to
Hi,

Thanks, this is a known bug and we are working on fixing it up..

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Import problems In reply to
Alex/Jason:

Not to rub salt in the wound, but "non-standard" imports are still not working... but I am sure you knew that!

dave

Quote Reply
Re: Import problems In reply to
What do you mean "non standard" ?

I have a heavily modified database that I was able to import with Alpha10 (the 11 has a problem) and it created all the fields and such for me. It seems to be working near as I can tell. Much improved from the last time I tried it.

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://postcards.com/FAQ


Quote Reply
Re: Import problems In reply to
My database with all the added fields imported fine with alpha10 as well. The column definitions were all correct. The only change was the fields appeared in a different order. Everthing worked with the database (browse etc) until build ran head on into mod_perl.

Quote Reply
Re: Import problems In reply to
I believe you can re-order the fields in the new links to display the way you would like.

The columns are 'hashed' meaning they don't have a retrieval order like an array, but they use the "form display" field to determine how they will display.

This unlinks the physical properties of the database from the display.

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://postcards.com/FAQ


Quote Reply
Re: Import problems In reply to
The problems are probably deeper with a-11, since I can't add, resync or anything else with the database either.

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://postcards.com/FAQ


Quote Reply
Re: Import problems In reply to
Pugdog:

Sorry- haven't checked back in a bit.

I have a previous post about import problems... Jason and I wrote back and forth about the problems. I am still having those problems.

Basically, while the newest versions will CREATE the appropriate fields, it does not import the data I have in those fields. All the standard fields import fine, just not the special fields...

Dave

Quote Reply
Re: Import problems In reply to
You're right. Most of the special fields did not import -- they are nulled out.

Odd. But that can easily be fixed doing a select/insert.

Creating the fields, and updating the category linkages is the problem. Once that is done, importing the special fields, or extra data is just a query!

Glad you pointed that out, though, since enough got imported to appear to work, I would have started to hit problems once I started to move the customized scripts over, and it might have been awhile before I checked that <G>



PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://postcards.com/FAQ


Quote Reply
Re: Import problems In reply to
The latest version should have that working perfectly - I've tested it on a couple sample databases here (both with and without prefixes enabled), and it does import correctly. This will be included in the next release.

Hopefully the latest version will solve the problems.

Jason Rhinelander
Gossamer Threads
Quote Reply
Re: Import problems In reply to
Jason:

I am very ezxcited- you will hear from me one way or another!!!! (If you want Smile)

Pugdog:

Select/Import.... hmmm, above my VERY basic knowledge. I do not know how... if you wanted to show mw how, I'll give it a try; if you do not, well, of course, I understand. In any case, I think I will wait until the next version to do anything!

Thanks!

Dave