name of the team

[Miguel De Gregorio]

Hi
I have updated to the new version and in the option to view a team
the fields appear like this:
computer name ## unknown ## name
hidden team ## unknown ## thide

php / team_show.php? id = 6482

[Gero Kohnert]

Have you run a database update after going to the new version ?
Admin -> Click Database Name -> Tool -> Update
https://<your system="">/php/admin/update.php?id=0</your>

This will fix missing fields in the database.
What version you run now and which one before update ?

[Miguel De Gregorio]

this was my previous version:
TUTOS 1.8.20111223 and it worked great for me

and the current one is:
TUTOS 1.12.20160813

I have updated at the beginning with:
http://arenitaplayita.com/porteno/php/admin/update.php?id=0

after seeing so many corrections in the process I decided to repair and optimize the database (see photo)

In the other options the team names are identified and the system works well (see photo) it is only not seen in the:

team_show.php? id =

also updated now with:

"Admin -> Click on Database Name -> Tool -> Update
https: // <your system=""> / php / admin / update.php? Id = 0 </your> "

see result photo

[Gero Kohnert]

Some things to check:

1) Is the generation of a PDF containing the team info OK. When on the team_show.php page goto menu Views -> PDF
Do you see the name there ?

2) Have you modified the file ...../tutos/db/table.pinc (this file describes how the database should look like) also table_custom.pinc might interfere here.
The section around line 280 in table.pinc should look like this:

$table['team'] = array(
    name => 'teams',
    Desc => 'TUTOS teams',
    'id'       => array(type => 'ID_TYPE',             constraints => 'PK',  Desc => 'Object ID'),
    'name'     => array(type => 'VARCHAR', size => 30, constraints => '',    Desc => 'name',
                        'hideempty' => false,
                        'field'     => 'name',
                        'lang'      => 'TeamName',
        ),
    'comment'  => array(type => 'VARCHAR', size => 90, constraints => '',    Desc => 'comment about team',
                        'hideempty' => true,
                        'field'     => 'comment',
                        'lang'      => 'Comment',
        ),
    'owner'    => array(type => 'ID_TYPE',             constraints => 'NN',  Desc => 'owner ID'),
    'email'    => array(type => 'VARCHAR', size => 60, constraints => '',    Desc => 'email to reach the team',
                        'hideempty' => true,
                        'field'     => 'email',
                        'lang'      => 'AdrEmail',
                        'handler'   => 'email',
        ),
    'hidden'   => array(type => 'ID_TYPE',             constraints => '',    Desc => 'a hidden team',
                        'field'     => 'thide',
                        'lang'      => 'TeamHidden',
                        'ftype'     => 'Boolean'
        ),
    'creator'  => array(type => 'ID_TYPE',             constraints => '',    Desc => 'creator ID'),
    'creation' => array(type => 'TS_TYPE',             constraints => '',    Desc => 'creation date')
    );

3) is there anything worth mentioning (about teams) in your debug.out file (via Admin Page -> Debug&Errors File)

[Miguel De Gregorio]

Hi

1- when generating the PDF for the team_show.php I get this error:

"TCPDF ERROR: [Image] Unable to get image: http://salasituacional.org/locales/php/logo.jpg"

when opening all the administration config they are suspended in
"loading"
and I can't change:
Logo Image URL

2- I am sending you the files of:
table.pinc
table_custom_example.pinc

table_custom.pinc file does not exist in directory

1. I can't locate my debug.out file (via Admin Page -> Debug & Errors File)

[Miguel De Gregorio]

1- how I could not change the url of the logo for the link
/php/admin/main_config.php (won't open)

I made the change in the database in the t_config table
and the PDF works perfectly and the team names if they appear published in the PDF

2- The section around line 280 in table.pinc is the same after checking

3- I can't locate the debug.out file (via the admin page -> Debug and errors file)

4- none of these config links open

..... / php / admin / main_config.php
..... / php / bugtracking / bug_config.php
..... / php / invoice / invoice_config.php
..... / php / timetrack / timetrack_config.php

the only config that works is
..... / porteno / php / file / file_config.php

[Gero Kohnert]

Looks like we should find and enable debugging first.
Ensure that in your php/config.php you have something like
$tutos[debug] = 1;
and
$tutos[errlog] = 'tutos_private/log/debug.out';

This will ensure that you find the output in an subdirectory tutos_private under the installation directory. You will also see a debug section in the admin page.

Please never post urls or config files here in the public discussion. Use email gokohnert@users.sourceforge.net or gero@tutos.org instead

[Miguel De Gregorio]

thank you Gero for answering our little questions about this efficient TUTOS software

continuing with the revision of the update of the latest version of Tutos I have been able to resolve details easily but when one finds errors in the database I will consult

in the section of
"/php/product_show.php?id=8406"

there are 2 invoice summary
the first
"php / invoice / invoice_overview.php? link_id = 8406"

no problem, but the second
"php / invoice / invoice_overview.php? pos_id = 8406"

I get this error:

"You have an error in your SQL syntax; see the manual that corresponds to your MySQL server version for the correct syntax to use near ',,,,) ORDER by name ASC' on line 1
Detail:

SELECT * from invoice WHERE id in (-1 ,,,,,,) ORDER by name ASC "