Phpbb: Username Already Taken After Deleting
I tested to delete phpbb user where user_post = 0.
After deletion, the query exe as normal.
But when I start to register, the phpBB immediately shows
Sorry, but the username is already taken.
instead of showing registeration form.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Phpbb
I am trying to set up PHPbb on my website using MySql 4.1 for my forums and I can't figure out how to create a new database and connect the database to the actual site and also I need to locate my: 1 database name 2 username 3 password
Phpbb With Mysql
Im going to uss phpbb as my forums but i dont have a clue where to get started. I know i have to create a database with mysql so it can connect, but i need help on how to start the database what should i put in it etc. I think i can use phpadmin, if i'm right. My host provides me with sql database and sql. Can any please help so i can get this working.
PHPBB Forums
I have MySQL 4.0 installed on my computer. I tried to install the PHPBB forums and set it to MYSQL 4.0, but i dont know a valid host name, or database name, database username, and password. How can i figure these things out.
MySQL With PHPbb?
Is it enough to just install mySQL on the webbserver for the phpbb-forum to work? Or do I have to create my own database-files with predefined tables too?
How To Read Phpbb
php file is loaded as codes on windows, but when u upload it on web u get the codes showed as image and stuff, so my question is, when using local host (windows xp) what prog or how i can see the php files not as codes/source when opening but as image or table or whatever.
Phpbb And Firefox
I am developping a forum using phpbb 2.0.17 (the lastest version). My forum url is www.qnhl.com. The problem is the following: When you make a new post in a specific forum, this forum should show the "new post" icon instead of the "no new post" one. But it's not the case in Mozilla firefox. The "no new post" is always there. What's the problem? Anything related with cookies? Note that I don't have this problem with Internet Explorer.
Phpbb Forum
I'm experiencing some problems trying to get my phpbb forum to work with mysql. I'm running the newest version of apache, and php is installed and working, but I'm not quite sure about what I have to do with the MySQL database part to get it working. If anyone knows of any tutorials or anything I would be grateful Just for reference: I'm a newb when it comes to both php, and MySQL.
PhpBB Slow Loading
my site runs quickly except when a user hits forum (allready signed in or logging in) to login to the forums it takes 10x as long to get to the forums as it does the rest of the site, once in the forums its ok and runs as normal,is there any settings in SQL that can speed this up? or is there another problem.
PHPBB Can't Connect To Database
So i'm running Apache, PHP, and MySQL 4.x/5.x (i've attempted both) on Win2k. When i try to install phpBB2 it says it can't connect to the database Connection to database You have not established a connection to MySQL 4.x. ERROR: Access denied for user 'ODBC'@'localhost' (using password: NO) Your database was not found. ERROR: Access denied for user 'ODBC'@'localhost' (using password: NO)
MySQL Query For PhpBB
i want to display 5-10 latest phpBB2 posts on my homepage, and i know there are mods for the forum's index page that do similar thing, but i want to do it in my Perl script. I know how to connect to mySQL DB, but I don't know SQL.. could someone help me with mySQL query for X latest posts, so I would get the result containing user name, post topic, post date&time and post text?
Editing Not Working In PhpBB
After transfering my forum from one server to another, editing stopped working. You can go to phpBB's edit link, but when you try to edit the post nothing is changed. Topic titles can be edited, but nothing else can (including uploaded files with the attachment MOD). If I edit it directly from phpMyAdmin it will work fine, but editing through the forum does nothing. On the last server it worked fine, although I'm pretty sure on my last server I was running on an older version of MySQL (3.x). On my new host (globat) I'm on MySQL 4.1.Nothing was changed in phpBB's scripts since the transfer, so nothing would have taken away the ability to edit post text. If anybody knows what is stopping these things I would greatly appreciate the help, since I've been looking for a solution for quite some time now.
Seprate Database For PHPBB
I have a databse for the main website that will contain ~15 tables. Are there any advantages/disadvantages to merging and seprating and what is generally the best way to go? I'm also interested to hear about (other) situations in wich you would choose for an additional database to increase my insight in the subject.
Help Rewriting A Slow Phpbb Query
I have a "glance" or "Recent Topics" list on my forums that have become fairly complex. I modified an already feature rich glance mod to allow users to select individual forums to exclude from showing topics in the list. As well when users are members of certain forum groups, they see topics from the group forum in the list, and they are highlighted a different colour. The main SQL query to create the list often is showing up in the MySQL Slow_query log and I'm pretty sure is the main cause for the page loading slow. I am no mysql Guru, so I thought I would seek the advice of some to improve or totaly rewrite this slow query. PHP $sql = "SELECT f.forum_id, f.forum_name, t.topic_title, t.topic_id, t.topic_last_post_id, t.topic_poster, t.topic_views, t.topic_replies, t.topic_type, p2.post_time, p2.poster_id, u.username as last_username, u2.username as author_username FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u, " . USERS_TABLE . " u2 WHERE f.forum_id NOT IN (" . $forumsignore . $glance_recent_ignore . ") AND t.forum_id = f.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND t.topic_moved_id = 0 AND p2.poster_id = u.user_id AND t.topic_poster = u2.user_id ORDER BY t.topic_last_post_id DESC"; $sql .= ($glance_recent_offset) ? " LIMIT " . $glance_recent_offset . ", " . $glance_num_recent : " LIMIT " . $glance_num_recent; The "NOT IN" list varies per user, but here is an example: NOT IN (77,75,76,25,26,37,63,64,66,67,67,1,25,26,37,70,28,75,76,78)
Mysql Login Error For Phpbb.
what i am used to do, if i have to select more rows by their id's i write "SELECT * FROM table1 WHERE id IN (1,2,3,4,5)" how can i do this via Execution in adodb (http://phplens.com/adodb/) ? if i pass array, adodb starts complaining, if i implode it, it adds quotes around the string... any help? $ado -> Execute("select * from table1 where id IN (?)", array(array(1,2,3,4,5)) ) //this does not work:(
Tables Import PhpBB/phpNuke
My existing site is ok but limited and I'm now at the point where I would like to use a CMS, but I want to import all the old sites membership and comments into the new install. I HAVE A SCRIPT THAT WILL DO THIS called. phpbb_nuke_conv.tar should anyone else ask. but for this to happen the phpBB data must be in the same database where the nuke data resides, ie moving the phpBB tables over to the nuke SQL database. The prefixes are different so there no problems there, could someone please point set-by-step for this proceedure. I'm sure it only a few buttons and it would save me an ENOURMOUS amount of time reading about a subject I would rather not.
MySQL Query Linking OpenCrypt & PhpBB
I understand that this will seem very novice to you all as developers, but I really need some expert eyes on my question because frankly the other forums have offered no real assistance. I have a customer database system called OpenCrypt installed and running on my website. OpenCrypt has built in features to connect to my mySQL database as to create phpBB accounts similtaneously as general website accounts are created on my website! Now. I am new to mySQL and am working on getting the correct syntax to work with my phpBB database. The following are my current fields in question: user_id -> I need these id's to be created sequentially when new rows are added to my table, phpbb_users. user_regdate -> What date parameters does phpBB read? Thanks for your help! This is my current simple syntax used to similtaneously add phpBB rows to the table, where %variable% refers to my OpenCrypt fields: INSERT INTO kylebt_Forums.phpbb_users SET `username` = '%username', `user_password`=MD5('%password%'), `user_email`='%email%'
Help With MYSQL And PHPBB On Server 2003 Standard
Trying to get help with this situation. I have installed PHPBB, PHP (4X) and MySQL 4.1. This is how I started out. 1. Installed MYSQL - ran setup - did FULL install - and entered in new password when requested. MYSQL gave the green light when computer rebooted. Created new database with CREATE DATABASE XXX; Also installed ODBC from MYSQL site and created a "SITE DSN" for the ODBC 2. Installed PHP and verfied working and accessible 3. Installed PHPBB per the instructions on the site. Did the permissions as instructed on config.php and install.php 4. Came to the install screen. Entered the info and password that I did with MYSQL installation (Root was the username) NOW SAYS - CANNOT CONNECT TO THE DATABASE. I do not know what to do at this point.
Making Site Login Add Users To Phpbb Database Table
I have a login script for my site that I got off the net and was planning to use, but, I also wanted to make it so that when a user signed up thru the registration form it would also add them to the phpbb database's table. It wasn't discussed heavily from where i got the script but from what was mentioned the encryptions differ which results in a rejected login. Code:
Username?
I use the default mySQL username (root) in localhost and i want to upload it in my hosting's server using another username (e.g. : whutadilly) is it possible to do? or should i change mySQL username on localhost or what. i've read the stickied thread "Importing and exporting data with phpMyAdmin" but i wonder if its for different usernames.
Username And Pwd.
I have installed the database...and downloaded mysql administrator and mysql browser from this site.But I dont understand what username and password I need to enter?? I tried entering this site's username and password but it failed.
Username For Mysql
when I signed up to mysql, I got a root password Which is what i use to sign in to mysql. But,no user name. ( I know to use root but i would like to change it) Does anyone know how to go about doing this or at least point me in the right direction.
Username Question
I've got one little question, maybe a little silly, but where can I find my MySQL password? I've installed apache, PHP and MySQL on my computer, for learning PHP and MySQL, but to use MySQL with PHP I need the username of my MySQL account or something, but I don't know what it is and I can't remember I once set a username.
Seleting The Id Of A Username
Basically what I'm trying to do is make a delivery system, what the system does is the user enteres a name of a person, this then grabs teh users id and and inserts that id in to a database along some other details, that the mian bit I need help with the other bits I have sorted. $invitedinfo=mysql_query("SELECT id,username,address FROM users WHERE username='$inviteid'"); Then what I want to insert is for '$inviteid' to be turned in to the id of the username which it is being paried up with at the moment.
1 Username Databases?
Many ISP:s offer web-service with MySQL - with 1 user / 1 database. Have I understood right that this means there is that 1 read/write user only, and no chance to make read-only username, so only chance is to put username/password with write-rights into scripts?
Setting Up A Username
I am both the user and the admin. I am using winXP, and I am the root. This is all happening on one laptop since I am using Apache as a server. I have to ONLY provide mysql with my password to get into my database. My Q is how can I assign an actual username to myself, so MySQL connects my password that is already in use with the new username which I don't know how to create?
Forgot Username
I wanted to export a mysql database so i can take it to school. i did some research and i found out this is how to export a database: # mysqldump -u username -ppassword database_name > FILE.sql unfortunately, i dont remember my username! Is there any way i can find out what it is? I am using Windows XP and MySQL server 5.0. also i have tried using 'root' as my username
'Username'@'localhost' OR %?
I created a new user using the grant create... on *.* to 'username' identified by 'password'; When I tried to use mysql.exe to change to Old_Password the row was not found initially. Further investigation highlighted that the account was to username@% rather the username@localhost that I had anticipated. what is the username@% and can it be used in the same way as username@localhost?
Username On Install
The *** thing wont let me in, so secretive are these clever sprites! Installing mysql is simple enough (latest version), apache and php work together happily - but not mysql. My problem seems to be the username, as the basedir (default) and the datadir (my own within My Documents) should be OK in the my.ini file. But nowhere did it ask for a username. When I try to connect it says 'No way, go away root@localhost' and whatever I try in place of 'root' - it still wont play. Where/when can I choose the username to force it, screaming, to let me connect to it (Win XP, mysql-essential-4.1.11)
Change Username
I have installed MySQL 4.1 (after much trouble with firewall, password format, etc!!) but I would like to know if I can change the MySQL username on our local MySQL server from 'root' to something else. I know that password is changeable. I like to test my scripts on my localhost before uploading them to the server. But the problem is that the MySQL username on our webhotel is not 'root' therefore I always have to go into our configuration files before uploading and change the username. This is a pain.
MySQL Username
I downloaded an application that uses MySQL, PHP and IIS. What i did, I just copy the PHP files in c:inetpubwwwroot and run http://localhost/newweb/install.php. During installation, it asks for MySQL username which i dont know because during installation of MySQL 5.0 , I was not asked to enter username, only password for the root. I tried typing root for MySql username but states that "Client does not support authentication protocol requested by server; consider upgrading MySQL client". What username will i enter? It says to try FTP username account which i also dont know.
Incorrect Username
I added a new user to the mysql database by means of SQLyog. I specified test as "New Username", and wxpfvdb01.fvdb.local (an existing host on my network) as "New Host". I left the password blank, and selected all privileges for this new user. When i tried to connect as this new user, i got the following erros message : access denied for user: 'test@WXPFVDB01' (Using password: YES). The Full Computer Name of my system is: wxpfvdb01.fvdb.local, and this name is dynamically registered in my DNS Server (both forward and reverse zone). I get the same error message when trying to connect with other programs (mysqlc, mysql qdministrator, It is clear that for some reason the client programs put the netbios name of my computer after the @.
Request | Username
I didn't found a good example to set the three % to single variable characters... My sql string = SELECT * FROM table WHERE username LIKE '".$_SESSION['user'] &&& $_SESSION['domain']."' ORDER BY username ASC LIMIT $current_page, $results_per_site");
Username & Password
i've jz installed mysql query browser and it requires me to fill in username n password, but i can't remember of setting any username b4...wat shud i do?
Username/Password
I am practising both PHP and MySQL programming on my desktop with Windows 98SE / PWS 4 Web Server. Using PHP script to connect to MySQL server, when I define DB_USER and DB_PASSWORD with my real user name and real password, I get the following error message: Warning: mysql_connect(): Client does not support authentication protocol requested by server. Consider upgrading MySQL client in D:Inetpubwwwrootphpmysql_scripts6mysql_connect.inc on line 20 The category could not be added! To get these to work, I had to change DB_USER name to "root" and DB_PASSWORD to blank.
Finding Username And Password
i havent used it for since ive installed it and i forgot my username and password. is there any way of finding this out and how?
Blank Username In Mysql Db
Using a Virtual Private Server -UNIX & Apache 1.3.22 & mysql 3.23.46 I was able to create the mysql root password, however the system will not let me create the admin password (which is supposed to be the same as my account name). When I checked the database to see the current names, this is what I got below: Code:
Username And Password For Phpmyadmin
I have to put a password and username for that php page where is index for phpmyadmin, my site is on some german windows server, which is user-nofriendly, no support, so these guys can not help me. I tryed with http auth or cookies, its not working, only config (which is without password. If i use http authentification, i allways have a small window for user and pass, but if i write a proper user/pass it pop up again, like its not a good pass or user.
Forgot MySQL Username
When securing down the Windows 2003 server that I use for MySQL I followed the advice of dev.mysql.com and changed the root username to something else. Under step 12 for securing your windows box for MySQL it states to do the following command. mysql> USE mysql; Database changed mysql> UPDATE user SET user='bob' WHERE user='root'; Query OK, 1 row affected (0.19 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.23 sec) I changed my username (while forgetting to write it down before I hit enter), and hit enter. The list of commands above show that I should have gotten back a response and still would have been able to see what username I typed. But that isn't what happened. For some amazing reason the command prompt closed and the commands must have completed, because now I can't get into MySQL anymore. So is there a way that I can go about finding out what the h*** I typed? If not, can I do anything to undo, or reset the username? If I have to reinstall that is fine, but I'm not sure how to do that without losing all my data.
Check Username Case
I have a query about checking the case of a username. If i have a username TEST, if i enter in TEST or test the result from sql is true. I can check it in the program itself but is there a way to do it in SQL.
MySQL Username Lookup
I installed MySQL about a year ago on my machine here at home but have only used phpMyAdmin to access it. Using MySQL and phpMyadmin, I was able to load WordPress and run a blog for about a year. A couple of days ago, I downloaded the GUI Tools bundle and MySQL Administrator is asking for Username and Password. Problem is that I've forgotten what the Username is. Is there any way to find out what that would be?
Checking Username/password
I have this sql statement: SELECT * FROM projects WHERE `username` = 'FAA' OR `username` = 'faa' AND `password` = 'ASW2004' OR `password` = 'asw2004' in order to check for whether for the correct combination whether the user used upper or lower case. It's returning 2 rows from the database but that combination occurs only for one row. Do I have my syntax wrong?
Username And Password Verification
I am querying a table on two fields, Username and Password to validate a site log-on attempt. Is there a way of verifying that a record matches apart from running through a fetchrow_array() loop?
Two Databases, One Username And Password
I have two databases that both require a username and password. The one database I just created and would like to have the usernames and passwords in both to be syncronized.
Username And Passwd Updating
i have an excel list with 200 people, so what i do is convert the excel file to mysql, using a $24.90 sofware.....once i have the mysql databse i add the column username and Password, so each people can access through a php login page enternig their username and a password and see their information in the database... The excel list changes every 15 days...all the fields!...so the problem is the fact that this excel sheet does not comes with a username and password column....and since they may be more or less people on it user information will not correspond to the username and password rows that on the db
Username, Password And Database Name
but the person that installed mysql on my laptop told me that the username and database name was not that important. Is there a way to retrieve my username, password and database name? Im trying to practice php and mysql but it give me an error.
Password/Username Locked Me Out Of PhpMyAdmin
I'm using MySQL 5.X on a Mac. I was trying to create a password and username for a new database. I created the database, then clicked on Privileges. Next, I created a password and username. Not only can I not access the database, I can't even access phpMyAdmin now; I get this error message:
Username Won't Work In Permissions Script
I am setting up a classified site. I can run my build scripts, but when I try to run the permission scripts, and try to grant access for my username DB_234608_mysql_user, it says no user or group found in the database...Though it clearly says on my database manager what the DB login name is. My server has confirmed the correct username, and the software manufacturer says I need to talk to my hosting server, because it's set up acurrectly in my SQL script.
|
TRACKER
