teke507
Posts: 69
|
| Posted: 10/21/2007, 10:51 PM |
|
I recently encoutered the following error
Database Error: 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('test', '1246015075', 'test', 'test', 'test', 'MS', '2007-10-26 00:00:0' at line 1
i am using a common.php from a set of pages on a different area on the same server but im getting this error..i coppied the common.php that i know is working with the version of mysql on my server any ideas on what could be causing the problem or where to start troubleshooting thanx
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 10/23/2007, 6:08 AM |
|
teke507
What version of CCS, PHP and MySQL are you using?? Also, is it possible to see a copy of the code that is having the problem?? Have you run your query directly on MySQL?? Do you have the right version of the MySQL library loaded in CCS (MySQL or MySQLi)??
|
|
|
|
teke507
Posts: 69
|
| Posted: 10/23/2007, 5:32 PM |
|
IM USING CODE CHARGE 3.1 PHP 4.1 AND MYSQL 5.0
WHEN i put the syntax for the sql statment in the phpmyadmin it works
INSERT INTO `RemovalFull` ( `Ticket_Num` , `Company` , `Address` , `City` , `State` , `Zip` , `Floor` , `Pick_up_date` )
VALUES (
'123456', 'TEST', 'TEST', 'TEST', 'NJ', '07090', '1001', '2007-12-07 00:00:0'
)
at first i thought it was the zero at the end of the date time insert but it works when i use the sql query manually ...what code do you need i dont know how to echo the sql statement ..i trying doing an echo $this; in the common.php ccbuildinsert and it statment it echos is "Object" thank you for your response and help
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 10/24/2007, 5:29 PM |
|
teke507
Try this link and let me know if it helps you: http://forums.yessoftware.com/posts.php?post_id=77314
|
|
|
|
|
