Jump to content
marinelc

Paypal Module error - ps_paypal_order doesn't exist

Recommended Posts

Hello, everyone,

(I don't know if this is the good section so, I apologize if is not)

I've just installed the PayPal payments module, connected the account, made a purchase - everything good till here.

The problem is, when I'm trying to see the order details in the backend I get this error:

Table 'ps_paypal_order' doesn't exist

I assume the module should create some tables in the database but looks like that's not the case here. Can someone give me the dumps or data structure(so I can create them myself) for the module's tables ? (Or a solution/idea, if any)

 

Thank you

Share this post


Link to post
Share on other sites
On 9/26/2019 at 1:14 PM, marinelc said:

Hello, everyone,

(I don't know if this is the good section so, I apologize if is not)

I've just installed the PayPal payments module, connected the account, made a purchase - everything good till here.

The problem is, when I'm trying to see the order details in the backend I get this error:

Table 'ps_paypal_order' doesn't exist

I assume the module should create some tables in the database but looks like that's not the case here. Can someone give me the dumps or data structure(so I can create them myself) for the module's tables ? (Or a solution/idea, if any)

 

Thank you

Hello, i have the same problem, did you find a solution?

Share this post


Link to post
Share on other sites

Hello you need to follow these steps and View the result of Query.
If result show This "SQL query has no result." means module was not installed perfect you need to reinstall

Screenshot.png

Screenshot(1).png

Share this post


Link to post
Share on other sites

 

On 10/4/2019 at 1:35 PM, Razi said:

Hello you need to follow these steps and View the result of Query.
If result show This "SQL query has no result." means module was not installed perfect you need to reinstall

Screenshot.png

Screenshot(1).png

Thanks for feedback, mate, but I've already tried this.

Also, you don't have to use the sql manager to see the tables, you can just create a SSH tunnel(is running on google cloud, i'm using presta certified by bitnami) and connect straight to phpmyadmin to see everything.

gYlLN0Y.png

Edited by marinelc (see edit history)

Share this post


Link to post
Share on other sites
On 10/4/2019 at 8:18 AM, banton said:

Hello, i have the same problem, did you find a solution?

Sorry, mate, not yet. I was thinking to read the module's files and try to reverse the tables and create them myself. I'll wait a few more days to see if I find another solution.

Share this post


Link to post
Share on other sites

Hello,

I have exactly the same problem. Does anybody found out the solution yet?

 

In debug mode during installation it reports that it failed to write to database with this command.

CREATE TABLE IF NOT EXISTS `ps_paypal_capture` (`id_paypal_capture` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `id_capture` VARCHAR(255) NOT NULL, `id_paypal_order` INT(10) SIGNED NOT NULL, `capture_amount` DECIMAL(10,2) NOT NULL, `result` VARCHAR(255) NOT NULL, `date_add` DATETIME NOT NULL, `date_upd` DATETIME NOT NULL, PRIMARY KEY (`id_paypal_capture`)) ENGINE=InnoDB CHARSET=utf8 COLLATE=DEFAULT;
 

Edited by Tomas Z (see edit history)

Share this post


Link to post
Share on other sites

SOLUTION !!

you have to edit DbTable.php in the installation zip file before installing. You can download installation file from prestashop addons website. See picture for full filepath and what to remove. The problem was with the part "COLLATE=DEFAULT" mentioned in previous post, which was not recognized by my database version MySQL 8.0. I have some information that the best databases to use with prestashop are 5.6 or 10.1. 

 

After removing part shown in the picture, the module installs correctly and the tables in database are also correctly created.

 

 

dbtable.jpg

Edited by Tomas Z (see edit history)

Share this post


Link to post
Share on other sites

Hello,
I've made an upgrade of Prestashop (1.6.1.8 to 1.7.6.2.) and when I've downloaded the module Paypal, it's no more possible to see the orders and to download invoices in the back-office or to make an order if the Paypal module is installed.
Can you help me ?

Additional information
PrestaShop version: 1.7.6.2
PHP version: 7.2

 

PS the solution above doesn't work

 

 

order.jpg

71443976-7d186e80-270e-11ea-8581-15528eeeb259.png

71443954-565a3800-270e-11ea-8117-44f8973f3cfe.png

Edited by shana0780 (see edit history)

Share this post


Link to post
Share on other sites
On 11/20/2019 at 9:21 AM, Tomas Z said:

SOLUTION !!

you have to edit DbTable.php in the installation zip file before installing. You can download installation file from prestashop addons website. See picture for full filepath and what to remove. The problem was with the part "COLLATE=DEFAULT" mentioned in previous post, which was not recognized by my database version MySQL 8.0. I have some information that the best databases to use with prestashop are 5.6 or 10.1. 

 

After removing part shown in the picture, the module installs correctly and the tables in database are also correctly created.

 

 

dbtable.jpg

Thanks Thomas, worked perfect vor me upgrade from 1.6 to 1.7  maybe good to say that you first have to delete all existing ps_paypal_..  ( see image) tables from your excisting database and make the changes inside the zip file!

Capture.JPG

Share this post


Link to post
Share on other sites

I literally mentioned that zip part in the first sentence. But you are right with the ps_paypal tables deleting, it worked for me without deleting it but its better to be on the safer side. 

  • Like 1

Share this post


Link to post
Share on other sites

Hola badi3, yo ya tenía un modulo de paypal con la version de prestashop 1.6 ahora con la versión 1.7 he comprado otro módulo, pero me sale el error al final del proceso que habéis comentado. He modificado el zip pero sigue apareciendo.

Me falta eliminar las tablas ps_paypal_... que tengo, pero tengo miedo que al eliminarlar, los clientes que pagaron por paypal anteriormente les desaparezca de la factura. o que tenga algun problema. Es seguro eliminar estas tablas?

Share this post


Link to post
Share on other sites

I've had the same problem with my prestashop 1.7.6.4 + mysql 8.0.18-9 + PHP: 7.2.28

I've created manually the table taking the structures from another prestashop 1.7.x installation.
I've created this table:

  • ps_paypal_order
  • ps_paypal_capture
  • ps_paypal_ipn
  • ps_paypal_processlogger
  • ps_paypal_vaulting

Did I forget any db tables?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More