PDA

View Full Version : please helpme... i will apreciate


elviejoepu
01-22-2008, 11:44 AM
we had several months trying with great difficulty in transferring users from phpbb2 but we got the error "stack over flow" when the process go for the 69000 members. well, we decided to lost 44000 members in the attempt, and we chose quality for quantity. (a really hard decision

Now I have a problem that I would like you helpme, and is that now all users have the basic editor as default, I would like to have the wysiwyg, as do we all have as default?

what can i do?
can u helpme?

Another situation is that when i try to edit the users info in Admin panel, it redirect me to "create new user"

Marco van Herwaarden
01-22-2008, 12:00 PM
To set the default for new users:

AdminCP -> vBulletin Options -> User Registration Options -> Default Registration Options

To change the setting for all current users:

AdminCP -> Maintenance -> Execute SQL Query -> Automatic Query

elviejoepu
01-23-2008, 11:44 AM
Hi,

Thanks for the answer, but when i enter to automatic query says: You are not authorized to execute SQL queries

how is possible if im the main admin ?


i?ll appreciated

thanks.. :)

--------------- Added 1201097239 at 1201097239 ---------------

By the way, when a new member try to register its give a database error.. specifically says "my domain database error"and that its.. in my url i got this path: "register.php?do=addmember", i don?t know how i can solve this issue.. i just import 70 000 members from my phpbb 2x forum.. all members works fine but when a new member try to register i got this issue but it get register in the database..

MoT3rror
01-23-2008, 08:10 PM
In your config file you must fill out this section to get access.
// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';

You will need to post the database error that you got from your email here or you can contact support at vbulletin.com and they should fix that register problem in no time.

elviejoepu
01-23-2008, 10:20 PM
Thanks!! :D

--------------- Added 1201136049 at 1201136049 ---------------

this is the error.. i hope somebody help me out with this.. :'(

Database error in vBulletin 3.6.8:

Invalid SQL:
INSERT INTO vbforo_usertextfield
(userid)
VALUES
(70029);

MySQL Error : Duplicate entry '70029' for key 1
Error Number : 1062
Date : Wednesday, January 23rd 2008 @ 05:51:27 PM
Script : http://www.elcorito.com/elforovb/register.php?do=addmember
Referrer : http://www.elcorito.com/elforovb/register.php?do=register
IP Address : 201.229.254.180
Username : fourtest
Classname : vb_database
================================================== ===

MoT3rror
01-24-2008, 03:36 AM
I had the same problem once.
http://www.vbulletin.com/forum/showthread.php?t=250538

It looks like your autoincrement values are off. You can use phpmyadmin to examine the database and set the appropriate autoincrement value for the user table. Or we can do this for you if you submit a trouble ticket with a URL and login to phpmyadmin:

http://members.vbulletin.com/membersupport_contactform.php

I sent in a ticket and they fix it very quickly so if you want to save the headache I suggest just submit a ticket.