STFU and say these things before I post it ¬¬ We gotta 'commoonicate' whatever that means.
STFU and say these things before I post it ¬¬ We gotta 'commoonicate' whatever that means.
~ Underseas
So.. anyone else having trouble with the files/found a bug? If so, please post here, so we can fix the problem![]()
Line no.:184
Error Code: 1153 - Got a packet bigger than 'max_allowed_packet' bytes
@Zoozlo: You can either split the DB into multiple pieces and install them seperately, or use your mySQL's 'larger' settings. You can find a full explanation on this over on the Project Silvermoon website, I believe.![]()
C & P'ed from projectsilvermoon.net:
here's a guide, too adjust the buffer settings in your mysql, when using the
project silvermoon phoenix .bat tool~
The server's default max_allowed_packet value is 1MB.
it needs to be 32MB
• goto your MySQLMySQL Server 5.0
- make sure you have 5.0 or higher installed
• delete your "my.ini"
• open "my-medium.ini" (with wordpad or notepad)
you will see :
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
change max_allowed_packet = 1M
so it will now show max_allowed_packet = 32M
• then find :
[mysqldump]
quick
max_allowed_packet = 1M
change max_allowed_packet = 1M
so it will now show max_allowed_packet = 32M
• you're done, save & close my-medium.ini
• then rename "my-medium.ini" to "my.ini"
• restart your mysql server (if you dont know how to do that, just reboot your comp)
and there ya go ~
We are looking for members to join us and help create even more awesome. We have some good things planned, but need more people to make it happen.
If you feel like helping please PM me or Utsjitimmie.
~ Underseas
Hey guys,
First off, I want to say thank you for continuing work on this project. It is by far one of my favorite DBs to use.
That being said, I have a simple, sort of "noobish" question for you guys. How exactly do I get the Org Fireworks show to work? I executed the necessary SQL files and I put the LUA fils in the ArcEmu scripts folder.
Everything else is working completely fine. I installed all of the custom areas, two of the obstacle courses and all of the events. I just can't seem to get those darn fireworks to... well, work! Any Ideas?
Last edited by Nikogrom; 09-26-2008 at 09:47 PM.
Either go somewhere on your own and spawn the creature 10002683, if you have installed the staff npc correctly then you will be able to speak with him, then enter a password for the fireworks. Or recall port to gmmap0 or 1.
You must have staff npc, configs and orgrimmar fireworks scripts in your /Scripts directory for it to work.
If you don't know the password for starting the event, see PS FUNDB - Events - Configs.lua, default is areafun.
~ Underseas
Like itkeep them coming just love it
i shi ! *
Hello chrispee
and guys, GG make more epix dbs![]()
Why fill up a signature?
I'm glad to see some positive feedback at last.. However last week I quit the team due to nobody actually liking it and or even being bothered to comment positively on it, as far as I know Utsjitimmie is now the only member actively working on the database.
Some good things are on their way to you, but that's still quite a wait.
~ Underseas
I'm sorry to hear that you quit the team. As far as these forums go, and as far as I can tell, you're one of the most helpful of the PS team.
I think the lack in comments and feedback has to do with the fact that you are doing the whole "SVN" thing now. I'm not saying that it would be good to not use SVN. I'm just pointing out that there are still many people who don't know how to do it and/or are too lazy to take the time to learn it. Personally, I love it.
Anyways, I hope to see some more positive feedback and such. PSFDB is by far my favorite FunDB out there.
I have a small question, i used a AC Web Ultimate Repack (v.7.in form of an .exe file so it installed everything for me but the database was made for 2.4.2 so i downloaded PsFDB and executed it into my "ascent" database but when i start my ascent-world.exe i get an error saying "one of you creature_spawns table has the wrong column count.
Ascent has skipped loading this table in order to avoid crashin.
Please correct this, if you do not no spawns will show."
AND when i press ok and it loads the rest up and then try to login to the server i can chose realm but then it stops at "connected"
What can be my problem? i really need profesional help here, since im still a bit of noob at the whole emu thing so far.
Thanks in advance /Henka44
Hm.. Make sure you update the db with arcemu's sql updates.