NO ADMIN USER CREATED DURING INSTALL

[nay27uk]

I have installed this 3 times now and during install where it ask for an admin name it will not allow changing the alredy filled in admin to anything else.
So I installed it three times leaving the admin username as admin and then entering my admin password two times and clicking on the install button, the installer then takes me to a page that canot be displayed but the script is installed if I go back to my domain.
The script is also installed in the database in PHP my admin as all tables are there, However when trying to login to the admin section by inputting the username of admin and the password I created during install it says the account was not found, upon looking In PHP myadmin at the faquser table the faquser table is empty nothing in it at all.

PLEASE give me some SQL I can run in PHP my admin to add a admin user to the database because without access to the admin section this script is useless

[jason102178]

Here is what i can suggest..... instead of installing version 2.6.16 install version 2.6.15 just to let you know within the next few days version 2.6.17 will be released

http://phpmyfaq.de/download.php?do=down ... 5&ext=.zip

Cheers,

Jason

[nay27uk]

thanks jay I will try the version you sujest as the version I downloaded of the site will not add any admin to the faquser table of the database

[nay27uk]

ok I downloaded and installed the version you posted here and it is still exactly the same as described clcicking install loads a page canopt be displayed and trying to login to admin using admin and my chosen password says User or password not valid.

in PHP Myadmin under faquser thier is nothing I can not even click the browse button so nothing is being entered into that table. I will try and find another faq system that actualy enters the proper info into the database during install.

I know it is nothing to do with my hosting as I am the owner of the server and provide hosting at http://www.listerhosting.co.uk I have been a server operator and hosting provider since 1995 so there is a problem with the script it is making the table in the databae but not populating it. for example I dont see in any of the install scripts a dump data into table

[jason102178]

Ok this is really odd I have never herd of it not creating the admin user or the password you create, Can you tell me what server you have Linux or Windows, and also which Version of mySql you are using when you create the phpmyadmin database are you using 4.1 or 5.0.....


And also During installation which version of are you selecting on the install page example.com/faq/install/setup.php are you selecting SQL lite or MySQL and were it says Database table prefix you can leave that area blank

I can Talk to Thorsten about this issue, to see about a way to manually import admin to phpmyadmin since its not letting you manually create the user in phpmyadmin


Thanks Jason

[nay27uk]

Hi thanks jay.
I am on a linux server with the latest version of mySql and indeed I was selecting mySql from the dropdown on the installer and was leaving the table prefix blank.
Thanks for the help on this

[jason102178]

Your Welcome, As i had mentioned Thorsten will be able to give me a little more insight on this issue as to why it is happening and what next step could be taken, Its Very Strange, Because i Am running a Linux Server also with the latest Mysql and i just did a fresh install on my server of phpNyFaq to see if this was an issue that was happening to everyone or just you for some reason, and i was able to install and it created the Database Tables just fine and i was able to login using admin and pass....


When you are on the setup page and you have to enter your host name and host username and pass and all the other stuff, at the top what does it say, does it say something like all tables were created sucesfully or does it give some kind of error message.....

[jason102178]

Also take a look at this Ariticle i created for a user who was having a hard time creating a username and pass, you prolly know how to use phpmyadmin pretty well already but just take a look at this and let me know if this is how you were trying to create a username and password in phpmyadmin it starts on the 3rd article

Code: Select all

http://forum.phpmyfaq.de/viewtopic.php?f=7&t=12177

[nay27uk]

Hi jay
with regards to the server info in setup I enter localhost as the server then fill out all the other database fields acording to my database setup.
I leave the middle bit all as it is without adding anything or removing anything I then fill out the admin bits and click the large green button that says install, after around 10 seconds this refreshes with a this page can not de displayed, with no errors even with (show friendly error messages disabled in internet explorer) just a page can not be diplayed, however all tables have been added to the database.
I then go to the main domain the faq is installed in and the faq loads, when going to admin I can not log in due to the admin details not being in the database.
I am installing it in a sub directory of another domain so it is not being installed to its own domain or subdomain.

To the other user
I will take a look at your post but I am thinking it maybe one I alredy read (just looked and it is one I have seen) I can not do anything with the faquser table as it will not allow me to click the BROWSE tab for that table in php my admin, hence I can not manualy enter anything. I could do this by using some SQL syntax in the SQL section of PHPMy admin for that table to dump the data needed but dont have a clue what SQL to use as I am not fermilier with the script and what SQL to use in order to populate the table with the required information.

[nay27uk]

Ok I seem to have this working now I downloaded the alpha version and chmoded every file and folder in the faq to 777 and installation finished corectly and I am able to log in to admin

[jason102178]

Ok well i am glad you where able to get the alpha version installed, corectly and you were able to login, But i must warn you trying to use the Alpha version for your primary FAQ system is not recommended since it is in the Development stage and allot of the features do not work correctly,

But i will tell you this within a week or so the 2,7 Beta version will be pushed out and will replace the 2.7 Alpha 2 , But there Beta version is going to be a little more stable and usable and allot moee features will work, But the beta version will work allot better in the meantime until we Releases the Release Canidate, the beta still contains minor bugs and is not yet stable by any means.


Cheers,

Jason

[nay27uk]

thanks jay
I removed the alpha and tried to reinstall the stable version using the same method of chmod 777 to every file and folder still exactly the same problems as above so the alph version adresses the install problems that must be in the stable versions

[jason102178]

Ok, Well Thorsten Commented on the other post that u submitted for the Bug forum, asking what erros did you get and you reffered him to this board, so he will look at it when he has time, since he is a very busy person, but if anyone would know what to do it will be him...

[nay27uk]

Great thanks jay.
A very nice script by the way I have seen it being used on lots of websites hyence my trying to use this script. I have patients so will probably have to wait untill the release of the beta

[jason102178]

Just an update so you know beta will more then likey be released within a week.... week been trying to fix a major issue with the emails of 2.7 Beta