Error - Field 'specialty' doesn't have a default value

[Envomni]

WinXP Pro Sp2
Apache 2.2.3
MySQL 4.1.7 (API)
PHP 5.1.4
LOTGD 1.1.0

Finally get through all the setup stages. Go to create a new account, get this error. Search of the forums/faq has no answers for what this is or how to fix it. Just 3 posts that mention the line 192 peice, but no replies on how to fix it. No mention of this "specialty" specific error anywhere in the forums either.


Field 'specialty' doesn't have a default value
Call Stack:
1: db_query("INSERT INTO accounts ...") called from
(path edited out)\games\lotgd\create.php on line 192

[Sanctum]

Not sure why it would do that, but you can try just going into your mySQL database and giving that field a default value.. I would just make it 0.

[Envomni]

The table has no entries at all. This is just after installling. I shouldn't be manually entering single fields of data - thats what the game is supposed to do for you as you create a new account. The specialty field is, I suspect, the classic "warrior/mage/theif" class you are supposed to be choosing from. But all I'm getting prompted for in the first creation screen is my player name, password, and sex - nothing of the class yet. But here it seems the game is trying to write to the user file without that information and so it crashes.

[Sanctum]

I didn't tell you to create the field, I said to put in a default value. Now if there is no field specialty then you're out of look, but I'm guessing you didn't check yet, and you don't put anything in the first selection screen for your specialty, you pick that after you have logged in.

[Envomni]

No9 no.. I was saying I shouldn't be having to manually enter a value for that field. Its supposed to be a peice of info the game puts in, not me.

I wouldn't know what value I could even put in there, I don't know what a valid entry should be.

This is really getting rediculous. I spent the day switching over to Apache from Xitami to see if things would be any better (because it wouldn't go past stage 8 of the install), and all I got was one more step forward, then a whole new bug appears in this thing that brings it to a halt.

[Elessa]

i am finding it mystifying that ye are having so much difficulty with installation and setup where so many other hath not had any issues at all. 

yea, there are questions here and there, but an insignifcant number when compared with the nearly 10,000 combined downloads of the game source code between version 1.0.6 and 1.1.0.

i wish i had an anwer for why this is so ye could get the game up and running smoothly.

[Talisman]

The problems you've been having are pretty much unique to you, as has been mentioned a couple times already.  It could be a result of the version of mySQL you're running, or some settings you've made.

What you might want to try is to setup services on a Win XP box using a package like EasyPHP or xampp, and install LOGD on that.  If nothing else, that will show you that it actually does work as advertised.  You might be able to compare your configurations from there, and find the problem with your setup.

[Catscradler]

PHP has two extensions for MySQL support: MySQL and MySQLi (improved).

You may want to try changing the configuration of your setup to use whichever one it's not using right now.  (If that is indeed what's happening.)


EDIT: If this is indeed the solution, it might involve wiping your database and doing a fresh LoGD install.

[Envomni]

Tried the mysql and mysqli versions, no difference. I've re-installed from scratch over a dozen times now.

Can someone give me a list of their running versions for
PHP
MySQL
Apache

The only thing it could possibly be at this point is something to do with the latest version of mysql5 or php5 not being able to work with lotgd 1.1.0

I mean come on, I went through an entire process of installing a whole new server system (Apache over Xitami) to try to make this work. This cannot just be me. I've put alot of testing into this and there's no way its just something local to me when everything on my system is entirely different many times around.

[Talisman]

I hate to say it, but considering how many people have downloaded and installed the game on any number of different platforms, and this forum generally being the focal point of all help requests, if there was a more global problem I'm sure we would have heard of it by now.

Unfortunately, you're the first.  Our goal is the same as yours - to help you get it running, and learn from the experience in case someone else has the same problem...so rest assured that we're on your side with this.

My webhost is running on:

Linux Kernel version 2.6.17.1
Machine type:  i686
Apache:  1.3.36 (Unix)
PERL: 5.8.7
PHP:  4.4.2
MySQL: 4.1.19-standard

On my local machine, I'm running Win XP Pro SP2 and using the EasyPHP installation of Apache/PHP/mySQL, and have never experienced problems of the nature you're encountering.

[kickme]

My host is almost the same. I just have an earlier kernel, and have never had this problem.

[XChrisX]

This "field_name has no default value" is a typical mysql5 error.

By now, mysql5 is not fully supported, but you might solve this, by editting all tables and adding appropriate default values.

EDIT: Aaaah. Okay, you found the solution (just read the other thread now...)