Gossamer Forum
Home : Products : Gossamer Links : Discussions :

import links 2 > links sql

Quote Reply
import links 2 > links sql
hi,

i've made the update from links 2.0 to links sql and had some problems.

solved problems Smile
  • My links.def has 35 fields. most additional fields can be automatically imported but not all. the field 'contact name2' gets an error. it works only as contact_name2
  • I can't see any order which are used to import the additional fields, means that my field order was totally changed - i would like to change the def file to re-arrange my admin-form.


unsolved problems Frown
  • the userdata contains a blank password field. with a blank userfield, the users can't login. the password reminder works but it sends a blank password...
  • the userdata newsletter field contains No but the Receive Mail contains Yes


BTW: Why is the password not crypted?

best regards

eljot
Quote Reply
Re: [eljot] import links 2 > links sql In reply to
1) Try running these via MySQLMonitor (Database);

UPDATE Users SET Password = FLOOR(RAND() * 10000) WHERE Password = NULL

2) Thats cos newsletter, and emails are different :) The newsletter is actually a newletter, whilst the 'send email' option defines is a user is sent details on updates etc...

>>>I can't see any order which are used to import the additional fields, means that my field order was totally changed - i would like to change the def file to re-arrange my admin-form.<<<

You could try going into Database > Links > Properties

That should let you re-arrange the fields there Smile

Hope that helps.

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 links 2 > links sql In reply to
thanks andy,

but this does not work

UPDATE Users SET Password = FLOOR(RAND() * 10000) WHERE Password = NULL

MySQL message: 0 row(s) affected

best regards

eljot
Quote Reply
Re: [eljot] import links 2 > links sql In reply to
NULL and blank are different. Try:

UPDATE Users SET Password = FLOOR(RAND() * 10000) WHERE Password = ""
Quote Reply
Re: [Paul] import links 2 > links sql In reply to
Hello Paul,

well done Wink it works...

thanks

eljot
Quote Reply
Re: [Andy] import links 2 > links sql In reply to
In Reply To:
You could try going into Database > Links > Properties

That should let you re-arrange the fields there Smile

Hope that helps.


Hello Andy,

I can re-arrange the sort-order in the links.def file

but after using resync database, all fields are

in the order of the sql database again. I would

like to change the order permanent. How can I

do this?



But: I've changed the order of the links 2 data exactly as I would use it in the sql database

before the import/update to links sql and did not understand why the import utility can not use this

order and mixed the fields. I can't see any order which was used by the utilty.

best regards

eljot
Quote Reply
Re: [eljot] import links 2 > links sql In reply to
Unfortunately its not that easy. Here's an old discussion:

http://www.gossamer-threads.com/...i?post=208538#208538

I also upgraded from Links2 over a year ago and still haven't got round to moving my fields around!

Laura.
The UK High Street
Quote Reply
Re: [afinlr] import links 2 > links sql In reply to
hello laura,

thanks, a very interested discussion which will

helps me to re-arrange my sql table.

regards



eljot
Quote Reply
Re: [eljot] import links 2 > links sql In reply to
Hi,

If you are familiar with SQL, you can do something like:

alter table lsql_Users change Email Email char(75) after Newsletter;

that will move the Email column right after the Newsletter column in the Users table. You must ensure you create the column with the proper SQL. You can use MySQLMan to help you here.

Once you are done, go into Links SQL and click on Resync and it will automatically update Links SQL.

Hope that helps,

Alex
--
Gossamer Threads Inc.