vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Profile Enhancements - vBulletin Self Delete - Allow users to self-delete their profile (https://vborg.vbsupport.ru/showthread.php?t=274112)

KevinL 02-07-2016 07:19 PM

Quote:

Originally Posted by Vossi (Post 2564416)
Yes, I don't see another usefull way of doing it otherwise.

I'm not sure I understand. It would be more useful to move them manually or to have them automatically moved back to their usergroup they were in before asking to be deleted? I would think to have them moved automatically would be more useful no?

Thank you for the reply!

MrD 02-10-2016 04:07 PM

Hi,
Quote:

Originally Posted by Vossi (Post 2564416)
Yes, I don't see another usefull way of doing it otherwise.

at the VBouncer Addon, there are an Option that Users where moved Back in the Usergroups if there have the Mailadress verified.

Maybe this is an Idea for Future Versions :)

Elixar 02-10-2016 04:10 PM

Just a random question: Is there a way to have them delete their profile, but hide it from the public and still have it visible to Staff?

AllenBAN 03-16-2016 12:18 AM

when will this work for V 4.2.2 cos id like to use it

MrD 04-18-2016 02:19 PM

This Addon Works fine with 4.2.x :D

Hostboard 06-29-2017 12:22 PM

Throws a DB error with 4.2.5
I know were talking an older modification but does anyone have it working or a quick fix?


Database error in vBulletin 4.2.5:
Invalid SQL:
CREATE TABLE vbselfdelete_user (
id int(11) NOT NULL auto_increment,
username varchar(255) NOT NULL default '',
userid int(11) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
status smallint(1) unsigned NOT NULL default '0',
deltime int(10) unsigned NOT NULL default '0',
delcode varchar(255) default NULL,
cooldown smallint(1) unsigned NOT NULL default '0',
reason text,
PRIMARY KEY (id)
) TYPE=MyISAM;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 12
Error Number : 1064
Request Date : Thursday, June 29th 2017 @ 02:02:40 PM
Error Date : Thursday, June 29th 2017 @ 02:02:45 PM
Script : http://www.MyDomain.com/forums/ACP/p...=productimport
Referrer : http://www.MyDomain.com/forums/ACP/p...?do=productadd
IP Address : xxx.xxx.xxx.xxx
Username : UserID
Classname : vB_Database_MySQLi
MySQL Version : 10.1.10-MariaDB
Server : xxx.xxx.7.194
User Agent :

z3r0 07-01-2017 01:33 PM

Quote:

Originally Posted by Hostboard (Post 2587897)
Throws a DB error with 4.2.5
I know were talking an older modification but does anyone have it working or a quick fix?


Database error in vBulletin 4.2.5:
Invalid SQL:
CREATE TABLE vbselfdelete_user (
id int(11) NOT NULL auto_increment,
username varchar(255) NOT NULL default '',
userid int(11) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
status smallint(1) unsigned NOT NULL default '0',
deltime int(10) unsigned NOT NULL default '0',
delcode varchar(255) default NULL,
cooldown smallint(1) unsigned NOT NULL default '0',
reason text,
PRIMARY KEY (id)
) TYPE=MyISAM;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 12
Error Number : 1064
Request Date : Thursday, June 29th 2017 @ 02:02:40 PM
Error Date : Thursday, June 29th 2017 @ 02:02:45 PM
Script : http://www.MyDomain.com/forums/ACP/p...=productimport
Referrer : http://www.MyDomain.com/forums/ACP/p...?do=productadd
IP Address : xxx.xxx.xxx.xxx
Username : UserID
Classname : vB_Database_MySQLi
MySQL Version : 10.1.10-MariaDB
Server : xxx.xxx.7.194
User Agent :

Try this - https://vborg.vbsupport.ru/showpost....0&postcount=20

Paul M 07-01-2017 01:46 PM

TYPE is old MySQL (MariaDB) syntax, no longer supported, change it to ENGINE.

Hostboard 07-03-2017 11:39 AM

Thank you, that did the trick :)


All times are GMT. The time now is 05:56 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01071 seconds
  • Memory Usage 1,739KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete