Title: #1064 error when using code in wordpress database
Last modified: August 20, 2016

---

# #1064 error when using code in wordpress database

 *  [mitdrissia](https://wordpress.org/support/users/mitdrissia/)
 * (@mitdrissia)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/1064-error-when-using-code-in-wordpress-database/)
 * 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](https://wordpress.org/support/users/mitdrissia/)
 * (@mitdrissia)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/1064-error-when-using-code-in-wordpress-database/#post-3032707)
 * no one out there who knows how to solve this problem guys?
 *  [kmessinger](https://wordpress.org/support/users/kmessinger/)
 * (@kmessinger)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/1064-error-when-using-code-in-wordpress-database/#post-3032708)
 * 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](https://wordpress.org/support/users/mitdrissia/)
 * (@mitdrissia)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/1064-error-when-using-code-in-wordpress-database/#post-3032711)
 * 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](https://wordpress.org/support/users/kmessinger/)
 * (@kmessinger)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/1064-error-when-using-code-in-wordpress-database/#post-3032712)
 * There is nothing about messing with the database here.
 * [http://wordpress.org/extend/plugins/author-advertising-plugin/installation/](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/](http://www.craftycoding.com/help/)
 *  [kmessinger](https://wordpress.org/support/users/kmessinger/)
 * (@kmessinger)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/1064-error-when-using-code-in-wordpress-database/#post-3032713)
 * 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.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 5 replies
 * 2 participants
 * Last reply from: [kmessinger](https://wordpress.org/support/users/kmessinger/)
 * Last activity: [13 years, 9 months ago](https://wordpress.org/support/topic/1064-error-when-using-code-in-wordpress-database/#post-3032713)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics