ArkCORE-NG icon indicating copy to clipboard operation
ArkCORE-NG copied to clipboard

World database error

Open rezalord12 opened this issue 5 years ago • 10 comments

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

rezalord12 avatar Sep 16 '19 04:09 rezalord12

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

gpn39f avatar Sep 16 '19 04:09 gpn39f

You can replace

carbon

with

carbon(1)

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

rezalord12 avatar Sep 16 '19 06:09 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.

gpn39f avatar Sep 17 '19 08:09 gpn39f

@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'

Screenshot_20190917_141543

but with xampp on windows 10 work perfectly

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??

gpn39f avatar Sep 17 '19 11:09 gpn39f

@gpn39f

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

Screenshot_20190917_160157

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

rezalord12 avatar Sep 17 '19 13:09 rezalord12

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.

gpn39f avatar Sep 17 '19 15:09 gpn39f

any news about this issue?

rezalord12 avatar Sep 22 '19 03:09 rezalord12