Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
Olá preciso da ajuda de vocês,
Eu tenho a tabela abaixo que contém somente um registro, ela guarda templates de e-mail, quando um cliente se cadastra no site é enviado um e-mail baseado neste template, o mais estranho é que o registro é apagado sem mais nem menos o administrador do site não apaga o registro e mais estranho que é só esta tabela. Tenho outro sistema que também apresenta esse problema de sumir registros sem ser apagados. O que pode ser ?
CREATE TABLE IF NOT EXISTS `templates` (
`id` int(11) NOT NULL auto_increment,
`novo_assinante` text NOT NULL,
`reenvio_de_senha` text NOT NULL,
`vencendo` longtext NOT NULL,
`renovacao_de_assinatura` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Extraindo dados da tabela templates
--
INSERT INTO `templates` (`id`, `novo_assinante`, `reenvio_de_senha`, `vencendo`, `renovacao_de_assinatura`) VALUES
(1, 'PHA+Jm5ic3A7PC9wPg0KPHA+T2wmYWFjdXRlOyBbbm9tZV9jbGllbnRlXTwvcD4NCjxwPkluZm9ybWFtb3MgcXVlIHNldXMgZGFkb3MgZXN0JmF0aWxkZTtvIGVtIG5vc3NvIHNpc3RlbWEgY29uZm9ybWUgYWJhaXhvLiBTZXUgICAgYWNlc3NvIGEgdG9kYXMgYXMgJmFhY3V0ZTtyZWFzIGRvIHNpdGUgaW5pY2lhciZhYWN1dGU7IGVtIGF0JmVhY3V0ZTsgPGVtPjxzdHJvbmc+dW1hIGhvcmE8L3N0cm9uZz48L2VtPi48L3A+DQo8cD5Mb2dpbjogW2xvZ2luXTwvcD4NCjxwPlNlbmhhOiBbcGFzc3dvcmRdPC9wPg0KPHA+U3VhIHZhbGlkYWRlICZlYWN1dGU7IGF0JmVhY3V0ZTs6IFtkYXRhX3ZhbGlkYWRlXTwvcD4NCjxwPiZuYnNwO09icy46IERpZ2l0ZSBjb3JyZXRhbWVudGUgb3MgZGFkb3MgY29tbyBhY2ltYSwgcG9pcyBsZXRyYXMgICAgbWFpdXNjJnVhY3V0ZTtsYXMsIHBvbnRvcywgIHYmaWFjdXRlO3JndWxhcyBvdSBhdCZlYWN1dGU7IG1lc21vIGVzcGEmY2NlZGlsO29zIHMmYXRpbGRlO28gcmVjb25oZWNpZG9zIHBlbG8gICAgc2lzdGVtYS48L3A+DQo8cD5BdGVuY2lvc2FtZW50ZSw8L3A+DQo8cD5TdXBvcnRlIC0gSW5uZXIgQ2x1YjwvcD4NCjxwPjxmb250PjxiciAvPg0KPC9mb250PjwvcD4NCjxkaXY+PGhyIC8+DQo8Zm9udD5Ob3NzYSBtYWlvciBhdHJhJmNjZWRpbDsmYXRpbGRlO28gJmVhY3V0ZTsgbyA8c3Ryb25nPlYmaWFjdXRlO2RlbyBDaGF0Ojwvc3Ryb25nPjwvZm9udD48L2Rpdj4NCjxkaXY+PGZvbnQ+Jm5ic3A7PC9mb250PjwvZGl2Pg0KPGRpdj48Zm9udD4tIEVzcGEmY2NlZGlsO28gcGFyYSAxMDAgcGVzc29hcyBuYSBzYWxhLjxiciAvPg0KLSBBdCZlYWN1dGU7IDEyIGMmYWNpcmM7bWVyYXMgc2ltdWx0JmFjaXJjO25lYXMuPGJyIC8+DQotICBWb2MmZWNpcmM7IG4mYXRpbGRlO28gcHJlY2lzYSB0ZXIgd2ViY2FtIHBhcmEgYWNlc3NhciBlIHZlci48YnIgLz4NCi0gRGlzcG9uJmlhY3V0ZTt2ZWwgMjQgaHMgcG9yICBkaWEuPGJyIC8+DQotIE4mYXRpbGRlO28gJmVhY3V0ZTsgbmVjZXNzJmFhY3V0ZTtyaW8gaW5zdGFsYXIgbmVuaHVtIHNvZnR3YXJlIHBhcmEgYWNlc3Nhciwgc29tZW50ZSAgICBwcmVjaXNhIHRlciBvIHBsdWdpbiBzaG9ja3dhdmUgZmxhc2ggYXR1YWxpemFkbyBubyBuYXZlZ2Fkb3IsIHF1ZSAgIG5vcm1hbG1lbnRlICZlYWN1dGU7ICBpbnN0YWxhZG8gYXV0b21hdGljYW1lbnRlLjwvZm9udD48L2Rpdj4NCjxkaXY+PGZvbnQ+Jm5ic3A7PC9mb250PjwvZGl2Pg0KPGRpdj48Zm9udD48YnIgLz4NClBvbnRvcyBGb3J0ZXM8L2ZvbnQ+PC9kaXY+DQo8ZGl2Pjxmb250PiZuYnNwOzwvZm9udD48L2Rpdj4NCjxkaXY+PGZvbnQ+TyBWaWRlbyBDaGF0ICZlYWN1dGU7IHVtYSBwYXJjZXJpYSBlbnRyZSB2JmFhY3V0ZTtyaW9zIHNpdGVzIGRlIHJlZ2kmb3RpbGRlO2VzICAgZGlmZXJlbnRlcyBlbnQmYXRpbGRlO28gIGFvIGFjZXNzYXIgdm9jJmVjaXJjOyBlbmNvbnRyYSBwZXNzb2FzIGRlIHRvZGFzIGFzIHJlZ2kmb3RpbGRlO2VzICAgZG8gQnJhc2lsLCBmYWNpbGl0YW5kbyBhICBhcHJveGltYSZjY2VkaWw7JmF0aWxkZTtvIGUgbyBjb250YXRvLiA8L2ZvbnQ+PC9kaXY+DQo8ZGl2Pjxmb250PiZuYnNwOzwvZm9udD48L2Rpdj4NCjxkaXY+PGZvbnQ+TSZlYWN1dGU7ZGlhIGRlIHVzdSZhYWN1dGU7cmlvczwvZm9udD48L2Rpdj4NCjxkaXY+PGZvbnQ+Jm5ic3A7PC9mb250PjwvZGl2Pg0KPGRpdj48Zm9udD4tIE1hbmgmYXRpbGRlOyAtIDIwIGEgMzUgcGVzc29hcyBuYSBzYWxhPGJyIC8+DQotIFRhcmRlIC0gMzAgYSA0NSBwZXNzb2FzIG5hIHNhbGE8YnIgLz4NCi0gIE5vaXRlIC0gNDUgYSA3MCBwZXNzb2FzIG5hIHNhbGEgLSBBbGd1bnMgZGlhcyBjaGVnYSBhIHBpY29zIGRlIDg4ICAgcGVzc29hcyBvbiAgbGluZS48L2ZvbnQ+PC9kaXY+DQo8ZGl2Pjxmb250PiZuYnNwOzwvZm9udD48L2Rpdj4NCjxkaXY+DQo8ZGl2Pjxmb250Pjxmb250IHNpemU9IjIiIGZhY2U9IkFyaWFsIj5DbGFzc2lmaWNhZG9zIGNvbSBtYWlzIGRlIDIwMDAgICBhbiZ1YWN1dGU7bmNpb3MsIHRvZG9zIGNvbSAgZm90b3MsIHNlbSBhbiZ1YWN1dGU7bmNpb3MgcmVwZXRpZG9zLjwvZm9udD48L2ZvbnQ+PC9kaXY+DQo8ZGl2Pjxmb250PiZuYnNwOzwvZm9udD48L2Rpdj4NCjxkaXY+DQo8ZGl2Pjxmb250Pjxmb250IHNpemU9IjIiIGZhY2U9IkFyaWFsIj48c3Ryb25nPkFsJmVhY3V0ZTttIGRpc3NvIGFpbmRhIHRlbW9zICAgdW1hIGdhbGVyaWEgZGUgZm90b3MgICwgdiZpYWN1dGU7ZGVvcyBlciZvYWN1dGU7dGljb3MsIGVuc2Fpb3MgZXNwZWNpYWlzIGUgIGV0Yy48L3N0cm9uZz48L2ZvbnQ+PC9mb250PjwvZGl2Pg0KPC9kaXY+DQo8L2Rpdj4NCjxwPiZuYnNwOzwvcD4NCjxwPiZuYnNwOzwvcD4=', 'PHA+Jm5ic3A7PC9wPg0KPHA+T2wmYWFjdXRlOyBbbm9tZV9jbGllbnRlXTwvcD4NCjxwPlNldSBsb2dpbjogW2xvZ2luXTwvcD4NCjxwPlN1YSBzZW5oYTogW3Bhc3N3b3JkXTwvcD4NCjxwPiZuYnNwO09icy46IERpZ2l0ZSBjb3JyZXRhbWVudGUgb3MgZGFkb3MgY29tbyBhY2ltYSwgcG9pcyBsZXRyYXMgICAgIG1haXVzYyZ1YWN1dGU7bGFzLCBwb250b3MsICB2JmlhY3V0ZTtyZ3VsYXMgb3UgYXQmZWFjdXRlOyBtZXNtbyBlc3BhJmNjZWRpbDtvcyBzJmF0aWxkZTtvIHJlY29uaGVjaWRvcyBwZWxvICAgICBzaXN0ZW1hLjwvcD4NCjxwPkF0ZW5jaW9zYW1lbnRlLDwvcD4NCjxwPkNyaXMgLSBJbm5lciBDbHViPC9wPg0KPHA+PGZvbnQ+PGJyIC8+DQo8L2ZvbnQ+PC9wPg0KPGhyIC8+DQo8cD48Zm9udD5Ob3NzYSBtYWlvciBhdHJhJmNjZWRpbDsmYXRpbGRlO28gJmVhY3V0ZTsgbyA8c3Ryb25nPlYmaWFjdXRlO2RlbyBDaGF0Ojwvc3Ryb25nPjwvZm9udD48L3A+DQo8cD4mbmJzcDs8L3A+DQo8ZGl2Pjxmb250PiZuYnNwOzwvZm9udD48L2Rpdj4NCjxkaXY+PGZvbnQ+LSBFc3BhJmNjZWRpbDtvIHBhcmEgMTAwIHBlc3NvYXMgbmEgc2FsYS48YnIgLz4NCi0gQXQmZWFjdXRlOyAxMiBjJmFjaXJjO21lcmFzIHNpbXVsdCZhY2lyYztuZWFzLjxiciAvPg0KLSAgVm9jJmVjaXJjOyBuJmF0aWxkZTtvIHByZWNpc2EgdGVyIHdlYmNhbSBwYXJhIGFjZXNzYXIgZSB2ZXIuPGJyIC8+DQotIERpc3BvbiZpYWN1dGU7dmVsIDI0IGhzIHBvciAgZGlhLjxiciAvPg0KLSBOJmF0aWxkZTtvICZlYWN1dGU7IG5lY2VzcyZhYWN1dGU7cmlvIGluc3RhbGFyIG5lbmh1bSBzb2Z0d2FyZSBwYXJhIGFjZXNzYXIsIHNvbWVudGUgICAgIHByZWNpc2EgdGVyIG8gcGx1Z2luIHNob2Nrd2F2ZSBmbGFzaCBhdHVhbGl6YWRvIG5vIG5hdmVnYWRvciwgcXVlICAgIG5vcm1hbG1lbnRlICZlYWN1dGU7ICBpbnN0YWxhZG8gYXV0b21hdGljYW1lbnRlLjwvZm9udD48L2Rpdj4NCjxkaXY+PGZvbnQ+Jm5ic3A7PC9mb250PjwvZGl2Pg0KPGRpdj48Zm9udD48YnIgLz4NClBvbnRvcyBGb3J0ZXM8L2ZvbnQ+PC9kaXY+DQo8ZGl2Pjxmb250PiZuYnNwOzwvZm9udD48L2Rpdj4NCjxkaXY+PGZvbnQ+TyBWaWRlbyBDaGF0ICZlYWN1dGU7IHVtYSBwYXJjZXJpYSBlbnRyZSB2JmFhY3V0ZTtyaW9zIHNpdGVzIGRlIHJlZ2kmb3RpbGRlO2VzICAgIGRpZmVyZW50ZXMgZW50JmF0aWxkZTtvICBhbyBhY2Vzc2FyIHZvYyZlY2lyYzsgZW5jb250cmEgcGVzc29hcyBkZSB0b2RhcyBhcyByZWdpJm90aWxkZTtlcyAgICBkbyBCcmFzaWwsIGZhY2lsaXRhbmRvIGEgIGFwcm94aW1hJmNjZWRpbDsmYXRpbGRlO28gZSBvIGNvbnRhdG8uIDwvZm9udD48L2Rpdj4NCjxkaXY+PGZvbnQ+Jm5ic3A7PC9mb250PjwvZGl2Pg0KPGRpdj48Zm9udD5NJmVhY3V0ZTtkaWEgZGUgdXN1JmFhY3V0ZTtyaW9zPC9mb250PjwvZGl2Pg0KPGRpdj48Zm9udD4mbmJzcDs8L2ZvbnQ+PC9kaXY+DQo8ZGl2Pjxmb250Pi0gTWFuaCZhdGlsZGU7IC0gMjAgYSAzNSBwZXNzb2FzIG5hIHNhbGE8YnIgLz4NCi0gVGFyZGUgLSAzMCBhIDQ1IHBlc3NvYXMgbmEgc2FsYTxiciAvPg0KLSAgTm9pdGUgLSA0NSBhIDcwIHBlc3NvYXMgbmEgc2FsYSAtIEFsZ3VucyBkaWFzIGNoZWdhIGEgcGljb3MgZGUgODggICAgcGVzc29hcyBvbiAgbGluZS48L2ZvbnQ+PC9kaXY+DQo8ZGl2Pjxmb250PiZuYnNwOzwvZm9udD48L2Rpdj4NCjxkaXY+DQo8ZGl2Pjxmb250Pjxmb250IHNpemU9IjIiIGZhY2U9IkFyaWFsIj5DbGFzc2lmaWNhZG9zIGNvbSBtYWlzIGRlIDIwMDAgICAgYW4mdWFjdXRlO25jaW9zLCB0b2RvcyBjb20gIGZvdG9zLCBzZW0gYW4mdWFjdXRlO25jaW9zIHJlcGV0aWRvcy48L2ZvbnQ+PC9mb250PjwvZGl2Pg0KPGRpdj48Zm9udD4mbmJzcDs8L2ZvbnQ+PC9kaXY+DQo8ZGl2Pg0KPGRpdj48Zm9udD48Zm9udCBzaXplPSIyIiBmYWNlPSJBcmlhbCI+PHN0cm9uZz5BbCZlYWN1dGU7bSBkaXNzbyBhaW5kYSB0ZW1vcyAgICB1bWEgZ2FsZXJpYSBkZSBmb3RvcyAgLCB2JmlhY3V0ZTtkZW9zIGVyJm9hY3V0ZTt0aWNvcywgZW5zYWlvcyBlc3BlY2lhaXMgZSAgZXRjLjwvc3Ryb25nPjwvZm9udD48L2ZvbnQ+PC9kaXY+DQo8L2Rpdj4NCjwvZGl2Pg0KPHA+Jm5ic3A7PC9wPg0KPHA+Jm5ic3A7PC9wPg==', '', 'PHA+Jm5ic3A7PC9wPg0KPHA+T2wmYWFjdXRlOyBbbm9tZV9jbGllbnRlXSAsPC9wPg0KPHA+U3VhIHJlbm92YSZjY2VkaWw7JmF0aWxkZTtvIGZvaSBlZmV0dWFkYSBwYXJhIFtkYXRhX3ZhbGlkYWRlXS48L3A+DQo8cD5BdGVuY2lvc2FtZW50ZSw8L3A+DQo8cD5DcmlzIC0gSW5uZXIgQ2x1YjwvcD4NCjxwPiZuYnNwOzwvcD4NCjxwPiZuYnNwOzwvcD4NCjxociAvPg0KPHA+PGZvbnQ+Tm9zc2EgbWFpb3IgYXRyYSZjY2VkaWw7JmF0aWxkZTtvICZlYWN1dGU7IG8gPHN0cm9uZz5WJmlhY3V0ZTtkZW8gQ2hhdDo8L3N0cm9uZz48L2ZvbnQ+PC9wPg0KPGRpdj48Zm9udD4mbmJzcDs8L2ZvbnQ+PC9kaXY+DQo8ZGl2Pjxmb250Pi0gRXNwYSZjY2VkaWw7byBwYXJhIDEwMCBwZXNzb2FzIG5hIHNhbGEuPGJyIC8+DQotIEF0JmVhY3V0ZTsgMTIgYyZhY2lyYzttZXJhcyBzaW11bHQmYWNpcmM7bmVhcy48YnIgLz4NCi0gIFZvYyZlY2lyYzsgbiZhdGlsZGU7byBwcmVjaXNhIHRlciB3ZWJjYW0gcGFyYSBhY2Vzc2FyIGUgdmVyLjxiciAvPg0KLSBEaXNwb24maWFjdXRlO3ZlbCAyNCBocyBwb3IgIGRpYS48YnIgLz4NCi0gTiZhdGlsZGU7byAmZWFjdXRlOyBuZWNlc3MmYWFjdXRlO3JpbyBpbnN0YWxhciBuZW5odW0gc29mdHdhcmUgcGFyYSBhY2Vzc2FyLCBzb21lbnRlICAgICAgcHJlY2lzYSB0ZXIgbyBwbHVnaW4gc2hvY2t3YXZlIGZsYXNoIGF0dWFsaXphZG8gbm8gbmF2ZWdhZG9yLCBxdWUgICAgIG5vcm1hbG1lbnRlICZlYWN1dGU7ICBpbnN0YWxhZG8gYXV0b21hdGljYW1lbnRlLjwvZm9udD48L2Rpdj4NCjxkaXY+PGZvbnQ+Jm5ic3A7PC9mb250PjwvZGl2Pg0KPGRpdj48Zm9udD48YnIgLz4NClBvbnRvcyBGb3J0ZXM8L2ZvbnQ+PC9kaXY+DQo8ZGl2Pjxmb250PiZuYnNwOzwvZm9udD48L2Rpdj4NCjxkaXY+PGZvbnQ+TyBWaWRlbyBDaGF0ICZlYWN1dGU7IHVtYSBwYXJjZXJpYSBlbnRyZSB2JmFhY3V0ZTtyaW9zIHNpdGVzIGRlIHJlZ2kmb3RpbGRlO2VzICAgICBkaWZlcmVudGVzIGVudCZhdGlsZGU7byAgYW8gYWNlc3NhciB2b2MmZWNpcmM7IGVuY29udHJhIHBlc3NvYXMgZGUgdG9kYXMgYXMgcmVnaSZvdGlsZGU7ZXMgICAgIGRvIEJyYXNpbCwgZmFjaWxpdGFuZG8gYSAgYXByb3hpbWEmY2NlZGlsOyZhdGlsZGU7byBlIG8gY29udGF0by4gPC9mb250PjwvZGl2Pg0KPGRpdj48Zm9udD4mbmJzcDs8L2ZvbnQ+PC9kaXY+DQo8ZGl2Pjxmb250Pk0mZWFjdXRlO2RpYSBkZSB1c3UmYWFjdXRlO3Jpb3M8L2ZvbnQ+PC9kaXY+DQo8ZGl2Pjxmb250PiZuYnNwOzwvZm9udD48L2Rpdj4NCjxkaXY+PGZvbnQ+LSBNYW5oJmF0aWxkZTsgLSAyMCBhIDM1IHBlc3NvYXMgbmEgc2FsYTxiciAvPg0KLSBUYXJkZSAtIDMwIGEgNDUgcGVzc29hcyBuYSBzYWxhPGJyIC8+DQotICBOb2l0ZSAtIDQ1IGEgNzAgcGVzc29hcyBuYSBzYWxhIC0gQWxndW5zIGRpYXMgY2hlZ2EgYSBwaWNvcyBkZSA4OCAgICAgcGVzc29hcyBvbiAgbGluZS48L2ZvbnQ+PC9kaXY+DQo8ZGl2Pjxmb250PiZuYnNwOzwvZm9udD48L2Rpdj4NCjxkaXY+DQo8ZGl2Pjxmb250Pjxmb250IHNpemU9IjIiIGZhY2U9IkFyaWFsIj5DbGFzc2lmaWNhZG9zIGNvbSBtYWlzIGRlIDIwMDAgICAgIGFuJnVhY3V0ZTtuY2lvcywgdG9kb3MgY29tICBmb3Rvcywgc2VtIGFuJnVhY3V0ZTtuY2lvcyByZXBldGlkb3MuPC9mb250PjwvZm9udD48L2Rpdj4NCjxkaXY+PGZvbnQ+Jm5ic3A7PC9mb250PjwvZGl2Pg0KPGRpdj4NCjxkaXY+PGZvbnQ+PGZvbnQgc2l6ZT0iMiIgZmFjZT0iQXJpYWwiPjxzdHJvbmc+QWwmZWFjdXRlO20gZGlzc28gYWluZGEgdGVtb3MgICAgIHVtYSBnYWxlcmlhIGRlIGZvdG9zICAsIHYmaWFjdXRlO2Rlb3MgZXImb2FjdXRlO3RpY29zLCBlbnNhaW9zIGVzcGVjaWFpcyBlIGV0Yy48L3N0cm9uZz48L2ZvbnQ+PC9mb250PjwvZGl2Pg0KPGRpdj48Zm9udD4mbmJzcDs8L2ZvbnQ+PC9kaXY+DQo8L2Rpdj4NCjwvZGl2Pg0KPHA+Jm5ic3A7PC9wPg0KPHA+Jm5ic3A7PC9wPg==');Carregando comentários...