Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

SQLSTATE[42000]: Sy...
 
Notifications
Clear all

SQLSTATE[42000]: Syntax error or access violation:

5 Posts
3 Users
0 Reactions
2,182 Views
(@maxiac)
Posts: 2
New Member
Topic starter
 
[#6446]

Hi, I have a problem installing projeqtor.
I have to use a database with a specific name that must be indicated with the first letter in upper case.
In the installation procedure the first letter is changed to lower case.

I can't change the name of the database. Is there a way to edit or configure the database name directly manually?

thank you very much


 
Posted : 14 Jan 2020 15H03
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

in file parameters.php
defaut locatrion is files/config, but it may be changed. To find location, look at tool/paramertersLocation.php


 
Posted : 15 Jan 2020 16H07
Damian
(@damian-sd)
Posts: 119
Active Member Admin Registered
 

Hello,

you can change the db name in Projeqtor parameters files,
go to : Projeqtor/files/config/parameters.php
change value of "$paramDbName", save and refresh Projeqtor.


 
Posted : 15 Jan 2020 16H17
(@maxiac)
Posts: 2
New Member
Topic starter
 

in the tool folder there is no parameterLocation.php file, in the files folder there is no config.php file. Probably why the installation procedure is not completed?


 
Posted : 18 Jan 2020 20H46
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

In file tool/configCheck.php, change line 41, from

  $param['DbName']=strtolower($param['DbName']);

to

  $param['DbName']=strtolower($param['DbName']);

This should allow you to complete installation


 
Posted : 18 Jan 2020 22H00
Share:

Scroll to Top