search

therecluse26 / PHP-Login

A login system built with PHP, MySQL, jQuery and Bootstrap
MIT License
839 stars 444 forks source link

Having alot of issues upon installing #231

Open ghost opened 5 years ago

ghost commented 5 years ago

Hello I have managed to figure out other issues but i am currently facing this issue upon trying to install the website. Link to what it says on install.php

https://i.imgur.com/qONsQnZ.png

let me know what code you require. or any screenshots

mattish91 commented 5 years ago

Did you try both automatic and manual install?

Did you ever try to import the SQL manually to the database trough EG. phpMyAdmin? And try manually after that?

therecluse26 commented 5 years ago

I know this might sound like a silly question, but did you enter all of the database information during the configuration step?

On May 18, 2019 at 5:29 PM, <Mattias Magnusson (mailto:notifications@github.com)> wrote:

Did you try both automatic and manual install?

Did you ever try to import the SQL manually to the database trough EG. phpMyAdmin? And try manually after that?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub (https://github.com/therecluse26/PHP-Login/issues/231?email_source=notifications&email_token=AB63QAQYMXIQBDBU2W3HLLTPWBYMXA5CNFSM4HNYZOX2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVWWKCQ#issuecomment-493708554), or mute the thread (https://github.com/notifications/unsubscribe-auth/AB63QAWUMXLTE3EMCWPA4FDPWBYMXANCNFSM4HNYZOXQ).

ghost commented 5 years ago

I know this might sound like a silly question, but did you enter all of the database information during the configuration step? … On May 18, 2019 at 5:29 PM, <Mattias Magnusson @.***)> wrote: Did you try both automatic and manual install? Did you ever try to import the SQL manually to the database trough EG. phpMyAdmin? And try manually after that? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub (#231?email_source=notifications&email_token=AB63QAQYMXIQBDBU2W3HLLTPWBYMXA5CNFSM4HNYZOX2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVWWKCQ#issuecomment-493708554), or mute the thread (https://github.com/notifications/unsubscribe-auth/AB63QAWUMXLTE3EMCWPA4FDPWBYMXANCNFSM4HNYZOXQ).

Did you try both automatic and manual install?

Did you ever try to import the SQL manually to the database trough EG. phpMyAdmin? And try manually after that?

I know this might sound like a silly question, but did you enter all of the database information during the configuration step? … On May 18, 2019 at 5:29 PM, <Mattias Magnusson @.***)> wrote: Did you try both automatic and manual install? Did you ever try to import the SQL manually to the database trough EG. phpMyAdmin? And try manually after that? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub (#231?email_source=notifications&email_token=AB63QAQYMXIQBDBU2W3HLLTPWBYMXA5CNFSM4HNYZOX2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVWWKCQ#issuecomment-493708554), or mute the thread (https://github.com/notifications/unsubscribe-auth/AB63QAWUMXLTE3EMCWPA4FDPWBYMXANCNFSM4HNYZOXQ).

https://i.imgur.com/JmlziD4.png I reinstalled the files and this is what comes up on automated.

https://i.imgur.com/kYLI9PL.png - the automated install infomation

https://i.imgur.com/vOCtJ44.png - phpmyadmin

when i try manual when it comes to password it says it needs to be filled out even the as i use xampp their isnt a password.

ghost commented 5 years ago

I know this might sound like a silly question, but did you enter all of the database information during the configuration step? … On May 18, 2019 at 5:29 PM, <Mattias Magnusson @.***)> wrote: Did you try both automatic and manual install? Did you ever try to import the SQL manually to the database trough EG. phpMyAdmin? And try manually after that? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub (#231?email_source=notifications&email_token=AB63QAQYMXIQBDBU2W3HLLTPWBYMXA5CNFSM4HNYZOX2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVWWKCQ#issuecomment-493708554), or mute the thread (https://github.com/notifications/unsubscribe-auth/AB63QAWUMXLTE3EMCWPA4FDPWBYMXANCNFSM4HNYZOXQ).

ignore that i managed to fix it, however upon installation it redirects me to a page that says this https://i.imgur.com/h5aOoPH.png

therecluse26 commented 5 years ago

Try running composer install from a terminal in that directory. If you don't have composer, install it first at getcomposer.org

On Sat, May 18, 2019 at 9:16 PM, losthdpenguin notifications@github.com wrote:

I know this might sound like a silly question, but did you enter all of the database information during the configuration step? … <geary:body#> On May 18, 2019 at 5:29 PM, <Mattias Magnusson /@/.***)> wrote: Did you try both automatic and manual install? Did you ever try to import the SQL manually to the database trough EG. phpMyAdmin? And try manually after that? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub (#231 https://github.com/therecluse26/PHP-Login/issues/231?email_source=notifications&email_token=AB63QAQYMXIQBDBU2W3HLLTPWBYMXA5CNFSM4HNYZOX2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVWWKCQ#issuecomment-493708554), or mute the thread (https://github.com/notifications/unsubscribe-auth/AB63QAWUMXLTE3EMCWPA4FDPWBYMXANCNFSM4HNYZOXQ).

ignore that i managed to fix it, however upon installation it redirects me to a page that says this https://i.imgur.com/h5aOoPH.png

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/therecluse26/PHP-Login/issues/231?email_source=notifications&email_token=AB63QAQJALNSSOQ6OIXU4V3PWCS5FA5CNFSM4HNYZOX2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVWYZ2Y#issuecomment-493718763, or mute the thread https://github.com/notifications/unsubscribe-auth/AB63QAQIYFJGL3WLNZF5GTLPWCS5FANCNFSM4HNYZOXQ.

[ { "@context": "http://schema.org", "@type": "EmailMessage", "potentialAction": { "@type": "ViewAction", "target": "https://github.com/therecluse26/PHP-Login/issues/231?email_source=notifications\u0026email_token=AB63QAQJALNSSOQ6OIXU4V3PWCS5FA5CNFSM4HNYZOX2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVWYZ2Y#issuecomment-493718763", "url": "https://github.com/therecluse26/PHP-Login/issues/231?email_source=notifications\u0026email_token=AB63QAQJALNSSOQ6OIXU4V3PWCS5FA5CNFSM4HNYZOX2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVWYZ2Y#issuecomment-493718763", "name": "View Issue" }, "description": "View this Issue on GitHub", "publisher": { "@type": "Organization", "name": "GitHub", "url": "https://github.com" } } ]

ghost commented 5 years ago

I have installed composer to my understanding (going to my cmd redirecting to D:\Desktop\452\PHP-Login-master\login\misc then putting composer install into the cmd then yh) is that it if so I have done that and it still doesn't work

ghost commented 5 years ago

Do I need to goto login/index.php or can i just go from index.php without going to login.

falconapps commented 5 years ago

I have a similar failure on Ubuntu 18.04 and 16.04, both auto and manual. I can say that the SQL fails (at least the first time) at:

mysql> CREATE TABLE `member_info` (
    ->   `userid` char(23) NOT NULL,
    ->   `firstname` varchar(45) NOT NULL,
    ->   `lastname` varchar(55) DEFAULT NULL,
    ->   `phone` varchar(20) DEFAULT NULL,
    ->   `address1` varchar(45) DEFAULT NULL,
    ->   `address2` varchar(45) DEFAULT NULL,
    ->   `city` varchar(45) DEFAULT NULL,
    ->   `state` varchar(30) DEFAULT NULL,
    ->   `country` varchar(45) DEFAULT NULL,
    ->   `bio` varchar(20000) DEFAULT NULL,
    ->   `userimage` varchar(255) DEFAULT NULL,
    ->   UNIQUE KEY `userid_UNIQUE` (`userid`),
    ->   KEY `fk_userid_idx` (`userid`),
    ->   CONSTRAINT `fk_userid` FOREIGN KEY (`userid`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ERROR 1022 (23000): Can't write; duplicate key in table 'member_info'
mysql>

Any idea?

therecluse26 commented 5 years ago

@falconapps is there already data in that table? That error would happen if you have an existing table with duplicate values in the userid field.

falconapps commented 5 years ago

I was trying the manual after a botched auto install. I've rolled out a fresh Ubuntu 16.04 and tried manual only - seems okay, although with some strange errors in the SQL which seemed like tab/space/whitespace. Anyway, sorted and all good - thanks!

therecluse26 commented 5 years ago

Yeah, I discovered a weird whitespace-related bug the other day that I patched. I wonder if that's related to your issue?

On Tue, May 28, 2019 at 10:05 AM falconapps notifications@github.com wrote:

I was trying the manual after a botched auto install. I've rolled out a fresh Ubuntu 16.04 and tried manual only - seems okay, although with some strange errors in the SQL which seemed like tab/space/whitespace. Anyway, sorted and all good - thanks!

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/therecluse26/PHP-Login/issues/231?email_source=notifications&email_token=AB63QAW55HHLRH64CM2I7JLPXU3Z5A5CNFSM4HNYZOX2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODWMHOMQ#issuecomment-496531250, or mute the thread https://github.com/notifications/unsubscribe-auth/AB63QATJ64OG2OZDMXOY4CTPXU3Z5ANCNFSM4HNYZOXQ .

falconapps commented 5 years ago

I think so. I've scripted most of this so I'll try again with Ubuntu 18.04 today - auto and if that fails manual - I have the feeling I'll have to tweak the SQL again, maybe. If so I'll come back with details. I'm wanting to upgrade from an older version of PHP-Login, and really want to upgrade PHP-Login to Bootstrap 4 as the rest of my older site is Bootstrap 4 - am I biting off more than I can chew?