Sample project, Project management -PROBLEM

Scriptcase 8 Discussion
#1

Hello,

Im trying to install using the automatic installation the project management sample project. Im getting following error when pressing the “add resource” application, unknown column “fld_name” in fieldlist (link to picture below).

http://postimg.org/image/sa02twk4l/

So, i started to look for the problem and i noticed that the table that the automatic installation create is below

http://postimg.org/image/x9l5igt1t/

It will create column name “name” instaid of “fld_name”.

So im asking is there somekind of solution for this? Do you have the same problem? And this is not the only location of tables where the “name” column messing up the “fld_name” error.

#2

The main problem is that the samples are old and you will run into some issues using them. In this case I would change the field name in your database with the Database Builder. Modern versions of MySQL are case-sensitive for tablenames (thank you oracle :frowning: ) and you might need to change the tablename somewhere. Not sure if this is in the pm sample btw.

#3

They’re old indeed.
But we have a team working on all samples projects we provide. Trying to update and fix everything there.

We have some hard work there since the samples have to work with all languages, databases and OS we support.