i've got some NPCs not having a dialog so we can't complete quests as well. In the NE starting area.
i've got some NPCs not having a dialog so we can't complete quests as well. In the NE starting area.
I am trying to use the upgrade 10764_01_mangos_spell_proc_event.sql from the upgrades folder because after I imported my old backup db's I got this error:
SQL: SELECT required_10764_01_mangos_spell_proc_event FROM db_version LIMIT 1
query ERROR: Unknown column 'required_10764_01_mangos_spell_proc_event' in 'field list'
The table `db_version` in your [WORLD] database indicates that this database is out of date!
[A] You have: --> `10314_02_mangos_command.sql`
[B] You need: --> `10764_01_mangos_spell_proc_event.sql`
You must apply all updates after [A] to [B] to use mangos with this database.
These updates are included in the sql/updates folder.
Please read the included [README] in sql/updates for instructions on updating.
So now that I try to do the update using sqlyog, I select restore from sql dump and then select that file and I get this error:
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_10160_02_characters_pet_aura required_10254_01_characters_auctionhouse bit
Error occured at:2011-02-10 22:31:06
Line no.:2
Error Code: 1054 - Unknown column 'required_10160_02_characters_pet_aura' in 'character_db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_10762_01_mangos_spell_proc_event required_10764_01_mangos_spell_proc_event bit
Error occured at:2011-02-11 00:23:40
Line no.:1
Error Code: 1054 - Unknown column 'required_10762_01_mangos_spell_proc_event' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_10762_01_mangos_spell_proc_event required_10764_01_mangos_spell_proc_event bit
Error occured at:2011-02-11 00:24:09
Line no.:1
Error Code: 1054 - Unknown column 'required_10762_01_mangos_spell_proc_event' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_10762_01_mangos_spell_proc_event required_10764_01_mangos_spell_proc_event bit
Error occured at:2011-02-11 02:31:07
Line no.:1
Error Code: 1054 - Unknown column 'required_10762_01_mangos_spell_proc_event' in 'db_version'
Can anyone tell me why these tables are non existent if I am supposed to be using this upgrade file? It doesn't make sense.
Last edited by zothecula; 11-02-11 at 08:35 AM. Reason: Fixed first prob
This is because you need to update your DB version manually to the number of version you want to update.Originally Posted by zothecula
EDIT: When will Amber for 4.x?
Last edited by Snowmane; 11-02-11 at 12:33 PM.
I am not sure what you mean by I need to update my DB version manually? Can you explain please, thanks.
Does this server have Frostmourne item ???
I have this problem in the past...
In your Navicat or SQLYog find for the DB version tables that causes error.
Edit this tables and change to the number of version to update.
Of course, first of all make a security copy of your DB's.
Great work , the release 4.x.x of amber is next developement?
will be there some update dbs release ?
I'm using win7 and when I try to start AmberGUI it crashes immidiatly!How to fix that? Plz help me...
Try running the Amber startup as administrator (right click the icon, the select "run as administrator"), you can also set the program to run as administrator by default in the program properties. Hope this helps:)
timeout trigged in start_dbserver() and when i`m instaling .. the program gives me a error he can not instal.. :(
[01:58:11] Settings loaded from inifile...
[01:58:12] Initialised...
[01:58:18] Starting database server...
[01:58:49] [Error:] timeout trigger hit in start_dbserver()
[01:58:49] Starting webserver...
[01:58:57] Apache [pID:3324] started...
[01:58:57] using child process [pID:3372]...
[01:58:57] on port: 80
[01:58:57] Apache child process [pID:3372] terminated...
[01:58:57] Apache [pID:3324] terminated...
[01:58:57] mysqld-opt [pID:2756] terminated...
[01:58:57] Unhandled thread exception logged to err.txt
When i open amber in safe mod it works.. in normal mode it`s giving me this error :(
anyone know how could i solve this problem ?
Last edited by arhicon; 28-02-11 at 12:59 AM.
ckclyde no work
---------- Post added at 06:30 PM ---------- Previous post was at 06:29 PM ----------
I'm using win7 and when I try to start AmberGUI it crashes immidiatly!How to fix that? Plz help me...
Open amber.ini and change the gui_opacity_val to 1
gui_opacity_val=1
my problem is some of the mobs/boss in the instances in northend, when they get hit, they jump and dissappear
