search

Arkania / ArkCORE-NG

Cataclysm 4.3.4 emulator.. with archeology..
http://gpn39f.spdns.de/forum1/
GNU General Public License v2.0
71 stars 93 forks source link

World database error #328

Open rezalord12 opened 5 years ago

rezalord12 commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

You can replace

carbon

with

carbon(1)

rezalord12 commented 5 years ago

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

gpn39f commented 5 years ago

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 commented 5 years ago

@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

gpn39f commented 5 years ago

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 commented 5 years ago

@gpn39f

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

Screenshot_20190917_160157

rezalord12 commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

any news about this issue?