Our site www.viart.com site is operated by latest Viart Shop 5 with default Clear design
Topic Information
ViArt Team (Guest)
ViArt Team (Guest)
Brief.
We have slightly modified the following script after release 3.3.2 has been issued:
db_odbc.php
 
Description.
The following SQL error occurred while insert/update of fields that contain backslashes:
 
DB ERROR 37000
 
Database error: Invalid SQL: INSERT INTO va_global_settings (setting_type, setting_name, setting_value) VALUES ('global', 'tmp_dir','c:\windows\temp\')
ODBC Error: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt] 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 ''c:\windows\temp\')' at line 1
 
Solution.
Please download an updated version of the files from here:
http://viart.com/downloads/db_odbc-3.3.2.zip
Then extract the above mentioned file into the 'includes' folder of your shop replacing existing one. Don't forget to make backup copies of the current file in case something goes wrong.
Last modified: 12 Dec 2007 5:44 PM