World database error

[rezalord12]

Hi
When i import this world database (https://drive.google.com/drive/folders/1tJ3uh0O2pU6vaPeS3cvuq4LAywIekoJY) i get this errors

ERROR 1067 (42000) at line 1742674: Invalid default value for 'start_time'
ERROR 1067 (42000) at line 1742675: Invalid default value for 'end_time'
ERROR 1054 (42S22) at line 2657699: Unknown column 'npc_entry' in 'field list'

And i use mariadb Ver 15.1 Distrib 10.4.7-MariaDB

[gpn39f]

before it was allowed to use 0 as default time value.
it seems this is obsolete now, you have to give a valid date info, from 1 Jan 1970 to 20??
i will look at this

[old-intelligentquantum-boycott]

You can replace

with

[rezalord12]

tnx but still i have this error ERROR 1054 (42S22) at line 2657699: Unknown column 'npc_entry' in 'field list'

[gpn39f]

i have uploaded new SnapShot to my google drive..
it's changed the date value back to '0000-0-0 00:00:00'
it's changed my prevered database name to ang434_xxx

it's not possible that you have the error with the npc_entry !!!!!
you are possible using a old, own database structure..
pls. use the file as is, then u can use HeidiSQL to copy/paste from ang434_xxx databases to youre own choose. this prevent language problems to.

[old-intelligentquantum-boycott]

@gpn39f confirm!! i have this error

Mariadb Version: mysql Ver 15.1 Distrib 10.4.8-MariaDB, for Linux (x86_64) using readline 5.1

1: mysql -uroot -proot ang434_world < ang434_world.sql
ERROR 1054 (42S22) at line 2657672: Unknown column 'npc_entry' in 'field list'

but with xampp on windows 10 work perfectly

[gpn39f]

this is part of a stored procedure.
this is not being changed last 10 Years
and i have no skill to change this, the names are given by table and by core, so this have to go.
so you have to use other tools to import the sql file,
what is with phpMyAdmin??

[old-intelligentquantum-boycott]

@gpn39f

with phpMyAdmin and heidisql i have this error i dont know why.
on windows i dont have any error.

[rezalord12]

i have uploaded new SnapShot to my google drive..
it's changed the date value back to '0000-0-0 00:00:00'
it's changed my prevered database name to ang434_xxx

it's not possible that you have the error with the npc_entry !!!!!
you are possible using a old, own database structure..
pls. use the file as is, then u can use HeidiSQL to copy/paste from ang434_xxx databases to youre own choose. this prevent language problems to.

still I have error on ubuntu 19.4 i use this world database https://drive.google.com/drive/folders/1TDw8Xf05XbLrebMYXAM2Fd92EuLh2y4j

[gpn39f]

This is exported with HeidSQL. The other with Navicat. Both are using MariaDB as MySQL do.. So i have no chance for give u a "better" packet. You have to use other tools for import. More Help has to come from other Linux member.

[rezalord12]

any news about this issue?