Inserting into Database

General Questions/Discussions
1

I get a nice little error here when trying to input into the database.

Just testing some stuff to make sure I did it right.

Either I didnt, or I have found a bug.

here is the error produced.

INSERT INTO temp_list (name, ) VALUES (‘hahah’, );

Fatal error: Uncaught exception ‘epExceptionDbAdodb’ with message 'Cannot execute query: mysql error: [1064: 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 ‘) VALUES (‘hahah’, )’ at line 1] in EXECUTE(“INSERT INTO temp_list (name, ) VALUES (‘hahah’, );”) ’ in /var/www/vhosts/myarcworld.com/httpdocs/arcg2/lib/phporm/src/db/epDbAdodb.php:194 Stack trace: #0 /var/www/vhosts/myarcworld.com/httpdocs/arcg2/lib/phporm/src/db/epDb.php(317): epDbAdodb->_execute(‘INSERT INTO tem…’) #1 /var/www/vhosts/myarcworld.com/httpdocs/arcg2/lib/phporm/src/db/epDbObject.php(2283): epDb->execute(‘INSERT INTO tem…’) #2 /var/www/vhosts/myarcworld.com/httpdocs/arcg2/lib/phporm/src/db/epDbObject.php(1548): epDbObject->_execute(‘INSERT INTO tem…’) #3 /var/www/vhosts/myarcworld.com/httpdocs/arcg2/lib/phporm/src/runtime/epManager.php(992): epDbObject->insert(Object(epClassMap), Object(epObjectWrapper)) #4 /var/www/vhosts/myarcworld.com/httpdocs/arcg2/lib/phpor in /var/www/vhosts/myarcworld.com/httpdocs/arcg2/lib/phporm/src/db/epDbAdodb.php on line 194

Any idea?

2

$lol = “hahah”;
$list = temp_listDAO::createTemp_list();
$list->name = $lol;
temp_listDAO::save($list);

Thats my php code.

3

Hello nomspes,

Thank you for your post. We are now working on a new version, which is likely to fix this problem. Would you mind sending me your project file so that we can confirm if the fix work with your project?

Best regards,
Jick