Hi there i got new problem now when i try to armorysync memberlist is just goes fine but when i try to armorysync guild it gives me a mysql error


ps: why the realm status dont show as online?

Well,
You have the answer right in front of you.

Search this text in the error dialog box & read very slowly "SQL server has gone away" (because, I agree, it cryptic).
This means that the communication between your web server and your SQL server died.

This is might be a hosting problem, a far too complicated SQL statement (very long treatment, which is not the case here), and normally it indicated that your SQL is overloaded, the connection times out.
On a shared server, your not the ONLY user – there can be many more.

One thing for sure: this has nothing to do with the Armory Addon.




PS : Instead of hitting PrintScreen for every question and paste the entire image on the net, why not starting paint, do a Paste and select the important part of it.
This make the image smaller and more clear, doesn't blow up this forum layout, speed the transfert time (discharges the web server of WowRoster, which makes its SQL connexions more stable ), making having you having an answer faster ^^

i think i got a solution.
if i install mysql in my home computer and apache and etcs i could put the database in mysql then export it to a sql file and upload it to the web hoster and it would work?

Possible.

The installer creats some SQL tables, and fills them up with some initial information.
This will happen also later on. For example, when activating a WoWRoster addon/plugin.

Btw : Upping your exported SQL tables (the dump) from your PC to your host will do the same thing as the installer does.

Sounds to me like the server timed out. AS waits a lot. If AS is waiting for a minute to get around the DDOS filter, it won't access the database for that minute. If the mysql timeout is set to less than a minute, then the connection will be gone when AS tries to use it again.

I can think of two possible solutions if this is the case:
- Increase mysql connection timeout
- Modify AS to optionally reconnect if the connection has timed out.

how do i do that?
ps the error appears after about 10 seconds when i start