WhatCD / Gazelle

http://whatcd.github.io/Gazelle/
1.84k stars 364 forks source link

Secret #121

Open alby696 opened 6 years ago

alby696 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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

cyberegg commented 6 years ago

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 commented 1 year ago

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