Charset install on Brinkster.com issue....1st hurdle

[Doots]

Hello,

I discovered Coppermine today and have been trying to get it working with Brinkster for about 6 hours.....

I am on the intial installation and I get the following message.....





mySQL 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 ';>|` &')' at line 1 on query ' INSERT INTO cp3_config VALUES ('forbiden_fname_char', '$/\\\\:*?"\'<>|` &')'...


I can see what is wrong with the SQL, and I've attempted to edit the PHP (new to this today also), to no avail, can one of you Coppermine addicts out there please let me know what I need to do in order to get this working....

Also at the top of the rendered install.php is this message,

File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2) Character set '#33' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' file

Which looks like it has something to do with it, I've tried messing around with the UTF-8 char set.... but again no luck...

Help

Thanks

Doots

[Vargha]

r u self hosted?

[Tranz]

r u self hosted?

Brinkster is a webhost.

Doots, does brinkster meet the requirements for running Coppermine? Have you searched the brinkster forums to see if anyone else had trouble installing coppermine? Where did you get the coppermine files from? How did you download it?

[Doots]

Yes it does, well PHP and MySQL are greater versions than the what's needed.... I got the Coppermine files from Sourceforge.

http://sourceforge.net/project/showfiles.php?group_id=89658

The 1.4.8 release.

I've had a look through the Brinkster forums and can't see anything anyone whose having a problem...

Cheers for any help.

Doots

[Sami]

would you please post a link to your installation folder ?
I think there are not regular CPG files.

[Doots]

http://dootlands.brinkster.net/Copper/

I downloaded the files from the download link on the CPG home page.... nothing different at all....

Doots

[Sami]

there should be a basic.sql file under your sql folder but it seems it's empty !!!
did you delete it ?

[Doots]

It's there, but you don't have rights to see it, The Readme.html file in the Doc directory said that only...

"include", "albums", "albums/userpics", and "albums/edit" directories to 777.....

Nothing about the SQL directory... attached is my Basic.sql file (changed to .txt so I can attach)... nothing altered from download

Doots

[Sami]

- I don't get forbiden error ! i got 404 not found error !
- your attached file is fine .
but now you have "Fatal error " .
I think that you are trying new installation ...so I'm waiting

[Doots]

Sorry, don't quite understand?

I'm in the middle of the installation when I get the error I posted about..... so what are you waiting for?

Doots

[Sami]

- as I said before I got 404 Not Found error (it means the file is not there) not Forbiden !
- double check your sql directory , do you have "basic.sql" , "schema.sql" & "update.sql" out there ?
- when I checked your site , I saw fatal error  about db and now I see "Unable to connect to database " error, so I see that you are giong to install or modify somthing , so I'm waiting for your installation to be compelete or ....

Update:You have MySql server Issue

Code Select Expand

MySQL said: Can't connect to MySQL server on 'localhost' (10061)

[Doots]

I have re checked the directory and the all three files are there.
I put a basic.txt file in that directory (along with the 3 .sql files) and you can see it... it is there, I don't know why it doesn't show up...

http://dootlands.brinkster.net/Copper/sql/basic.txt

All 3 files are there.

I have deleted the partially installed app (Hence the reason you get, can't connect), I can try and run the http://dootlands.brinkster.net/Copper/install.php again, but this will only get to the error I first installed...

What would you like me to do?

Partially run the install.php again?

Doots

[Doots]

Just run  it and I get the same as before....

mySQL 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 ';>|` &')' at line 1 on query ' INSERT INTO cp_config VALUES ('forbiden_fname_char', '$/\\\\:*?"\'<>|` &')'

[Sami]

in what stage you've got that error ? in the beginning of installation?

update:check this out:
http://dootlands.brinkster.net/Copper/index.php
no error for me

[Doots]

yes in the begining.....

I've just edited this line....

INSERT INTO CPG_config VALUES ('forbiden_fname_char', '$/\\\\:*?&quot;\&lt;&gt;|');

I've put the ' where they should be, ie at the begin and end of the string...... and now it works....

Doots

[Sami]

okey now go to:
admin mode=>config=>Files and thumbnails advanced settings=>Characters forbidden in filenames
and the value should be "$/\\:*?"'<>|` &" (without "") if it's not please add this to value

[Doots]

all done..... does this need changing in the basic.sql? 

[Sami]

No!
this is the first time this happen
- did you checked "Characters forbidden in filenames" , specialy "single quotes sign"=> ' should be there
- I think your server has some security mod and that was the issue

[Doots]

fair enough, it's all working now anyway.... thanks for your help