05-24-2014, 09:19 AM
Ok everythink works fine now, ads displaying great!
for those with problem with installation on sql 5.5.X
when importing table.txt - edit and add: delimiter |
example 1058 line:
delimiter |
CREATE TRIGGER `adserver_parentstatus_updation` AFTER UPDATE ON `nesote_inoutscripts_users`
FOR EACH ROW BEGIN
UPDATE `ppc_users` SET parent_status = NEW.status WHERE common_account_id = NEW.id;
UPDATE `ppc_publishers` SET parent_status = NEW.status WHERE common_account_id = NEW.id;
END;
for those with problem with installation on sql 5.5.X
when importing table.txt - edit and add: delimiter |
example 1058 line:
delimiter |
CREATE TRIGGER `adserver_parentstatus_updation` AFTER UPDATE ON `nesote_inoutscripts_users`
FOR EACH ROW BEGIN
UPDATE `ppc_users` SET parent_status = NEW.status WHERE common_account_id = NEW.id;
UPDATE `ppc_publishers` SET parent_status = NEW.status WHERE common_account_id = NEW.id;
END;