|
Post by Austinpowers on Jan 26, 2017 17:51:33 GMT -5
Hey everyone!
I took the game down to move over to godaddy cloud. I also did migrate the IP in DNS. We found out that we could not generate core files in any VPS. Godaddy support took 4 hours and a lot of money to tell me this. Today I received an update on my posts from godaddy moderators that no VPS can generate a core file. That effectively takes any troubleshooting down.
I moved us in 30 minutes, and 7 minutes to copy the databases and upload.
the issue is all of a sudden, mysql is throwing an query error. It is the same code we have used for almost a year now. I am debugging it, and once fixed, I will bring it right back up up.
SQL: Error With Query at (sqlcommon.c)sql_real_query:90: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE idnum = 'xxxxxx'' at line 1 (Query: WHERE idnum = 'xxxxx')
I am sorry for this, i will work hard to get this rectified.
AP
|
|
Thf
New Member
Posts: 49
|
Post by Thf on Jan 26, 2017 18:20:35 GMT -5
Thank you for the update Ap as well as your dedicated service to our game. Is there a Paypal donation link or something similar at the JediMud website? JediMud has been great over the years and I would be happy to help sometimes. A fine topic for an Admin meeting otherwise.
|
|
|
Post by Dank on Jan 26, 2017 18:43:17 GMT -5
Thank you for the update Ap as well as your dedicated service to our game. Is there a Paypal donation link or something similar at the JediMud website? JediMud has been great over the years and I would be happy to help sometimes. A fine topic for an Admin meeting otherwise. Yeah, agreed. Gimme a paypal link and get some cash.
|
|
|
Post by Austinpowers on Jan 26, 2017 19:51:53 GMT -5
I believe i have found the problem. The problem is that mariaDB on its update release in the past few days has changed the way it accepts fields. I have to updated every mysql query to use the new format. I am using phpmyadmin to ensure i am using the right format. I am sorry about this.
AP
|
|
|
Post by Austinpowers on Jan 26, 2017 19:52:59 GMT -5
As i talked about this with the Admin, i clearly forgot about donations. The DIKU license clearly states money cannot change hands. The admin reminded me of this little clause
|
|
|
Post by Dank on Jan 26, 2017 21:06:26 GMT -5
Ah right the license.
|
|
|
Post by syllix on Jan 26, 2017 21:20:23 GMT -5
Seems like you may be in SQ-hell...
|
|
Thf
New Member
Posts: 49
|
Post by Thf on Jan 26, 2017 21:36:40 GMT -5
np on the downtime, just gives me time to plot.. I am emailing each copyright holder concerning donations and would be happy to forward any response I receive considering these are the correct addresses:
Sebastian Hammer Prss. Maries Alle 15, 1 1908 Frb. C. DENMARK (email quinn@freja.diku.dk)
Michael Seifert Nr. Soeg. 37C, 1, doer 3 1370 Copenhagen K. DENMARK (email seifert@freja.diku.dk)
Hans Henrik St{rfeldt Langs} 19 3500 V{rl|se DENMARK (email bombman@freja.diku.dk)
Tom Madsen R|de Mellemvej 94B, 64 2300 Copenhagen S. DENMARK (email noop@freja.diku.dk)
Katja Nyboe Kildeg}rdsvej 2 2900 Hellerup 31 62 82 84 DENMARK (email katz@freja.diku.dk)
|
|
|
Post by Austinpowers on Jan 26, 2017 21:49:04 GMT -5
Due to the amount of SQL queries i have to update, i have put the game back up on the old DNS IP. I will fix this over the next few days, but i wont keep the players from having some fun.
|
|
|
Post by Dank on Jan 26, 2017 22:36:29 GMT -5
you rock thanks! now back to transcribing fire balls scrolls off Alhandril.
|
|
Thf
New Member
Posts: 49
|
Post by Thf on Jan 26, 2017 22:39:50 GMT -5
old dns IP anyone?
132.148.86.77 -- got it
|
|
|
Post by Austinpowers on Jan 28, 2017 11:46:28 GMT -5
Now that i got the sql issue ironed out, not even sure why it was doing it. I am fixing some mysql updates the game does, adding some new stuff, fixing some bugs before I update DNS to push over.
AP
PS sorry it is taking so long, I worked from 5:45MA EST yesterday morning til 4:30AM EST this morning.
|
|