Osclass Support Forums

Osclass plugin support => Favorite Items Plugin => Topic started by: alexborg on February 26, 2017, 02:24:35 PM

Title: Problem with installing Favorite items
Post by: alexborg on February 26, 2017, 02:24:35 PM

When installing throws an error:

"Plugin couldn't be installed because of: Error importSQL::ModelFI
favorite_items/model/struct.sql
/var/www/vhosts/mysite.com/httpdocs/oc-content/plugins/favorite_items/model/struct.sql

Please check your database for table t_favorite.
If any of those tables exist in your database, delete them!


The base does not have this "table t_favorite" I would erase it and do the installation.
What's the problem and how to install Favorite items?  Tnx

Title: Re: Problem with installing Favorite items
Post by: BabyDunk on February 26, 2017, 03:15:26 PM

are you looking for t_favorite with the osclass prefix? like this oc_t_favorite?

it can have a different prefix if it was changed at osclass installation.

Title: Re: Problem with installing Favorite items
Post by: alexborg on February 26, 2017, 03:35:38 PM

There is no entry in the   mysql   oc_t_favorite ...

Title: Re: Problem with installing Favorite items
Post by: MB Themes on February 26, 2017, 09:54:49 PM

@alexborg
In file:
oc-content/plugins/favorite_items/model/struct.sql

Try to remove:

Code: [Select]

  FOREIGN KEY (list_id) REFERENCES /*TABLE_PREFIX*/t_favorite_list (list_id) ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (item_id) REFERENCES /*TABLE_PREFIX*/t_item (pk_i_id) ON DELETE CASCADE ON UPDATE CASCADE

and make sure you have 2 lines here with:
DROP TABLE

Title: Re: Problem with installing Favorite items
Post by: alexborg on February 26, 2017, 11:11:07 PM

I deleted the two lines of the file struct.sql and again was happening. The same problem.

Report an error, a base of the insert the following: oc_t_favorite_list

Title: Re: Problem with installing Favorite items
Post by: MB Themes on February 27, 2017, 08:44:38 AM

@alexborg
Drop those tables from your database manually.

Title: Re: Problem with installing Favorite items
Post by: alexborg on February 27, 2017, 01:16:57 PM

Yes, delete it all again the same problem.

Title: Re: Problem with installing Favorite items
Post by: MB Themes on February 27, 2017, 01:21:42 PM

@alexborg
Did you try it on fresh osclass installation as well?
What version of DB do you use?
Can you PM login to your ftp and oc-admin?

Title: Re: Problem with installing Favorite items
Post by: alexborg on March 08, 2017, 10:23:03 AM

Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.5.52-cll-lve - MySQL Community Server (GPL) by Atomicorp

PHP extension: mysqli
PHP version: 5.6.27

Title: Re: Problem with installing Favorite items
Post by: club4dog on December 04, 2017, 08:50:45 PM

Hi I have the same problem, I have tried everything, but it does not work. I have 2 osclasses a test on a server and one on the main site. on the test site it works, but on the main site it does not work. the only difference is that on the main website I previously configured another favorite plugin, but I deleted it.

Title: Re: Problem with installing Favorite items
Post by: MB Themes on December 04, 2017, 08:56:42 PM

@club4dog
Remove those foreign keys, remove plugin tables on database and install it.

Title: Re: Problem with installing Favorite items
Post by: club4dog on December 04, 2017, 10:09:06 PM

I tried again I did everything, but it keeps giving me error, can I write in private my oc-admin and ftp accesses?

the problem persists, please help me

Title: Re: Problem with installing Favorite items
Post by: club4dog on December 07, 2017, 10:54:02 PM

Quote from: club4dog on December 04, 2017, 10:09:06 PM

I tried again I did everything, but it keeps giving me error, can I write in private my oc-admin and ftp accesses?

the problem persists, please help me

Quote from: alexborg on February 26, 2017, 03:35:38 PM

There is no entry in the   mysql   oc_t_favorite ...

Title: Re: Problem with installing Favorite items
Post by: MB Themes on December 08, 2017, 11:33:25 AM

@club4dog
What version of plugin you have?

Title: Re: Problem with installing Favorite items
Post by: club4dog on December 09, 2017, 08:28:11 PM

Version:1.0.4 | By MB Themes | Plugins Site

Title: Re: Problem with installing Favorite items
Post by: MB Themes on December 10, 2017, 12:49:04 PM

@club4dog
Try latest one.

Title: Re: Problem with installing Favorite items
Post by: club4dog on December 12, 2017, 02:37:24 AM

I followed step by step and I solved, Thanks

Title: Re: Problem with installing Favorite items
Post by: MB Themes on December 12, 2017, 09:31:43 AM

Cool, welcome ;)