SOLVED - installation error - Error importSQL::ModelPayment payment/struct.sql

[DrLightman]

I get this flash when installing the plugin:

Error importSQL::ModelPayment
payment/struct.sql

Using latest osclass 3.3.2 with "italia" theme

[DrLightman]

it seems tables were created first time, so the next times it fails and gives that error. but I don't understand why if tables were created, plugin is not active.

[DrLightman]

ok maybe i understand what happened.

i think it crashed during the installation because it made a select all from items table, but since I come from an old site which held 115k ads and i imported them all at once into osclass, the plugin made a select all of all those ads and only managed to create 65k entries in the payments_publish table. so it either crashed for memory consumption or execution time out, i got to check that.

maybe the install procedure should be optimized to take into consideration the case of sites holding a lot of classifieds.

[DrLightman]

Ok I fixed by disabling the code that performs the oc_t_payment_publish population, installed the plugin and making the population myself executing this single query from mysql command line on ssh ( maybe it should be adopted into the plugin itself? it looks even more optimized, never used myself also this kind of mass insert before )

insert into oc_t_payments_publish (fk_i_item_id,dt_date,b_paid,s_keyword,fk_i_payment_id)
select pk_i_id, now(), 1, null, null from oc_t_item order by pk_i_id asc;

[gede]

Hello!
I have this problem to, what I need to do to solve this error???
Thanks!

[gede]

Solved! Delete all tables for payments and install the plugin again.

[thunderbird]

can anyone provideo step by step instruction on how to do it

[sujithsidhardhan]

Me too facing the same error.

I go this error at first - Plugin couldn't be installed because it triggered a fatal error

I tried to install it again and got the error - Plugin couldn't be installed because of: Error importSQL::ModelPaymentPro
/var/www/trinisale.com/public_html/oc-content/plugins/payment_pro/struct.sql

I searched for the forums and deleted the tables of the plugin and tried a fresh install. But nothing helps. Any one got any work around?

[Dublay]

Same problem here. Just bought that plugin but no way to get it installed.

"Plugin couldn't be installed because of: Error importSQL::ModelPaymentPro"

[new_phpd]

mdeah.....today, 2018 may

same problems, not fixed yet, no answer to my tickets from support team

[abc500x500]

Hi.
I had this problem and after downgrading php version problem solved.
maybe some codes can not good properly with higher versions php.

for example you must downgrade: 7.2--> 5.6
or 5.6 --> 5.2

[Aficionado]

Hi.
I had this problem and after downgrading php version problem solved.
maybe some codes can not good properly with higher versions php.

for example you must downgrade: 7.2--> 5.6
or 5.6 --> 5.2

Please do not give such bad advice.

Osclass works great with 7.0.x and 5.6.x

PHP 5.2 is dead and burried.

[abc500x500]

Hi.
I had this problem and after downgrading php version problem solved.
maybe some codes can not good properly with higher versions php.

for example you must downgrade: 7.2--> 5.6
or 5.6 --> 5.2

Please do not give such bad advice.

Osclass works great with 7.0.x and 5.6.x

PHP 5.2 is dead and burried.

some plugins has problem with some version of php.
I had this topic error and see several topics and act all advice but problem not solved.
after downgrading php 7.2 to php 5.6 problem solved.