• Resolved smlabonia

    (@smlabonia)


    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)
Viewing 1 replies (of 1 total)

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