Polls 1.2 database error

  • Hi,
    I get this error installing “WP Polls”
    Database error: [You have an error in your SQL syntax near ‘) ‘ at line 1]
    CREATE TABLE wp_pollsa ( aid int(10) unsigned NOT NULL auto_increment, qid int(10) NOT NULL default ‘0’, answers varchar(200) NOT NULL default ”, votes int(10) NOT NULL default ‘0’, PRIMARY KEY (aid),)
    Database error: [You have an error in your SQL syntax near ‘) ‘ at line 1]
    CREATE TABLE wp_pollsq ( id int(10) unsigned NOT NULL auto_increment, question varchar(200) NOT NULL default ”, timestamp varchar(20) NOT NULL default ”, total_votes tinyint(4) NOT NULL default ‘0’, PRIMARY KEY (id),)
    Database error: [Table ‘wordpress.wp_pollsq’ doesn’t exist]
    INSERT INTO wp_pollsq VALUES (1, ‘How Is My Site?’, ‘1075479885’, 0);
    Database error: [Table ‘wordpress.wp_pollsa’ doesn’t exist]
    INSERT INTO wp_pollsa VALUES (1, 1, ‘Good’, 0);
    Database error: [Table ‘wordpress.wp_pollsa’ doesn’t exist]
    INSERT INTO wp_pollsa VALUES (2, 1, ‘Excellent’, 0);
    Database error: [Table ‘wordpress.wp_pollsa’ doesn’t exist]
    INSERT INTO wp_pollsa VALUES (3, 1, ‘Bad’, 0);
    Database error: [Table ‘wordpress.wp_pollsa’ doesn’t exist]
    INSERT INTO wp_pollsa VALUES (4, 1, ‘Can Be Improved’, 0);
    Database error: [Table ‘wordpress.wp_pollsa’ doesn’t exist]
    INSERT INTO wp_pollsa VALUES (5, 1, ‘No Comments’, 0);
    Any idea?
    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)

  • you could alway use phpmyadmin to create the extra fields first then try the install- but as always back up your existing db before anything.

    CREATE TABLE wp_pollsa ( aid int(10) unsigned NOT NULL auto_increment, qid int(10) NOT NULL default '0', answers varchar(200) NOT NULL default '', votes int(10) NOT NULL default '0', PRIMARY KEY (aid))
    Try running this query in phpMyAdmin. There seems to be an extra , at the end of the query.

    Thread Starter Anonymous

    I tried the query in phpmyadmin, but it does not work…

    I am having the same problem!
    I suppose there isn’t a solution yet?
    I tried the phpmyadmin thing as well,
    It comes up with the error:
    You have an error in your SQL syntax near ‘)’ at line 1

    CREATE TABLE wp_pollsa(
    aid int( 10 ) unsigned NOT NULL auto_increment,
    qid int( 10 ) NOT NULL default '0',
    answers varchar( 200 ) NOT NULL default '',
    votes int( 10 ) NOT NULL default '0',
    PRIMARY KEY ( aid ) ,
    )

    Thread Starter Anonymous

    Thanks Nukie ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Polls 1.2 database error’ is closed to new replies.