Errors with SQL syntax in step 4

[pablo]

Hi,
Done a previous install in Windows on my own machine with no problems. Now I'm installing on a remote web host and I'm getting errors.

Version 1.3 (standard zip)
Server: Unix
PHP: 4.1.2
MySQL: 3.23.43

On step 4, here is the start of the response:

Inserting data package 1
No Errors

Inserting data package 2
Errors: You have an error in your SQL syntax near '\\\'0\\\', ID_BOARD int(11) NOT NULL auto_increment, name tinytext NOT NULL, ' at line 1

Inserting data package 3
Errors: You have an error in your SQL syntax near '\\\'0\\\', PRIMARY KEY (ID_CAT)) TYPE=MyISAM' at line 1

Inserting data package 4
No Errors

Inserting data package 5
Errors: You have an error in your SQL syntax near '\\\'0\\\', ID_MEMBER_TO int(11) NOT NULL default \\\'0\\\', deletedBy int(11) ' at line 1

[SNIP]

What to do???

Thanks,
Paul.
PS: On your download page, the standard tar.gz has no content in the archive.ya file... but I guess you knew that already.
PPS: Thanks for creating a great BB.  

[pablo]

Problem solved. Please ignore first post.

Can't explain it but the .sql file had been created incomplete and every ' appeared as \' causing all sorts of problems.
Did a fresh install and it worked fine!

Cheers,
Paul.

[mediman]

just to inform you

this error is not a error, your server has magic_quotes_runtime  = on

magic_quotes_gpc is for get,post,cookies

magic_quotes_runtime is for datas from databases, files or external sources

magic_quotes escaped ' " \ and NUL

you can disable magic_quotes in php.ini or if you not have access to php.ini with a .htaccess file! If .htaccess is not allowed on your server or you will only disable magic_quotes in a script, then you can disable it in your php file!

php.ini:
magic_quotes_runtime = on|off
magic_quotes_gpc     = on|off

.htaccess, httpd.conf:
php_flag magic_quotes_runtime on|off
php_flag magic_quotes_gpc     on|off

*.php
ini_set("magic_quotes_runtime", 0|1);

medi

p.s. you can in phpmyadmin use a option to change " in ' this will often help to avoid your prob!