Topic: 2 questions about registration
Hello !
1/ I do not want to display Registration and Connection links in the upper menu bar, since they are already displayed on the line below. How can I achieve this ?
2/ I receive too many bot registrations and I removed possibility to register, replacing it with a contact form from which I will create accounts for real persons.
I cannot install either anti spam extensions, meeting this issue :
For Fancy Stopspam v. 1.3.52.2 I get this issue :
Le serveur BDD a répondu: duplicate column name: fancy_stop_spam_bot (Errno: 1).
Impossible d'exécuter la requête : CREATE TABLE dbtusers ( fancy_stop_spam_bot INTEGER NOT NULL DEFAULT 0, ip_geolocation VARCHAR(40) DEFAULT '', pan_chat_data TEXT DEFAULT '', pun_bbcode_use_buttons INTEGER NOT NULL DEFAULT 1, pun_bbcode_enabled INTEGER NOT NULL DEFAULT 1, id INTEGER NOT NULL, group_id INTEGER NOT NULL DEFAULT 3, username VARCHAR(200) NOT NULL DEFAULT '', password VARCHAR(40) NOT NULL DEFAULT '', salt VARCHAR(12), email VARCHAR(80) NOT NULL DEFAULT '', title VARCHAR(50), realname VARCHAR(40), url VARCHAR(100), facebook VARCHAR(100), twitter VARCHAR(100), linkedin VARCHAR(100), skype VARCHAR(100), jabber VARCHAR(80), icq VARCHAR(12), msn VARCHAR(80), aim VARCHAR(30), yahoo VARCHAR(30), location VARCHAR(30), signature TEXT, disp_topics INTEGER, disp_posts INTEGER, email_setting INTEGER NOT NULL DEFAULT 1, notify_with_post INTEGER NOT NULL DEFAULT 0, auto_notify INTEGER NOT NULL DEFAULT 0, show_smilies INTEGER NOT NULL DEFAULT 1, show_img INTEGER NOT NULL DEFAULT 1, show_img_sig INTEGER NOT NULL DEFAULT 1, show_avatars INTEGER NOT NULL DEFAULT 1, show_sig INTEGER NOT NULL DEFAULT 1, access_keys INTEGER NOT NULL DEFAULT 0, timezone FLOAT NOT NULL DEFAULT 0, dst INTEGER NOT NULL DEFAULT 0, time_format INTEGER NOT NULL DEFAULT 0, date_format INTEGER NOT NULL DEFAULT 0, language VARCHAR(25) NOT NULL DEFAULT 'English', style VARCHAR(25) NOT NULL DEFAULT 'Oxygen', num_posts INTEGER NOT NULL DEFAULT 0, last_post INTEGER, last_search INTEGER, last_email_sent INTEGER, registered INTEGER NOT NULL DEFAULT 0, registration_ip VARCHAR(39) NOT NULL DEFAULT '0.0.0.0', last_visit INTEGER NOT NULL DEFAULT 0, admin_note VARCHAR(30), activate_string VARCHAR(80), activate_key VARCHAR(8), avatar INTEGER NOT NULL DEFAULT 0, avatar_width INTEGER NOT NULL DEFAULT 0, avatar_height INTEGER NOT NULL DEFAULT 0, fancy_stop_spam_bot INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (id) );
Une erreur est apparue à la ligne 552 dans le fichier /var/www/legtux.org/users/revest/www/include/dblayer/sqlite3.php
For Pan Antispam v.0.3.4, I get this issue :
Le serveur BDD a répondu: duplicate column name: errors (Errno: 1).
Impossible d'exécuter la requête : CREATE TABLE dbtonline ( errors INTEGER NOT NULL DEFAULT 0, user_id INTEGER NOT NULL DEFAULT 1, ident VARCHAR(200) NOT NULL DEFAULT '', logged INTEGER NOT NULL DEFAULT 0, idle INTEGER NOT NULL DEFAULT 0, csrf_token VARCHAR(40) NOT NULL DEFAULT '', prev_url VARCHAR(255), last_post INTEGER, last_search INTEGER, errors INTEGER NOT NULL DEFAULT 0, UNIQUE (user_id,ident) );
Une erreur est apparue à la ligne 552 dans le fichier /var/www/legtux.org/users/revest/www/include/dblayer/sqlite3.php
I use sqlite3.
Thank you for any help.
