SQL syntax error in install

Brought to you by: letreo

SQL syntax error in install

Forum: Hilfe/Help

Creator: Gary Cunningham-Lee

Created: 2002-04-24

Updated: 2002-04-26

Gary Cunningham-Lee - 2002-04-24

I get this error when creating the tables in my database (using phpMyAdmin, MySQL 3.23.39, PHP 4.1.2):

"MySQL said: You have an error in your SQL syntax near 'Logo varchar(255) NOT NULL default 'images/exit_logo.gif', ExitURL varchar(25' at line 8"

Did anyone else encounter this? Any ideas? Thanks for any help.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Gary Cunningham-Lee - 2002-04-24
  
  OK, the problem seems to be the # marks in the HTML color codes. I replaced the hex codes with plain text (white and grey) and the table was created with no error message. Does this mark have to be escaped in some mysql versions?
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Mirko Giese - 2002-04-26
  
  no this is more a problem of older phpmyadmin-versions. the db-dump delivered by phpopenchat comes directly from mysqldump and therefore the mysql-syntax should be ok
  mirko
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.