Forum

Impossible to enter...
 
Notifications
Retirer tout

Impossible to enter date, time and location for a meeting

13 Posts
2 Utilisateurs
0 Reactions
4,373 Vu
(@surfingjack)
Posts: 17
Active Member
Début du sujet
 
[#8465]

Hi,
I'm using 10.0.3 version.
When creating or updating a meeting, impossible to enter :

  • "From" and "to" fields
  • location field

in the database, start and end dates have 0:00:00 time
I did not find a column talking about "location" in the "meeting" table schema.

Thanks !


 
Posté : 2 Sep AM 11:099
(@babynus)
Posts: 14952
Membre Admin
 

Possibly you have an issue ion the description of this table.
Please post DESC for table meeting


 
Posté : 2 Sep PM 14:099
(@surfingjack)
Posts: 17
Active Member
Début du sujet
 

Here is the DESC :
 


 
Posté : 2 Sep PM 14:099
(@babynus)
Posts: 14952
Membre Admin
 

Very strange, you don't have all columns expected on table meeting.
What is your DB / Version ?

Can you try and execute :

ALTER TABLE `meeting` ADD COLUMN meetingStartTime time,
ADD COLUMN meetingEndTime time,
ADD COLUMN location varchar(100);

 
Posté : 2 Sep PM 16:099
(@surfingjack)
Posts: 17
Active Member
Début du sujet
 

I'll try, in fact, Sorry, I was looking the wrong log. I have errors telling these column are missing. I try you script and come back.


 
Posté : 2 Sep PM 16:099
(@surfingjack)
Posts: 17
Active Member
Début du sujet
 

Hi, OK, it works fine now. thanks. Any idea on why these fields was not created ? was it a wrong way from my side ?


 
Posté : 2 Sep PM 16:099
(@babynus)
Posts: 14952
Membre Admin
 

No, I cannot find why this part of script did not execute correctly.
It is strange as it is part of script from version V2.2.0, quite old, and we never had issues on that part.
Do you have logs for Installation of ProjeQtOr (if you installed recently, maybe) ?


 
Posté : 2 Sep PM 16:099
(@surfingjack)
Posts: 17
Active Member
Début du sujet
 

Sure; No error in installing but error while connecting as admin for first time.
Anyway, I tryied a fresh installation from the zip 10.0.3 and this is correct., the fields are there.
I add the installation log.

My other issue, impossible to enter dates and location is still existing after the patch.


 
Posté : 2 Sep PM 16:099
(@surfingjack)
Posts: 17
Active Member
Début du sujet
 

OK i did remove the projeqtor tree and refresh from the zip file and it works fine.
sorry for bothering you. Maybe a problem at installation. Tou can close the ticket; Many thanks and congratulation for your product.


 
Posté : 2 Sep PM 16:099
(@babynus)
Posts: 14952
Membre Admin
 

Very strange
Log shows no error and correct update of table meeting.


 
Posté : 2 Sep PM 19:099
(@surfingjack)
Posts: 17
Active Member
Début du sujet
 

I guess I'll rebuild completely my instance because I still have strange things. Nos I've lost all strings with accents.
I will juste drop this instance and réinstall from scratch projeqtor.
By the Way, is it possible to import timesheets ? I would like to avoid my teams to re-enter all figures.
Thanks !


 
Posté : 2 Sep PM 19:099
(@babynus)
Posts: 14952
Membre Admin
 

You don't need to reinstall from scratch.
You can reimport the DB, just take care of charset conversion.
Check your dump (open it with notepad++) to verify if accents are correct and if file format is UTF8. If not, you should convert before importing.


 
Posté : 2 Sep PM 19:099
(@surfingjack)
Posts: 17
Active Member
Début du sujet
 

Great ! Thanks for the advice. I'll do that tonight or tomorrow.


 
Posté : 2 Sep PM 20:099
Share:
Retour en haut