WP Poll install error

  • dimenster

    (@dimenster)


    19 years, 2 months ago

    I have tried to install GaMerZ Poll without any luck. When I want to run the installation script I got the following error:

    WordPress database error: [You have an error in your SQL syntax near '( aid int(10) unsigned NOT NULL auto_increment, qid int(10) NOT NULL default '0'' at line 1]
    CREATE TABLE ( 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))

    WordPress database error: [You have an error in your SQL syntax near '( id int(10) unsigned NOT NULL auto_increment, question varchar(200) NOT NULL de' at line 1]
    CREATE TABLE ( 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))

    WordPress database error: [You have an error in your SQL syntax near 'VALUES (1, 'How Is My Site?', '1075479885', 0)' at line 1]
    INSERT INTO VALUES (1, 'How Is My Site?', '1075479885', 0);

    WordPress database error: [You have an error in your SQL syntax near 'VALUES (1, 1, 'Good', 0)' at line 1]
    INSERT INTO VALUES (1, 1, 'Good', 0);

    WordPress database error: [You have an error in your SQL syntax near 'VALUES (2, 1, 'Excellent', 0)' at line 1]
    INSERT INTO VALUES (2, 1, 'Excellent', 0);

    WordPress database error: [You have an error in your SQL syntax near 'VALUES (3, 1, 'Bad', 0)' at line 1]
    INSERT INTO VALUES (3, 1, 'Bad', 0);

    WordPress database error: [You have an error in your SQL syntax near 'VALUES (4, 1, 'Can Be Improved', 0)' at line 1]
    INSERT INTO VALUES (4, 1, 'Can Be Improved', 0);

    WordPress database error: [You have an error in your SQL syntax near 'VALUES (5, 1, 'No Comments', 0)' at line 1]
    INSERT INTO VALUES (5, 1, 'No Comments', 0);

    Somebody a idea how to solve this error?
    Thanks,
    Dimenster

Viewing 1 replies (of 1 total)
  • hardincomp

    (@hardincomp)

    18 years, 11 months ago

    As I posted in anothe thread, the problem seems to be whwre it selects the table by specifying “$wpda->pollsq” and “$wpdb->pollsq”. Remove the code “$wpdb->” and it should work. At least that’s what did it for me. Of course I had to go through damned near every file and make the edits, but it works now.

Viewing 1 replies (of 1 total)
  • The topic ‘WP Poll install error’ is closed to new replies.