#1064 error when using code in wordpress database

  • mitdrissia

    (@mitdrissia)


    13 years, 9 months ago

    Hi,
    i have downloaded and activated the author adsense plugin.But before i can use it i have to put some code in phpmyadmin.
    the code is as follows:
    CREATE TABLE wp_author_advertising ( id mediumint(9) NOT NULL auto_increment, author_id int(11) NOT NULL default ’0′, author_advertising text NOT NULL, author_custom1 text, author_custom2 text, PRIMARY KEY (id) );

    I get this error:
    #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 ‘’0′, author_advertising text NOT NULL, author_custom1 text, author_custom2 t’ at line 1

    Can anybody help me out?
    thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter mitdrissia

    (@mitdrissia)

    13 years, 9 months ago

    no one out there who knows how to solve this problem guys?

    kmessinger

    (@kmessinger)

    13 years, 9 months ago

    Why are you messing with the database? To install the plugin you

    Upload adsense-plugin folder to the /wp-content/plugins/ directory.
    Activate plugin through the ‘Plugins’ menu in WordPress.
    Plugin settings are located in “BWS Plugin”, “AdSense”.

    I hope you have a backup for the db.

    Thread Starter mitdrissia

    (@mitdrissia)

    13 years, 9 months ago

    Dear kmessinger,
    first of all thanks for your reply but i dont follow what you mean

    I did all the things you mentioned except for the part where you say:
    Plugin settings are located in “BWS Plugin”, “AdSense”.

    The plugins name is “author advertising plugin” and when you go to settings it tells me to alter the database.

    I can’t see the table i created so i think its not added to database untill i remove the errors.
    Hope to receive help because i really need this plugin
    thank you

    kmessinger

    (@kmessinger)

    13 years, 9 months ago

    There is nothing about messing with the database here.

    http://wordpress.org/extend/plugins/author-advertising-plugin/installation/

    [edit] Ok, I installed the plugin and I see the db instructions. I will check further.

    [edit] There is support for this plugin at http://www.craftycoding.com/help/

    kmessinger

    (@kmessinger)

    13 years, 9 months ago

    I put the plugin name in tags. Maybe the plugin developer will respond here. The whole purpose of plugins is to add to your sites functionality without having to change code, database etc.

    I have installed several plugins, all of which wrote to the db with no problem. But this one cannot. Something is wrong with that.

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

The topic ‘#1064 error when using code in wordpress database’ is closed to new replies.