Jump to content

(DP43) Groups View Limits


Recommended Posts

  • 2 years later...

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.

Link to comment

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`)
);
Link to comment
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. 😉

Link to comment
  • 7 months later...

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

 

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

Link to comment
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...