SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: PhpFOX

  1. #1
    SitePoint Enthusiast weblover1984's Avatar
    Join Date
    Jul 2010
    Location
    UK
    Posts
    37
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    PhpFOX

    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:-

    PHP Code:
    "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

    #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


    In my cPanel it says that my MySQL version is 5.0.95-community. Any ideas?

  2. #2
    SitePoint Zealot
    Join Date
    Jan 2011
    Location
    Portland
    Posts
    148
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.
    coming soon sitejuju.com my new development portfolio


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •