#138 can not add new contacts

v1.0_(example)
closed
nobody
6
2012-10-29
2012-10-15
Bauer
No

With respect to version 8.1.15 there is a discrepance between the file addressbook.sql creating a database with fields im, im2, im3 and the INSERT-command in file "include\address.class.php" (line 86) which does not care for this fields. As a workaround the lines regarding im can be removed from addressbook.sql prior creating the database. As long as this discrepancy is not removed it is not possible to add or edit entries.

Discussion

  • chatelao
    chatelao
    2012-10-15

    Hi. there should be no issue with this columns.
    => What was the error displayed?

     
  • Bauer
    Bauer
    2012-10-15

    There is no error message displayed. After filling out the form (edit.php) and clicking to the "save"-button the homepage (index.php) is displayed but without the newly enterred address. (Even if I create an entry using php MyAdmin, this entry is displayed on the homepage correctly but - after editing and saving - the entry disappears.)
    If I debug and capture the INSERT SQL-Statement (include\address.class.php line 73) and try to enter the command manually at a mysql prompt I get the following result:

    mysql> INSERT INTO addressbook ( domain_id, id, firstname, lastname, nickname, c
    ompany, title, address, home, mobile, work, fax, email, email2, email3, homepage
    , aday, amonth, ayear, bday, bmonth, byear, address2, phone2, photo, notes, crea
    ted, modified) SELECT 0 domain_id , ifnull(max(id),0)+1 id , 'test' firstname ,
    'test' lastname , '' nickname , '' company , '' title , '' address , '' home , '
    ' mobile , '' work , '' fax , '' email , '' email2 , '' email3 , '' homepage , '
    1' aday , '-' amonth , '' ayear , '1' bday , '-' bmonth , '' byear , '' address2
    , '' phone2 , '' photo , '' notes , now(), now() FROM addressbook;
    ERROR 1364 (HY000): Field 'im' doesn't have a default value

    The system is a Windows IIS 6.1 with PHP Version 5.3.15 and 5.5.28 MySQL Community Server (GPL).

     
  • Bauer
    Bauer
    2012-10-18

    The configuration "innodb_strict_mode" is not used but the MySQL ini-file (my.ini) contains

    [mysqld]
    sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

    If the STRICT_TRANS_TABLES is removed the problem dissapears and new entries can be added without problem.

    The configuration of MySQL for Windows was out of the box (http://dev.mysql.com/downloads/mysql/) without any modifications.

     
  • chatelao
    chatelao
    2012-10-29

    Add mysql_query("SET SQL_MODE = 'MYSQL40';"); to dbconnect.php

     


Anonymous


Cancel   Add attachments