Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Nov 2009
    Posts
    202
    Thanks
    25
    Thanked 0 Times in 0 Posts

    PHP List (phplist) - latest version - cannot create user_attribute table.

    Anyone know how to get around this? Is this even a major problem? the user_attribute table *is* created but i don't know if it is missing fields. can someone post their user_attribute table or help determine a fix?

    Creating tables

    Initialising table attribute... ok
    Initialising table user_attribute
    Database error 1064 while doing query 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 '=> aindex (attributeid),index userattid (attributeid,userid),index attuserid (us' at line 2
    ... failed
    Code:
    "user_attribute" => array(
            "attributeid" => array("integer not null","attribute"),
            "userid" => array("integer not null","user"),
            "value" => array("varchar(255)","Value of this attribute for this user"),
            "primary key" => array("(attributeid,userid)","PKey"),
            "index_1" => array("userindex (userid)",""),
            "index_2" => array("att => aindex (attributeid)",""),
            "index_3" => array("userattid (attributeid,userid)",""),
            "index_4" => array("attuserid (userid,attributeid)",""),
        ),

  • #2
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,987
    Thanks
    4
    Thanked 2,660 Times in 2,629 Posts
    Never used PHPList before.
    Its something wrong with the data to parse using this: "index_2" => array("att => aindex (attributeid)",""),
    What the problem is, I'm not sure. It looks like its just trying to name and assign index associations, so I question of the 'att =>' part is needed at all. To me, it shows 'aindex' as its index name, and 'attributeid' for the indexed column.
    I'd try just dropping that 'att => ' off of that index_2 and see if that doesn't fix it.
    PHP Code:
    header('HTTP/1.1 420 Enhance Your Calm'); 


  •  

    Posting Permissions

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