AAC Znote pagseguro problem

[Lurk]

I recently downloaded Znote and everything works fine but pagseguro.
Whenever I try to buy sites using that I'm redirected to Checkout - PagSeguro UOL (https://pagseguro.uol.com.br/checkout/error.jhtml#rmcl)
the error message translates to: invalid transaction. always start transaction from trusted sites.

@Znote can you help me?

 

[Discovery]

Enjoy reading the documentation:
❤

https://dev.pagseguro.uol.com.br/reference#checkout-pagseguro-criacao-checkout-pagseguro

 

[Lurk]

from what I'm seeing, pagseguro_ipn.php has some sql code

znote_pagseguro

but the znote schema I downloaded doesn't have it

Dunno if that's the problem but still. I got the db on http://127.0.0.1/special/ as he says I should
---
nvm just found the sql code in the files

CREATE TABLE IF NOT EXISTS `znote_pagseguro` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,
                  `transaction` varchar(36) NOT NULL,
                  `account` int(11) NOT NULL,
                  `price` decimal(11,2) NOT NULL,
                  `points` int(11) NOT NULL,
                  `payment_status` tinyint(1) NOT NULL,
                  `completed` tinyint(4) NOT NULL,
                  PRIMARY KEY (`id`),
                  FOREIGN KEY (account) REFERENCES accounts(id)
                ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

                CREATE TABLE IF NOT EXISTS `znote_pagseguro_notifications` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,
                  `notification_code` varchar(40) NOT NULL,
                  `details` text NOT NULL,
                  `receive_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                  PRIMARY KEY (`id`)
                ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

I'm still getting the same error tho

 

[Discovery]

Idk if that will help you, but reading the ipn.php about pagseguro.

I assume the table structure is something like that:

CREATE TABLE `znote_pagseguro` (
  `payment_id` int(11) NOT NULL,
  `transaction` varchar(200) NOT NULL,
  `completed` int(11) NOT NULL,
  `payment_status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `znote_pagseguro`
  ADD PRIMARY KEY (`payment_id`);
 
ALTER TABLE `znote_pagseguro`
  MODIFY `payment_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

 

[Lurk]

yeah just found and fixed it I'm still getting the same error... I remember reading in a brazilian forum that using a free ip (like from no-ip) would result in this but I'm using a domain that I bought so I really don't get it

 

[Discovery]

Put that online and use a source (your website) with SSL. Some Api's just receive requests by SSL and with register IP per query. (like google sometimes)

 

[Lurk]

I managed to make it work following this video

thank you for your help !