ace104th Posted July 12, 2020 Report Share Posted July 12, 2020 Way every time I try to upload my list of fleet in my phpvms via using CSV file it always comes up with the name/type as my airline ICAO not the airplane as seen in these photo any ideas https://prntscr.com/tg60mz https://prntscr.com/tg60l4 Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted July 12, 2020 Administrators Report Share Posted July 12, 2020 phpVMS version? PHP version? MySQL or MariaDB version? Free or paid hosting? Quote Link to comment Share on other sites More sharing options...
ace104th Posted July 12, 2020 Author Report Share Posted July 12, 2020 Version 5.5.2.72 PHP Version7.0.33 MySQL Version10.0.38-MariaDB paid hosting not free Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted July 12, 2020 Administrators Report Share Posted July 12, 2020 What program and version are you using to save as a comma delimited CSV file? Make another file that includes only 2 aircraft and attempt to import that CSV. Post results here. Any chance you can change to MariaDB10.1 or MySQL 5.6 ? There may be some incompatibilities between MariaDB 10.0.38 and MySQL 5.6 - phpVMS 5.5.2.72 was only tested on MySQL 5.6 Quote Incompatibilities between Currently Unsupported MariaDB Versions and MySQL¶ Incompatibilities between MariaDB 10.0 and MySQL 5.6 MySQL does not support MariaDB's Spider Storage Engine. All MySQL binaries (mysqld, myisamchk etc.) give a warning if one uses a prefix of an option (such as --big-table instead of --big-tables). MariaDB binaries work in the same way as most other Unix commands and don't give warnings when using unique prefixes. MariaDB GTID is not compatible with MySQL 5.6. This means that one can't have MySQL 5.6 as a slave for MariaDB 10.0. However MariaDB 10.0 can be a slave of MySQL 5.6 or any earlier MySQL/MariaDB version. Note that MariaDB and MySQL also have different GTID system variables, so these need to be adjusted when migrating. MariaDB 10.0 multi-source replication is not supported in MySQL 5.6. To make CREATE TABLE ... SELECT work the same way in statement based and row based replication it's by default executed as CREATE OR REPLACE TABLE on the slave. One benefit of this is that if the slave dies in the middle of CREATE ... SELECT it will be able to continue. One can use the slave-ddl-exec-mode variable to specify how CREATE TABLE and DROP TABLE is replicated. See also a detailed breakdown of System variable differences between MariaDB 10.0 and MySQL 5.6. MySQL 5.6 has performance schema enabled by default. For performance reasons MariaDB 10.0 has it disabled by default. You can enable it by starting mysqld with the option --performance-schema. MariaDB 10.0 does not support the MySQL Memcached plugin. However, data stored using memcached can be retrieved because the data is stored as InnoDB tables. MariaDB is able to start successfully with an error message of not being able to find libmemcached.so library. Users created with MySQL's SHA256 password algorithm cannot be used in MariaDB 10.0 as MariaDB does not include MySQL's sha256_password plugin. MariaDB 10.0 does not support delayed replication - MDEV-7145. Also see a detailed breakdown of System variable differences between MariaDB 10.0 and MySQL 5.6. The low-level temporal format used by TIME, DATETIME and TIMESTAMP is different in MySQL 5.6 and MariaDB 10.0. (In MariaDB 10.1, the MySQL implementation is used by default - see mysql56_temporal_format.) MariaDB implements some changes in the SQL query optimizer over what's available in MySQL. This can result in EXPLAIN statements showing different plans. MySQL delayed replication, (through MASTER_DELAY), is not supported in MariaDB 10.0, it was implemented in MariaDB 10.2.5 Quote Link to comment Share on other sites More sharing options...
ace104th Posted July 12, 2020 Author Report Share Posted July 12, 2020 39 minutes ago, ProAvia said: What program and version are you using to save as a comma delimited CSV file? Make another file that includes only 2 aircraft and attempt to import that CSV. Post results here. Any chance you can change to MariaDB10.1 or MySQL 5.6 ? There may be some incompatibilities between MariaDB 10.0.38 and MySQL 5.6 - phpVMS 5.5.2.72 was only tested on MySQL 5.6 Windwos Excel for CVS I dont think i can change MariaDC10.1 to MySQL5.6 Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted July 12, 2020 Administrators Report Share Posted July 12, 2020 Verify which version of MariaDB you have. In one reply you said 10.0.38 and your last reply referenced changing from MariaDB 10.1 . Is it MariaDB 10.0.38 or MariaDB 10.1 ?? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.