The cogs keep spinning!

[revsie]

So I have been looking around, trying all sorts of different things, reading this forum and that but have been unable to resolve my issue.

I have entered in all the details and installation starts but gets to 10 or 11 in the Ajax requests on the symfony toolbar, it then goes a lovely shade of red and gives this error "An exception occurred while executing 'SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3 FROM uv_support_role t0 WHERE t0.code = ? LIMIT 1' with params ["ROLE_SUPER_ADMIN"]:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'UVDesk.uv_support_role' doesn't exist"

I have read this post 'https://github.com/uvdesk/community-skeleton/issues/257' and followed it through, but unfortunately this doesn't fix the issue. I have tried following all the tutorials and run through them. Have looked at this 'https://forums.uvdesk.com/topic/511/installation-stuck-at-step-4-need-help' and get this error "In ConfigureHelpdesk.php line 241: Call to a member function fetch() on bool" When running that and also checked composer is installed.

Really lost now so any ideas will be welcome.

[vaishaliwebkul]

@revsie It seems all the tables in the database are not migrated successfully. you can go to .env file and add the fresh database credentials here then run php bin/console configure:helpdesk

[papnoisanjeev]

Do the below steps to setup UVdesk manually.

1. Download the project zip from here.

2. Unzip the zip file and put it in your localhost or server directory where you are planning to run project.

3. Upload or import below given fresh database zip directly into your database if not able to do it directly you can try to import using command as well. Database ZIP: uvdesk-latest.sql.zip

4. Open the .env file of project and put your database details in the .env file as shown in screenshot.

If everything works well then log in using the below details:

Login URl: your_domain/en/member/login (Default URl)

Username: admin@admin.com Password: querty@12345

Update your database using the below command: php bin/console d:s:u --force

Clear project cache using the below command: php bin/console c:c

[revsie]

@papnoisanjeev

You are a gent, it is now working.

As I am testing this is obviously all on a test server and will do a brand new install when we go live, do you have any idea why this would happen? Would be good to get to the bottom of it so that I don't hit the same issue again next time round.

[papnoisanjeev]

@revsie

Would be good to get to the bottom of it so that I don't hit the same issue again next time round.

It happens mainly because of less execution time in php.ini file. By default max_execution_time is 30 sec you need to increase it and restart your server.

Also provide write permission for .env file in your project.

Then finally try to setup your project.

[revsie]

Hi,

Yes I read those and they have been changed. I might spin up another as I am getting errors now when trying to upload a logo, stuck at line 55 mkdir($pathToActiveDirectory, 0777, true); of the file vendor/uvdesk/core-framework/FileSystem/UploadManagers/Localhost.php. Guessing that is a permissions thing.

[papnoisanjeev]

@revsie

Provide read/write permission for below folders.

For var folder -chmod 777 -R path of var folder of UVdesk project For config folder – chmod 777 -R path of config folder of UVdesk project For public folder – chmod 777 -R path of public folder of UVdesk project

[revsie]

@papnoisanjeev

Thank you again, the others were already at 777 but the public folder wasn't as that wasn't mentioned in the documentation I have read, which may well be the reason the database didn't populate?

I appreciate your help.

[morevnaproject]

Login URl: your_domain/en/member/login (Default URl)

username: admin@admin.com password: password

Hi! I did everything above, but when I trying to login with above credentials it gives me "Incorrect credentials" error. Any help is appreciated!

[papnoisanjeev]

@morevnaproject

Are you getting any error when you are using web installer to setup the project.

[morevnaproject]

@papnoisanjeev Installer fails with an error described in this issue - https://github.com/uvdesk/community-skeleton/issues/290#issue-661916548

[papnoisanjeev]

@morevnaproject

Have you enable all file permissions(read/write permission) which is required. .env and files under config/packages

[morevnaproject]

@papnoisanjeev Yes, did all that and increased max_execution_time too.

[papnoisanjeev]

@morevnaproject

Can you let us know the error you were getting with screenshot. Also you need to restart your server(apache) to reflect changes like max_execution_time

[morevnaproject]

Can you let us know the error you were getting with screenshot.

Also you need to restart your server(apache) to reflect changes like max_execution_time

Yes, I did that.

[morevnaproject]

Okay, I did chmod 777 -R on all files in "uvdesk" installation dir and after that I was able to pass setup successfully. ^__^

[papnoisanjeev]

@morevnaproject

Glad to know that you have successfully setup to installation part. Hope we will get more contribution form your end as well as you done recently for docker file.

[morevnaproject]

My guess is that it was required to add write permissions to some other dirs/files, than .env, var, config and public. I haven't had time to investigate that, so I have added permissions to all dirs/files. Of course it would be nice to figure out which exact dirs need write permissions, but I have no time to investigate that further, unfortunately.

Also, I believe it is better to use chmod -R ugo+rwX instead of chmod 777 -R, as it will avoid making regular files executables.

[papnoisanjeev]

@morevnaproject

I believe it is better to use chmod -R ugo+rwX instead of chmod 777 -R, as it will avoid making regular files executables.

Yes, of course also can use chmod 775 -R

[ericastillo]

Gracias por la información. Mi error es el de la imagen. Sin embargo aun soy nueva en estos temas de importacion de bases de datos, por favor me podrian ayudar enr como puedo importar la la base de datos uvdesk.sql a mysql y la otra pregunta es: interfiere si tienen el mismo nombre de base de datos en el docker-compose.yml, es decir, que ambas se llamen uvdesk? Gracias.

[PeopleInside]

@ericastillo are you sure the database username is root? Seems, from the error message showed, that MySQL credentials are not correct. You can have a database named uvdesk and username of the database same as the database name: should be not a problem.

Are you creating a new UVdesk instance? From your message seems you are asking how to migrate import an existent database.

[ericastillo]

GenteDentro gracias por contestar. Tengo varios dias tratando de solucionar ese problema de conexión. He intentado con el usuario root y con otro usuario que yo creo y en ambos me da el mismo error. Pedi ayuda en soporte de UVDESK y me pasaron a este link, supuse que al cargar la base de datos que indica papniosaanjev uvdesk.sql.zip tal vez se corregiria. He cambiado los datos en el arvhico .env y aun asi no deja desde la pagina localhost:8787. Sin embargo desde un probador de base de datos como lo es DBeaver con el usuario root y erika (usuario alterno) y si me conecta. Pero desde la web no. Una cosa más, parece que mi contenedor no termina como otros que he hecho. Ya no se que hacer llevo 3 meses tratanto de arreglar esto y no se que sea. Y lo malo es que soy principiante en todo este mundo. Usted me podria ayudar por favor? Le comparto una imagen de mi configuracion. Gracias.

[PeopleInside]

Hi @ericastillo I would be happy to try to help you, just need to see what I can I do from here :)

First question: Do you need create a new UVdesk install? If so maybe if you are trying to use the database provided in this issue this is more complicated than create a new empty database.

First of all you need have an empty database and you need creating this in your hosting. In mine for example I can create a database named uvdesk with username uvdesk and with a strong password.

Than when you run the setup wizard that you have attached in your screenshot, you will need use the database username uvdesk , database name uvdesk and the strong password than when you click on next you should not have database connection error.

Oh I see you are trying to use and install UVdesk in localhost. If you still facing issue you can try to reach me in the live chat (when is online) at https://helpdesk.peopleinside.it/it/blog/uv

My time zone is Europe/Rome UTC +2 If the chat is online but I'm unable to reply, please try in another moment.