syntax error

[Taz-Mania]

who nows what this is

Inserting data package 1
Errors: Table 'banned' already exists

Inserting data package 2
Errors: You have an error in your SQL syntax near '\\\'0\\\', ID_BOARD tinyint(4) 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 '\\\'General Discussion\\\', \\\'Feel free to talk about anything and everything ' at line 1

my ips made a database en this is what i get

[ad4ms]

Yes, I have same problems with you too on hypermart.net webhosting.

Its seems that mysql did not recognize the single quote (') characters on file yabb.sql. I've tried to delete that single quote, the result is some codes success to execute but for string that need the single quote become unrecognize as 'strings type' and cannot be isserted to mysql database.

And I think there should be make some modification on install.php. I hope there are some solutions for this thing.  

[groundup]

i have absolutely no idea but I am going to take a wild guess and tell you to check if magicquotes is on in PHP

[Jeff Lewis]

Are you guys both on Hypermart?  Do you know the version of mySQL running?

[ad4ms]

MySQL version on hypermart: MySQL 3.23.46-debug
and the current version of PHP on HyperMart is PHP 4.
Is that version compatible with YaBB SE?

And also, I found that install.php added backslash ( \ ) infront of all single quote & double quote strings.
So the syntax on yabb.sql become like this:

INSERT INTO boards VALUES (1, 1, \'General Discussion\', \'Feel free to talk about anything and everything in this board.\', \'\', 0, 1, 1, 0);

That syntax then supplied to mysql and mysql gave a whole error messages.
So I make some modification on install.php. I add this bold code to install.php source code after line 209:

         
   .
   .
   .
$remm = "\'"; $remm2 = "'";
if((ereg(";\n?$",$line) or feof($fd)) and $query != "") {
   $query = str_replace($remm, $remm2, $query);
   counter++;
    .
    .
    .


Then I removed all the tables from previous error installation on my mysql database, and reexecute the install.php. And whala! The installation successful! But I found the files from extracted archive (*.php, *.lng, *.xml) have a same problem too, all the single & double quote in source code inside that files have that d**n backslash character. So its full of errors when I execute index.php. Uff... what da bad day..

[Jeff Lewis]

They must have magic_quotes_gpc turned off

[ad4ms]

So what can I do Jeff? Is there any trick to solve this? Please tell me ..  

[Jeff Lewis]

Set boarddir to simply a period or use the full path...

[ad4ms]

Yes, I've already do so and the cool YaBB SE is on the fly!  
But, may other error occure when magic_quotes_gpc turned off Jeff? For example when installing new mod, or activate an installed mods? If yes, how I cover this?