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

Database prefix not being applied #442

Closed
NevaPortal opened this issue Nov 19, 2019 · 16 comments · Fixed by #555
Closed

Database prefix not being applied #442

NevaPortal opened this issue Nov 19, 2019 · 16 comments · Fixed by #555
Labels
Milestone

Comments

@NevaPortal
Copy link

From second step to third stem not jumping. I jumped manually to the third step when i click oncomplete setup button i get
Illuminate\Database\QueryException SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO) (SQL: select count(*) as aggregate from airlineswhereicao = THY) http://www.turkishva.com/install/usersetup

@nabeelio
Copy link
Owner

Did you try the 'check connection' button? Did a config.php and env.php files get created, and does the config.php have your credentials?

@NevaPortal
Copy link
Author

I tried check connection button and connection was ok. Bur after i fill step two (database connection page) i tried to go step 3 but didn't let me. Just refresh the page. I enter manually step 3 page and i get this error. I will check config.php and env.php in couple hours and let you know.

@NevaPortal
Copy link
Author

NevaPortal commented Nov 20, 2019

I found the problem. Step two at the bottom Database Prefix, i put phpvms_ and i get the error. This time i left it empty and now no problem.

@nabeelio
Copy link
Owner

Ah wow, thanks for tracking that down. Do you remember if it write the prefix to the config.php file? Guess there's a beta 3 coming out tomorrow ;)

@nabeelio nabeelio changed the title Beta v2 Setup Issue Database prefix not being applied Nov 20, 2019
@nabeelio nabeelio added this to the 7.0.0-beta3 milestone Nov 20, 2019
@nabeelio nabeelio added the bug label Nov 20, 2019
@NevaPortal
Copy link
Author

No i didn't check it. Sorry my friend. When you have new beta or stable release, do i have to fresh setup or can i update from my phpvms7 dashboard?

@nabeelio
Copy link
Owner

There's no auto update (yet); you would just have to extract the latest files over what you have, and the admin will alert if it needs to run the upgrader

@NevaPortal
Copy link
Author

Thanks my friend.

@nabeelio
Copy link
Owner

Hi, sorry for the delay - is this still valid in the latest dev version?

@NevaPortal
Copy link
Author

NevaPortal commented Feb 14, 2020

Latest version Still have the same problem.
https://prnt.sc/r2h0ia

@nabeelio
Copy link
Owner

Could you post the entire Laravel log file from storage/logs?

@nabeelio nabeelio reopened this Feb 14, 2020
@nabeelio nabeelio modified the milestones: 7.0.0-beta3, 7.0.0 Feb 14, 2020
@NevaPortal
Copy link
Author

NevaPortal commented Feb 14, 2020

[2020-02-14 20:04:31] dev.INFO: Connection string: mysql:host=localhost;port=3306;dbname=ottomanva  
[2020-02-14 20:04:32] dev.INFO: ENV setup {"_token":"dyCDpr5c0WdJwtenTftuzQmSYR8IQjuxOpZufxLD","site_name":"Ottoman Airlines","site_url":"http://www.ottomanva.com","db_conn":"mysql","db_host":"localhost","db_port":"3306","db_name":"ottomanva","db_user":"OmerAslan","db_pass":"","db_prefix":null} 
[2020-02-14 20:04:32] dev.INFO: Testing Connection: mysql::OmerAslan:<hidden>@localhost:3306;ottomanva  
[2020-02-14 20:04:32] dev.INFO: Connection string: mysql:host=localhost;port=3306;dbname=ottomanva  
[2020-02-14 20:04:32] dev.INFO: Connection string: mysql:host=localhost;port=3306;  
[2020-02-14 20:04:32] dev.INFO: Detected DB Version: 5.7.29-0ubuntu0.18.04.1  
[2020-02-14 20:04:32] dev.INFO: Detected extension "Zend OPcache", setting driver to "opcache"  
[2020-02-14 20:04:32] dev.INFO: Redirecting to database setup  
[2020-02-14 20:04:42] prod.INFO: Running seeder  
[2020-02-14 20:04:42] prod.INFO: Seeding ./home/ottomanva/public_html/app/Database/seeds/prod/ranks.yml  
[2020-02-14 20:05:15] prod.INFO: Set pilot ID for user 1 to 1  
[2020-02-14 20:05:16] prod.INFO: NotificationEvents::onUserRegister: OTM0001 is Active, sending active email  ""  ```

@nabeelio
Copy link
Owner

Ok, interesting, it's showing db_prefix":null in that log.

@NevaPortal
Copy link
Author

i add prefix phpvms_

@nabeelio
Copy link
Owner

Can you try the branch in the above PR? I'm not able to duplicate the db_prefix: null portion, but I did find other errors which would cause errors if there's a prefix specified

@NevaPortal
Copy link
Author

I will be available Monday my friend. I will try and let you know.

@nabeelio
Copy link
Owner

Thanks!

nabeelio added a commit that referenced this issue Feb 18, 2020
* Fix migrations when table prefix is involved #442

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

Successfully merging a pull request may close this issue.

2 participants