Title: Database error
Last modified: February 19, 2017

---

# Database error

 *  Resolved [smlabonia](https://wordpress.org/support/users/smlabonia/)
 * (@smlabonia)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/database-error-232/)
 * I need some help with this.
 * I get a job solving problemas with a WordPress web in 4.3.1 with adRotate v3.8.3.4.
 * I make work all aspects of the web, but adRotate still giving me some errors.
 * ¿How i migrate de database? Im just replace the new database of adRotate with
   the old tables.
 * When i go to AdRotates/Adverts i get this errors:
 * Error en la base de datos de WordPress: [Column ‘ad’ in where clause is ambiguous]
   
   SELECT `starttime` FROM `gp_adrotate_schedule`, `gp_adrotate_linkmeta` WHERE `
   ad` = ’17’ AND `schedule` = `gp_adrotate_schedule`.`id` ORDER BY `starttime` 
   ASC LIMIT 1;
 * Error en la base de datos de WordPress: [Column ‘ad’ in where clause is ambiguous]
   
   SELECT `stoptime` FROM `gp_adrotate_schedule`, `gp_adrotate_linkmeta` WHERE `
   ad` = ’17’ AND `schedule` = `gp_adrotate_schedule`.`id` ORDER BY `stoptime` DESC
   LIMIT 1;
 * Error en la base de datos de WordPress: [Column ‘ad’ in where clause is ambiguous]
   
   SELECT `starttime` FROM `gp_adrotate_schedule`, `gp_adrotate_linkmeta` WHERE `
   ad` = ’18’ AND `schedule` = `gp_adrotate_schedule`.`id` ORDER BY `starttime` 
   ASC LIMIT 1;
 * Error en la base de datos de WordPress: [Column ‘ad’ in where clause is ambiguous]
   
   SELECT `stoptime` FROM `gp_adrotate_schedule`, `gp_adrotate_linkmeta` WHERE `
   ad` = ’18’ AND `schedule` = `gp_adrotate_schedule`.`id` ORDER BY `stoptime` DESC
   LIMIT 1;
 * Error en la base de datos de WordPress: [Column ‘ad’ in where clause is ambiguous]
   
   SELECT `starttime` FROM `gp_adrotate_schedule`, `gp_adrotate_linkmeta` WHERE `
   ad` = ’19’ AND `schedule` = `gp_adrotate_schedule`.`id` ORDER BY `starttime` 
   ASC LIMIT 1;
 * Error en la base de datos de WordPress: [Column ‘ad’ in where clause is ambiguous]
   
   SELECT `stoptime` FROM `gp_adrotate_schedule`, `gp_adrotate_linkmeta` WHERE `
   ad` = ’19’ AND `schedule` = `gp_adrotate_schedule`.`id` ORDER BY `stoptime` DESC
   LIMIT 1;
 * Error en la base de datos de WordPress: [Column ‘ad’ in where clause is ambiguous]
   
   SELECT `starttime` FROM `gp_adrotate_schedule`, `gp_adrotate_linkmeta` WHERE `
   ad` = ’20’ AND `schedule` = `gp_adrotate_schedule`.`id` ORDER BY `starttime` 
   ASC LIMIT 1;
 * And a lot more.
 * And when i got to groups, get this:
 * Notice: Undefined property: stdClass::$adspeed in /var/www/html/wp-content/plugins/
   adrotate/dashboard/publisher/groups-main.php on line 59
 * Notice: Undefined property: stdClass::$modus in /var/www/html/wp-content/plugins/
   adrotate/dashboard/publisher/groups-main.php on line 60
 * Notice: Undefined property: stdClass::$modus in /var/www/html/wp-content/plugins/
   adrotate/dashboard/publisher/groups-main.php on line 61
 * Notice: Undefined property: stdClass::$modus in /var/www/html/wp-content/plugins/
   adrotate/dashboard/publisher/groups-main.php on line 62
 * Notice: Undefined property: stdClass::$adspeed in /var/www/html/wp-content/plugins/
   adrotate/dashboard/publisher/groups-main.php on line 59
 * Notice: Undefined property: stdClass::$modus in /var/www/html/wp-content/plugins/
   adrotate/dashboard/publisher/groups-main.php on line 60
 * Notice: Undefined property: stdClass::$modus in /var/www/html/wp-content/plugins/
   adrotate/dashboard/publisher/groups-main.php on line 61
 * Notice: Undefined property: stdClass::$modus in /var/www/html/wp-content/plugins/
   adrotate/dashboard/publisher/groups-main.php on line 62
 * And a lot more.
 * Could somebody know how i solve this?
 * Thank you very much!

Viewing 1 replies (of 1 total)

 *  Plugin Author [Arnan](https://wordpress.org/support/users/adegans/)
 * (@adegans)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/database-error-232/#post-8855361)
 * Start with updating to a newer version. The latest version is 4.4 (Pro) / 4.0(
   Free).
    It’s likely that your problem goes away with the newer version.
 * Upgrade instruction: [https://ajdg.solutions/adrotate/manuals/upgrade-adrotate-pro-to-a-newer-version/](https://ajdg.solutions/adrotate/manuals/upgrade-adrotate-pro-to-a-newer-version/)
   
   To activate licenses you need version 3.12 or newer.

Viewing 1 replies (of 1 total)

The topic ‘Database error’ is closed to new replies.

 * ![](https://ps.w.org/adrotate/assets/icon-256x256.gif?rev=3117289)
 * [AdRotate Banner Manager](https://wordpress.org/plugins/adrotate/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/adrotate/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/adrotate/)
 * [Active Topics](https://wordpress.org/support/plugin/adrotate/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/adrotate/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/adrotate/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Arnan](https://wordpress.org/support/users/adegans/)
 * Last activity: [9 years, 3 months ago](https://wordpress.org/support/topic/database-error-232/#post-8855361)
 * Status: resolved