Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Secret #121

Open
alby696 opened this issue May 15, 2018 · 7 comments
Open

Secret #121

alby696 opened this issue May 15, 2018 · 7 comments

Comments

@alby696
Copy link

alby696 commented May 15, 2018

Hello to all,

after finally solving a memcache problem, now I am faced with this problem when I go to create the first user and consequently I do not know if the others can have the same problem.

The query is located on the sections / register / index.php page on line 108 - 112.

schermata 2018-05-15 alle 09 40 26

Thank you

schermata 2018-05-15 alle 09 31 08

@arthur4ires
Copy link

Try this:

`$DB->query("
				INSERT INTO users_main
					(Username, Email, PassHash, torrent_pass, IP, PermissionID, Enabled, Invites, Uploaded, ipcc,Secret)
				VALUES
					('".db_string(trim($_POST['username']))."', '".db_string($_POST['email'])."', '".db_string(Users::make_crypt_hash($_POST['password']))."', '".db_string($torrent_pass)."', '".db_string($_SERVER['REMOTE_ADDR'])."', '$Class', '$Enabled', '".STARTING_INVITES."', '5368709119', '$IPcc','0')");`

@alby696
Copy link
Author

alby696 commented May 17, 2018

i have remove not null to define a database in gazelle.sql but i have the same problem in the field Title.
The primary query to insert the admin account ( SYSOP ).
Fixed this thing continues to give me errors, even in creating new users such as the screenshoot.
I tried to login the admin user, which appears registered in the table but remains in the login window but in the database tells me that I entered.

I would not want there to be an error in the query file at this point.

schermata 2018-05-17 alle 21 55 50

@arthur4ires
Copy link

You removed the null because? It appears it several fields of Bank of the Gazelle, this is causing the error.
Have you followed the gazelle's wiki step-by-step?

@alby696
Copy link
Author

alby696 commented May 18, 2018

I followed the guide step by step ... I removed the not null because otherwise it did not make me generate the first user and I did not know what value to put.

I also watched a front end video on windows, I think the most clicked on youtube and show that the first user is created without error and the camnpo secret and titel are empty.

I have also created all the files a query that generated the secret field but I did not find anything.

@alby696
Copy link
Author

alby696 commented May 18, 2018

but if I put Secret to 0 on the query, does the problem persist with the titled field?
what do I put them?

@cyberegg
Copy link

cyberegg commented Oct 2, 2018

Ran into the same issue.
I got through by allowing several columns to be NULL:
ALTER TABLE users_main MODIFY COLUMN Secret INT(32);
ALTER TABLE users_main MODIFY COLUMN Title TEXT;
ALTER TABLE users_info MODIFY COLUMN Info TEXT;

The initial user was created in users_main but I am unable to log in, it simply returns me to the login page with 5 attempts remaining.

Were you able to find a resolution? Any thoughts on where I'm stuck?

@mcangeli
Copy link

mcangeli commented Sep 1, 2023

Any update to this by chance?? I think I am at where you were.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants