Advertisement:

Author Topic: SOLVED - installation error - Error importSQL::ModelPayment payment/struct.sql  (Read 4985 times)

DrLightman

  • Newbie
  • *
  • Posts: 36
I get this flash when installing the plugin:

Error importSQL::ModelPayment
payment/struct.sql

Using latest osclass 3.3.2 with "italia" theme
« Last Edit: May 16, 2014, 07:48:07 pm by DrLightman »

DrLightman

  • Newbie
  • *
  • Posts: 36
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

  • Newbie
  • *
  • Posts: 36
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

  • Newbie
  • *
  • Posts: 36
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;


gede

  • Newbie
  • *
  • Posts: 12
Hello!
I have this problem to, what I need to do to solve this error???
Thanks!


gede

  • Newbie
  • *
  • Posts: 12
Solved! Delete all tables for payments and install the plugin again.

thunderbird

  • Newbie
  • *
  • Posts: 15
can anyone provideo step by step instruction on how to do it

sujithsidhardhan

  • Newbie
  • *
  • Posts: 2
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

  • Newbie
  • *
  • Posts: 33
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

  • Newbie
  • *
  • Posts: 9
mdeah.....today, 2018 may

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

abc500x500

  • Jr. Member
  • **
  • Posts: 96
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

  • Guest
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.
« Last Edit: June 20, 2018, 03:52:04 pm by Aficionado »

abc500x500

  • Jr. Member
  • **
  • Posts: 96
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.
« Last Edit: June 20, 2018, 05:29:18 pm by abc500x500 »