Title: Polls 1.2 database error
Last modified: August 18, 2016

---

# Polls 1.2 database error

 *  indiano
 * [22 years ago](https://wordpress.org/support/topic/polls-12-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)

 *  [bAs](https://wordpress.org/support/users/bas/)
 * (@bas)
 * [22 years ago](https://wordpress.org/support/topic/polls-12-database-error/#post-61481)
 * 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.
 *  [Daynah](https://wordpress.org/support/users/phpprincess/)
 * (@phpprincess)
 * [22 years ago](https://wordpress.org/support/topic/polls-12-database-error/#post-61503)
 * `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
 * [22 years ago](https://wordpress.org/support/topic/polls-12-database-error/#post-61563)
 * I tried the query in phpmyadmin, but it does not work…
 *  [nukie](https://wordpress.org/support/users/nukie/)
 * (@nukie)
 * [22 years ago](https://wordpress.org/support/topic/polls-12-database-error/#post-61613)
 * 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
 * [22 years ago](https://wordpress.org/support/topic/polls-12-database-error/#post-61658)
 * Thanks Nukie 🙂

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

The topic ‘Polls 1.2 database error’ is closed to new replies.

 * 5 replies
 * 4 participants
 * Last reply from: Anonymous
 * Last activity: [22 years ago](https://wordpress.org/support/topic/polls-12-database-error/#post-61658)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics