jhvanee Posted July 4, 2015 Share Posted July 4, 2015 Hello,On CC Security Suite I can't list trusted IP addresses. When I push the submit button, the box remains empty. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted July 4, 2015 Share Posted July 4, 2015 I just installed it to see what it did for me. I was able to save my own IP address without issue. Quote Link to comment Share on other sites More sharing options...
fabriceunko Posted July 4, 2015 Share Posted July 4, 2015 Hello, I tested and I have told my ip address as part .. Quote Link to comment Share on other sites More sharing options...
ozzyizzy Posted July 9, 2015 Share Posted July 9, 2015 Trialing the cubecart security suite plugin and experiencing the same issue as the op. Plugin is not allowing me to put in ip address anywhere. I am also getting copious amounts of system error logs (about 6-10 every min). I have installed the standard version, but had to disable plugin to stop my error log overflowing. It is a great idea, but not curently working for me in standard version.Today, 14:08File: [ccss.class.php] Line: [24] "SELECT * FROM `cc_CubeCart_ccss_ip_addresses` ;" - Table 'knickXXX_cube3XXX.cc_CubeCart_ccss_ip_addresses' doesn't exist Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted July 9, 2015 Share Posted July 9, 2015 Have you checked to see if the CubeCart_ccss_ip_addresses table actually exists? If I'm reading your error message correctly, you have a prefix on your database. Maybe the plugin needs to be tweaked to handle that. Quote Link to comment Share on other sites More sharing options...
bsmither Posted July 9, 2015 Share Posted July 9, 2015 From looking at the code, the table will only get created if the module is enabled from the module's settings page. That is, if the settings are entered, but the module is not enabled on this page, then the table will not get created. If the module is later enabled via the checkbox at the "Manage Plugins" listing, the table is still not created.Please try:1. Viewing the CCSS module's settings page.2. Uncheck the module's 'Status' checkbox.3. Save.4. Return to the module's settings page (if not already remained on this page).5. Check the module's 'Status' checkbox.6. Save. Quote Link to comment Share on other sites More sharing options...
ozzyizzy Posted July 9, 2015 Share Posted July 9, 2015 Hi Dirty Butter and bsmithers, thanks for the quick response. @Dirty ButterHave you checked to see if the CubeCart_ccss_ip_addresses table actually exists? If I'm reading your error message correctly, you have a prefix on your database. Maybe the plugin needs to be tweaked to handle that.No, the table doesn't exist@bsmithersFrom looking at the code, the table will only get created if the module is enabled from the module's settings page. That is, if the settings are entered, but the module is not enabled on this page, then the table will not get created. If the module is later enabled via the checkbox at the "Manage Plugins" listing, the table is still not created.Please try:1. Viewing the CCSS module's settings page.2. Uncheck the module's 'Status' checkbox.3. Save.4. Return to the module's settings page (if not already remained on this page).5. Check the module's 'Status' checkbox.6. Save.Did as you suggested. Made no difference. In the minute it took me to do this I received 8 errors. The one mentioned below,Trialing the cubecart security suite plugin and experiencing the same issue as the op. Plugin is not allowing me to put in ip address anywhere. I am also getting copious amounts of system error logs (about 6-10 every min). I have installed the standard version, but had to disable plugin to stop my error log overflowing. It is a great idea, but not currently working for me in standard version. Today, 14:08File: [ccss.class.php] Line: [24] "SELECT * FROM `cc_CubeCart_ccss_ip_addresses` ;" - Table 'knickXXX_cube3XXX.cc_CubeCart_ccss_ip_addresses' doesn't exist but also this:File: [database.class.php] Line: [484] "ALTER TABLE `cc_cc_CubeCart_ccss_ip_addresses` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `ip_address` (`ip_address`), ADD KEY `trusted` (`trusted`) " - Multiple primary key definedand this:File: [database.class.php] Line: [484] "ALTER TABLE `cc_CubeCart_ccss_integrity` ADD PRIMARY KEY (`id`) " - Multiple primary key defined oh.. and this error too: (same as earlier one, but different line no).File: [ccss.class.php] Line: [40] "SELECT * FROM `cc_CubeCart_ccss_ip_addresses` ;" - Table 'knickXXX_cube3XXX.cc_CubeCart_ccss_ip_addresses' doesn't exist Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted July 10, 2015 Share Posted July 10, 2015 @ozzizzy Doesn't seem like it should matter, but did you attempt the install from the lightning bolt or download method? Quote Link to comment Share on other sites More sharing options...
ozzyizzy Posted July 11, 2015 Share Posted July 11, 2015 @Dirty Butter. I installed from the lightning rod initially. I deleted it since and thought I would try installing manually. Made no difference. Plugin currently disabled Quote Link to comment Share on other sites More sharing options...
jhvanee Posted July 11, 2015 Author Share Posted July 11, 2015 I experience the same problems as Ozzyizzy. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted July 11, 2015 Share Posted July 11, 2015 @jhvanee Do you also have a prefix on your CubeCart tables? Quote Link to comment Share on other sites More sharing options...
jhvanee Posted July 13, 2015 Author Share Posted July 13, 2015 @Dirty Butter What kind of prefix do you mean? I have no technical knowledge. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted July 13, 2015 Share Posted July 13, 2015 If you have access to your host's cpanel, goto phpMyAdmin and look at your cubecart tables. Do they look like CubeCart_nameoftable or is there something in front, like the cc_ on ozzydizzy's cc_CubeCart_ccss_integrity table error message in the thread here?I don't use a prefix - didn't even know such a thing could exist when I started using CubeCart. But if by chance you didn't create your original database, but someone else did it, they might have used a prefix. I am not saying that's what the problem is, just trying to narrow down why this plugin works for some and not for others. Quote Link to comment Share on other sites More sharing options...
ozzyizzy Posted July 13, 2015 Share Posted July 13, 2015 @Dirty Butter... I downloaded cubecart onto my cpanel through softaculous, and that put the prefix in automatically. I am sure others have done the same. I am not sure if that is the problem, but just putting it out there. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted July 14, 2015 Share Posted July 14, 2015 I had hoped someone would have suggested a way to fix this plugin by now, but nothing forthcoming. So I've posted a GitHub request linked to this thread. https://github.com/cubecart/v6/issues/685 Quote Link to comment Share on other sites More sharing options...
verhoejw Posted December 18, 2015 Share Posted December 18, 2015 so the cronjob is only working with a subscipton key, if im correct ? Bit pricy at minimum 25 dollar a month. Quote Link to comment Share on other sites More sharing options...
ozzyizzy Posted December 19, 2015 Share Posted December 19, 2015 I had another look at my problem, and I think I solved mine. This is what I did. 1. I enabled the module on the module page.2. Clicked on the tab that has now appeared on the left hand side of admin ( very last tab under "advanced", it was never there before, so something has changed) and looked under "trusted ip Addresses",.3. Tried to enter my own trusted ip address in there. No go... would not save.4. Went into my cpanel and phpmyAdmin.5. selected cubecart database6 Checked to see if the table CubeCart_ccss_ip_addresses existed ( it did not)7 . Created new table WITH the prefix that all my other tables had ( in my case cc)8. went back to cubecart admin and under security suite "trusted ip addresses" tab I was finally able to enter my trusted ip address and save as it was supposed to.Voila. all looks good, no more errors in admin log, and the module now appears to be working Hope this works for someone else too. Have a great day. Quote Link to comment Share on other sites More sharing options...
bsmither Posted December 19, 2015 Share Posted December 19, 2015 The problem seems to be a doubling of the table prefix.See: https://github.com/cubecart/v6/issues/685 Quote Link to comment Share on other sites More sharing options...
bsmither Posted December 19, 2015 Share Posted December 19, 2015 Please make this edit and try again -- for those who still have problems:In the module's file /admin/index.inc.php, find near line 8 the variable $create_table. That statement will be about 22 lines long. (Do not think to apply the following to line 6 -- ignore line 6.)Everywhere you see:".$GLOBALS['config']->get('config', 'dbprefix')."including the first and last quote marksDelete that.But not in line 6!Sending this string to parseSchema() automatically adds the table prefix if one exists. The table prefix must not be included in $create_table. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.