Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: Import v1.13 defs into v2.0 format tables

Quote Reply
Re: Import v1.13 defs into v2.0 format tables In reply to
Hello Alex!

OK. I have tried like before but no sucess. Following are the errors:

Import error: Warning: Custom import column `Users.User' had no destination equivelant. A column will be created

Import error: Warning: Custom import column `Users.Pass' had no destination equivelant. A column will be created

Import error: CRITICAL ERROR OCCURED: Unable to execute query `SELECT Username, Password, Email, Validation, Status, User, Pass, Pass, User FROM Users': Table 'Database.Users' doesn't exist at /usr/.../Import/S1S2.pm line 282

What it does is simply creating two columns User, Pass in the table and crashes. Here there is no control as to which field goes where. Table.Validate has all the data that needs to be distributed into different tables in Links SQL v2.0 and therefore this would be necessary.

What I meant was that if in the import routines if one could select fields and either delete or rename them then it can function. I mean otherwise it does what may be unwanted. For e.g. earlier there was User + Pass in the Links1.Validate and now Username + Password table. So what it will do is create and bring the data with the same Properties to the new table. The custom_new table created by import.cgi may not have the same properties as the default_new. This would also be in a conflict with the INDEXES.

Almost everyone has customized their tables and hence an import utility that functions is therefore an acute necessicity.

Subject Author Views Date
Thread Import v1.13 defs into v2.0 format tables dearnet 2010 Jan 8, 2001, 7:55 AM
Thread Re: Import v1.13 defs into v2.0 format tables
Alex 1993 Jan 8, 2001, 11:49 AM
Thread Re: Import v1.13 defs into v2.0 format tables
dearnet 1964 Jan 9, 2001, 12:12 AM
Thread Re: Import v1.13 defs into v2.0 format tables
Alex 1954 Jan 9, 2001, 12:57 PM
Thread Re: Import v1.13 defs into v2.0 format tables
dearnet 1954 Jan 9, 2001, 1:17 PM
Thread Re: Import v1.13 defs into v2.0 format tables
Alex 1945 Jan 9, 2001, 3:12 PM
Post Re: Import v1.13 defs into v2.0 format tables
dearnet 1927 Jan 10, 2001, 12:30 AM
Thread Re: Import v1.13 defs into v2.0 format tables
dearnet 1888 Jun 21, 2001, 1:27 AM
Thread Re: [rajani] Import v1.13 defs into v2.0 format tables
dearnet 1819 Nov 25, 2001, 11:49 PM
Post Re: [rajani] Import v1.13 defs into v2.0 format tables
Alex 1806 Nov 27, 2001, 7:11 PM