I have a little problem with my MySQL database with PhpMyAdmin for administration.
When I create a table with several rows at the same time, I always have this type of error when I go to the structure tab of my table in the PhpMyAdmin panel. I don’t know how to fix it, because when I create line by line, it works well.
I suggest showing you all the settings on my tab: There are some French, because I'm French!
Titre_de_l_album
Column Type Null Default Links to Comments
id (Primary) int(11) No
artiste varchar(20) Yes NULL
album varchar(20) Yes NULL
annee int(4) Yes NULL
pistes int(11) Yes NULL
duree int(11) Yes NULL
Indexes
Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id 0 A No
Space usage:
Data 0 B
Index 0 B
Total 0 B
Row Statistics:
Open new phpMyAdmin window
Warning in ./libraries/tbl_printview.lib.php
Illegal string offset 'Data_length'
Backtrace
./libraries/tbl_printview.lib.php
string '',
string 'Album_TAR',
string 'Titre_de_l_album',
string 'left',
)
./libraries/tbl_printview.lib.php
boolean true,
boolean false,
array,
array,
array,
string 'Album_TAR',
string 'Titre_de_l_album',
array,
array,
string '',
string 'left',
)
./tbl_printview.php
array,
string 'Album_TAR',
array,
array,
string 'left',
)
Notice in ./libraries/tbl_printview.lib.php
Uninitialized string offset: 0
Backtrace
./libraries/tbl_printview.lib.php
string '',
string 'Album_TAR',
string 'Titre_de_l_album',
string 'left',
)
./libraries/tbl_printview.lib.php
boolean true,
boolean false,
array,
array,
array,
string 'Album_TAR',
string 'Titre_de_l_album',
array,
array,
string '',
string 'left',
)
./tbl_printview.php
array,
string 'Album_TAR',
array,
array,
string 'left',
)
Warning in ./libraries/tbl_printview.lib.php
Illegal string offset 'Index_length'
Backtrace
./libraries/tbl_printview.lib.php
string '',
string 'Album_TAR',
string 'Titre_de_l_album',
string 'left',
)
./libraries/tbl_printview.lib.php
boolean true,
boolean false,
array,
array,
array,
string 'Album_TAR',
string 'Titre_de_l_album',
array,
array,
string '',
string 'left',
)
./tbl_printview.php
array,
string 'Album_TAR',
array,
array,
string 'left',
)
Notice in ./libraries/tbl_printview.lib.php
Uninitialized string offset: 0
Backtrace
./libraries/tbl_printview.lib.php
string '',
string 'Album_TAR',
string 'Titre_de_l_album',
string 'left',
)
./libraries/tbl_printview.lib.php
boolean true,
boolean false,
array,
array,
array,
string 'Album_TAR',
string 'Titre_de_l_album',
array,
array,
string '',
string 'left',
)
./tbl_printview.php
array,
string 'Album_TAR',
array,
array,
string 'left',
)
Warning in ./libraries/tbl_printview.lib.php
Illegal string offset 'Data_length'
Backtrace
./libraries/tbl_printview.lib.php
string '',
string 'Album_TAR',
string 'Titre_de_l_album',
string 'left',
)
./libraries/tbl_printview.lib.php
boolean true,
boolean false,
array,
array,
array,
string 'Album_TAR',
string 'Titre_de_l_album',
array,
array,
string '',
string 'left',
)
./tbl_printview.php
array,
string 'Album_TAR',
array,
array,
string 'left',
)
Notice in ./libraries/tbl_printview.lib.php
Uninitialized string offset: 0
Backtrace
./libraries/tbl_printview.lib.php
string '',
string 'Album_TAR',
string 'Titre_de_l_album',
string 'left',
)
./libraries/tbl_printview.lib.php
boolean true,
boolean false,
array,
array,
array,
string 'Album_TAR',
string 'Titre_de_l_album',
array,
array,
string '',
string 'left',
)
./tbl_printview.php
array,
string 'Album_TAR',
array,
array,
string 'left',
)
Warning in ./libraries/tbl_printview.lib.php
Illegal string offset 'Index_length'
Backtrace
./libraries/tbl_printview.lib.php
string '',
string 'Album_TAR',
string 'Titre_de_l_album',
string 'left',
)
./libraries/tbl_printview.lib.php
boolean true,
boolean false,
array,
array,
array,
string 'Album_TAR',
string 'Titre_de_l_album',
array,
array,
string '',
string 'left',
)
./tbl_printview.php
array,
string 'Album_TAR',
array,
array,
string 'left',
)
Warning in ./libraries/tbl_printview.lib.php
Illegal string offset 'Data_length'
Backtrace
./libraries/tbl_printview.lib.php
string '',
string 'Album_TAR',
string 'Titre_de_l_album',
string 'left',
)
./libraries/tbl_printview.lib.php
boolean true,
boolean false,
array,
array,
array,
string 'Album_TAR',
string 'Titre_de_l_album',
array,
array,
string '',
string 'left',
)
./tbl_printview.php
array,
string 'Album_TAR',
array,
array,
string 'left',
)
Notice in ./libraries/tbl_printview.lib.php
Uninitialized string offset: 0
Backtrace
./libraries/tbl_printview.lib.php
string '',
string 'Album_TAR',
string 'Titre_de_l_album',
string 'left',
)
./libraries/tbl_printview.lib.php
boolean true,
boolean false,
array,
array,
array,
string 'Album_TAR',
string 'Titre_de_l_album',
array,
array,
string '',
string 'left',
)
./tbl_printview.php
array,
string 'Album_TAR',
array,
array,
string 'left',
)
Warning in ./libraries/tbl_printview.lib.php
Illegal string offset 'Index_length'
Backtrace
./libraries/tbl_printview.lib.php
string '',
string 'Album_TAR',
string 'Titre_de_l_album',
string 'left',
)
./libraries/tbl_printview.lib.php
boolean true,
boolean false,
array,
array,
array,
string 'Album_TAR',
string 'Titre_de_l_album',
array,
array,
string '',
string 'left',
)
./tbl_printview.php
array,
string 'Album_TAR',
array,
array,
string 'left',
)
Automatically send report next time
Thank you for your help. PS: I see other topics about this, but I could not fix it, because it is only with Php
EDIT : how do I make this mistake
- Create a new database
Album_TAR Titre_de_l_album 6- :
- id, int, Primary, A_I
- Artiste, varchar, 20
- , varchar, 20
- Annee, int, 4
- Nombre, int
- Duree, int
,