DragonPrime - LoGD Resource Community
Welcome Guest
  • Good morning, Guest.
    Please log in, or register.
  • May 22, 2019, 06:09:05 AM
Home Forums News Downloads Login Register Advanced Search
* * *
DragonPrime Menu
Login
 
 
Resource Pages
Search

Pages: [1]   Go Down
  Print  
Author Topic: Probleme with create.php  (Read 2656 times)
0 Members and 1 Guest are viewing this topic.
Sacha Fournier
Guest
« on: January 17, 2006, 12:55:00 PM »

Hi,

I've gone throught all logd installation steps including Apache 2, Mysql 5.1 and PHP5. Everything works fine. I've also gone throught installer.php and didn't get any problems. But when I try to create a new character, I get this error

Field 'specialty' doesn't have a default value
Call Stack:
1: db_query("INSERT INTO isi_accounts ...") called from C:\Program Files\Apache Group\Apache2\htdocs\lotgd-1.0.6\create.php on line 189

I took a look at the code and table structure and notice that a lots of non null collumns is not inserted when creating a new character in create.php

Any ideas ?
Logged
XChrisX
Global Moderator
Mod God
*****
Offline Offline

Posts: 4647

Be aware of the squirrel!


View Profile WWW
« Reply #1 on: January 17, 2006, 09:12:04 PM »

There are some differences between mysql4 and mysql5. Besides others, in mysql4 certain fieldtypes must not have a default value whereas mysql5 allows and requires this.

You'd have to go to you database and manually add empty default values (DEFAULT = '') for those fields.
Logged

Running for more than three years now:
Sacha Fournier
Guest
« Reply #2 on: January 18, 2006, 05:13:55 AM »

Ok. I'll try to replace Mysql 5 to MySQL 4 tonight and let you know. Thanks.
Logged
sachafournier
Guest
« Reply #3 on: January 19, 2006, 06:59:27 AM »

Hey ! That was the problem. It's working now. Thank you.
Logged
XChrisX
Global Moderator
Mod God
*****
Offline Offline

Posts: 4647

Be aware of the squirrel!


View Profile WWW
« Reply #4 on: January 19, 2006, 07:01:04 AM »

I'm glad, I could help Smiley
Logged

Running for more than three years now:
Pages: [1]   Go Up
  Print  
 
Jump to:  


*
DragonPrime Notices
Play LoGD on Dragonprime

Support Us
No funds raised yet this year
Your help is greatly appreciated!
Recent Topics
DragonPrime LoGD
Who's Online
113 Guests, 0 Users
Home Forums News Downloads Login Register Advanced Search