| auto_increment [message #2883] |
Sun, 12 February 2012 20:59  |
kong
Messages: 90
Registered: December 2011
|
Member |
|
|
Radicore v1.70.0
MySQL v5.5.16
1. Create table with auto increment PK as the only column.
2. Import table and export to php result in dict.inc file with following:
$fieldspec['project_id'] =
array('type' => 'integer',
'size' => 11,
'auto_increment' => 'y',
'minvalue' => -2147483648,
'maxvalue' => 2147483647,
'pkey' => 'y',
'required' => 'y');
3. Create list1 transaction for this table.
4. Add a new record, the following error will show up upon submit:
Fatal Error: MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 (# 1064).
SQL query: INSERT INTO a_project SET
Error in line 941 of file 'C:\wamp\www\radicore\includes\dml.mysqli.class.inc'.
Host Info: localhost via TCP/IP
Server Version: 5.5.16-log
Client Version: mysqlnd 5.0.8-dev - 20102224 - $Revision: 310735 $, Character sets - client: utf8, - connection: utf8, - database: latin1, - server: latin1
PHP_SELF: /radicore/aa/a_project(add1).php
CURRENT DIRECTORY: C:\wamp\www\radicore\aa
SERVER_ADDR: 127.0.0.1
SERVER_NAME: localhost
HTTP_HOST: localhost
User Id: MGR
REMOTE_ADDR: 127.0.0.1
REQUEST_URI: /radicore/aa/a_project(add1).php
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
