Osclass forums

Support forums => Plugins => Plugin Payments => Topic started by: DrLightman on May 16, 2014, 07:14:59 pm

Title: SOLVED - installation error - Error importSQL::ModelPayment payment/struct.sql
Post by: DrLightman on May 16, 2014, 07:14:59 pm
I get this flash when installing the plugin:

Error importSQL::ModelPayment
payment/struct.sql

Using latest osclass 3.3.2 with "italia" theme
Title: Re: installation error - Error importSQL::ModelPayment payment/struct.sql
Post by: DrLightman on May 16, 2014, 07:22:17 pm
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.
Title: Re: installation error - Error importSQL::ModelPayment payment/struct.sql
Post by: DrLightman on May 16, 2014, 07:30:03 pm
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.
Title: Re: installation error - Error importSQL::ModelPayment payment/struct.sql
Post by: DrLightman on May 16, 2014, 07:45:40 pm
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 :) )

Quote
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;

Title: Re: SOLVED - installation error - Error importSQL::ModelPayment payment/struct.sql
Post by: gede on July 02, 2014, 03:22:50 am
Hello!
I have this problem to, what I need to do to solve this error???
Thanks!

Title: Re: SOLVED - installation error - Error importSQL::ModelPayment payment/struct.sql
Post by: gede on July 02, 2014, 03:30:01 am
Solved! Delete all tables for payments and install the plugin again.
Title: Re: SOLVED - installation error - Error importSQL::ModelPayment payment/struct.sql
Post by: thunderbird on August 12, 2014, 10:29:21 pm
can anyone provideo step by step instruction on how to do it
Title: Re: SOLVED - installation error - Error importSQL::ModelPayment payment/struct.sql
Post by: sujithsidhardhan on September 12, 2015, 10:24:51 am
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?
Title: Re: SOLVED - installation error - Error importSQL::ModelPayment payment/struct.sql
Post by: Dublay on June 14, 2016, 12:26:37 pm
Same problem here. Just bought that plugin but no way to get it installed.

"Plugin couldn't be installed because of: Error importSQL::ModelPaymentPro"
Title: Re: SOLVED - installation error - Error importSQL::ModelPayment payment/struct.sql
Post by: new_phpd on April 11, 2018, 03:01:44 am
mdeah.....today, 2018 may

same problems, not fixed yet, no answer to my tickets from support team
Title: Re: SOLVED - installation error - Error importSQL::ModelPayment payment/struct.sql
Post by: abc500x500 on June 20, 2018, 02:42:55 pm
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
Title: Re: SOLVED - installation error - Error importSQL::ModelPayment payment/struct.sql
Post by: Aficionado on June 20, 2018, 03:13:54 pm
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.
Title: Re: SOLVED - installation error - Error importSQL::ModelPayment payment/struct.sql
Post by: abc500x500 on June 20, 2018, 05:27:11 pm
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.