Gauravk Posted April 29, 2020 Share Posted April 29, 2020 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? Link to comment
DawPi Posted April 29, 2020 Author Share Posted April 29, 2020 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. Link to comment
Gauravk Posted January 31, 2023 Share Posted January 31, 2023 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. Link to comment
DawPi Posted January 31, 2023 Author Share Posted January 31, 2023 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
Gauravk Posted January 31, 2023 Share Posted January 31, 2023 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? Link to comment
DawPi Posted January 31, 2023 Author Share Posted January 31, 2023 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? Link to comment
Gauravk Posted January 31, 2023 Share Posted January 31, 2023 Thanks @DawPi This is what I have in conf_global.php I still cant understand how to edit the above query to run Link to comment
Gauravk Posted January 31, 2023 Share Posted January 31, 2023 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
DawPi Posted February 1, 2023 Author Share Posted February 1, 2023 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
DawPi Posted September 15, 2023 Author Share Posted September 15, 2023 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. Link to comment
Recommended Posts