(DP43) Groups View Limits

[Gauravk]

On 4/24/2020 at 3:27 PM, DawPi said:

No need to do that. Will be checked once I'll start doing it.

It's been 7 days I reported a bug in this plugin.

Any clue, how long it will take more to fix it?

[DawPi]

I don't have any ETA right now. You're the one with this issue and I need more time to take a look on it (TIER III). I need also your access details - ACP, FTP. Send me PM with them.

[Gauravk]

Hi @DawPi just updated to 2.0.2 and I cannot log back as admin anymore.

URL changes from this

https://carnity.com/admin/?app=core&module=system&controller=login&ref=

to this

https://carnity.com/admin/?app=core&module=system&controller=login&error=Table 'carnity_carnipb.dp4groupsviewlimits_members' doesn't exist&ref=

 

Appreciate your prompt help, please.

[DawPi]

Weird. You're missing one table in SQL. Do you have access to PhpMyAdmin?

If yes, then run that query:

CREATE TABLE IF NOT EXISTS `<PREFIX>dp4groupsviewlimits_members` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `memberid` bigint(10) NOT NULL,
  `dp43gvl_limit_views_cookie` varchar(90) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `memberid` (`memberid`)
);

Don't forget to replace <PREFIX> by your prefix database.

[Gauravk]

Thanks @DawPi, Yes I do have PHPMyAdmin access.

May I know how to find the prefix?

Is that the DB name?

Just FYI, I have dp4 one table showing 0 rows. Is that normal or something went wrong while updating?

[DawPi]

5 minutes ago, Gauravk said:

May I know how to find the prefix?

Open conf_global.php file (it's on your FTP in the same place as index.php) and look for sql_tbl_prefix. What is your prefix there?

[Gauravk]

Thanks @DawPi

This is what I have in conf_global.php

I still cant understand how to edit the above query to run

[Gauravk]

Please advise which one is correct to run

CREATE TABLE IF NOT EXISTS `<''>dp4groupsviewlimits_members` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `memberid` bigint(10) NOT NULL,
  `dp43gvl_limit_views_cookie` varchar(90) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `memberid` (`memberid`)
);

 

OR

 

CREATE TABLE IF NOT EXISTS `<>dp4groupsviewlimits_members` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `memberid` bigint(10) NOT NULL,
  `dp43gvl_limit_views_cookie` varchar(90) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `memberid` (`memberid`)
);

 

OR

 

CREATE TABLE IF NOT EXISTS `dp4groupsviewlimits_members` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `memberid` bigint(10) NOT NULL,
  `dp43gvl_limit_views_cookie` varchar(90) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `memberid` (`memberid`)
);

[DawPi]

9 hours ago, Gauravk said:

CREATE TABLE IF NOT EXISTS `dp4groupsviewlimits_members` ( `id` bigint(10) NOT NULL AUTO_INCREMENT, `memberid` bigint(10) NOT NULL, `dp43gvl_limit_views_cookie` varchar(90) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `memberid` (`memberid`) );

That of course. 😉

[DawPi]

Thank you for being a client!  The Invision Community Marketplace is closing October 30 2023, so I am moving all of my files over to my personal site https://forum.invisionize.pl. 

• You can redeem the marketplace purchase keys provided by IPS in order to keep getting updates and support for the applications/plugins you purchased.
• You can purchase files directly on my marketplace.
• You can get support for your purchased applications/plugins directly on their new support topics.
• You can request a custom application/plugin or service.

 

Bookmark https://forum.invisionize.pl and the new Marketplace Directory www.Invisioneer.org.