PhpFOX

PHP
1

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?

2

For your first error make sure your database type and collation are exactly the same from your previous database. For your second error i’m not sure but you seem to have an extra quote in your sql pertaining to the 1046 error.