SQL error when manually adding an IP address
When manually adding a recordset to tx_cyberpeace_iplist via the backend ('Create new CyberPeace IPs on page "CyberPeace"') an SQL error occurs.
The message reads as follows:
2: SQL error: 'Unknown column 'cruser_id' in 'field list'' (tx_cyberpeace_iplist:NEW5856e97d0ce79)
#1 Updated by Gisèle Wendl almost 3 years ago
- File cyberpeace100.fix.cruser_id.zip added
Hello Hanno, thanks for this first bug report.
1) Unhappily there's not yet a backend module for CyberPeace.
It should follow, because current solution to display the data in backend tables is not really clean:
Normally all CyberPeace-data should be displayed in a backend module, because CyberPeace-data (log and iplist) are not intended to be added or deleted in backend tables.
For the first version of the extension I decided to display the data in the backend in TYPO3-tables, but I did not manage to find out how to avoid that records may be added or deleted in the backend tables.
Any hints are welcome, diving into the manuals or google did not bring up a solution to me yet :-)
2) However, the error you report is a "true error" - in $TCA the cruser_id is referenced, this triggers the error... I added a zip containing 2 new files, you can replace the present files with them, then uninstall/reinstall the extension in extension manager.
3) Ok, with this you could add now records to IPList, but please be aware of the following:
- Only records with blockforever=1 will remain in the table forever
- Maintaining an own local blacklist, best practise is to install ext:toctoc_comments and use the "Local IP blocking list for toctoc_comments". Here you can also specify IP-subnetworks like 220.127.116.11/24.
Also - in toctoc_comments backendmodule - you can refresh data from spamhaus.org, this goes then in another table which is called "Static IP blocking list for toctoc_comments" (normally located on the Websiteroot)
For CyberPeace 1.0.0 it took around 45 days time to come up to this version.
It was "rapid application development", because I wanted a solution to be present as fast as possible.
With this it is clear that in the next development cycles some parts will be added and improved, for example:
- Move of toctoc_comments local IP-Lists into CyberPeace
- For the crawler blocking: configuration versus robots.txt
- IP-ranges for .htaccess
- The apache error-log is also kind of interesting, isn't? ;-)
Well there are plenty of ideas ... and plenty of developers are needed, if we want to have this fast :-)