Osclass Error import SQL
Date: 10/07/2017

Sometimes when you installing new Osclass plugins there is an error - Error import SQL struct.sql.

And the plugin is not installed. 

This can easily be fixed:

1) The first reason is that the database already has tables with the same name. 

For example, you have an old Payments plugin installed. 

And when you try to install a new one( Ultimate Payments or any other payment plugin), get error Error import SQL.

You must unistall the old  Payments plugin and try again install new one.

2) The second reason MySQL Engine. 

Ultimate Payments plugin ( for example) use by default InnoDB Engine.

And if you have an old MyISAM Engine - you will get an Error import SQL.

You need to open a file struct.sql in plugin folder and search tables from this file in your MySQL Database.

For Example in Ultimate Payments this is :

oc_t_upayments_log, oc_t_upayments_wallet, oc_t_upayments_premium, oc_t_upayments_prices, oc_t_upayments_publish, oc_ t_upayments_is_publish_payment_needed,  oc_t_upayments_cron_email_filter,  oc_t_upayments_policy,  oc_t_upayments_skrill, oc_t_upayments_bitcoin, oc_ t_upayments_colorized.

If there are any of these tables, delete them. 

Then open the file struct.sql and replace all ENGINE=InnoDB to ENGINE=MyISAM.

Install the plugin.

Other plugins may have different tables, but the order of the action is the same.

 

Comments: 0  |  Please login or register to comment

Add a comment

Please login or register to comment