Advertisement:

Author Topic: Plugin Paymant Master - Error importing SQL  (Read 1141 times)

D4rKn3ssKn1gh7

  • Newbie
  • *
  • Posts: 4
Plugin Paymant Master - Error importing SQL
« on: February 01, 2014, 12:06:54 am »
Hello,
I'm having problem importing the SQL plugin structure as follows: https://github.com/osclass/plugin-payment
The following error appears.
Code: [Select]
Erro

Comando SQL:



CREATE TABLE /*TABLE_PREFIX*/t_payments_wallet (
    fk_i_user_id INT UNSIGNED NOT NULL,
    i_amount BIGINT(20) NULL,

        PRIMARY KEY (fk_i_user_id),
        FOREIGN KEY (fk_i_user_id) REFERENCES /*TABLE_PREFIX*/t_user (pk_i_id)
) ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';

Mensagens do MySQL : Documentação
#1005 - Can't create table 'sadrachs_oscl805.t_payments_wallet' (errno: 150) (Informações…)

Use the version Osclass 3.3.2

Regards.

teseo

  • Hero Member
  • *****
  • Posts: 6169
Re: Plugin Paymant Master - Error importing SQL
« Reply #1 on: February 01, 2014, 12:16:57 am »
Hi,

This seems weird to me:

table 'sadrachs_oscl805.t_payments_wallet'

That dot, open config.php and tell me what's the line below /** Database Table prefix */

And open phpMyAdmin and look what's the prefix shared by all the tables there.

Regards

D4rKn3ssKn1gh7

  • Newbie
  • *
  • Posts: 4
Re: Plugin Paymant Master - Error importing SQL
« Reply #2 on: February 01, 2014, 12:31:20 am »
Hi teseco,
thanks for the quick reply.

Code: [Select]
/ ** Database Table prefix * /
define ('DB_TABLE_PREFIX', 'os_');
It's all right.

In PHPMyAdmin is also correct
http://prntscr.com/2ocafm

teseo

  • Hero Member
  • *****
  • Posts: 6169
Re: Plugin Paymant Master - Error importing SQL
« Reply #3 on: February 01, 2014, 12:54:52 am »
Well, how what should be "os_" ends appearing as "sadrachs_oscl805." is a mistery to me... :D Rings a bell to you? ???

Anyway, you can try this: uninstall the plugin, do a copy of struct.sql and replace in the original all the "/*TABLE_PREFIX*/" with "os_", then try to install again.

Regards

D4rKn3ssKn1gh7

  • Newbie
  • *
  • Posts: 4
Re: Plugin Paymant Master - Error importing SQL
« Reply #4 on: February 01, 2014, 01:31:49 am »
I changed the name and says there.
Now he does not leave the table to delete ...
That's why I just wanted to use the payment method that would only Bitcoin ...

I'll end it starting from 0.