Hi,
I have just upgraded to 3.3.0(build 1) from 3.2.0 and I can’t seem to transfer my members, which I have 1600 of, to the new database.
I have tried exporting it as a CSV but it’s not integrating with the new database.
Here’s an example of a line out of the database phpfox_user:-
"2","0","0","2","0","0","profile-2","Jared","3c51408358652551287a9d7641c42921","1I.","Jared.*******@gmail.com","1","09291997","875491200","US","en","0","-6","0","1340050244","1342563593","1342563819","2012/07/361a3597b2698ab2696eb35788a51100%s.jpg","0",NULL,"0","0","0","0","0","0","66.90.104.230","0"
It keeps coming up with the same result:-
Invalid field count in csv input on line 1
and
[COLOR=“#FF0000”]
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘“2”,“0”,“0”,“2”,“0”,“0”,“profile-2”,“Jared”,“3c51408358652551287a9d7641c42921”,"’ at line 1
[/COLOR]
In my cPanel it says that my MySQL version is 5.0.95-community. Any ideas?