# \[Archive\] CDO Forum Issues & Site Errors

**URL:** https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638
**Category:** \[Archive\] Website News
**Created:** [4 July 2019 07:23 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638 "2019-07-04T07:23:32Z")
**Posts on this page:** 16
**Page:** 1

<div class="post-metadata">

### Author: ![Nicodemus](https://discourse.chaos-dwarfs.com/user_avatar/discourse.chaos-dwarfs.com/nicodemus/32/18731_2.png) [@Nicodemus](https://discourse.chaos-dwarfs.com/u/Nicodemus)
#### Post date: [4 July 2019 07:23 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/1 "2019-07-04T07:23:32Z")

</div>

**Nicodemus** :

Since mid-June CDO has been experiencing issues with particular areas of the forum. The error message will occur after a new post is made to a forum that someone has subscribed to for updates. You will see something like:

> MySQL error: 1364  
>   
> Field ‘headers’ doesn’t have a default value  
>   
> Query: INSERT INTO mybb\_mailqueue (mailto, mailfrom, subject, message) VALUES (‘someone@mailserver.com’, ‘’, ‘New Thread in Staff’, ‘Username,\n\nNicodemus has just started a new thread in Staff\nThis is a forum you have subscribed to at CDO Forums.\n\nThe thread is titled test2\n\nHere is an excerpt of the message:\n–\nanother test… (visit the thread to read more…)\n–\n\nTo view the thread, you can go to the following URL:\n[CDO Forums](http://www.chaos-dwarfs.com/forum/showthread.php?tid=17921%5Cn%5CnThere) may also be other new threads and replies but you will not receive anymore notifications until you visit the board again.\n\nThank you,\nCDO Forums Staff\n\n------------------------------------------\nUnsubscription Information:\n\nIf you would not like to receive any more notifications of new threads in this forum, visit the following URL in your browser:\n[CDO Forums](http://www.chaos-dwarfs.com/forum/usercp2.php?action=removesubscription&amp;type=forum&amp;fid=17%5Cn%5Cn------------------------------------------)’)

On the server-side it seems that some of the SQL functionality of our host’s server have not been configured correctly, which results in an error message being issued instead of being forwarded to the new post.  
  
While the posts still get created, the error triggers before the form can update the other parts of the site that keep track of the latest posts. As a result you will not be aware of some new posts if you are browsing the forum and clicking the “View Today’s Posts” won’t display these new posts either.  
  
We’ve been aware of this problem since the site was migrated to a new server mid-June and there are several posts behind-the-scenes in the staff and admin sections of the site that most forum members don’t have access to.&nbsp;&nbsp;Xander and I have exchanged text messages about this as well, but it requires some level of involvement from our hosting company as well, which adds to the delays.  
  
Hang in there… we have a very good picture of what the problem is and how to fix it. It’ll just take some time!  
  
Meanwhile, feel free to browse through the forum manually and you may be surprised at a few of the thread contributions hiding here and there!! :hat off  
  
~N

---

<div class="post-metadata">

### Author: ![Nicodemus](https://discourse.chaos-dwarfs.com/user_avatar/discourse.chaos-dwarfs.com/nicodemus/32/18731_2.png) [@Nicodemus](https://discourse.chaos-dwarfs.com/u/Nicodemus)
#### Post date: [4 July 2019 07:24 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/2 "2019-07-04T07:24:29Z")

</div>

**Nicodemus** :

Haha, in fact, I got the error message when I posted this message as well :wink:

---

<div class="post-metadata">

### Author: ![Admiral](https://discourse.chaos-dwarfs.com/user_avatar/discourse.chaos-dwarfs.com/admiral/32/616_2.png) [@Admiral](https://discourse.chaos-dwarfs.com/u/Admiral)
#### Post date: [4 July 2019 08:07 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/3 "2019-07-04T08:07:25Z")

</div>

**Admiral** :

Thank you very much, Nicodemus! Fingers crossed our tech-savants can iron it out. :hat off  
  
And since the forum errors include some threads not updating properly in the forum list: Deadline for the Artisan’s Contest pushed 24 hours. Turned out too busy with work to handle it today, so any revisions and latecomers are welcome.

---

<div class="post-metadata">

### Author: ![tjub](https://discourse.chaos-dwarfs.com/user_avatar/discourse.chaos-dwarfs.com/tjub/32/80_2.png) [@tjub](https://discourse.chaos-dwarfs.com/u/tjub)
#### Post date: [4 July 2019 08:29 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/4 "2019-07-04T08:29:17Z")

</div>

**tjub** :

Great work Nico thanks for keeping us up to date! 🙂

---

<div class="post-metadata">

### Author: ![Jasko](https://discourse.chaos-dwarfs.com/user_avatar/discourse.chaos-dwarfs.com/jasko/32/378_2.png) [@Jasko](https://discourse.chaos-dwarfs.com/u/Jasko)
#### Post date: [4 July 2019 09:40 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/5 "2019-07-04T09:40:18Z")

</div>

**Jasko** :

Thanks for working on this, I was already wondering about the drop in new posts. Well now there is an opportunity to stroll through each and every board for hidden gems :hat off

---

<div class="post-metadata">

### Author: ![Nicodemus](https://discourse.chaos-dwarfs.com/user_avatar/discourse.chaos-dwarfs.com/nicodemus/32/18731_2.png) [@Nicodemus](https://discourse.chaos-dwarfs.com/u/Nicodemus)
#### Post date: [4 July 2019 10:58 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/6 "2019-07-04T10:58:29Z")

</div>

**Nicodemus** :

> Thanks for working on this, I was already wondering about the drop in new posts. Well now there is an opportunity to stroll through each and every board for hidden gems :hat off  
>   
> **Jasko**

At least that was my attempt to put a positive spin on it ;)

---

<div class="post-metadata">

### Author: ![Xander](https://discourse.chaos-dwarfs.com/user_avatar/discourse.chaos-dwarfs.com/xander/32/10_2.png) [@Xander](https://discourse.chaos-dwarfs.com/u/Xander)
#### Post date: [4 July 2019 11:12 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/7 "2019-07-04T11:12:40Z")

</div>

**Xander** :

I’ve submitted a ticket to support, and hopefully they can resolve it. My research suggests it’s a quick settings fix, but I don’t have the required privileges to make the change myself, so I have requested that the host does it for me, stay tuned!

---

<div class="post-metadata">

### Author: ![Nicodemus](https://discourse.chaos-dwarfs.com/user_avatar/discourse.chaos-dwarfs.com/nicodemus/32/18731_2.png) [@Nicodemus](https://discourse.chaos-dwarfs.com/u/Nicodemus)
#### Post date: [5 July 2019 03:35 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/8 "2019-07-05T03:35:40Z")

</div>

**Nicodemus** :

Guess we can add another SQL issue to the list - updating images to the wiki generated:

> Database error  
>   
> A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:  
>   
> &nbsp;&nbsp;&nbsp;&nbsp;(SQL query hidden)  
>   
> from within function “Revision::insertOn”. MySQL returned error “1406: Data too long for column ‘rev\_comment’ at row 1 (localhost)”.

The image update was applied but when the image is clicked there’s an error on the subsequent page indicating that there is data missing… will link in the staff thread.  
  
x.x

---

<div class="post-metadata">

### Author: ![Admiral](https://discourse.chaos-dwarfs.com/user_avatar/discourse.chaos-dwarfs.com/admiral/32/616_2.png) [@Admiral](https://discourse.chaos-dwarfs.com/u/Admiral)
#### Post date: [5 July 2019 09:28 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/9 "2019-07-05T09:28:58Z")

</div>

**Admiral** :

Ouch! When it rains, it pours…  
  
I’m so glad you’re here to try and tackle the issues, Nico. Please know we all value your efforts highly. 🙂  
  
The current site errors means the new voting thread for ACXXVII didn’t get updated in the forum list. [So here it is](http://www.chaos-dwarfs.com/forum/showthread.php?tid=17945), until it happens with the seemingly usual lag.

---

<div class="post-metadata">

### Author: ![Xander](https://discourse.chaos-dwarfs.com/user_avatar/discourse.chaos-dwarfs.com/xander/32/10_2.png) [@Xander](https://discourse.chaos-dwarfs.com/u/Xander)
#### Post date: [6 July 2019 09:48 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/10 "2019-07-06T09:48:19Z")

</div>

**Xander** :

The host has switched us to a new server, so hopefully that clears up the errors!

---

<div class="post-metadata">

### Author: ![Nicodemus](https://discourse.chaos-dwarfs.com/user_avatar/discourse.chaos-dwarfs.com/nicodemus/32/18731_2.png) [@Nicodemus](https://discourse.chaos-dwarfs.com/u/Nicodemus)
#### Post date: [7 July 2019 03:53 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/11 "2019-07-07T03:53:20Z")

</div>

**Nicodemus** :

Some things working, other things still not quite. Wiki is currently unavailable and I can’t seem to figure out where we’re getting redirected to, but it isn’t our index.php page by the look of what’s loading…  
  
If anyone else notices odd behaviour over the next day or so please post it here!  
  
~N

---

<div class="post-metadata">

### Author: ![tjub](https://discourse.chaos-dwarfs.com/user_avatar/discourse.chaos-dwarfs.com/tjub/32/80_2.png) [@tjub](https://discourse.chaos-dwarfs.com/u/tjub)
#### Post date: [7 July 2019 05:27 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/12 "2019-07-07T05:27:28Z")

</div>

**tjub** :

At least the posting bit seems to work now, thanks alot for putting time into this guys!

---

<div class="post-metadata">

### Author: ![Uther.the.unhinged](https://discourse.chaos-dwarfs.com/letter_avatar_proxy/v4/letter/u/c0e974/32.png) [@Uther.the.unhinged](https://discourse.chaos-dwarfs.com/u/Uther.the.unhinged)
#### Post date: [7 July 2019 07:07 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/13 "2019-07-07T07:07:36Z")

</div>

**Uther the unhinged** :

Well done guys. Thank you for what you have done!

---

<div class="post-metadata">

### Author: ![Reaver](https://discourse.chaos-dwarfs.com/user_avatar/discourse.chaos-dwarfs.com/reaver/32/209_2.png) [@Reaver](https://discourse.chaos-dwarfs.com/u/Reaver)
#### Post date: [8 July 2019 03:26 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/14 "2019-07-08T03:26:43Z")

</div>

**Reaver of Uzkulak** :

Thanks for all of the hard work folks, greatly appreciated! :cheers

---

<div class="post-metadata">

### Author: ![Jasko](https://discourse.chaos-dwarfs.com/user_avatar/discourse.chaos-dwarfs.com/jasko/32/378_2.png) [@Jasko](https://discourse.chaos-dwarfs.com/u/Jasko)
#### Post date: [8 July 2019 09:07 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/15 "2019-07-08T09:07:44Z")

</div>

**Jasko** :

> Some things working, other things still not quite.&nbsp;&nbsp;Wiki is currently unavailable and I can't seem to figure out where we're getting redirected to, but it isn't our index.php page by the look of what's loading...  
>   
> If anyone else notices odd behaviour over the next day or so please post it here!  
> ~N  
>   
> **Nicodemus**

Splendid work, Nicodemus! :hat off

---

<div class="post-metadata">

### Author: ![system](https://chaos-dwarfs-uploads.s3.dualstack.eu-west-1.amazonaws.com/original/1X/058cf99fdec95c6eee5c82f87c1a7b1af846a162.png) [@system](https://discourse.chaos-dwarfs.com/u/system)
#### Post date: [8 July 2019 11:51 UTC](https://discourse.chaos-dwarfs.com/t/archive-cdo-forum-issues-site-errors/23638/16 "2019-07-08T11:51:57Z")

</div>

**Parish** :

Thank you guys for the fixes 🙂
