Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+1 vote
718 views
in Q2A Core by
edited
I have a profiles site and want to install your q2a script with a single sign on but i'm afraid i don't understand databases too well.
I need to enter the column type (step 7 of the instructions) but don't know how to find this data.
If i go into phpmyadmin and check the database, what am i looking for and where? Your help would be so much appreciated as i've been up all night trying to work this out and to be honest i just can't figure it.
By the way, it's the best question/answer script i've come across and believe me i've tried them all!

Edit: Ok i really need a dummies guide here! I tried what i believe to be the correct data and first i got an error when i went to the web page. So i altered it and tried again but got an error page. So i put it back to how it was before i got the error page and now all i get is a 500 internal server error.

Assuming i have the correct identifiers, have i written this correctly?
function qa_get_mysql_user_column_type ('VARCHAR(20)')

Wow i'm feeling really despondent now. I've searched the internet for a long time to find a script like this and was even happier to find it can have integrated log in, but honestly i've been up all night and i just cannot do this install. I just don't know what i'm looking for or how to write it into the file once i've found it.
I have a 'members' table which say's the following:
member id mediumint(8)
login varchar(20)
password varchar(20)
email varchar(150)

So assuming i use varchar(20) then how do write that?
function qa_get_mysql_user_column_type ('VARCHAR(20)')
This just gives me a page 500 error page, but at first it gave me an error code saying something about expecting something at line 19. But it no longer gives that.
I really am upset with myself for not being able to do this.

1 Answer

0 votes
by
I can't know what would be most appropriate without seeing your database tables and columns. The chances are that you have a table called something like 'users', and that has some kind of 'id' column in it which is also used as the primary key. If you like you can post the output of this SQL and I'll help further.

DESCRIBE users

Replace the word 'users' above with the appropriate table name.
...